Andreas,
1) Didn't check it but I think both methods start with index 0. There
might be indeed a column 3 with all cells being blank?
2) The error message you've seen is related to the shared formula
problem. See:
http://mail-archives.apache.org/mod_mbox/jakarta-poi-user/200406.mbox/[EMAIL
PROTECTED]
Hope this helps,
Thomas
Andreas Korthaus schrieb:
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/
--
Mit freundlichen Grüßen / Best Regards
Thomas Herre
ABOSCO GmbH
Schlossmattenstraße 9a
79268 Bötzingen
Phone: +49 (0)7663/9140 - 13
Fax: +49 (0)7663/9140 - 29
eMail: [EMAIL PROTECTED]
Web..: www.abosco.com
---------------------------------------------------------------------
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/
