1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104518"><META NAME="lcid" CONTENT="1033"><title>DataValidation element</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>DataValidation element</h1><p>Contains the data validation criteria, an input message, and elements related to error messages for a specified range.</p><h2>Usage</h2><pre>
<code>
<DataValidation />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="xtcoDataValidationType_HV01105098.htm" id="HV01105098" lcid="">DataValidationType</a></td>
</tr>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleRange_DataValidationType_HV01104917.htm" id="HV01104917" lcid="">Range</a></td>
<td>Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source.</td>
</tr>
<tr>
<td><a href="xeleType_HV01105035.htm" id="HV01105035" lcid="">Type</a></td>
<td>Specifies the type of axis scaling, chart, data source, 3-D shape, or trendline, the data validation constraints on data entered into a range, or the position of legend entries.</td>
</tr>
<tr>
<td><a href="xeleCellRangeList_HV01104468.htm" id="HV01104468" lcid="">CellRangeList</a></td>
<td>Specifies whether a list of values is used for data validation.</td>
</tr>
<tr>
<td><a href="xeleQualifier_DataValidationType_HV01104907.htm" id="HV01104907" lcid="">Qualifier</a></td>
<td>Contains the qualifier of a condition in conditional text formatting and data validation.</td>
</tr>
<tr>
<td><a href="xeleUseBlank_HV01105045.htm" id="HV01105045" lcid="">UseBlank</a></td>
<td>Specifies whether blank cells in a range are used when validating input data.</td>
</tr>
<tr>
<td><a href="xeleMin_HV01104744.htm" id="HV01104744" lcid="">Min</a></td>
<td>Specifies the minimum value to be used for tests that use the BETWEEN operator.</td>
</tr>
<tr>
<td><a href="xeleMaxChange_HV01104729.htm" id="HV01104729" lcid="">Max</a></td>
<td>Specifies the maximum value to be used for tests that use the BETWEEN operator.</td>
</tr>
<tr>
<td><a href="xeleValue1_HV01105052.htm" id="HV01105052" lcid="">Value</a></td>
<td>Specifies the value to be tested.</td>
</tr>
<tr>
<td><a href="xeleComboHide_HV01104484.htm" id="HV01104484" lcid="">ComboHide</a></td>
<td>Suppresses the list of acceptable values.</td>
</tr>
<tr>
<td><a href="xeleIMEMode_HV01104682.htm" id="HV01104682" lcid="">IMEMode</a></td>
<td>Specifies the status of the Input Method Editor (IME).</td>
</tr>
<tr>
<td><a href="xeleInputHide_HV01104685.htm" id="HV01104685" lcid="">InputHide</a></td>
<td>Specifies whether an input dialog box is displayed during data validation.</td>
</tr>
<tr>
<td><a href="xeleInputTitle_HV01104687.htm" id="HV01104687" lcid="">InputTitle</a></td>
<td>Contains the title of an input dialog box displayed during data validation.</td>
</tr>
<tr>
<td><a href="xeleInputMessage_HV01104686.htm" id="HV01104686" lcid="">InputMessage</a></td>
<td>Contains the input message displayed during data validation.</td>
</tr>
<tr>
<td><a href="xeleErrorHide_HV01104584.htm" id="HV01104584" lcid="">ErrorHide</a></td>
<td>Specifies whether error messages are displayed during data validation.</td>
</tr>
<tr>
<td><a href="xeleErrorStyle_HV01104587.htm" id="HV01104587" lcid="">ErrorStyle</a></td>
<td>Contains the style of a data validation error message.</td>
</tr>
<tr>
<td><a href="xeleErrorMessage_HV01104585.htm" id="HV01104585" lcid="">ErrorMessage</a></td>
<td>Contains the data validation error message that is displayed when invalid data is entered.</td>
</tr>
<tr>
<td><a href="xeleErrorTitle_HV01104588.htm" id="HV01104588" lcid="">ErrorTitle</a></td>
<td>Contains the title of an error dialog box displayed during data validation.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:element name="DataValidation" type="DataValidationType" >
</xsd:element>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
