https://bugs.documentfoundation.org/show_bug.cgi?id=147955
Bug ID: 147955
Summary: FILEOPEN XLSXwith formulas (=number) displays as zero
Product: LibreOffice
Version: 7.1.8.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: o...@lfix.co.uk
Created attachment 178854
--> https://bugs.documentfoundation.org/attachment.cgi?id=178854&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
