Issue 65109 - sumif does not recognize empty cells paraphrased with ""
Summary: sumif does not recognize empty cells paraphrased with ""
Status: CLOSED DUPLICATE of issue 65221
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, oooqa
Depends on: 50331
Blocks:
  Show dependency tree
 
Reported: 2006-05-05 13:06 UTC by plavrov
Modified: 2006-05-09 16:54 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Demonstrates wrong count of empty cells (7.50 KB, application/vnd.ms-excel)
2006-05-05 13:07 UTC, plavrov 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description plavrov 2006-05-05 13:06:41 UTC 
I am trying to sum the cells with keys equal to a constant string. With an empty
string as a pattern it fails: empty cell is not equal to an empty string. M$
Excel calculates it properly
Comment 1 plavrov 2006-05-05 13:07:42 UTC 
Created attachment 36283 [details]
Demonstrates wrong count of empty cells
Comment 2 Rainer Bielefeld 2006-05-05 18:04:18 UTC 
Of course the "" often is used to paraphrase "nothing", but currently I can't
see any evidence that OOo should recognize empty cells with description "", so
"OOo internal" it seems to work "as designed". But, if EXCEL really recognizes
and  counts empty cells in 'B$1:B$6' using '=SUMMEWENN(B$1:B$6;"";A$1:A$6)', we
have an import problem.

Unfortunately my knowledge is too poor for a final decision. Currently I do not
have any Idea how to describe "empty cell" in a formula.
Comment 3 Rainer Bielefeld 2006-05-05 18:05:56 UTC 
more meaningful summary
Comment 4 Rainer Bielefeld 2006-05-05 18:12:44 UTC 
We have a WONTFIX _ui_ issue 13702 for this, but I blieve for EXCEL import
affairs  this should be checked again.
Comment 5 plavrov 2006-05-08 15:18:25 UTC 
I am not sure I can agree that an empty cell should not be equal to "". Even if
I try to insert a string of zero characters into a cell, the result is the same. 
I see this is a duplicate to number of issues I have not found myself, but the
resolution WONTFIX seems doubtful.
Comment 6 Rainer Bielefeld 2006-05-08 16:03:11 UTC 
I see some relation to issue 50331

@plavrov:
May be you should VOTE for this issue ?!
Comment 7 Rainer Bielefeld 2006-05-08 16:13:58 UTC 
In issue 11273 you will find a workaround Replace your dondition "" by ">""" and
Sumif will count as you need - may be, some day I will understand, why :-/

My be the EXCEL import filter can do that replacement?
Comment 8 plavrov 2006-05-08 21:48:02 UTC 
Thanks. If I knew about the COUNTBLANK, it would be easier for me. :-)
">""" is worse as it is still incompatible with Excel.
Comment 9 ooo 2006-05-09 16:54:15 UTC 
Created consolidation issue 65221.

*** This issue has been marked as a duplicate of 65221 ***
Comment 10 ooo 2006-05-09 16:54:44 UTC 
Closing dupe.