Bug 60982

Summary: FormulaParser does not recognize multi-sheet references when quoted
Product: POI Reporter: Efthimia <e.aivaloglou>
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: 3.15-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

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