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
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
