https://bugs.documentfoundation.org/show_bug.cgi?id=102623
Bug ID: 102623
Summary: Including a parentheses character in a cell causes
Countif return an incorrect result.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: david.sarnow...@digitalmeasures.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:49.0)
Gecko/20100101 Firefox/49.0
Build Identifier: LibreOffice 5.2.1.2
I have a spreadsheet with data in one column and I am using the formula
=Countif(A:A,A1) to count the number of instances of certain values in the
column. When certain combinations of parentheses characters are included in the
cell, the countif formula returns a value of zero (0).
Excel correctly calculates the instances of the values in the column.
Reproducible: Always
Steps to Reproduce:
1. Create a new spreadsheet
2. Paste the following data into column A:
A
B
C
A
D
E
F
Chicken
Dog
Cat ()
()
(
)
Cat )
Cat (
Cat (
Cat )
Chicken
3. In cell B1 enter the following formula "=COUNTIF(A:A,A1)".
4. Copy this formula down in column B so each value in the column A has a
corresponding formula in column B.
Actual Results:
The formula in column B returns the following results:
2
1
1
2
1
1
1
2
1
0
0
1
1
0
0
0
0
2
Expected Results:
The results in column B should be
2
1
1
2
1
1
1
2
1
1
1
1
1
2
2
2
2
2
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs