Description: The equality test used in SUMIF function does not return the same value than the IF equality test for which appears to be the same cases, resulting in simingly wrong values. Steps to Reproduce: Exemple can be reproduced as follow, using the format <Cell> = "Value in cell" : A2 = "Aaa" A3 = "BingoXyZ(ART)" A4 = "Ddd" B2 = "1" B3 = "1" B4 = "1" C2 = "Aaa" C3 = "BingoXyZ(ART)" C4 = "Ddd" D3 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)" D4 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)" D5 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)" E2 = "=SI(C2=A2;1;0)" E3 = "=SI(C2=A2;1;0)" E4 = "=SI(C2=A2;1;0)" The goal of this exemple is to show that the label "BingoXyZ(ART)" is not being recognized and so counted by the SUMIF function while testing equality with IF proves that the 2 values in A3 and C3 should have been reported as the same. Actual Results: Value returned in SUMIF cells are : D2 = "1" D3 = "0" D4 = "1" Expected Results: Results should have been : D2 = "1" D3 = "1" D4 = "1" Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0
Forgot to change the formulas in the exemple given after copy and paste. Should have been D3 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)" D4 = "=SUMIF($A$2:$A$4;C3;$B$2:$B$4)" D5 = "=SUMIF($A$2:$A$4;C4;$B$2:$B$4)" E2 = "=SI(C2=A2;1;0)" E3 = "=SI(C3=A3;1;0)" E4 = "=SI(C4=A4;1;0)"
SUMIF takes care of regular expression to search, while IF not. You have the options to use regular expressions, wildcards or non in Menu/Tools/Options/LibreOffice calc/calculate, There are parenthesis '(' and ')' what are part of regular expression. https://help.libreoffice.org/Common/List_of_Regular_Expressions
That way, your story will be more authentic, you’ll engage your audience by making yourself vulnerable, and you won’t seem like you’re just boasting. https://dltutuapp.com/tutuapp-download/ https://showbox.run/ https://kodi.software/
Based on Comment 2 I think this should be re-opened as a usability issue. However any solution would have impacts to backwards compatibility and maybe the ODF spec, etc. Solving this would not be simple, and the bug will likely just be re-closed as WF. But to spur discussion I will reopen anyway.