https://issues.apache.org/bugzilla/show_bug.cgi?id=45334
Summary: Excel function "ERRORTYPE" not recognized properly
Product: POI
Version: 3.0
Platform: All
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
When encountering a formula that uses the ERRORTYPE the FormulaParser does not
recognize it as a function. Here is the stack trace:
java.lang.IllegalArgumentException: Invalid Formula cell reference: 'ERROR'
at org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:61)
at org.apache.poi.hssf.util.AreaReference.<init>(AreaReference.java:63)
at
org.apache.poi.hssf.record.formula.AreaPtgBase.<init>(AreaPtgBase.java:59)
at org.apache.poi.hssf.record.formula.AreaPtg.<init>(AreaPtg.java:36)
at
org.apache.poi.hssf.model.FormulaParser.parseIdentifier(FormulaParser.java:242)
at
org.apache.poi.hssf.model.FormulaParser.parseFunctionOrIdentifier(FormulaParser.java:229)
at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:468)
at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:433)
at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:420)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:628)
at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:709)
at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:693)
at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:650)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:405)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:308)
at
org.apache.poi.hssf.model.FormulaParser.parseFunctionOrIdentifier(FormulaParser.java:227)
at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:468)
at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:433)
at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:420)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:628)
at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:709)
at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:693)
at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:650)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:405)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:308)
at
org.apache.poi.hssf.model.FormulaParser.parseFunctionOrIdentifier(FormulaParser.java:227)
at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:468)
at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:433)
at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:420)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:628)
at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:709)
at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:693)
at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:650)
at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:751)
at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:113)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateCell(HSSFFormulaEvaluator.java:346)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:338)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:183)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:278)
...
Note: there is no way to select the 3.1 final in the Version select. The jars
I used to get this are poi-*FINAL-20080629.jar
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
