https://bugs.freedesktop.org/show_bug.cgi?id=42397
Bug #: 42397
Summary: : SUMIF fails if criteria text contains brackets
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.3.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: risimmon...@virginmedia.com
Created attachment 52910
--> https://bugs.freedesktop.org/attachment.cgi?id=52910
Image showing correct and incorrect behaviour side-by-side
Problem description: When using the SUMIF function, the function gives a result
of 0 if the cell referenced in the criteria (second argument) contains
brackets.
Steps to reproduce:
Enter the following data in A1:B6;
Primary Teacher 3
Secondary Teacher 7
Teachers (other) 5
Primary Teacher 3
Secondary Teacher 7
Teachers (other) 5
Enter the following in D1:D3;
Primary Teacher
Secondary Teacher
Teachers (other)
Enter the following formula in cell E1 and then copy down to E2 & E3
=SUMIF($A$1:$A$6,D1,$B$1:$B$6)
Note that the result for "Primary Teacher" is correct (ie 6), "Secondary
Teacher" is correct (ie 14), "Teachers (other)" is incorrect (result is 0).
Now search and replace "Teachers (other)" with "Other Teachers" and note that
the result is correct (ie 10).
Current behavior:
Expected behavior:
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
