From The Document Foundation Wiki
Jump to navigation Jump to search
  • During the loading of the sheet, the software recalculates... which is troublesome in the case of cumulative calculations. So you should take the precaution of deactivating this calculation automatically (menu Data ▸ Calculate ▸ AutoCalculate) and then carry out the recalculation "manually" by using Ctrl+⇧ Shift+F9.