[Libreoffice-bugs] [Bug 121696] New: [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: lorma100 at arcor.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181124/3eb6543b/attachment-0001.html>