Language Asturianu (ast) Català (ca) Čeština (cs) Dansk (da) Deutsch (de) English [US] (en-US) Español (es) Esperanto (eo) Eesti keel (et) Euskara (eu) Français (fr) Gàidhlig (gd) Galego (gl) Italiano (it) Lietuvių (lt) Magyar (hu) Nederlands (nl) Norsk (no) Polski (pl) Português [do Brasil] (pt-BR) Português [Europeu] (pt) Română (ro) Slovenčina (sk) Slovenščina (sl) Suomi (fi) Svenska (sv) Yкраїнська (uk) Tiếng Việt (vi) Türkçe (tr) ኦሮሚኛ (om) Հայերեն (hy) Ελληνικά (el) български език (bg) Русский (ru) Cрпски [ћирилицом] (sr) עברית (he) हिन्दी (hi) ភាសាខ្មែរ (km) தமிழ் (ta) ภาษาไทย (th) 简体中文 (zh-CN) 正體中文 (zh-TW) 日本語 (ja) 한국어 (ko)

The Free and Open Productivity Suite

• Product
• Download
• Support
• Blog
• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

home » api » docs » common » ref » com » sun » star » sheet

Overview

Module

Use

Devguide

Index

Services' Summary

Interfaces' Summary

Properties' Summary

Services' Details

Interfaces' Details

Properties' Details

---

:: 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

---

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

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.