DO NOT REPLY [Bug 33160] - cell formula "40000" throws NumberFormatException: Value out of range

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=33160>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=33160





------- Additional Comments From amolweb@yahoo.com  2005-01-21 15:51 -------
***** fix suggestion ******

Following the stack trace in the source code, the exception is at foll. place in
code:

// class: org.apache.poi.hssf.model.FormulaParser, line 486

tokens.add(new IntPtg(number)); //TODO:what if the number is too big to be a
short? ..add factory to return Int or Number!


Perhaps IntPtg is used instead of NumberPtg for efficiency of storage? But since
it breaks the functionality for large values (since internal representation for
IntPtg is short), could a temporary fix be made that uses NumberPtg instead of
IntPtg till the TODO is actually resolved? I have tried that change on my local
source and it works fine.



-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/