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)
(In reply to Oliver Elphick from comment #0) > 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. Because that QuickBooks (via Apache POI) generator had the document written with formula cells instead of value cells and also claimed the results to be 0.0 for each formula cell. Hence all cells display 0 until recalculated. > However the > file still loads as editable when it should be read only. Nothing in the attached document says it should be read-only.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ec912956903b2657f4a6b67a68c2687e8be32508 Resolves: tdf#147955 Recalculate OOXML for bad generators with all 0.0 results It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/154953 for 7-6
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-6": https://git.libreoffice.org/core/commit/69184e2eff8eeb1f2a0b10279c1d08f70b2e7000 Resolves: tdf#147955 Recalculate OOXML for bad generators with all 0.0 results It will be available in 7.6.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0e4429983eb73c8e0ce27feb3c5fa35bead64b88 tdf#147955: sc_subsequent_filters_test4: Add unittest It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.