Issue 53946

Summary: SUMIF with single "=" criteria denoting empty cell doesn't work
Product: Calc Reporter: spiree <spiree>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, weigel
Version: OOO 2.0 Beta2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Simple Excel example using SUMIF none

Description spiree 2005-08-30 08:24:35 UTC 
à have a simple spreadsheet that sums the values in column B if the 
corresponding row in column A is empty. This works fine in Excel but 
apparently fails to work in OO.

See attachment. The result in Excel is "2" (since two cells in column A are 
empty) but in OO it's "0".
Comment 1 spiree 2005-08-30 08:25:43 UTC 
Created attachment 29157 [details]
Simple Excel example using SUMIF
Comment 2 frank 2005-09-21 14:34:28 UTC 
Hi Eike,

one for you. It's in there at leasrt since SO5.2.

The worst thing is that the opposit way, criteria changed to "<>" works perfectly.

So if possible re-target this one.

frank
Comment 3 ooo 2005-12-15 00:35:11 UTC 
Accepted.
Comment 4 ooo 2005-12-15 00:47:12 UTC 
*** Issue 25808 has been marked as a duplicate of this issue. ***
Comment 5 mathieuparent 2006-12-14 15:57:36 UTC 
linked with issue 65221 ?
Comment 6 ooo 2006-12-14 18:25:29 UTC 
Yes and no. This issue here is a special case of the "just an equal sign" for
comparing against emptyness, it is solvable without finding a consolidation for
issue 65221.
Comment 7 Stefan Weigel 2008-09-10 17:41:11 UTC 
+me to CC
Comment 8 Marcus 2017-05-20 11:13:46 UTC 
Reset assigne to the default "issues@openoffice.apache.org".