https://bugs.documentfoundation.org/show_bug.cgi?id=121696

            Bug ID: 121696
           Summary: [EDITING] Usage of "Inequality" criteria in function
                    SUMIF creates wrong result
           Product: LibreOffice
           Version: 6.1.2.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Starting with V. 6.1 the function SUMIF creates wrong results.
When using "<> 0" as criteria the function adds all content of Sum Range
without checking the range content.
Problem occurs since switching from V. 6.0.6.2 (x64)to V. 6.1.2.1 (x64)

see example Example_Inequality.ods


Steps to Reproduce:
see Example_Inequality.ods

Actual Results:
see Example_Inequality.ods

Expected Results:
see Example_Inequality.ods


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to