[Libreoffice-bugs] [Bug 133588] calc:The function SUM() does not produce the same result as the '+' operator
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 2 21:50:17 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=133588
--- Comment #13 from sebastien.kramm at wanadoo.fr ---
(In reply to m.a.riosv from comment #11)
> It is not a bug
So it's a feature ;-)
>, LibreOffice it's very strict about numbers as text, only
> direct references are treated as numbers, text numbers in ranges a never
> converted.
Thank you for that clarification.
> There are some options in Menu/Tools/Options/LibreOffice Calc/Formula -
> Detailed calculation settings.
Indeed, to have the same behavior, you have to check "treat as 0" in
"conversion from text to numbers" (see attached calc screenshot).
Thanks to all.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200602/9b5bb374/attachment.htm>
More information about the Libreoffice-bugs
mailing list