https://bugs.documentfoundation.org/show_bug.cgi?id=95659
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |miguelangelrv@libreoffice.o
| |rg
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
Hi @Mark, thanks for reporting.
SUMIF uses regular expression (like extended wildcards), but more powerful.
https://help.libreoffice.org/3.3/Common/List_of_Regular_Expressions
+ is part of them.
Two solutions;
· Disable regular expressions in Menu/Tools/Options/LibreOffice
calc/Calculation - Regular expression.
· Escaape the plus for search with a backslash \+ if you want to use regex.
One trick, is involve the text to search with SUBSTITUTE function to replace in
the text to search the + with a \+, if you wan to use regex.
If you are not agree or is a different issue, please reopen the bug.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
