1 /*************************************************************************
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5 * Copyright 2000, 2010 Oracle and/or its affiliates.
7 * OpenOffice.org - a multi-platform office productivity suite
9 * This file is part of OpenOffice.org.
11 * OpenOffice.org is free software: you can redistribute it and/or modify
12 * it under the terms of the GNU Lesser General Public License version 3
13 * only, as published by the Free Software Foundation.
15 * OpenOffice.org is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU Lesser General Public License version 3 for more details
19 * (a copy is included in the LICENSE file that accompanied this code).
21 * You should have received a copy of the GNU Lesser General Public License
22 * version 3 along with OpenOffice.org. If not, see
23 * <http://www.openoffice.org/license.html>
24 * for a copy of the LGPLv3 License.
26 ************************************************************************/
28 #ifndef __com_sun_star_sheet_SpreadsheetDocumentSettings_idl__
29 #define __com_sun_star_sheet_SpreadsheetDocumentSettings_idl__
31 #ifndef __com_sun_star_beans_XPropertySet_idl__
32 #include
<com
/sun
/star
/beans
/XPropertySet.idl
>
35 #ifndef __com_sun_star_util_Date_idl__
36 #include
<com
/sun
/star
/util
/Date.idl
>
39 #ifndef __com_sun_star_i18n_XForbiddenCharacters_idl__
40 #include
<com
/sun
/star
/i18n
/XForbiddenCharacters.idl
>
43 #ifndef __com_sun_star_lang_Locale_idl__
44 #include
<com
/sun
/star
/lang
/Locale.idl
>
47 #ifndef __com_sun_star_awt_XDevice_idl__
48 #include
<com
/sun
/star
/awt
/XDevice.idl
>
51 //=============================================================================
53 module com
{ module sun
{ module star
{ module sheet
{
55 //=============================================================================
57 /** contributes properties to control the configuration which is global
58 for all views of a spreadsheet document.
62 @see com::sun::star::sheet::SpreadsheetDocument
64 published service SpreadsheetDocumentSettings
66 //-------------------------------------------------------------------------
68 //!published service PropertySet
69 /** provides access to the properties.
71 interface com
::sun
::star
::beans
::XPropertySet
;
73 //=========================================================================
75 /** enables iterated calculation of circular references.
77 [property
] boolean IsIterationEnabled
;
79 //-------------------------------------------------------------------------
81 /** specifies how many iterations are carried out.
83 <p>This setting is only used, if iteration is enabled using
84 <member>SpreadsheetDocumentSettings::IsIterationEnabled</member>.</p>
86 [property
] long IterationCount
;
88 //-------------------------------------------------------------------------
90 /** specifies the point at which a change in results will stop
93 <p>More exactly it specifies a difference in the change of the
94 result between two iterations. If the result difference
95 is less than or equal to this epsilon-value, the iteration
98 <p>This setting is only used, if iteration is enabled using
99 <member>SpreadsheetDocumentSettings::IsIterationEnabled</member>.</p>
101 [property
] double IterationEpsilon
;
103 //-------------------------------------------------------------------------
105 /** specifies the number of decimals in the default number format.
107 [property
] short StandardDecimals
;
109 //-------------------------------------------------------------------------
111 /** specifies the date that is represented by the value zero.
113 [property
] com
::sun
::star
::util
::Date NullDate
;
115 //-------------------------------------------------------------------------
117 /** specifies the width of default tabulators.
119 [property
] short DefaultTabStop
;
121 //-------------------------------------------------------------------------
123 /** specifies whether upper and lower cases are treated as equal
124 when comparing cells.
126 [property
] boolean IgnoreCase
;
128 //-------------------------------------------------------------------------
130 /** specifies whether calculations are performed with the rounded
131 values displayed in cells (set to <TRUE/>) instead of the
132 internal values (set to <FALSE/>).
134 [property
] boolean CalcAsShown
;
136 //-------------------------------------------------------------------------
138 /** specifies whether filter criteria must match entire cell contents.
140 [property
] boolean MatchWholeCell
;
142 //-------------------------------------------------------------------------
144 /** enables online spell checking.
146 [property
] boolean SpellOnline
;
148 //-------------------------------------------------------------------------
150 /** specifies whether column or row labels are looked up from
151 anywhere on the sheet.
153 <p>Explicitly defined label ranges are used even if this property
154 is set to <FALSE/>.</p>
156 @see com::sun::star::sheet::LabelRanges
158 [property
] boolean LookUpLabels
;
160 //-------------------------------------------------------------------------
162 /** specifies whether regular expressions in formulas are enabled,
163 e.g., for functions which look up spreadsheet contents.
165 [property
] boolean RegularExpressions
;
167 //-------------------------------------------------------------------------
169 /** contains the interface XForbiddenCharacters.
171 [readonly, optional, property
] com
::sun
::star
::i18n
::XForbiddenCharacters ForbiddenCharacters
;
173 //-------------------------------------------------------------------------
175 /** If this property is set the document has DrawPages. Use this
176 property to find out, whether the document has DrawPages or not,
177 because the getDrawPage method on the XDrawPageSupplier and the
178 getDrawPages method on the XDrawPagesSupplier always creates the
179 DrawPages if there are none; and this is very slow and needs more
182 [readonly, optional, property
] boolean HasDrawPages
;
184 //-------------------------------------------------------------------------
186 /** contains the standard document language for Western text.
188 [optional, property
] com
::sun
::star
::lang
::Locale CharLocale
;
190 //-------------------------------------------------------------------------
192 /** contains the standard document language for Asian text.
194 [optional, property
] com
::sun
::star
::lang
::Locale CharLocaleAsian
;
196 //-------------------------------------------------------------------------
198 /** contains the standard document language for Complex text.
200 [optional, property
] com
::sun
::star
::lang
::Locale CharLocaleComplex
;
202 //-------------------------------------------------------------------------
204 /** specifies whether the document data are already loaded.
208 [optional, property
] boolean IsLoaded
;
210 //-------------------------------------------------------------------------
212 /** specifies whether the undo command is enabled.
216 [optional, property
] boolean IsUndoEnabled
;
218 //-------------------------------------------------------------------------
220 /** specifies whether the automatic adjustment of the row height is
225 [optional, property
] boolean IsAdjustHeightEnabled
;
227 //-------------------------------------------------------------------------
229 /** specifies whether the automatic execution of links is enabled.
233 [optional, property
] boolean IsExecuteLinkEnabled
;
235 //-------------------------------------------------------------------------
237 /** contains the reference device used for formatting the document.
241 [readonly, optional, property
] com
::sun
::star
::awt
::XDevice ReferenceDevice
;
245 //=============================================================================