https://bugs.documentfoundation.org/show_bug.cgi?id=98344
--- Comment #11 from [email protected] --- After some tests, my opinion was changed: suggested change of "Conversion from text to numbers" value does not solve the problem. Imagine column with all numeric cells but one or couple erroneously text ones. In this case formulae A1+...+A6 will give error(and that is good), but SUM(A1:A6) will give just "incorrect" result without any warning, so user could not always trust the SUM formulae. So the point is the same - why these two formulae give different results? I do understand that SUM just ignores text values, but is it possible to force it to give an error in this case? -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
