Bug 56752 - XSSFEvaluationWorkbook.getExternalName should take advantage of the ExternalLinkTable cache potentials
Summary: XSSFEvaluationWorkbook.getExternalName should take advantage of the ExternalL...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.11-dev
Hardware: PC Linux
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2014-07-20 19:13 UTC by Nick Burch
Modified: 2015-09-13 20:13 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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