[Libreoffice-bugs] [Bug 133588] calc:The function SUM() does not produce the same result as the '+' operator

[bugzilla-daemon at bugs.documentfoundation.org]

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>