Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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

3 Answers 3

up vote 6 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.

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*

share|improve this answer

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

Your Answer

 
discard

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.