https://bugs.freedesktop.org/show_bug.cgi?id=64132
Leo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|NOTABUG |--- Ever confirmed|0 |1 --- Comment #2 from Leo <[email protected]> --- (In reply to comment #1) > 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. We have opposing desires. > > > > > 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. Look, you are completely missing why this is a bug. A user copies a "number" like 190.20 from thunderbird or wherever into calc. Calc sees this number as a string and coerces this "number" to 0 in sum, et. al. No warnings, no errors, nothing. That is absolute crap. And how is an unsophisticated user even to know where or why the error happened? > > > > > 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. Let me be clear, I identified this bug because another user came to me telling me what crap libreoffice is, it can't even sum a column of numbers correctly. Who would expect that pasting a damn number into libreoffice office would require such damn contortions as you are suggesting? Come on. > I think it is your responsibility have the data in the proper way, numbers > are numbers not text. Indeed, and when calc, by default, displays a stringified number as a number and *silently* coerces that string to 0, then calc violates your principal. That is the bug report I am filing. > If you want you can set easily verifications to be sure no text data in the > list. So, an unsophisticated calc user can be bitten in the ass by a bug that can be easily fixed if only the user were more sophisticated. Just so the sophisticated user can take advantage of some short cuts that could be easily customised. Come on. -- 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
