Bug 56742 - Filename missing from result of getFormulaCell for formulas that reference ranges in other files
Summary: Filename missing from result of getFormulaCell for formulas that reference ra...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.11-dev
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-18 17:17 UTC by Nick Burch
Modified: 2014-07-18 17:17 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-07-18 17:17:08 UTC
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