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. 12/30/1899 (Standard) 01/01/1900 (StarCalc 1.0) 01/01/1904 Specifies the month. 12/30/1899 (Standard) 01/01/1900 (StarCalc 1.0) 01/01/1904 Specifies the day. 12/30/1899 (Standard) 01/01/1900 (StarCalc 1.0) 01/01/1904 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. Formulas false NN Indicates whether numbers containing the 0 value are shown. Zero values true NN Indicates whether comments are marked. Comment tags true NN Indicates whether all values are highlighted in the sheet (text black, numbers blue, others green). Value highlighting false NN Indicates whether anchor icons are displayed next to selected graphics in the document. Anchor true NN Indicates whether text overflow is marked via a small triangle. Text overflow true NN Indicates whether objects and graphics are shown, hidden or replaced by a placeholder. Objects and Graphics Show Hide Show placeholders 0 NN Indicates whether charts are shown, hidden or replaced by a placeholder. Charts Show Hide Show placeholders 0 NN Indicates whether drawing objects are shown, hidden or replaced by a placeholder. Drawing objects 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 Links 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. Grid lines true André Schnabel Specifies whether grid lines should be displayed on top of colored cells. Grid lines on colored background false NN Specifies the color of the grid lines. Color 12632256 NN Specifies whether page breaks are displayed. Page breaks true NN Specifies whether helplines are displayed when moving objects. Helplines false NN Specifies whether control points are displayed as simple squares without 3D effect. Simple control points false NN Specifies whether control points are displayed as larger than the default size. Large control points false Contains settings that control which windows are shown around the editing window. NN Specifies whether row and column headers are displayed. Column/Row headers true NN Specifies whether a horizontal scroll bar is displayed. Horizontal scroll true NN Specifies whether a vertical scroll bar is displayed. Vertical Scroll true NN Specifies whether sheet tabs are displayed. Sheet tabs true NN Specifies whether outline symbols are displayed. Outline symbols 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. Statusbar Function 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. Tab stops 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. Measurement unit 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. Zoom Type Percentage value Whole page Width of a page 0 NN Specifies the percentage value to which the view is scaled. Zoom Value 100 NN Specifies if zoom is applied to all sheets of a document. Synchronize sheets true Contains settings that affect cell input. NN Specifies whether pressing the Enter key should move the selection. Press Enter to move selection true NN Specifies the direction where the selection is moved when pressing Enter, if moving is enabled. Direction to move selection Move down Move right Move up Move left 0 NN Specifies whether the selected cell can be edited immediately after pressing the Enter key. Press Enter to switch to edit mode false NN Specifies whether formatting a cell also affects subsequently entered cells. Expand formatting false NN Specifies whether formula references from the input line are highlighted in color in the cell. Show references in color true NN Specifies whether references are expanded when inserting columns or rows next to, above or below the reference range. Expand references if new columns/rows are inserted false NN Specifies whether column and row headers are highlighted in the selected columns or rows. Highlight selection in column/row headings 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. Use Tab Column false NN Specifies whether text metrics from the printer will be used to format text on the screen. Use printer metrics for text formatting false NN Specifies whether a warning box will appear when existing cells are replaced (i.e. pasting from clipboard). Warn before replacing cells true NN Specifies the functions last used. Last Used Functions SUM AVERAGE MIN MAX IF 224 226 222 223 6 NN Specifies whether the AutoInput function is active. Auto Input true NN Specifies whether all the Detective traces in the sheet are automatically refreshed when modifying a formula. Detective Auto Refresh 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. Snap to grid false NN Specifies whether the snap grid is matched with the main grid. Size to grid true NN Specifies whether the grid is displayed. Visible grid false NN Specifies whether the current grid settings are changed symmetrically. The resolution and subdivision for the X/Y axes remain the same. Synchronize axes true NN Defines the horizontal distance between the single grid points in 1/100th millimeters. X axis 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. Y axis 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. X Axis Resolution 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. Y Axis Resolution 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. X Axis Subdivision 1 NN Specifies the number of intervals between two grid points on the Y axis. Y Axis Subdivision 1 Contains the sort list settings. NN Specifies the available lists. Lists NULL Contains the dialogs settings. Contains settings for DBF Import dialog muthusuba Charset/Language CharSet -1 Contains settings for DBF Export dialog muthusuba Charset/Language CharSet -1 Contains setting for Text CSV Import muthusuba Merge Delimiter check box status MergeDelimiters false kyoshida If true, quoted field is always imported as text with no exception. QuotedFieldAsText false kyoshida If true, Calc tries to detect special number format, such as date and scientific notation. DetectSpecialNumbers false kyoshida Language to use for CSV import. This determines how the numbers are parsed. Language 0 muthusuba List of Separators - as a String Separators ,; muthusuba Text Separators TextSeparators " muthusuba Fixed width FixedWidth false muthusuba From Row FromRow 1 muthusuba Char Set CharSet -1 muthusuba Fixed Width List of separators FixedWidthList 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. Iterations false NN Specifies the maximum number of iteration steps. Steps 100 NN Specifies the result change value below which iteration is stopped. Minimum Change 0.001 Contains other calculation settings. NN Specifies whether upper and lower case in texts are distinguished when comparing cell contents. Case sensitive true NN Specifies whether the calculation uses the rounded values displayed in the sheet. Precision as shown false NN Specifies whether search criteria in formulas must match the whole of the cell contents. Search criteria = and <> must apply to whole cells 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. Automatically find column and row labels true NN Specifies the number of decimals to be displayed for the Standard number format. Decimal places -1 NN Specifies whether the calculation uses regular expressions in formulas, e.g. for functions which look up sheet contents. Enable regular expressions in formulas 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 Grammar for INDIRECT function same as formula grammar Calc A1 Excel A1 Excel R1C1 Contains settings that affect revision marking. Specifies the colors for revision marking. NN Specifies the modification color for changes of cell contents. Changes -1 NN Specifies the color to highlight deletions. Deletions -1 NN Specifies the color to highlight insertions. Insertions -1 NN Specifies the color to highlight moved contents. Moved entries -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. Load Basic Code to edit true AB Indicates whether VBA macros are imported without comments to be executable. Executable code true NN Indicates whether the original VBA storage is preserved while editing. Save Original Basic Code again true Contains settings for Lotus 1-2-3 import. NN Indicates whether the import of Lotus wk3 files is enabled. Enable WK3 Filter false Contains settings for MS Excel import. NN Specifies the factor for multiplying the column width when importing Excel documents from Biff 5 format. Excel Column Width Scale Specifies the minimum allowed value. 1.0 NN Specifies the factor for multiplying the row height when importing Excel documents from Biff 5 format. Excel Row Height Scale 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. Printing Empty Pages false Contains other print settings. Specifies whether all sheets are printed instead of only the selected sheets. Print all 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. Default Object Size Specifies the default width in 1/100th millimeters. 8000 Specifies the default height in 1/100th millimeters. 5000 TBE Contains settings for shared documents. Shared document Specifies whether the warning box for shared documents is shown. Show warning box 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