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): openoffice.org-calc-2.1.0-4.2 How reproducible: Always Steps to Reproduce: 1. Look at attached spreadsheet 2. 3. Actual results: FALSE in C1 Expected results: TRUE in C1 Additional info: 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
unfortunately <from help> 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 not empty. </from help> 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.