https://bugs.freedesktop.org/show_bug.cgi?id=64132
--- Comment #8 from Leo <[email protected]> --- (In reply to Robinson Tryon (qubit) from comment #6) > (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. > > > 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 Thanks for looking into this. Excel's bugs shouldn't be replicated in libreoffice, imo. a1+a2 and sum(a1:a2) should produce the same output. The latter is just an abbreviation for the former. -- 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
