Recalculation of formulas in automatic mode

In automatic mode, only outdated formula values are recalculated when opening a document. If you want to force calculate all formulas in the document, press Ctrl+Shift+F9.