https://bz.apache.org/bugzilla/show_bug.cgi?id=62170
Bug ID: 62170
Summary: NumberFormatException when trying to get reference
from named range with getRefersToFormula()
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: stephane.tes...@soprasteria.com
Target Milestone: ---
When I try to get the reference behing my named range via the
getRefersToFormula() function, in some cases, I get a NumberFormatException.
It depends on the sheet name where the named range is, for example :
- the named range is in a sheet named '2620000001', it's OK.
- the named range is in a sheet named 'C2620000001', it fails -> i don't know
why but it seems POI considers that it's a number and tries to parse it into a
string, thus the NumberFormatException : 2620000001 is higher than the int
limit 2^31-1
When I check the named cells in Excel's name manager, sometimes the sheet name
is surrouded with quotes, sometimes it isn't.
Note that when there are quotes, it works everytime with POI. Otherwise, it
fails sometimes (cf. the case mentionned before, Excel doesn't add quotes with
the sheet name C2620000001)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
