https://bugs.freedesktop.org/show_bug.cgi?id=77343
Priority: medium
Bug ID: 77343
Assignee: [email protected]
Summary: FILTER: formula countif does not count text with "text
(text)"
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Steps to reproduce:
1. Cell A1 = "text (more text)"
2. Cell B1 = =COUNTIF(A1:A4,A1)
Current behavior:
Cell B1 = 0
Expected behavior:
Cell B1 = 1
Without the () the formula works correctly. ex:
1. Cell A1 = "text more text"
2. Cell B1 = =COUNTIF(A1:A4,A1)
Cell B1 = 1
Operating System: Windows 7
Version: 4.2.2.1 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs