https://issues.apache.org/bugzilla/show_bug.cgi?id=49720
Summary: getRefersToFormula() returns a formula with '$'
characters removed, for column references
Product: POI
Version: 3.6
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Excel creates named column references of the form 'SW'!$AL:$AL.
However when these are accessed using the Name's getRefersToFormula() method
the string returned is missing the '$' characters, e.g. 'SW'!AL:AL
PS: I have an easy workaround for any one who cares:
Name name = iwb2.getNameAt(n);
String formula = name.getRefersToFormula();
if (!formula.contains("$"))
{
int pos = formula.indexOf('!');
formula = formula.substring(0, pos+1) + '$'
+ formula.substring(pos+1);
pos = formula.indexOf(':');
formula = formula.substring(0, pos+1) + '$'
+ formula.substring(pos+1);
}
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
