Mailing List
Home
Forum Home
Maven - Project building tool
Axis - Java SOAP implementation
Lucene - Full-featured text search engine APIs
Cocoon - MVC web framework based on XML/XSL
Fop - Create PDF, PCL, PS, SVG, XML driven by XSL formatting objects.
Log4J - A log library
POI - Java Excel, Word and other Microsoft Office files manipulating library
Oracle database error code ...
Subjects
• log4j warning: No appenders could be found
• java security AccessControlException: access denied (java io FilePermission clie
• java lang InstantiationException: org apache tools ant Main
• Apache Axis Tutorial
• Subject: Struts <logic iterate >
• log4j properties How to parse outpu to multiple files
• configuring log4j with BEA Weblogic 8 1
• How to use XSL FOP Java together
• JSP precompile
• Proposal: Adding jar manifest classpath in jar and war plugins
• Servlet File Download dialog problem (IE6,Adobe 6 0)
• java security AccessControlException: access denied (java io FilePermission
• Unsupported major minor version 48 0 problem while running the an
   telope task
• Subject: axis wsdl2java Ant Task usage
• net sf hibernate MappingException: Error reading resource: test/User hbm xml
• Building EAR ANT Script for websphere 5 0
• CREATING WAR Files
• Classpath problem
• jsp data into Excel
• Jboss 3 2 3+ vs Tomcat Axis Question
• RE: How to include jars and add them into the MANIFEST MF/Class Path
attribute
• Printing problem
• Subject: InstantiationException
• Couldn 't find trusted certificate
• Please : How can one install ant 1 6 0 under Eclipse 2 1 ?
• Excel: Too many different cell formats
• Subject: AXIS: tomcat timeout ?
• 1 3 final: now giving me java io FileNotFoundException (Too many
open files)
• XDoclet, Struts and Maven: Where to start? SOLUTION
• Subject: Running junit tests fails
 
POI Bug - opening workbooks containing "shared formulas "

POI Bug - opening workbooks containing "shared formulas "

2007-05-16       - By kix

 Back

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