You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2018/03/09 15:12:48 UTC
[Bug 62170] New: NumberFormatException when trying to get reference
from named range with getRefersToFormula()
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.tesoka@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 62170] NumberFormatException when trying to get reference from
named range with getRefersToFormula()
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62170
stephane.tesoka@soprasteria.com changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from stephane.tesoka@soprasteria.com ---
After further investigations, it seems that the problem only concerns XLS
files. It works fine with XLSX files.
--
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