https://bugs.freedesktop.org/show_bug.cgi?id=77570
--- Comment #11 from Marco Gaiarin <[email protected]> --- (In reply to Matthew Francis from comment #10) > 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 Many thanks for the explanation. > 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. I can confirm that LO 4.2.7.2 on ubuntu, with a Ctrl+Shift+F9, recalculate correctly the cells. I can confirm that on windows also, but on windows i've set 'OOXMLRecalcMode' property now and sheets get recalculated on open, so i've simply opened it and was correct (version 4.2.8.2). > 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. I suggest to force a recalculation importing an excel file (or ask about it, or adding a prefs to do it), so we are sure that just conferted excel files does not suffer from ''cached data poisoning''. Thanks. -- 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
