Hi,
I use POI to import quite large and complex Excel files having a lot of
formulas. Some of these formulars are stored as "shared formulas". I can
open the file, but when I try to call HSSFFormulaEvaluator.evaluate() I get
a RecordFormatException on some cells:
org.apache.poi.hssf.record.RecordFormatException: Coding Error: Expected
ExpPtg to be converted from Shared to Non-Shared Formula
at
org.apache.poi.hssf.record.formula.ExpPtg.toFormulaString(ExpPtg.java:78)
at
org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:886)
at
org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:868)
at
org.apache.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:630)
I think there is a bug in the implementation of shared formulas. I checked
out POI trunk from SVN on 2007-05-16. The problem also occured in POI 2.5.1
(not an Exception but a text like "NO IDEA SHARED FORMULA" was shown.
Thx for help,
Regards,
Günter
--
View this message in context:
http://www.nabble.com/POI-Bug---opening-workbooks-containing-%22shared-formulas%22-tf3763371.html#a10638070
Sent from the POI - User mailing list archive at Nabble.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/
