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. 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. Indicates whether formulas instead of results are displayed in the cells. false Indicates whether numbers containing the 0 value are shown. true Indicates whether comments are marked. true Indicates whether all values are highlighted in the sheet (text black, numbers blue, others green). false Indicates whether anchor icons are displayed next to selected graphics in the document. true Indicates whether text overflow is marked via a small triangle. true Indicates whether objects and graphics are shown, hidden or replaced by a placeholder. Show Hide Show placeholders 0 Indicates whether charts are shown, hidden or replaced by a placeholder. Show Hide Show placeholders 0 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. 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. Specifies whether grid lines are displayed. true Specifies whether grid lines should be displayed on top of colored cells. false Specifies the color of the grid lines. 12632256 Specifies whether page breaks are displayed. true Specifies whether helplines are displayed when moving objects. false Specifies whether control points are displayed simple or enhanced. false Specifies whether control points are displayed as larger than the default size. true Contains settings that control which windows are shown around the editing window. Specifies whether row and column headers are displayed. true Specifies whether a horizontal scroll bar is displayed. true Specifies whether a vertical scroll bar is displayed. true Specifies whether sheet tabs are displayed. true Specifies whether outline symbols are displayed. true Specifies whether a summarizing dialog is displayed after search. true If true, a themed cursor is used (fat cross) otherwise the system default (arrow). false Contains other layout settings. Selects a set of functions that are calculated for the selected cells, and which show the results in the status bar. 514 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 1 Specifies if the tabbar should be shown inline with the scrollbar. false 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 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. Specifies the zoom type. Percentage value Whole page Width of a page 0 Specifies the percentage value to which the view is scaled. 100 Specifies if zoom is applied to all sheets of a document. true Contains settings that affect cell input. Specifies whether pressing the Enter key should move the selection. true Specifies the direction where the selection is moved when pressing Enter, if moving is enabled. Move down Move right Move up Move left 0 Specifies whether the selected cell can be edited immediately after pressing the Enter key. false Specifies whether formatting a cell also affects subsequently entered cells. false Specifies whether formula references from the input line are highlighted in color in the cell. true Specifies whether references are expanded when inserting columns or rows next to, above or below the reference range. false Specifies whether references get updated when performing sort on a range of cells. false Specifies whether column and row headers are highlighted in the selected columns or rows. true Specifies whether pressing Enter will move the cursor to the column where it was before the Tab key was used to change columns. false Specifies whether text metrics from the printer will be used to format text on the screen. false Specifies whether a warning box will appear when existing cells are replaced (i.e. pasting from clipboard). true Use legacy behaviour when selecting cells false Press Enter to paste and clear clipboard true Specifies the functions last used. SUM AVERAGE MIN MAX IF 224 226 222 223 6 Specifies whether the AutoInput function is active. true 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. Specifies whether frames, drawing elements and form functions are only movable between grid points. false Specifies whether the snap grid is matched with the main grid. true Specifies whether the grid is displayed. false Specifies whether the current grid settings are changed symmetrically. The resolution and subdivision for the X/Y axes remain the same. true 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 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. 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 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. Specifies the number of intervals between two grid points on the X axis. 1 Specifies the number of intervals between two grid points on the Y axis. 1 Contains the sort list settings. Specifies the available lists. NULL Contains the dialogs settings. Contains settings for DBF Import dialog Charset/Language -1 Contains settings for DBF Export dialog Charset/Language -1 Contains setting for Text CSV Export Char Set -1 Field delimiter Text delimiter If true, formatted cell content is exported. If false, raw cell content is exported. true If true, text formulas are exported instead of the calculated values. false If true, text cells are always enclosed in quotes with no exception. false All fields are exported having the same width false Contains setting for Text CSV Import Merge Delimiter check box status false If true, leading and trailing white spaces are trimmed off. false If true, formula expressions are evaluated, else set as text cell content. false If true, quoted field is always imported as text with no exception. false If true, Calc tries to detect special number format, such as date and scientific notation. false Language to use for CSV import. This determines how the numbers are parsed. 0 List of Separators - as a String ,; Text Separators " Fixed width false From Row 1 Char Set -1 Fixed Width List of separators Contains setting for Unformatted Text Import from Clipboard Merge Delimiter check box status false If true, leading and trailing white spaces are trimmed off. false If true, formula expressions are evaluated, else set as text cell content. true If true, quoted field is always imported as text with no exception. false If true, Calc tries to detect special number format, such as date and scientific notation. true If true, Calc preserves previous content of cells when pasting empty ones. If false, Calc delete content of previous cells. true Language to use for CSV import. This determines how the numbers are parsed. 0 List of Separators - as a String Text Separators " Fixed width false From Row 1 Char Set -1 Fixed Width List of separators Contains setting for Text to Columns Import Merge Delimiter check box status false If true, leading and trailing white spaces are trimmed off. false If true, formula expressions are evaluated, else set as text cell content. true List of Separators - as a String If true, Calc preserves previous content of cells when pasting empty ones. If false, Calc delete content of previous cells. false Text Separators " Fixed width false Fixed Width List of separators Contains settings that affect cell calculation. Contains settings for iterative calculation of circular references. Specifies whether iterative calculation is used for formulas with circular references. false Specifies the maximum number of iteration steps. 100 Specifies the result change value below which iteration is stopped. 0.001 Contains other calculation settings. Specifies whether upper and lower case in texts are distinguished when comparing cell contents. true Specifies whether the calculation uses the rounded values displayed in the sheet. false Specifies whether search criteria in formulas must match the whole of the cell contents. true 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. false Specifies the number of decimals to be displayed for the Standard number format. -1 Specifies whether the calculation uses regular expressions in formulas, e.g. for functions which look up sheet contents. false Specifies whether the calculation uses wildcards in formulas, e.g. for functions which look up sheet contents. true 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 how to calculate formulae. Whether to use threaded calculation of formula groups when applicable. true Whether to use OpenCL only when a formula uses only a subset of operator and function opcodes. true An approximate lower limit on the number of data cells a spreadsheet formula should use for OpenCL to be considered. 100 The list of operator and function opcodes (in English) for which to use OpenCL. If OpenCLSubsetOnly is true, and a formula contains only these operators and functions, it might be calculated using OpenCL. +;-;*;/;^;RAND;SIN;COS;TAN;ATAN;EXP;LN;SQRT;NORMSDIST;NORMSINV;ROUND;POWER;SUMPRODUCT;MIN;MAX;SUM;PRODUCT;AVERAGE;COUNT;VAR;NORMDIST;VLOOKUP;CORREL;COVAR;PEARSON;SLOPE;SUMIFS Whether to automatically select the OpenCL device true The Device ID of the OpenCL device selected if OpenCLAutoSelect is false Contains settings for formula syntax. Specifies what formula syntax type to use. Calc A1 Excel A1 Excel R1C1 Whether to use English function names or localized function names. false Argument separator in worksheet function Row separator in array constant Column separator in array constant Address syntax for reference in string for functions such as INDIRECT. same as formula grammar Calc A1 Excel A1 Excel R1C1 Whether to treat empty string formula result as equivalent of having a numeric zero value. false How to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Generate #VALUE! error Treat as zero Convert only unambiguous Convert also locale dependent Contains settings that affect formula handling while loading. 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 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. Specifies the modification color for changes of cell contents. -1 Specifies the color to highlight deletions. -1 Specifies the color to highlight insertions. -1 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. Indicates whether VBA macros are exported through the vba export code. true Indicates whether VBA macros are imported as comments. true Indicates whether VBA macros are imported without comments to be executable. true Indicates whether the original VBA storage is preserved while editing. true Contains settings for Lotus 1-2-3 import. Indicates whether the import of Lotus wk3 files is enabled. false Contains settings for MS Excel import. Specifies the factor for multiplying the column width when importing Excel documents from Biff 5 format. Specifies the minimum allowed value. 1.0 Specifies the factor for multiplying the row height when importing Excel documents from Biff 5 format. Specifies the minimum allowed value. 1.0 Contains settings for export filters. Contains settings for MS Excel export. Indicates whether sheet names should be truncated to 31 characters. true Contains settings that affect printing. Contains settings that affect which pages are printed. Specifies whether empty pages are printed. false Specifies whether manual row and column breaks should be forced, regardless of sheet scale settings. false Contains other print settings. Specifies whether all sheets are printed instead of only the selected sheets. false Contains miscellaneous settings. 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 Contains settings for shared documents. Specifies whether the warning box for shared documents is shown. true Contains various compatibility settings. Contains settings for merging cells. Specifies whether the Merge Cells dialog box is shown, when some cells are not empty. true Specifies whether to empty the contents of the hidden cells (like Excel does). false Contains options related to key bindings Specifies baseline key binding group to use. Default OpenOffice.org legacy Contains various defaults settings. Sheet defaults Option to set initial number of sheet tabs 1 Option to set the prefix name for new sheet tabs Enable very large spreadsheets (16m rows, 16384 cols) false data stream set the Timeout of DataStream updating 2000