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_TableValidation_idl__
29 #define __com_sun_star_sheet_TableValidation_idl__
31 #ifndef __com_sun_star_sheet_XSheetCondition_idl__
32 #include
<com
/sun
/star
/sheet
/XSheetCondition.idl
>
35 #ifndef __com_sun_star_beans_XPropertySet_idl__
36 #include
<com
/sun
/star
/beans
/XPropertySet.idl
>
39 #ifndef __com_sun_star_sheet_ValidationType_idl__
40 #include
<com
/sun
/star
/sheet
/ValidationType.idl
>
43 #ifndef __com_sun_star_sheet_ValidationAlertStyle_idl__
44 #include
<com
/sun
/star
/sheet
/ValidationAlertStyle.idl
>
47 //=============================================================================
49 module com
{ module sun
{ module star
{ module sheet
{
51 //=============================================================================
53 /** represents the data validation settings for a cell or cell range.
55 published service TableValidation
58 interface com
::sun
::star
::beans
::XPropertySet
;
60 interface com
::sun
::star
::sheet
::XSheetCondition
;
62 //=========================================================================
64 /** specifies the type of validation.
66 [property
] com
::sun
::star
::sheet
::ValidationType Type
;
68 //-------------------------------------------------------------------------
70 /** specifies if an input message is shown when the cursor is in a
71 cell with these validation settings.
73 [property
] boolean ShowInputMessage
;
75 //-------------------------------------------------------------------------
77 /** specifies the title of the window showing the input message.
79 <p>This is only used if <member>TableValidation::ShowInputMessage</member>
80 is set to <TRUE/>.</p>
82 [property
] string InputTitle
;
84 //-------------------------------------------------------------------------
86 /** specifies the text of the input message.
88 <p>This is only used if <member>TableValidation::ShowInputMessage</member>
89 is set to <TRUE/>.</p>
91 [property
] string InputMessage
;
93 //-------------------------------------------------------------------------
95 /** specifies if an error message is displayed when invalid data
98 [property
] boolean ShowErrorMessage
;
100 //-------------------------------------------------------------------------
102 /** specifies the title of the window showing the error message.
104 <p>This is only used if <member>TableValidation::ShowErrorMessage</member>
105 is set to <TRUE/>.</p>
107 [property
] string ErrorTitle
;
109 //-------------------------------------------------------------------------
111 /** specifies the text of the error message.
113 <p>This is only used if <member>TableValidation::ShowErrorMessage</member>
114 is set to <TRUE/>.</p>
116 [property
] string ErrorMessage
;
118 //-------------------------------------------------------------------------
120 /** specifies if blank cells should be allowed.
122 [property
] boolean IgnoreBlankCells
;
124 //-------------------------------------------------------------------------
126 /** specifies the style of the error message.
128 <p>This is used only if <member>TableValidation::ShowErrorMessage</member>
129 is set to <TRUE/>.</p>
131 [property
] com
::sun
::star
::sheet
::ValidationAlertStyle ErrorAlertStyle
;
133 //-------------------------------------------------------------------------
135 /** specifies if the list of possible values should be shown on the cell and how.
137 See also <type>TableValidationVisibility</type>
139 [optional,property
] short ShowList
;
143 //=============================================================================