<html> <head> <title>Service SpreadsheetDocumentSettings</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="SpreadsheetDocumentSettings-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</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">Services' Summary</td> <td class="navisub"><a href="#InterfacesSummary" class="navisub">Interfaces' Summary</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub">Services' Details</td> <td class="navisub"><a href="#InterfacesDetails" class="navisub">Interfaces' Details</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"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">deprecated </td> <td width="50%" class="title">service SpreadsheetDocumentSettings</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>deprecated</i></dd> <dt><b>Description</b></dt> <dd>contributes properties to control the configuration which is global for all views of a spreadsheet document. </dd> <dt><b>See also</b></dt> <dd><a href="SpreadsheetDocument.html">SpreadsheetDocument</a></dd> </dl> </td> </tr> </table> <hr> <a name="InterfacesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Summary</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"><p>provides access to the properties. </p> </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="#IsIterationEnabled">IsIterationEnabled</a></td> <td class="imsum_right">enables iterated calculation of circular references. </td> </tr> <tr> <td class="imsum_left">long<br> <a href="#IterationCount">IterationCount</a></td> <td class="imsum_right">specifies how many iterations are carried out. </td> </tr> <tr> <td class="imsum_left">double<br> <a href="#IterationEpsilon">IterationEpsilon</a></td> <td class="imsum_right">specifies the point at which a change in results will stop the iteration. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#StandardDecimals">StandardDecimals</a></td> <td class="imsum_right">specifies the number of decimals in the default number format. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/Date.html">Date</a><br> <a href="#NullDate">NullDate</a></td> <td class="imsum_right">specifies the date that is represented by the value zero. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#DefaultTabStop">DefaultTabStop</a></td> <td class="imsum_right">specifies the width of default tabulators. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IgnoreCase">IgnoreCase</a></td> <td class="imsum_right">specifies whether upper and lower cases are treated as equal when comparing cells. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#CalcAsShown">CalcAsShown</a></td> <td class="imsum_right">specifies whether calculations are performed with the rounded values displayed in cells (set to <b>true</b>) instead of the internal values (set to <b>false</b>). </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#MatchWholeCell">MatchWholeCell</a></td> <td class="imsum_right">specifies whether filter criteria must match entire cell contents. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#SpellOnline">SpellOnline</a></td> <td class="imsum_right">enables online spell checking. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#LookUpLabels">LookUpLabels</a></td> <td class="imsum_right">specifies whether column or row labels are looked up from anywhere on the sheet. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#RegularExpressions">RegularExpressions</a></td> <td class="imsum_right">specifies whether regular expressions in formulas are enabled, e.g., for functions which look up spreadsheet contents. </td> </tr> <tr> <td class="imsum_left">[ readonly ] ::com::sun::star::<a href="../i18n/module-ix.html">i18n</a>::<a href="../i18n/XForbiddenCharacters.html">XForbiddenCharacters</a><br> <a href="#ForbiddenCharacters">ForbiddenCharacters</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the interface XForbiddenCharacters. </td> </tr> <tr> <td class="imsum_left">[ readonly ] boolean<br> <a href="#HasDrawPages">HasDrawPages</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>If this property is set the document has DrawPages. Use this property to find out, whether the document has DrawPages or not, because the getDrawPage method on the XDrawPageSupplier and the getDrawPages method on the XDrawPagesSupplier always creates the DrawPages if there are none; and this is very slow and needs more memory. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/Locale.html">Locale</a><br> <a href="#CharLocale">CharLocale</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the standard document language for Western text. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/Locale.html">Locale</a><br> <a href="#CharLocaleAsian">CharLocaleAsian</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the standard document language for Asian text. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/Locale.html">Locale</a><br> <a href="#CharLocaleComplex">CharLocaleComplex</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the standard document language for Complex text. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IsLoaded">IsLoaded</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether the document data are already loaded. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IsUndoEnabled">IsUndoEnabled</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether the undo command is enabled. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IsAdjustHeightEnabled">IsAdjustHeightEnabled</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether the automatic adjustment of the row height is enabled. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IsExecuteLinkEnabled">IsExecuteLinkEnabled</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether the automatic execution of links is enabled. </td> </tr> <tr> <td class="imsum_left">[ readonly ] ::com::sun::star::<a href="../awt/module-ix.html">awt</a>::<a href="../awt/XDevice.html">XDevice</a><br> <a href="#ReferenceDevice">ReferenceDevice</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the reference device used for formatting the document. </td> </tr> </table> <a name="InterfacesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Details</td> </tr> <tr/> <tr> <td class="imdetail"><a name="XPropertySet" class="membertitle">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the properties. </dd> </dl> </td> </tr> </table> </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="IsIterationEnabled" class="membertitle">IsIterationEnabled</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsIterationEnabled</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>enables iterated calculation of circular references. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IterationCount" class="membertitle">IterationCount</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>long <b>IterationCount</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies how many iterations are carried out. </dd> <dd><p>This setting is only used, if iteration is enabled using <a href="SpreadsheetDocumentSettings.html">SpreadsheetDocumentSettings</a>::<a href="SpreadsheetDocumentSettings.html#IsIterationEnabled">IsIterationEnabled</a>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IterationEpsilon" class="membertitle">IterationEpsilon</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>double <b>IterationEpsilon</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the point at which a change in results will stop the iteration. </dd> <dd><p>More exactly it specifies a difference in the change of the result between two iterations. If the result difference is less than or equal to this epsilon-value, the iteration is stopped.</p> <p>This setting is only used, if iteration is enabled using <a href="SpreadsheetDocumentSettings.html">SpreadsheetDocumentSettings</a>::<a href="SpreadsheetDocumentSettings.html#IsIterationEnabled">IsIterationEnabled</a>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="StandardDecimals" class="membertitle">StandardDecimals</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>StandardDecimals</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the number of decimals in the default number format. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NullDate" class="membertitle">NullDate</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/Date.html">Date</a> <b>NullDate</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the date that is represented by the value zero. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DefaultTabStop" class="membertitle">DefaultTabStop</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>DefaultTabStop</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the width of default tabulators. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IgnoreCase" class="membertitle">IgnoreCase</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IgnoreCase</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether upper and lower cases are treated as equal when comparing cells. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CalcAsShown" class="membertitle">CalcAsShown</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>CalcAsShown</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether calculations are performed with the rounded values displayed in cells (set to <b>true</b>) instead of the internal values (set to <b>false</b>). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MatchWholeCell" class="membertitle">MatchWholeCell</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>MatchWholeCell</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether filter criteria must match entire cell contents. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SpellOnline" class="membertitle">SpellOnline</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>SpellOnline</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>enables online spell checking. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LookUpLabels" class="membertitle">LookUpLabels</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>LookUpLabels</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether column or row labels are looked up from anywhere on the sheet. </dd> <dd><p>Explicitly defined label ranges are used even if this property is set to <b>false</b>.</p> </dd> <dt><b>See also</b></dt> <dd><a href="LabelRanges.html">LabelRanges</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="RegularExpressions" class="membertitle">RegularExpressions</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>RegularExpressions</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies whether regular expressions in formulas are enabled, e.g., for functions which look up spreadsheet contents. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ForbiddenCharacters" class="membertitle">ForbiddenCharacters</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] ::com::sun::star::<a href="../i18n/module-ix.html">i18n</a>::<a href="../i18n/XForbiddenCharacters.html">XForbiddenCharacters</a> <b>ForbiddenCharacters</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the interface XForbiddenCharacters. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="HasDrawPages" class="membertitle">HasDrawPages</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] boolean <b>HasDrawPages</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>If this property is set the document has DrawPages. Use this property to find out, whether the document has DrawPages or not, because the getDrawPage method on the XDrawPageSupplier and the getDrawPages method on the XDrawPagesSupplier always creates the DrawPages if there are none; and this is very slow and needs more memory. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CharLocale" class="membertitle">CharLocale</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/Locale.html">Locale</a> <b>CharLocale</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the standard document language for Western text. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CharLocaleAsian" class="membertitle">CharLocaleAsian</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/Locale.html">Locale</a> <b>CharLocaleAsian</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the standard document language for Asian text. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CharLocaleComplex" class="membertitle">CharLocaleComplex</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/Locale.html">Locale</a> <b>CharLocaleComplex</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the standard document language for Complex text. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IsLoaded" class="membertitle">IsLoaded</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsLoaded</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether the document data are already loaded. </dd> <dt><b>Since </b></dt> <dd>OpenOffice 3.0</dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IsUndoEnabled" class="membertitle">IsUndoEnabled</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsUndoEnabled</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether the undo command is enabled. </dd> <dt><b>Since </b></dt> <dd>OpenOffice 3.0</dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IsAdjustHeightEnabled" class="membertitle">IsAdjustHeightEnabled</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsAdjustHeightEnabled</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether the automatic adjustment of the row height is enabled. </dd> <dt><b>Since </b></dt> <dd>OpenOffice 3.0</dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IsExecuteLinkEnabled" class="membertitle">IsExecuteLinkEnabled</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsExecuteLinkEnabled</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether the automatic execution of links is enabled. </dd> <dt><b>Since </b></dt> <dd>OpenOffice 3.0</dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ReferenceDevice" class="membertitle">ReferenceDevice</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] ::com::sun::star::<a href="../awt/module-ix.html">awt</a>::<a href="../awt/XDevice.html">XDevice</a> <b>ReferenceDevice</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the reference device used for formatting the document. </dd> <dt><b>Since </b></dt> <dd>OpenOffice 3.0</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 © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>