poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kix <g.kickin...@gmx.net>
Subject POI Bug - opening workbooks containing "shared formulas"
Date Wed, 16 May 2007 08:51:25 GMT

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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message