OpenOffice.org 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.
General
Defines general settings for spreadsheet documents.
View
Defines which elements of the OpenOffice.org Calc main window are displayed. You can also show or hide highlighting of values in tables.
Calculate
Defines the calculation settings for spreadsheets. Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.
Sort Lists
All user-defined lists are displayed in the Sort Lists dialog. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.
Changes
The Changes dialog specifies various options for highlighting recorded changes in documents.
Grid
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.
Back
Resets modified values back to the OpenOffice.org default values.
Index
metrics,in sheets
tab stops, setting in sheets
cells, cursor positions after input (Calc)
edit mode, through Enter key (Calc)
formatting, expanding (Calc)
expanding formatting (Calc)
references, expanding (Calc)
column headers, highlighting (Calc)
row headers, highlighting (Calc)
cells, showing grid lines (Calc)
borders, cells on screen (Calc)
grids, displaying lines (Calc)
colors, grid lines and cells (Calc)
page breaks, displaying (Calc)
guides, showing (Calc)
handles, showing simple/large handles (Calc)
displaying, formulas instead of results (Calc)
formulas, displaying instead of results (Calc)
displaying, zero values (Calc)
zero values, displaying (Calc)
displaying, notes (Calc)
notes, displaying (Calc)
tables in spreadsheets, value highlighting
cells, formatting without effect (Calc)
cells, coloring (Calc)
anchors, displaying (Calc)
colors,restriction (Calc)
text overflow in spreadsheet cells
references, displaying in color (Calc)
objects, displaying in spreadsheets
pictures, displaying in Calc
charts, displaying (Calc)
draw objects, displaying (Calc)
row headers, displaying (Calc)
column headers, displaying (Calc)
scrollbars, displaying (Calc)
sheets, displaying sheet tabs
tabs, displaying sheet tabs
outline symbols (Calc)
references, iterative (Calc)
calculating,iterative references (Calc)
iterative references in spreadsheets
recursions in spreadsheets
dates, default (Calc)
dates, start 1900/01/01 (Calc)
dates, start 1904/01/01 (Calc)
cell contents, case sensitivity (Calc)
numbers, decimal places (Calc)
decimal places displayed (Calc)
precision as shown (Calc)
values, rounded as shown (Calc)
rounding precision (Calc)
tables in spreadsheets, values as shown
search criteria for database functions in cells
Excel, search criteria
columns, finding labels automatically (Calc)
rows, finding labels automatically (Calc)
finding, column and row labels (Calc)
grids, defaults (Writer/Calc)
defaults, grids (Writer/Calc)
snap grid defaults (Writer/Calc)
This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.
