[Bug 57184] New: Missing Formula support for External References

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=57184

            Bug ID: 57184
           Summary: Missing Formula support for External References
           Product: POI
           Version: 3.11-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: apache@gagravarr.org

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)

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org