https://bugs.documentfoundation.org/show_bug.cgi?id=160299
--- Comment #2 from ady <[email protected]> --- In Excel, there is such a thing as a boolean type of value, which is (usually, not always) automatically interpreted as a number when such conversion is required; in some cases, some function might be required. In Calc, boolean values _are_ numeric values. FALSE() is equivalent to zero; zero is equivalent to FALSE(). TRUE() is equivalent to one; any non-zero numeric value is equivalent to TRUE(). There might be cases in which users might take advantage of showing "Average:TRUE; Sum:TRUE". As described in comment 0, this already happens. Perhaps the similar "Average:FALSE; Sum:FALSE" case might have some advantage for some users. My only concern (as a user) would be a potential misinterpretation, either from what such status bar text means (a user that has no knowledge about boolean might misinterpret it as some kind of error/crash), or from misinterpreting other "kinds" of zero as "FALSE()" (including but not limiting [empty] cases). -- You are receiving this mail because: You are the assignee for the bug.
