Hi!
I have a sheet like:
A1 B1 C1
A2 B2 C2
A3 B3 C3
When I use: HSSFSheet.getLastRowNum()
it returns "2" - so it starts counting rows from 0 = first row.
When I use: HSSFRow.getLastCellNum()
it returns "3" for every row, so it seems to start counting from 1 =
first col.
Why is there a different behaviour?
And why this way?
Perhaps the other way around I could understand it...
And another issue (another, more complex workbook), I try to read
formulas using
HSSFCell.getCellFormula()
which works nice, but in one Excel-Sheet I have a column with a lot of
formulas like:
=C61*F61
And some of these really simple formulas can't be displayed (problems
only in row 60-65?!?!). The output of HSSFCell.getCellFormula() is:
NO IDEA SHARED FORMULA EXP PTG
what's that?
What could be the problem?
The excel sheet is not really big or complex. If I copy all the cells to
another sheet the problem is still there.
best regards
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
