Bug 60983 - FormulaParser does not recognize external workbook references when quoted
Summary: FormulaParser does not recognize external workbook 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:44 UTC by Efthimia
Modified: 2017-06-16 20:19 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Efthimia 2017-04-13 12:44:23 UTC
When parsing formula ='C:\[ex45672.xls]d f'!$B$13, FormulaParser does not recognize is as a reference to an external workbook. Instead, it creates an org.apache.poi.ss.formula.ptg.Ref3DPxg [sheet=[1]d f ! $B$13] token where externalWorkbookNumber = -1 and firstSheetName = "[1]d f"