https://issues.apache.org/bugzilla/show_bug.cgi?id=45593
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
--- Comment #9 from Josh Micich <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
