https://issues.apache.org/bugzilla/show_bug.cgi?id=46951
Summary: Cannot parse range expressions with non-cell ref
operands
Product: POI
Version: 3.5-dev
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P5
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
The following code:
cell.setCellFormula("SUM(C1:OFFSET(C1,0,B1))");
fails with this exception:
org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Specified named
range 'OFFSET' does not exist in the current workbook.
This bug was noticed while fixing bug 46948 , which is concerned about
evaluation of the corresponding Ptg array (pre-parsed by Excel).
--
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]
