I filed a bug for this issue:
http://issues.apache.org/bugzilla/show_bug.cgi?id=36941
I think it's another issue than Thomas link.
Igor, perhaps you could add an Excel example as simple as possible to
the bug - which shows the problem?
I don't know a solution, so this problem and the two other issues I
posted to this list without response:
- I don't know how to find out the RGB-color from a color-index read by
HSSFStyle.getFillBackgroundColor()
http://thread.gmane.org/gmane.comp.jakarta.poi.user/7102
- I don't know how to add a PNG image with 100% size (pixels)
http://thread.gmane.org/gmane.comp.jakarta.poi.user/7088
will probably force me to use http://jexcelapi.sourceforge.net/.
I'm not very happy with that, because I like POI very much.
But at the moment I'm rewriting my code to use jexcelapi, it solves all
three mentioned issues for me.
To test if your formulas work with jexcelapi, you can check it easily
this way:
java -jar jxl.jar -formulas spreadsheet.xls
best regards
Andreas
Igor Androsov wrote:
I am having same problem with formulas showing - NO
IDEA SHARED FORMULA EXP PTG. I try to use 3.x alpha
version of POI but still got same result. Is this
really fixed and working with some patch for 3.x or
2.x? I did not try the fix the link pointing to for
2.x but it stated that 3.x has this rectified. Since
3.x did not work for me I did not think 2.x Fix will
work iether.
Any ideas?
Igor
--- Thomas Herre <[EMAIL PROTECTED]> wrote:
Andreas,
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?Een / 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/
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.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/
