<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - [FILEOPEN] XLSB booleans interpreted as numeric formulae"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143943#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - [FILEOPEN] XLSB booleans interpreted as numeric formulae"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143943">bug 143943</a>
from <span class="vcard"><a class="email" href="mailto:dev@sheetjs.com" title="SheetJS <dev@sheetjs.com>"> <span class="fn">SheetJS</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>