Bug 94130 - NB.IF - pb when using parenthesis in the criteria string
Summary: NB.IF - pb when using parenthesis in the criteria string
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-11 12:45 UTC by laurence.vignollet
Modified: 2015-09-12 00:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description laurence.vignollet 2015-09-11 12:45:42 UTC 
(I use the French version)

NB.SI(B2:B17;"Pas intéressé(e) du tout") does not work.

NB.IF(B2:B17;"Pas intéressé du tout") works
Comment 1 m_a_riosv 2015-09-12 00:06:37 UTC 
Hi @laurence, thanks for reporting.

This report system has English as language.

I think your issue are the parenthesis in the text, they are part of the regular expression, so you need to escape it.
Try: NB.SI(B2:B17;"Pas intéressé\(e\) du tout")

If you are not used to regular expressions, you can disable it in:
Menu/Tools/LibreOffice calc/Calculate.

To know more about it search in the help for "regular expressions"

I think not a bug, please if you are not agree reopen it.

There is a Mailing List localized in French to ask.
http://nabble.documentfoundation.org/Users-f1744091.html