Issue 50331 - COUNTBLANK() - MS-Excel compatibility
Summary: COUNTBLANK() - MS-Excel compatibility
Status: CLOSED DUPLICATE of issue 65221
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: ms_interoperability
Depends on:
Blocks: 65109
  Show dependency tree
 
Reported: 2005-06-05 13:36 UTC by gillou22
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Attachments
Countblank excel compatibility issue example (5.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-06-05 13:40 UTC, gillou22 		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 gillou22 2005-06-05 13:36:20 UTC 
When a cell contains a formula returning the empty string (""), COUNTBLANK 
counts it as an empty cell in MS-Excel. OpenOffice doesn't.
Comment 1 gillou22 2005-06-05 13:40:51 UTC 
Created attachment 26897 [details]
Countblank excel compatibility issue example
Comment 2 frank 2005-06-16 09:44:21 UTC 
Hi Eike,

I've re-flagged this Issue as Defect because the countblank function should
count blank *not* only empty cells. This is for logical and compatibility
reasons. A cell showing nothing as a result of a function (not Zero, this isn't
a blank cell, also one or more spaces aren't blank) has to be treated as a blank
cell.

Frank
Comment 3 ooo 2005-06-16 11:06:24 UTC 
Accepted.
Comment 4 gillou22 2006-03-07 21:16:27 UTC 
Is this issue going to be fixed ? That's quite some time it has been posted...
It would really help !
Thx
Comment 5 ooo 2006-05-09 16:51:54 UTC 
Created consolidation issue 65221.

*** This issue has been marked as a duplicate of 65221 ***
Comment 6 ooo 2006-05-09 16:52:49 UTC 
Closing dupe.