I started using LibreOffice and when I had laid out the formulas I pressed F9 like I normally did in Excel and nothing happened.
I couldn't figure out the keyboard shortcut to refresh and neither could I find it in the application menu.
How do I do it?
Best Answer
Simple Recalculation:
Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.
Choose Data - Calculate - Recalculate
F9
Press F9 to recalculate. Press Shift+Ctrl+F9 to recalculate all formulas in the document.
After the document has been recalculated, the display is refreshed. All charts are also refreshed.
The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9. Press Shift+Ctrl+F9 to recalculate all formulas, including the Add-In functions.
Source: http://help.libreoffice.org/Calc/Recalculate
References to Other Sheets and Referencing URLs or other external data
See source: http://help.libreoffice.org/Calc/References_to_Other_Sheets_and_Referencing_URLs*