Bug 60982 - FormulaParser does not recognize multi-sheet references when quoted
Summary: FormulaParser does not recognize multi-sheet references when quoted
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.15-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-04-13 12:37 UTC by Efthimia
Modified: 2017-06-16 20:19 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Efthimia 2017-04-13 12:37:04 UTC 
When parsing formula SUM('a b:c d'!F9), FormulaParser does not recognize the second sheet from multi-sheet reference 'a b:c d'!F9. Instead, it creates an org.apache.poi.ss.formula.ptg.Ref3DPxg [sheet=a b:c d ! F9] token with firstSheetName = a b:c d and lastSheetName = null