https://issues.apache.org/bugzilla/show_bug.cgi?id=47056
Summary: FormulaParser doesn't work correctly for sheets names
which contains white spaces.
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [email protected]
Class Poi.SS.Formula.FormulaParser.java, function private Identifier
parseIdentifier() doesn't work properly for parsing NameRanges included Sheet
Names which contains more than one word.
For example:
We have next NamedRanges: "Workunits!$A$1:$B$5" and "Workunit
status!$A$1:$C$2".
For second reference we get exception FormulaParseException("Specified named
range Workunit does not exist in the current workbook."
which comes from this method: private Ptg parseNameOrCellRef(Identifier iden)
EvaluationName evalName = _book.getName(name, _sheetIndex);
if (evalName == null) {
throw new FormulaParseException("Specified named range '"
+ name + "' does not exist in the current workbook.");
}
It happens because parseIdentifier() returns only first part of Sheet name
until first white space.
--
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]
