https://issues.apache.org/bugzilla/show_bug.cgi?id=49640
Summary: [PATCH] FormulaParser cannot parse formulas containing
defined names beginning with an underscore
Product: POI
Version: 3.7-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=25795)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25795)
Fixes incorrect rejection of defined names beginning with underscores in
formulas
Eclipse allows defined names to begin with either a letter or an underscore.
These defined names may be present in a formula (e.g. =SUM(F15:F16)+_GP108).
In the previous example _GP108 is a defined name beginning with an underscore.
FormulaParser fails to process the defined name in the previous example because
the parseNonRange(int) function only tests whether the defined name begins with
a letter. This occurs when processing xssf workbooks only.
The attached patch modifies the test for the defined name starting character to
accept underscores.
--
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]
