[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