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.
Created attachment 179158 [details] Comparison LibreOffice 7.4 master and Excel 2016
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
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
Created attachment 179159 [details] sample file saved with Excel 2016 The issue is not reproducible after resaving the document with Excel 2016
Also reproduced in Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)