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

Formula to value

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

To access this command...

Select a formula cell or a formula cell range and choose Data - Calculate - Formula to values

Use this command to convert formula cells into data cells. The converted cells contents becomes static and will not be recalculated.