https://bugs.documentfoundation.org/show_bug.cgi?id=99429
--- Comment #5 from raal <[email protected]> --- (In reply to c.cottignies from comment #4) > Thanks for helping. > It looks like it works, but I had to copy/paste the formulas in the cells. I > think automatic recalculation would have been done after closing/reloading > the file... > While in a spreadsheet, clicking Options-> LibreOfficecalc -> Formule, there > is a field for "file loading recalculation" option (always/no/On demand), > to be specified for Excel files or ODF files not saved by OpenOffice. > Default was "no recalculation"... may be it applies also for a file saved by > an earlier version of OpenOffice!.it was my case.... Any way that does not > explain why recalculation was not performed for the first 512 rows and > correctly done for the rest of the file.... The problem is that in the file are stored bad values(results) and when recalculation is turned off (for ods files is default off), then LO just show these bad values. When you set recalculation for .ods , then you should get good results. We need reproducible case where we can see bad results after save file. > I did not find in documentation the way to manually perfom a recalculation CTRL+Shift+F9 or data-Calculate-Recalculate(F9) https://help.libreoffice.org/Calc/Recalculate -- 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
