https://bugs.documentfoundation.org/show_bug.cgi?id=155046
Bug ID: 155046
Summary: Boolean cells in XLSX display correctly in Excel as
"TRUE" or "FALSE" but incorrectly in Calc as "FALSE"
or "0"
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Boolean cells in an XLSX spreadsheet which display as expected in Excel (as
"TRUE" when true and as "FALSE" when false) do not display as expected in
LibreOffice Calc.
In Calc, booleans are displayed as "FALSE". They are never "TRUE".
Here is an XLSX where I have observed this problem in LibreOffice Calc:
http://files.pineapplemachine.com/public/logs/2023-04-27-libreoffice-boolean-bug.xlsx
Here is a screenshot of what I see when opening this XLSX file in LibreOffice
Calc (Note that all booleans are "FALSE"):
http://files.pineapplemachine.com/public/logs/2023-04-27-libreoffice-boolean-bug-calc.png
Here is a screenshot that a colleague provided when opening the same file in
Microsoft Excel (Note that booleans are variously "TRUE" or "FALSE"):
http://files.pineapplemachine.com/public/logs/2023-04-27-libreoffice-boolean-bug-excel.png
---
Sometimes, unpredictably, booleans display as "0". Prior to reporting this bug,
I observed that booleans in columns A-L of the linked spreadsheet displayed as
"FALSE" whereas booleans in columns N-Q displayed as "0". Reviewing this
behavior again to create the bug report, I observed that all of them are
"FALSE" and none of them are "0". However, I did uninstall and reinstall
LibreOffice Calc a few times in the course of troubleshooting, and so it is
possible this behavior differs between recent 7.5.2 builds.
Please specifically note that this behavior is regardless of the actual value
of the boolean. In Calc, booleans are always being displayed as "FALSE" or "0",
even for true values. They are never "TRUE" or "1".
---
Keywords: FORMATTING, VIEWING
Steps to Reproduce:
1. Obtain an XLSX spreadsheet containing booleans, such as:
http://files.pineapplemachine.com/public/logs/2023-04-27-libreoffice-boolean-bug.xlsx
2. Open the spreadsheet in Excel to observe how booleans are displayed (Or
refer to the screenshot linked in the description)
3. Open the spreadsheet in LibreOffice Calc to observe how booleans are
displayed differently from Excel (Or refer to the screenshot linked in the
description)
Actual Results:
Boolean cells show "FALSE", or sometimes "0", regardless of whether the boolean
value was true or false.
Expected Results:
Boolean cells with a true value should show "TRUE" and boolean cells with a
false value should show "FALSE".
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.5.2~rc2-0ubuntu0.22.04.1~lo1
Calc: threaded
Kubuntu 22.04
--
You are receiving this mail because:
You are the assignee for the bug.
