poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 38396] - Formula Evaluator number range .
Date Sat, 11 Feb 2006 19:17:08 GMT
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=38396>.
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=38396


amolweb@yahoo.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |ASSIGNED




------- Additional Comments From amolweb@yahoo.com  2006-02-11 20:17 -------
The code I used to test had a bug :) 

So yes, this is a bug in the current implementation. However after some
debugging it seems like excel stores large numbers (in formula strings) with the
exponential notation. Thus 30000000/100 is stored as 3.0E7/100.
Apparently, FormulaParser cannot handle this and it simply returns a Ptg array
of size 1 containing the NumberPtg with numeric value "3.0" instead of Ptg array
of size 3 containing NumberPtg, DividePtg and NumberPtg



-- 
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/


Mime
View raw message