[Libreoffice-bugs] [Bug 131081] SUMIF with 1 conditional on a y/n match yields 0 in LibreOffice yet sums correctly in Google Sheet with same data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131081

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #6 from m.a.riosv <miguelangelrv at libreoffice.org> ---
So there it's not a but.

Calc it's strict about the use of string as number, and only works with a
direct reference, e.g. =A1 works but =SUM(A1:A1) not.

Some adjust can be done in Menu/Tools/Options/LibreOffice calc/Formula/Detailed
calculation settings.

-- 
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/20200304/00a2dbab/attachment.htm>