Andreas,
I tested your sheet with POI 2.51.
It has indeed the old shared formula problem I referred to last time.
Try this: remove the formulae that cause the problem (edit, delete,
formula).
Retype the formulae and I mean type each of them, don't drag and drop,
as this causes Excel to create the shared formula. Do not not save
the Workbook until you're done. Rerun your program, it should not
bring up the errors. Open the Workbook in Excel again and save it.
Run your program -> errors come up as Excel created the shared formulae
when saving the workbook.
For 2.5.1 this is my workaround when I encounter such problems.
Of cause you can also apply this with the help of a simple class that types
the formulae for you using POI :-)
My hope was that this is fixed in 3.0. Can anybody confirm it is not?
Cheers, Thomas
Andreas Korthaus schrieb:
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/
--
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/
