[Bug 56742] New: Filename missing from result of getFormulaCell for formulas that reference ranges in other files

[bu...@apache.org]

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

            Bug ID: 56742
           Summary: Filename missing from result of getFormulaCell for
                    formulas that reference ranges in other files
           Product: POI
           Version: 3.11-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: apache@gagravarr.org

This looks, based on the comments in unit tests I've found, to be related to
#45970. I spotted it with #56737

In excel, if you create a formula which references a named range in another
file, eg "TestFile.xls!NR_Global_B2", then ask POI to get you the formula of
the cell, it will be returned without the filename, so you'll just get
something like "NR_Global_B2"

This seems to be related to how we decode things like NameXPtg / SupBookRecords
etc

-- 
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