Re: COUNTBLANK function fault?

could oo has a function like ms onenote  so that it let users organise 
pictures, passages,videos and so on?
I really can't wait for it.

-----原始邮件----- 
From: Niklas Nebel
Sent: Tuesday, March 01, 2011 5:23 PM
To: [email protected]
Subject: [discuss] Re: COUNTBLANK function fault?

On 24.02.2011 00:31, Aubrey Hutton wrote:
> In the attached, please have a look at cell J12 on the (first) 'Summary'
> sheet. It reads incorrectly (should be 33%). It works in MS Office and
> on the Mac.
>
> Could it be that the cells being counted are populated with formulae?

Empty-string results (like ="") are not included in COUNTBLANK. That's
not wrong per se, and it's consistent with ISBLANK, but it can be a
problem because it's different from Excel. We have issue 65221 about
that, see http://openoffice.org/bugzilla/show_bug.cgi?id=65221.

Niklas
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help 

--