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

Office Calc Options

Defines various settings for spreadsheets, contents to be displayed, and the cursor direction after a cell entry. You can also define sorting lists, determine the number of decimal places and the settings for recording and highlighting changes.

To access this command...

Open a spreadsheet document, choose Tools - Options - Office Calc.


Defines general settings for spreadsheet documents.


Defines default settings for new spreadsheet documents.


Defines which elements of the Office Calc main window are displayed. You can also show or hide highlighting of values in tables.


Defines the calculation settings for spreadsheets. Defines the behaviour of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalisation or lower cases are to be considered when searching within sheets.


Defines formula syntax options and loading options for Office Calc.

Sort Lists

All user-defined lists are displayed in the Sort Lists dialogue box. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.


The Changes dialogue box specifies various options for highlighting recorded changes in documents.


Defines compatibility options for Office Calc.


Specifies the settings for the configurable grid on your document pages. This grid helps you determine the exact position of your objects. You can also set this grid in line with the "magnetic" snap grid.


Determines the printer settings for spreadsheets.


Resets changes made to the current tab to those applicable when this dialogue box was opened.