Bug with Boolean values [closed]

asked 2017-06-06 17:04:06 +0100

vandrouny gravatar image

updated 2020-10-06 13:02:19 +0100

Alex Kemp gravatar image

Here is XLSX file with some boolean columns.

MS Office 2007 Excel show it as TRUE/FALSE.

Libre Office 5.2.7.2 Calc show it all as 0 ("=FALSE()" on edit).

Really in sheet1.xml you can see

<c r="P3" s="2" t="b"><v>true</v></c>
<c r="Q3" s="2" t="b"><v>false</v></c>

[https://yadi.sk/i/qnGa7Pe63JsyhL]

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-06 13:02:28.790394