https://bugs.freedesktop.org/show_bug.cgi?id=57368
Priority: medium Bug ID: 57368 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: FORMULA SUMIF with brackets Severity: minor Classification: Unclassified OS: Windows (All) Reporter: alexurba...@googlemail.com Hardware: x86-64 (AMD64) Status: UNCONFIRMED Version: 3.5.6.2 release Component: Spreadsheet Product: LibreOffice Created attachment 70365 --> https://bugs.freedesktop.org/attachment.cgi?id=70365&action=edit ODS file with above steps done. Problem: SUMIF does not work when selecting by Text with brackets. How to reproduce: (Either see attached file or) In empty spread sheet Enter A1 Text: "VK 3001 (H)" Enter B1 Number: 100 Enter D1 Text: "VK 3001 (H)" Enter E1 Formular: "=SUMIF(A1;D1;B1)" Enter A2 Text: "VK 3001 H" Enter B2 Number: 100 Enter D2 Text: "VK 3001 H" Enter E2 Formular: "=SUMIF(A2;D2;B2)" (or just pull down from E1) Result E1: Number 0 Result E2: Number 100 I am using German version. Info window says "LibreOffice 3.5.6.2 Build-ID: e0fbe70-5879838-a0745b0-0cd1158-638b327" -- 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