[Libreoffice-bugs] [Bug 143943] [FILEOPEN] XLSB booleans interpreted as numeric formulae

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143943

--- Comment #3 from SheetJS <dev at sheetjs.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210819/54b11264/attachment-0001.htm>