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