https://bugs.documentfoundation.org/show_bug.cgi?id=153425
Bug ID: 153425
Summary: calc shows different representations (TRUE/FALSE/1/0)
of boolean data types stored in .xlxs starting near
row 50
Product: LibreOffice
Version: 7.5.0.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calc isn't consistent when displaying boolean values stored in .xlsx files.
Gnumeric, Excel, and GoogleSheets represent the same spreadsheet file data
differently than Calc.
Near row 50, libreoffice-calc switches from "TRUE" or "FALSE" text
representation to 1 or 0 integer value representations.
Steps to Reproduce:
1. In Excel, start a new spreadsheet.
2. Leave cell A1 empty.
3. Put 0 in cell A2, 1 in cell A3, and pull down on the lower corner of the
cell to fill 101 rows with increasing integers.
4. Put a title for column B in cell B1, like "column" or something
5. Put "TRUE" in B2 and "FALSE" in B3.
6. Select B2:B3 and then pull-down auto-fill, again, so that you have 100 rows
of True/False alternating values.
7. Save the file as standard "Excel Workbook" (.xlsx) file which is the newer
standard. I didn't test with "Strict OpenXML".
8. Now, save the same data as "Excel 97-2003" (.xls), too.
9. Open both export data files in Libre Office (calc)
Actual Results:
The .xls version opens fine, looks as expected.
The .xlsx version opens, but data is not shown in a consistent representation.
During my testing, the representation always starts out as "TRUE"/"FALSE", but
changes to 0/1 at least once around row 50, but not always on the same row, and
sometimes switches back and forth at least one more time within the first 100
rows.
Expected Results:
The same data type should have the same representation where identically
formatted. Since the data wasn't manually formatted, it is the default, and,
presumably, all the same in this example. Regardless, all other spreadsheet
programs work as expected with this data, so...
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.5.0.3 (X86_64)
Build ID: 50(Build:3)
CPU threads: 2; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
