https://issues.apache.org/bugzilla/show_bug.cgi?id=49783
Summary: [PATCH] Error Code for "#REF!" same as for "#NAME?"
Product: POI
Version: 3.6-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=25914)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25914)
Updates error code from 0x1D to 0x17 for REF value
In org.apache.poi.ss.usermodel.FormulaError, the REF and NAME values have the
same error code (0x1D). This results in an "IllegalArgumentException" when
running forString()/forInt(). REF should instead have code 0x17 as it is also
defined in other places (e.g. org.apache.poi.ss.usermodel.ErrorConstants)
To reproduce this:
- make an excel file (tested with OOXML)
- make a reference to a cell from another cell
- delete the first cell
- run the second cell through
"org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateInCell()".
The "IllegalArgumentException" will state "Unknown error type: 23".
--
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]
