Red Hat Bugzilla – Bug 217354
oocalc doens't consider a formula giving "" as blank
Last modified: 2007-11-30 17:11:50 EST
Description of problem:
In the spreadsheet attached, the formula in B1 gives "", so the formula at C1
should be TRUE, but isn't.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Look at attached spreadsheet
FALSE in C1
TRUE in C1
I'm sure it worked as I think it should at least up to August or so (this is
what I use when computing final grades to handle cases of people who are missing
a grade and gave an alternative test or similar)
missing attachment ?
Created attachment 142185 [details]
A spreadsheet showing the problem
ISBLANK: Returns TRUE if the reference to a cell is blank. This function is used
to determine if the content of a cell is empty. A cell with a formula inside is
And indeed I get "FALSE" like you do in devel, but also in FC-6 in 2.0.4 and
even also way back in FC-5 with 2.0.2 as well and in Excel. So this appears to
be the way it's supposed to be.
I don't understand what ISBLANK() is all about then... look at the new
spreadsheet attached, =if(isblank(<cell with formula evaluating to "">);"";<some
other junk>) behaves as if isblank() is true here (i.e., yields "")!
Created attachment 142222 [details]
New spreadsheet showing inconsistent behaviour
your example is...
A B C D
1 =IF(ISBLANK(A1);"";15) =ISBLANK(B1) =B1=""
2 =A2 =B2="" =B2=""
and results in...
A B C D
1 FALSE TRUE
2 0 FALSE FALSE
this is as expected, isblank is still FALSE for a cell that has any content in
it, including a formula, i.e. B1 isn't blank, though it's contents do evaluate
to an empty string as D1 shows.
There's nothing specific to fedora here, you might want to bring this up
upstream if you're unhappy with the behaviour.