[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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com

--- Comment #14 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to m.a.riosv from comment #11)
> It is not a bug, LibreOffice it's very strict about numbers as text, only
> direct references are treated as numbers, text numbers in ranges a never
> converted.
While I have no objections against marking this as NOTABUG or WONTFIX, the
above explanation is faulty because SUM(A1,A2) with direct references gives the
same result (0) as SUM(A1:A2) with range reference.

-- 
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/20200603/731a98fe/attachment.htm>