https://bz.apache.org/bugzilla/show_bug.cgi?id=60517
Bug ID: 60517
Summary: Incorrect parsing multiple sheet in formula
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 34554
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34554&action=edit
test file
Summary:
In my Excel research project from EUSES data base, I found that HSSF in POI
3.15 final release didn't parse multiple sheet formula correctly.
Details:
When the multiple sheet name quoted by single quote, HSSF put single quote
between every sheet name. (See at sheet: Summary in cell: D17 of formula:
SUM('1003':'1856'!D28))
For example,
Formula: = SUM('1003:1856'!D28)
Here the sheet name are 1003 and 1856. When HSSF parse string, it shows:
SUM('1003':'1856'!D28)
I should expect the formula string should be :
SUM('1003:1856'!D28)
If I convert XLS into XLSX file, the new XSSF parse it correctly as
SUM('1003:1856'!D28)
--
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]
