[Libreoffice-bugs] [Bug 130698] sum error when opening an xlsx in Calc

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Feb 19 17:24:29 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=130698

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
Note that the attached file was created by LibreOffice/6.0.7.3, not MS-Excel;
under some circumstances shared grouped formulas if copied/moved were not
recalculated before saving (e.g. on sheet Attendance in columns C, D, E).

I'm not sure if we always should recalculate documents saved with earlier
LibreOffice versions or whether there's a better approach. My take is
recalculate, maybe only if there are shared formula groups. Maybe even by
setting only those ranges dirty (which broadcasts to dependents), on the other
hand that might take longer than a forced recalc if there are a lot of formula
groups.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200219/6d5c5c56/attachment.htm>


More information about the Libreoffice-bugs mailing list