Q:

JOpenDocument: problems with blank rows and cells

I have a problem when I parse .ods file with JOpenDocument . There are three rows and four columns in my file, but when I parse this file I get 1024 columns and too many rows. There are many blank cells. 
I opened this .ods file like xml and it didn't have many lines.
And I couldn't find method for check empty cell in JOpenDocument API.
Here is my code where I create row with data:
ArrayList rowData = new ArrayList();
int countCol = sheet.getColumnCount();

for (int i = 0; i < countCol; i++) {
    rowData.add(getCellData(sheet.getName(), num, i));
}

How can I fix this problem? Maybe I have to change library?

A:

jopendocument has a function for that: getUsedRange()
Range range=sheet.getUsedRange();
System.out.println("RANGE: "+range.toString());

=> RANGE: Feuille1.A1:.C8 (example)

