<html> <head> <title>Service GlobalSheetSettings</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="GlobalSheetSettings-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Settings" class="navimain">Devguide</a></td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub">Included Services</td> <td class="navisub"><a href="#ExportedInterfaces" class="navisub">Exported Interfaces</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub"><a href="#PropertiesDetails" class="navisub">Properties' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">service GlobalSheetSettings</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>contributes properties to access the settings for all spreadsheets of a spreadsheet document. </dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Settings">Spreadsheets - Settings</a></dd> </dl> </td> </tr> </table> <hr> <a name="ExportedInterfaces"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces</td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the properties. </dd> </dl> </td> </tr> </table> <a name="PropertiesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Properties' Summary</td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#MoveSelection">MoveSelection</a></td> <td class="imsum_right">specifies whether the cursor is moved after entering into cells. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#MoveDirection">MoveDirection</a></td> <td class="imsum_right">contains the direction the cursor moves after entering cells. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#EnterEdit">EnterEdit</a></td> <td class="imsum_right">specifies whether the enter key can be used to start editing a cell. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#ExtendFormat">ExtendFormat</a></td> <td class="imsum_right">specifies whether cell formatting is extended when entering data. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#RangeFinder">RangeFinder</a></td> <td class="imsum_right">specifies whether ranges are highlighted on the sheet when editing a formula. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#ExpandReferences">ExpandReferences</a></td> <td class="imsum_right">specifies whether formula references are extended when cells are inserted below or to the right of them. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#MarkHeader">MarkHeader</a></td> <td class="imsum_right">specifies whether the current selection is highlighted in column and row headers. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#UseTabCol">UseTabCol</a></td> <td class="imsum_right">specifies whether the enter key moves the cursor to the column it was in before using the tab key to change columns. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#Metric">Metric</a></td> <td class="imsum_right">contains the metric for all spreadsheet documents. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#Scale">Scale</a></td> <td class="imsum_right">contains the default scale for new spreadsheet documents (in percent). </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#DoAutoComplete">DoAutoComplete</a></td> <td class="imsum_right">specifies whether automatic completion of text in a cell is used. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#StatusBarFunction">StatusBarFunction</a></td> <td class="imsum_right">contains the function that is displayed in the status bar. </td> </tr> <tr> <td class="imsum_left">sequence< string ><br> <a href="#UserLists">UserLists</a></td> <td class="imsum_right">contains the string lists used for sorting and filling. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#LinkUpdateMode">LinkUpdateMode</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies the update mode for external linked data. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#PrintAllSheets">PrintAllSheets</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether all sheets or only selected sheets are printed. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#PrintEmptyPages">PrintEmptyPages</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether empty pages are printed. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#UsePrinterMetrics">UsePrinterMetrics</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether printer metrics are used for display. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#ReplaceCellsWarning">ReplaceCellsWarning</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether a warning is shown before replacing cells (i.e. when pasting from clipboard). </td> </tr> </table> <a name="PropertiesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Properties' Details</td> </tr> <tr> <td class="imdetail"><a name="MoveSelection" class="membertitle">MoveSelection</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>MoveSelection</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether the cursor is moved after entering into cells. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MoveDirection" class="membertitle">MoveDirection</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>MoveDirection</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the direction the cursor moves after entering cells. </dd> <dt><b>See also</b></dt> <dd><a href="MoveDirection.html">MoveDirection</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="EnterEdit" class="membertitle">EnterEdit</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>EnterEdit</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether the enter key can be used to start editing a cell. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ExtendFormat" class="membertitle">ExtendFormat</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>ExtendFormat</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether cell formatting is extended when entering data. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="RangeFinder" class="membertitle">RangeFinder</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>RangeFinder</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether ranges are highlighted on the sheet when editing a formula. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ExpandReferences" class="membertitle">ExpandReferences</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>ExpandReferences</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether formula references are extended when cells are inserted below or to the right of them. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MarkHeader" class="membertitle">MarkHeader</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>MarkHeader</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether the current selection is highlighted in column and row headers. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="UseTabCol" class="membertitle">UseTabCol</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>UseTabCol</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether the enter key moves the cursor to the column it was in before using the tab key to change columns. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Metric" class="membertitle">Metric</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>Metric</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the metric for all spreadsheet documents. </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/MeasureUnit.html">MeasureUnit</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Scale" class="membertitle">Scale</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>Scale</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the default scale for new spreadsheet documents (in percent). </dd> <dd><p>There are several special values:</p> <p>-1 = Optimal width</p> <p>-2 = Show whole page</p> <p>-3 = Page width</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DoAutoComplete" class="membertitle">DoAutoComplete</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>DoAutoComplete</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether automatic completion of text in a cell is used. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="StatusBarFunction" class="membertitle">StatusBarFunction</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>StatusBarFunction</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the function that is displayed in the status bar. </dd> <dt><b>See also</b></dt> <dd><a href="StatusBarFunction.html">StatusBarFunction</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="UserLists" class="membertitle">UserLists</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>sequence< string > <b>UserLists</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the string lists used for sorting and filling. </dd> <dd><p>Each string contains the members of a list, separated by commas.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LinkUpdateMode" class="membertitle">LinkUpdateMode</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>LinkUpdateMode</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies the update mode for external linked data. </dd> <dd><p>0 = always</p> <p>1 = never</p> <p>2 = on demand</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PrintAllSheets" class="membertitle">PrintAllSheets</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>PrintAllSheets</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether all sheets or only selected sheets are printed. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PrintEmptyPages" class="membertitle">PrintEmptyPages</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>PrintEmptyPages</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether empty pages are printed. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="UsePrinterMetrics" class="membertitle">UsePrinterMetrics</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>UsePrinterMetrics</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether printer metrics are used for display. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ReplaceCellsWarning" class="membertitle">ReplaceCellsWarning</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>ReplaceCellsWarning</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether a warning is shown before replacing cells (i.e. when pasting from clipboard). </dd> </dl> </td> </tr> </table> </td> </tr> </table> <br> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>