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 NN Specifies the color of the grid lines. 12632256 NN Specifies whether page breaks are displayed. true NN Specifies whether guides are displayed when moving objects. false NN Specifies whether control points are displayed simple or enhanced. false NN 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. 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 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 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 Specifies the date that is represented by the number 0. 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. false 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