https://bugs.documentfoundation.org/show_bug.cgi?id=143943
--- Comment #3 from SheetJS <[email protected]> --- To be clear, 1 / TRUE / =TRUE() are not the same thing. Consider the sample file. Cell A3 is 1 and cell A4 is the boolean TRUE Do a small check in Excel: Set the cell D3 to the formula `=TYPE(A3)` and it returns 1 since A3 is a number. Set the cell D4 to the formula `=TYPE(A4)` and it returns 4 since A4 is a boolean. Do the same thing in LibreOffice: Set the cell D3 to the formula `=TYPE(A3)` and it returns 1 since A3 is a number Set the cell D4 to the formula `=TYPE(A4)` and it returns 8. It returns 8 because, according to the docs, "8 = formula". LibreOffice does have a fundamental understanding of booleans, as evidenced by the following sequence: set cell A7 to TRUE (just type TRUE in the formula bar and hit Enter) then set D7 =TYPE(A7) . That will return 4. As for the suggested workaround, it has no bearing on TYPE. Using the "Boolean Value" number format does not change the cell type. -- You are receiving this mail because: You are the assignee for the bug.
