Issue 22510 - problem with NB.SI function
Summary: problem with NB.SI function
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-16 15:55 UTC by Unknown
Modified: 2003-11-17 10:39 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-11-16 15:55:30 UTC 
When you have ( or ) or [ or ] in a string and you want to count the number of
this string with the NB.SI function (NB.IF in english ?), the result are wrong.

For example :
   A   B
1 A(N  0
2
(with B2 : =NB.SI(A1:A2;A1) ).
And, in fact, the correct result must be 1.

I can reproduce the problem on :
- WindowsXP, OpenOffice 1.0.1 and 1.1.0
- Windows2k, OpenOffice 1.1.0
- Linux, OpenOffice 1.1.0
All version are the official binaries translated in french.

I try also to change the cell format, but the problem is also present.
But if you create a file in MS Excel with this function and you import it in
OpenOffice, the problem is not present.
Comment 1 Unknown 2003-11-16 21:30:43 UTC 
The NB.SI function is COUNTIF in english version.
Comment 2 frank 2003-11-17 10:38:58 UTC 
Hi,

this is not a bug.

The '(' is interpreted as part of a regular expression if you have
enabled the option 'allow regular expressions in formulas' undert
tools options spreadsheet calculate. If you deselect this option, your
formula works as expected by you.

Frank
Comment 3 frank 2003-11-17 10:39:18 UTC 
closed worksforme