https://bugs.freedesktop.org/show_bug.cgi?id=57368
Priority: medium
Bug ID: 57368
Assignee: [email protected]
Summary: FORMULA SUMIF with brackets
Severity: minor
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
