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

m_a_riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
                   |                            |rg
         Resolution|FIXED                       |NOTABUG

--- Comment #2 from m_a_riosv <[email protected]> ---
Those special characters are part of 'Regular expression', so disable the use
of regular expression, or escape them with a backslash before the '\(' oe '\)'
etc. Or using wildcards instead.
Menu>Tools>Options>LibreOffice Calc>Calculate>Formulas Wildcards.

Please take a look into:
https://ask.libreoffice.org/t/why-does-sumif-ignore-strings-with-parentheses/9955/4?u=mariosv

More detailed information in:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc

https://help.libreoffice.org/latest/en-US/text/shared/01/02100001.html?&DbPAR=CALC&System=WIN

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to