https://bugs.documentfoundation.org/show_bug.cgi?id=161235
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|unspecified |Inherited From OOo Resolution|--- |WONTFIX Status|UNCONFIRMED |RESOLVED --- Comment #2 from Eike Rathke <[email protected]> --- ODF _differentiates_ between implementations with and without distinct logical boolean types. See https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017898_715980110 and https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#Distinct_Logical There is no distinct logical boolean type in Calc. This is also not specific to AVERAGE(), all functions taking a NumberSequence are affected, like SUM() et al. Btw, try this in Excel: =AVERAGE(TRUE(),FALSE()) vs A1: =TRUE() A2: =FALSE() A3: =AVERAGE(A1:A2) Importing logical boolean values as anything else than numeric values is not an option (unless we throw away all current handling and come up with a distinct logical boolean type), and treating any strings as something different than strings would be plain wrong. Yes, Calc and Excel differ in this regard. -- You are receiving this mail because: You are the assignee for the bug.
