Bug 147955 - FILEOPEN XLSX with formulas (=number) displays as zero
Summary: FILEOPEN XLSX with formulas (=number) displays as zero
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0 all versions
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-External-Generators
  Show dependency treegraph
 
Reported: 2022-03-13 05:52 UTC by Oliver Elphick
Modified: 2022-09-06 00:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
XLSX file generated by QuickBooks (4.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-03-13 05:52 UTC, Oliver Elphick
Details
Comparison LibreOffice 7.4 master and Excel 2016 (109.31 KB, image/png)
2022-03-28 09:28 UTC, Xisco Faulí
Details
sample file saved with Excel 2016 (9.17 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-03-28 09:30 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Elphick 2022-03-13 05:52:39 UTC
Created attachment 178854 [details]
XLSX file generated by QuickBooks

The attached XLSX file was generated by QuickBooks. In Excel it is supposed to load as a non-editable file. In LibreOffice it is editable immediately. In addition all the numeric fields are (for some reason!) the formula =123 rather than just 123 and when opened in LibreOffice they show as zero and are totalled as zero.

When such a field is edited and changed (add a space or decimal point) it becomes visible.

The default setting for Recalculate on load was "Never recalculate". When changed to "Always recalculate", the display problem goes away. However the file still loads as editable when it should be read only.
Comment 1 Xisco Faulí 2022-03-28 09:28:03 UTC
Created attachment 179158 [details]
Comparison LibreOffice 7.4 master and Excel 2016
Comment 2 Xisco Faulí 2022-03-28 09:28:35 UTC
Reproduced in

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 4a46a74a3de0ac7df5d3ce949dda5e809c1729ab
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded
Comment 3 Xisco Faulí 2022-03-28 09:29:16 UTC
Also reproduced in

Version: 6.0.0.0.alpha1+
Build ID: 6eeac3539ea4cac32d126c5e24141f262eb5a4d9
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3; 
Locale: es-ES (es_ES.UTF-8); Calc: group threaded
Comment 4 Xisco Faulí 2022-03-28 09:30:31 UTC
Created attachment 179159 [details]
sample file saved with Excel 2016

The issue is not reproducible after resaving the document with Excel 2016
Comment 5 Xisco Faulí 2022-03-28 09:31:52 UTC
Also reproduced in

Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)