Bug 56752

Summary: XSSFEvaluationWorkbook.getExternalName should take advantage of the ExternalLinkTable cache potentials
Product: POI Reporter: Nick Burch <apache>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: enhancement    
Priority: P2    
Version: 3.11-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

Description Nick Burch 2014-07-20 19:13:09 UTC
One improvement with the .xlsx file format is that for named ranges from external files, the details of what they point to get cached in the referring file in the external link table for that referenced workbook

Currently, XSSFEvaluationWorkbook.getExternalName behaves rather like HSSF does, and doesn't take advantage of this

We should extend XSSFEvaluationWorkbook.getExternalName to return a modified / updated kind of ExternalName which does have a link to this cache, and have the formula evaluation code use it if the linked workbook isn't available at evaluation time