Overview | Module | Use | Devguide | Index

Included Services | Exported Interfaces | Properties' Summary | Properties' Details

:: com :: sun :: star :: sheet ::
service GlobalSheetSettings
Description contributes properties to access the settings for all spreadsheets of a spreadsheet document. Developers Guide 8.4.3 Spreadsheet Documents - Overall Document Features - Settings

Exported Interfaces
::com::sun::star::beans::XPropertySet | Description provides access to the properties.

Properties' 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 | [ OPTIONAL ] specifies the update mode for external linked data.
PrintAllSheets | [ OPTIONAL ] specifies whether all sheets or only selected sheets are printed.
PrintEmptyPages | [ OPTIONAL ] specifies whether empty pages are printed.
UsePrinterMetrics | [ OPTIONAL ] specifies whether printer metrics are used for display.
ReplaceCellsWarning | [ OPTIONAL ] specifies whether a warning is shown before replacing cells (i.e. when pasting from clipboard).

Properties' 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; [ OPTIONAL ] Description specifies the update mode for external linked data. 0 = always 1 = never 2 = on demand
PrintAllSheets
boolean PrintAllSheets; [ OPTIONAL ] Description specifies whether all sheets or only selected sheets are printed.
PrintEmptyPages
boolean PrintEmptyPages; [ OPTIONAL ] Description specifies whether empty pages are printed.
UsePrinterMetrics
boolean UsePrinterMetrics; [ OPTIONAL ] Description specifies whether printer metrics are used for display.
ReplaceCellsWarning
boolean ReplaceCellsWarning; [ OPTIONAL ] Description specifies whether a warning is shown before replacing cells (i.e. when pasting from clipboard).

Top of Page

Copyright © 2003 Sun Microsystems, Inc.