Please whilereading place esacpe sequence and try pls. All the best for your future endeavour πΆπΆπΆππππππππ
On Mon, 26 Dec 2022 at 13:13, <bugzi...@apache.org> wrote: > https://bz.apache.org/bugzilla/show_bug.cgi?id=66401 > > Bug ID: 66401 > Summary: FormulaParser does not recognize sheet names > containing quotes > Product: POI > Version: 5.2.2-FINAL > Hardware: PC > Status: NEW > Severity: blocker > Priority: P2 > Component: SS Common > Assignee: dev@poi.apache.org > Reporter: mirko.sco...@addvalue.it > Target Milestone: --- > > Created attachment 38454 > --> https://bz.apache.org/bugzilla/attachment.cgi?id=38454&action=edit > FormulaParser.java > > I have an Excel file with a sheet whose name contains a quote. This name is > referenced in a formula on a cell of a different sheet. > > Example: > > Sheet name -> Valle d'Aosta > Sheet reference in formula -> 'Valle d''Aosta'!A1 > > The FormulaParser creates a Ref3DPxg instance having: > > _firstSheetName -> Valle dAosta > > I have found this issue in version 5.2.3. FormulaParser eats the two > consecutive quotes at line 1185 when, once they are detected, it scrolls > to the > next char without appending them to the string builder. > > Adding at line 1185 of FormulaParser the following statement solved my > issue. > > sb.appendCodepoint(look); > > See the patched FormulaParser.java. I wonder if you could insert this fix > in > the next release. > > -- > You are receiving this mail because: > You are the assignee for the bug. > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org > For additional commands, e-mail: dev-h...@poi.apache.org > >
