https://bz.apache.org/bugzilla/show_bug.cgi?id=66855
Bug ID: 66855
Summary: [PATCH] Formula parser incorrectly handles sheet name
containing multiple single quotes in a row
Product: POI
Version: 5.3.x-dev
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 38724
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38724&action=edit
FormulaParser.java
I have a workbook with a sheet whose name contains multiple single quotes. And
I ran into a problem when I try to refer to it from a formula.
I found a similar issue that was already fixed, it was about the case where the
sheet name contains only one single quote, but unfortunately in my case the
issue still exists.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66401
I investigated this problem and now I have a solution, please review my Pull
Request with a simple fix.
Example of the problem:
Sheet name - Sh''t1 (contains two single quotes).
In the formula it will be - 'Sh''''t1'
After parsing it will become - Sh''
--
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]
