Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

service GlobalSheetSettings
Description
contributes properties to access the settings for all spreadsheets of a spreadsheet document.
Developers Guide
Spreadsheets - Settings

Exported Interfaces - Summary
::com::sun::star::beans::XPropertySet

provides access to the properties.

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

0 = always

1 = never

2 = on demand

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

 
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.