Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Calculate

Commands to calculate formula cells.

To access this command...

Choose Data - Calculate

Recalculate

Recalculates formula cells.

Recalculate Hard

Recalculates all formulas in the document, including Add-In functions and non-volatile functions.

Formula to value

Replaces the formula cell with value calculated by the formula. The formula is lost.

AutoCalculate

Automatically recalculates all formulae in the document.