https://bz.apache.org/bugzilla/show_bug.cgi?id=60219
Bug ID: 60219
Summary: [PATCH] FormulaParser can't parse external references
when sheet name is quoted
Product: POI
Version: 3.15-FINAL
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 34334
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34334&action=edit
FormulaParser.java patch content ASCII
A formula cell contains a reference to a cell in an external workbook. This is
represented in POI as
[1]Shee1!A1
where [1] is an index on a table to de-reference external workbooks. The
current parser has no problems with this. But, if the sheet name contains
spaces or "special" characters, the formula cell contains:
'[1]Sheet 1'!A1
Note the quote starts before the square bracket indicating an external file
reference.
We resolved this problem by editing the FormulaParser.java file and I'm now
submitting a patch for revision.
--
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]
