https://bugs.documentfoundation.org/show_bug.cgi?id=172175
--- Comment #4 from ady <[email protected]> --- With LO Calc (and with AOO), I get ZERO (FALSE). I don't have access to Excel, so I cannot really compare it, but the screenshot in comment 2 shows the result for Excel as TRUE. I don't know whether there is really a bug, or just a different accepted behavior between Calc and Excel, or whether it depends on some setting in Calc. Please keep in mind that, if "cell_reference" points to an empty cell in Calc, then ISNUMBER(cell_reference) is FALSE in Calc. Additionally, please keep in mind that there are other differences between Calc and Excel regarding Boolean types and functions. For instance, for "=ISNUMBER(TRUE())" Calc returns true (because there is no "boolean" types in Calc), whereas Excel returns false for the same formula. -- You are receiving this mail because: You are the assignee for the bug.
