Bug 57184 - Missing Formula support for External References
Summary: Missing Formula support for External References
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.11-dev
Hardware: PC Linux
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-04 16:15 UTC by Nick Burch
Modified: 2017-01-08 20:24 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nick Burch 2014-11-04 16:15:49 UTC
We now have some support for External References (Workbook + Name or Workbook + Sheet + Cell) in the formula parser. This bug is to track what work is still required for a full(ish) implementation:

 * When evaluating XSSF external references, the last seen values can be cached in the link table. These should be used when evaluating formulas, if the external workbook wasn't attached to the evaluation context. See #56752
 * When fetching the formula string in HSSF, the workbook name or id should be included in the string for external references. (XSSF returns the id)
 * There should be an easy way to get the XSSF external workbook ID replaced with the filename, for XSSF formulas with external references, to give a "what excel shows" form of the formula string
 * It should be possible to create HSSF formulas which refer to a new external workbook, with the link table being set up for it (failing, commented out unit test available)
 * It should be possible to create XSSF formulas which refer to a new external workbook, with the link table and relations being set up for it (failing, commented out unit test available)
Comment 1 IgnacioHR 2016-10-10 16:32:02 UTC
https://bz.apache.org/bugzilla/show_bug.cgi?id=60219

Patch contains implementation of requirement:

 * It should be possible to create HSSF formulas which refer to a new external workbook, with the link table being set up for it (failing, commented out unit test available)
Comment 2 Dominik Stadler 2017-01-08 20:24:47 UTC
The following unit-tests at https://github.com/ZuInnoTe/hadoopoffice.git can be incorporated to verify some of the things discussed in this enhancement:

* fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapred/OfficeFormatHadoopExcelTest.java
* fileformat/src/test/java/org/zuinnote/hadoop/office/format/mapreduce/OfficeFormatHadoopExcelTest.java