https://bugs.freedesktop.org/show_bug.cgi?id=64132
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #1 from mariosv <[email protected]> --- Hi Leo, (In reply to comment #0) > In calc, a formula like sum(a1:a3) applied to cells which contain a string > results in the string being coerced to 0. However, if the the string > contains a number, this coercion is incorrect. Under you point of view. This works as intended and I hope this will never change. > > This *is* a bug, since the correct behaviour would be to signal an error > indicating the formula has been applied to invalid inputs. An error result only leads to make unusable the SUM() function for many people like me. > > This bug bit when copying numbers from one program into libreoffice/calc. > One of the numbers was read as a string by calc, and the resulting column > tally was off by ~$400. This wasn't noticed til it was too late... you have options to make the import in number properly, e.g. with paste special - unformatted text, you can select the right data type. > > --- > Btw, I discovered after the fact that View->Value Highlighting provides a > way to diagnose problems with string->0 coercion. > > --- > Here is a simple example: > > a1: "I am not a number" > a2: =sum(a1:a1) Result 0, what it is right, nothing to sum. > > This may be related to > https://bugs.freedesktop.org/show_bug.cgi?id=59309 I think it is your responsibility have the data in the proper way, numbers are numbers not text. If you want you can set easily verifications to be sure no text data in the list. -- 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
