[Libreoffice-bugs] [Bug 108811] SOMME.SI / SUMIF equality tests returns wrong values - is not the same than IF equality test - in some cases

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 27 12:06:20 UTC 2017


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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
         Resolution|---                         |NOTABUG

--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
SUMIF takes care of regular expression to search, while IF not.

You have the options to use regular expressions, wildcards or non in
Menu/Tools/Options/LibreOffice calc/calculate,

There are parenthesis '(' and ')' what are part of regular expression.

https://help.libreoffice.org/Common/List_of_Regular_Expressions

-- 
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/20170627/8b170ced/attachment.html>


More information about the Libreoffice-bugs mailing list