Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 16 down vote accepted

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.


References to Other Sheets and Referencing URLs or other external data

See source:*

share|improve this answer
When I wrote my custom function, use it in one cell and update it's formula in Macro editor, I need to recalculate (CTRL + SHIFT + F9) cells to see effects. Even if I edit cell (F2 button) and I hit ENTER, I do not see updated formula (as long as I will not use CTRL + SHIFT + F9). I think that this "feature" might be a source of confusion. – matandked Mar 2 at 9:19

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

share|improve this answer

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.

share|improve this answer

You can replace '=' by '=' in all sheets.

Ctrl + H, mark 'Search in all sheets', Replace All '=' by '='

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.