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 45593] Formula "Sum(a1:g1)" not calculating string values
Date Sat, 09 Aug 2008 00:11:44 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45593


Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID




--- Comment #9 from Josh Micich <josh@gildedtree.com>  2008-08-08 17:11:43 PST ---
(In reply to comment #8)
> The value of G1 is coming out to be 0 where as it should be 30. This is using
> formula "=SUM(A1:F1)".
> 
> But instead of using this SUM formula, if I use "=A1+B1+C1+D1+E1", then it
> works fine, see cell G2.

POI is just replicating Excel's behaviour here.  Excel evaluates G1 to 0.00
too.

There are quite a few tricks/inconsistencies in the implicit type conversions
that Excel does while evaluating formulas.  For example, sum("5", "5", "5",
"5", "5") = 25. 
Go figure.


POI does not attempt to 'correct' these inconsistencies.


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message