NN
Contains settings for the spreadsheet application.
Describes a conversion between two units.
Specifies the name of the first unit.
Specifies the name of the second unit.
Specifies the conversion factor between the two units.
Describes a complete date value.
Specifies the year.
Specifies the month.
Specifies the day.
NN/ER
Specifies the Euro currency conversion rates and possibly other unit conversion rules for the CONVERT function.
Contains settings for spreadsheet content.
Specifies which contents are displayed in a spreadsheet.
NN
Indicates whether formulas instead of results are displayed in the cells.
false
NN
Indicates whether numbers containing the 0 value are shown.
true
NN
Indicates whether comments are marked.
true
NN
Indicates whether all values are highlighted in the sheet (text black, numbers blue, others green).
false
NN
Indicates whether anchor icons are displayed next to selected graphics in the document.
true
NN
Indicates whether text overflow is marked via a small triangle.
true
NN
Indicates whether objects and graphics are shown, hidden or replaced by a placeholder.
Show
Hide
Show placeholders
0
NN
Indicates whether charts are shown, hidden or replaced by a placeholder.
Show
Hide
Show placeholders
0
NN
Indicates whether drawing objects are shown, hidden or replaced by a placeholder.
Show
Hide
Show placeholders
0
Contains settings that specify how contents are updated.
NN
Specifies if and how links are updated when loading a document.
Update always
Update never
Update on request
2
Contains settings that affect the window layout.
Contains settings that control visual aids.
NN
Specifies whether grid lines are displayed.
true
André Schnabel
Specifies whether grid lines should be displayed on top of colored cells.
false
NN
Specifies the color of the grid lines.
12632256
NN
Specifies whether page breaks are displayed.
true
NN
Specifies whether helplines are displayed when moving objects.
false
NN
Specifies whether control points are displayed as simple squares without 3D effect.
false
NN
Specifies whether control points are displayed as larger than the default size.
false
Contains settings that control which windows are shown around the editing window.
NN
Specifies whether row and column headers are displayed.
true
NN
Specifies whether a horizontal scroll bar is displayed.
true
NN
Specifies whether a vertical scroll bar is displayed.
true
NN
Specifies whether sheet tabs are displayed.
true
NN
Specifies whether outline symbols are displayed.
true
Contains other layout settings.
NN
Selects a function that is calculated for the selected cells, and which shows the result in the status bar.
No function
Average
Number count
Count of all non-empty cells
Maximum
Minimum
Sum
9
NN
Specifies the distance between tabulator stops in 1/100th millimeters.
Specifies the tabulator distance with locales that use the metric system.
1250
Specifies the tabulator distance with locales that don't use the metric system.
1270
NN
Specifies the measurement unit to be used in the user interface.
Specifies the measurement unit that is used with locales that use the metric system.
Millimeter
Centimeter
Point
Pica
Inch
2
Specifies the measurement unit that is used with locales that don't use the metric system.
Millimeter
Centimeter
Point
Pica
Inch
8
Specifies the zoom for new spreadsheet documents.
NN
Specifies the zoom type.
Percentage value
Whole page
Width of a page
0
NN
Specifies the percentage value to which the view is scaled.
100
NN
Specifies if zoom is applied to all sheets of a document.
true
Contains settings that affect cell input.
NN
Specifies whether pressing the Enter key should move the selection.
true
NN
Specifies the direction where the selection is moved when pressing Enter, if moving is enabled.
Move down
Move right
Move up
Move left
0
NN
Specifies whether the selected cell can be edited immediately after pressing the Enter key.
false
NN
Specifies whether formatting a cell also affects subsequently entered cells.
false
NN
Specifies whether formula references from the input line are highlighted in color in the cell.
true
NN
Specifies whether references are expanded when inserting columns or rows next to, above or below the reference range.
false
NN
Specifies whether column and row headers are highlighted in the selected columns or rows.
true
NN
Specifies whether pressing Enter will move the cursor to the column where it was before the Tab key was used to change columns.
false
NN
Specifies whether text metrics from the printer will be used to format text on the screen.
false
NN
Specifies whether a warning box will appear when existing cells are replaced (i.e. pasting from clipboard).
true
NN
Specifies the functions last used.
SUM
AVERAGE
MIN
MAX
IF
224 226 222 223 6
NN
Specifies whether the AutoInput function is active.
true
NN
Specifies whether all the Detective traces in the sheet are automatically refreshed when modifying a formula.
true
Contains settings for the grid.
Contains settings that control the behavior of the grid.
NN
Specifies whether frames, drawing elements and form functions are only movable between grid points.
false
NN
Specifies whether the snap grid is matched with the main grid.
true
NN
Specifies whether the grid is displayed.
false
NN
Specifies whether the current grid settings are changed symmetrically. The resolution and subdivision for the X/Y axes remain the same.
true
NN
Defines the horizontal distance between the single grid points in 1/100th millimeters.
Specifies the distance that is used with locales that use the metric system.
1000
Specifies the distance that is used with locales that don't use the metric system.
1270
NN
Defines the vertical distance between the single grid points in 1/100th millimeters.
Specifies the distance that is used with locales that use the metric system.
1000
Specifies the distance that is used with locales that don't use the metric system.
1270
Specifies the grid's resolution.
NN
Defines the distance between grid points on the X axis in 1/100th millimeters.
Specifies the distance that is used with locales that use the metric system.
1000
Specifies the distance that is used with locales that don't use the metric system.
1270
NN
Defines the distance between grid points on the Y axis in 1/100th millimeters.
Specifies the distance that is used with locales that use the metric system.
1000
Specifies the distance that is used with locales that don't use the metric system.
1270
Specifies how the grid is divided.
NN
Specifies the number of intervals between two grid points on the X axis.
1
NN
Specifies the number of intervals between two grid points on the Y axis.
1
Contains the sort list settings.
NN
Specifies the available lists.
NULL
Contains the dialogs settings.
Contains settings for DBF Import dialog
muthusuba
Charset/Language
-1
Contains settings for DBF Export dialog
muthusuba
Charset/Language
-1
Contains setting for Text CSV Import
muthusuba
Merge Delimiter check box status
false
kyoshida
If true, quoted field is always imported as text with no exception.
false
kyoshida
If true, Calc tries to detect special number format, such as date and scientific notation.
false
kyoshida
Language to use for CSV import. This determines how the numbers are parsed.
0
muthusuba
List of Separators - as a String
,;
muthusuba
Text Separators
"
muthusuba
Fixed width
false
muthusuba
From Row
1
muthusuba
Char Set
-1
muthusuba
Fixed Width List of separators
Contains setting for Unformatted Text Import from Clipboard
muthusuba
Merge Delimiter check box status
false
kyoshida
If true, quoted field is always imported as text with no exception.
false
kyoshida
If true, Calc tries to detect special number format, such as date and scientific notation.
true
kyoshida
Language to use for CSV import. This determines how the numbers are parsed.
0
muthusuba
List of Separators - as a String
muthusuba
Text Separators
"
muthusuba
Fixed width
false
muthusuba
From Row
1
muthusuba
Char Set
-1
muthusuba
Fixed Width List of separators
Contains setting for Text to Columns Import
muthusuba
Merge Delimiter check box status
false
muthusuba
List of Separators - as a String
muthusuba
Text Separators
"
muthusuba
Fixed width
false
muthusuba
Fixed Width List of separators
Contains settings that affect cell calculation.
Contains settings for iterative calculation of circular references.
NN
Specifies whether iterative calculation is used for formulas with circular references.
false
NN
Specifies the maximum number of iteration steps.
100
NN
Specifies the result change value below which iteration is stopped.
0.001
Contains other calculation settings.
NN
Specifies whether upper and lower case in texts are distinguished when comparing cell contents.
true
NN
Specifies whether the calculation uses the rounded values displayed in the sheet.
false
NN
Specifies whether search criteria in formulas must match the whole of the cell contents.
true
NN
Specifies whether column and row labels are used to refer to the column area beneath the text cell or to the row area at the right of the text cell while running a search.
true
NN
Specifies the number of decimals to be displayed for the Standard number format.
-1
NN
Specifies whether the calculation uses regular expressions in formulas, e.g. for functions which look up sheet contents.
true
kyoshida
Specifies what formula syntax type to use.
Calc A1
Excel A1
Excel R1C1
Specifies the date that is represented by the number 0.
Contains settings that affect formula handling.
Contains settings for formula syntax.
kyoshida
Specifies what formula syntax type to use.
Calc A1
Excel A1
Excel R1C1
kyoshida
Whether to use English function names or localized function names.
false
kyoshida
Argument separator in worksheet function
kyoshida
Row separator in array constant
kyoshida
Column separator in array constant
kyoshida
Address syntax for reference in string for functions such as INDIRECT.
same as formula grammar
Calc A1
Excel A1
Excel R1C1
kyoshida
Whether to treat empty string formula result as equivalent of having a numeric zero value.
false
Contains settings that affect formula handling while laoding.
Markus Mohrhard
Specifies whether to force a hard recalc after load on OOXML-based Excel documents (2007 and newer).
Recalc always
Recalc never
Ask before Recalc
1
Kohei Yoshida
Specifies whether to force a hard recalc after load on non-LibreOffice-generated ODF documents.
Recalc always
Recalc never
Ask before Recalc
1
Contains settings that affect revision marking.
Specifies the colors for revision marking.
NN
Specifies the modification color for changes of cell contents.
-1
NN
Specifies the color to highlight deletions.
-1
NN
Specifies the color to highlight insertions.
-1
NN
Specifies the color to highlight moved contents.
-1
Contains settings for file format filters.
Contains settings for import filters.
Specifies how VBA macros are treated in Excel files.
NN
Indicates whether VBA macros are imported as comments.
true
AB
Indicates whether VBA macros are imported without comments to be executable.
true
NN
Indicates whether the original VBA storage is preserved while editing.
true
Contains settings for Lotus 1-2-3 import.
NN
Indicates whether the import of Lotus wk3 files is enabled.
false
Contains settings for MS Excel import.
NN
Specifies the factor for multiplying the column width when importing Excel documents from Biff 5 format.
Specifies the minimum allowed value.
1.0
NN
Specifies the factor for multiplying the row height when importing Excel documents from Biff 5 format.
Specifies the minimum allowed value.
1.0
NN
Contains settings that affect printing.
Contains settings that affect which pages are printed.
Specifies whether empty pages are printed.
false
Contains other print settings.
Specifies whether all sheets are printed instead of only the selected sheets.
false
Contains miscellaneous settings.
NN
Defines the default size of newly created objects using CTRL-Return or CTRL-Click at an object creating Button.
Specifies the default width in 1/100th millimeters.
8000
Specifies the default height in 1/100th millimeters.
5000
TBE
Contains settings for shared documents.
Specifies whether the warning box for shared documents is shown.
true
Contains various compatibility settings.
Contains options related to key bindings
Kohei Yoshida
Specifies baseline key binding group to use.
Default
OpenOffice.org legacy
Contains various defaults settings.
Sheet defaults
Albert Thuswaldner
Option to set initial number of sheet tabs
1
Albert Thuswaldner
Option to set the prefix name for new sheet tabs