https://bugs.freedesktop.org/show_bug.cgi?id=77570
Matthew Francis <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |[email protected] Resolution|--- |WORKSFORME --- Comment #10 from Matthew Francis <[email protected]> --- Spreadsheets (both Excel and ODS) store cached values for each cell alongside the formulae. The cached values are then used to avoid having to recalculate the whole file on each load. At some point in the past, it seems that the situation existed that LO didn't pay attention to the cached values, and also possibly wrote them incorrectly in some circumstances. The range of commits covered by comment 9 are where the handling of the cached values changed, and we started to trust what was written and not always recalculate on load Unfortunately it seems what we have here is a file which has incorrect cached values which we are now trusting to be correct. I don't see any evidence that there is a current issue with converting from Excel, and the solution for any individual file like this one is just to hard recalculate (Ctrl+Shift+F9) and save again. If there is any such issue with a file that is newly converted to ODS with a current release (4.4 or later) then of course we should investigate further, but on the assumption that there is no currently existing problem here I'm going to close this bug. -> RESOLVED WORKSFORME -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
