https://bugs.documentfoundation.org/show_bug.cgi?id=102386
--- Comment #1 from [email protected] ---
Additionally I should mention that the Excel file was created through a
report-generation tool, it's downloaded through a website and since LO is the
default handler for xlsx files that's what opens them.
I don't have an Excel copy to replicate this. However I did try to create an
xlsx file in LO with a formula, save, re-open it - the issue doesn't occur.
Without knowing the particulars of xlsx format I would venture a guess that
maybe formula fields have a "last known result" attribute which gets saved when
the file is created in application, and when LO opens the file it initially
displays that value.
Since my files are created in some third party code it may not set this
attribute on the formula field, so it's defaulted to a "0"
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
