How do you refresh formulas in OpenOffice/LibreOffice Calc?

Question

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 what was the keyboard shortcut to refresh and neither I could find it on the application menu.

How do I do it? Thanks

Answer 1

Simple Recalculation: Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW. Choose Tools - Cell Contents - 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*

Answer 2

I found that if I pasted in an empty cell from where the formulas worked, then I could edit cells in the inserted column and they would evaluate. Of course, I had to do this for the entire column

Answer 3

I have found that if I insert a column between two existing columns, any formula I put into that column does not evaluate.

Recalculating does not help.

Putting the same formula into a column that was already part of the spreadsheet works properly.