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