https://bugs.freedesktop.org/show_bug.cgi?id=64132
Robinson Tryon (qubit) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Summary|Calc string-number coercion |Calc operators and built-in | |functions use different | |algorithm for | |string-to-number coercion Ever confirmed|0 |1 --- Comment #6 from Robinson Tryon (qubit) <[email protected]> --- (In reply to raal from comment #5) > Calc is inconsistent in conversion text to numbers. When I format A1 as text > and write "1", B1 = A1+1, result is 2. When I write formula =SUM(A1), result > is 0. CONFIRMED in LO 4.4.0.0.alpha2 + Ubuntu 14.04 To sum up (no pun intended), operators such as "+, -, /, *" coerce numbers formatted as text to their apparent value, whereas functions such as SUM() and AVERAGE() convert all strings to a value of zero. > In first case automatic conversion text to numbers works, in second > case text is not converted to number. In both cases the text is converted to a number, it's just that the built-in functions map all text inputs to zero :P > Calc do it the same way as excel. Hmm...that's a good data point, even if I think that the behavior is suboptimal. At the very least, we need to document this nuance of Calc. What version of Excel are you using to test? Status -> NEW -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
