:: com :: sun :: star :: sheet ::

interface XGlobalSheetSettings
Since
LibreOffice 4.1

Attributes' Summary
MoveSelection specifies whether the cursor is moved after entering into cells.  
MoveDirection contains the direction the cursor moves after entering cells.  
EnterEdit specifies whether the enter key can be used to start editing a cell.  
ExtendFormat specifies whether cell formatting is extended when entering data.  
RangeFinder specifies whether ranges are highlighted on the sheet when editing a formula.  
ExpandReferences specifies whether formula references are extended when cells are inserted below or to the right of them.  
MarkHeader specifies whether the current selection is highlighted in column and row headers.  
UseTabCol specifies whether the enter key moves the cursor to the column it was in before using the tab key to change columns.  
Metric contains the metric for all spreadsheet documents.  
Scale contains the default scale for new spreadsheet documents (in percent).  
DoAutoComplete specifies whether automatic completion of text in a cell is used.  
StatusBarFunction contains the function that is displayed in the status bar.  
UserLists contains the string lists used for sorting and filling.  
LinkUpdateMode specifies the update mode for external linked data.  
PrintAllSheets specifies whether all sheets or only selected sheets are printed.  
PrintEmptyPages specifies whether empty pages are printed.  
UsePrinterMetrics specifies whether printer metrics are used for display.  
ReplaceCellsWarning specifies whether a warning is shown before replacing cells (i.e. when pasting from clipboard).  
Attributes' Details
MoveSelection
boolean MoveSelection;
Description
specifies whether the cursor is moved after entering into cells.
MoveDirection
short MoveDirection;
Description
contains the direction the cursor moves after entering cells.
See also
MoveDirection
EnterEdit
boolean EnterEdit;
Description
specifies whether the enter key can be used to start editing a cell.
ExtendFormat
boolean ExtendFormat;
Description
specifies whether cell formatting is extended when entering data.
RangeFinder
boolean RangeFinder;
Description
specifies whether ranges are highlighted on the sheet when editing a formula.
ExpandReferences
boolean ExpandReferences;
Description
specifies whether formula references are extended when cells are inserted below or to the right of them.
MarkHeader
boolean MarkHeader;
Description
specifies whether the current selection is highlighted in column and row headers.
UseTabCol
boolean UseTabCol;
Description
specifies whether the enter key moves the cursor to the column it was in before using the tab key to change columns.
Metric
short Metric;
Description
contains the metric for all spreadsheet documents.
See also
::com::sun::star::util::MeasureUnit
Scale
short Scale;
Description
contains the default scale for new spreadsheet documents (in percent).

There are several special values:

-1 = Optimal width

-2 = Show whole page

-3 = Page width

DoAutoComplete
boolean DoAutoComplete;
Description
specifies whether automatic completion of text in a cell is used.
StatusBarFunction
short StatusBarFunction;
Description
contains the function that is displayed in the status bar.
See also
StatusBarFunction
UserLists
sequence< string > UserLists;
Description
contains the string lists used for sorting and filling.

Each string contains the members of a list, separated by commas.

LinkUpdateMode
short LinkUpdateMode;
Description
specifies the update mode for external linked data.

0 = always

1 = never

2 = on demand

PrintAllSheets
boolean PrintAllSheets;
Description
specifies whether all sheets or only selected sheets are printed.
PrintEmptyPages
boolean PrintEmptyPages;
Description
specifies whether empty pages are printed.
UsePrinterMetrics
boolean UsePrinterMetrics;
Description
specifies whether printer metrics are used for display.
ReplaceCellsWarning
boolean ReplaceCellsWarning;
Description
specifies whether a warning is shown before replacing cells (i.e. when pasting from clipboard).
Top of Page