To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85966
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Feb 8 14:29:15 +0000
2008 -------
I cannot confirm it. If the cell content is the number 0, isblank() returns
false and countblank() returns 0, which is both correct.
Whether an empty string is considered to be 'empty' is not determined in the
OASIS spec, it is allowed to be handled as 'empty', but also allowed to be
handled as 'not empty'.
OOo decides to handle it as 'not empty' in both cases, isblank() and
countblank(). Excel2007 handles it inconsistent: as 'not empty' in isblank() and
as 'empty' in countblank(). I do not think, that we should follow Excel in this
case.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
