summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01/12120100.xhp
blob: ada3870930834f1805e6601c7a2adbd2e6a44625 (plain)
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
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
 -->

<meta>
<topic id="textscalc0112120100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Criteria</title>
<filename>/text/scalc/01/12120100.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
</history>
</meta>
<body>
<section id="criteria">
<bookmark xml-lang="en-US" branch="index" id="bm_id1464278"><bookmark_value>selection lists;validity</bookmark_value>
</bookmark><comment>UFI added index entry for new list feature. Guide needed. MW changed index entry</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage" id="bm_id3145673" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/@@nowidget@@" id="bm_id3145673" localize="false"/>
<h1 id="hd_id3153032" xml-lang="en-US"><link href="text/scalc/01/12120100.xhp" name="Criteria">Criteria</link></h1>
<paragraph role="paragraph" id="par_id3156327" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage">Specify the validation rules for the selected cell(s).</ahelp></paragraph>
</section>
<section id="howtoget">
  <embed href="text/scalc/00/00000412.xhp#datengueltigwerte"/>
</section>
<paragraph role="paragraph" id="par_id3155923" xml-lang="en-US">For example, you can define criteria such as: "Numbers between 1 and 10" or "Texts that are no more than 20 characters".</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/allow" id="bm_id3148663" localize="false"/>
<h2 id="hd_id3153896" xml-lang="en-US">Allow</h2>
<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/allow">Click a validation option for the selected cell(s).</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3148797" xml-lang="en-US">The following conditions are available:</paragraph>
<table id="tbl_id3150870">
<tablerow>
<tablecell>
<paragraph role="tablehead" id="par_id3150447" xml-lang="en-US">Condition</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablehead" id="par_id3155854" xml-lang="en-US">Effect</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_id3153092" xml-lang="en-US">All values</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3155411" xml-lang="en-US">No limitation.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_id3147434" xml-lang="en-US">Whole numbers</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3154319" xml-lang="en-US">Only whole numbers corresponding to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_id3145802" xml-lang="en-US">Decimal</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3153160" xml-lang="en-US">All numbers corresponding to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_id3149377" xml-lang="en-US">Date</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3150718" xml-lang="en-US">All numbers corresponding to the condition. The entered values are formatted accordingly the next time the dialog is called up.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_id3146969" xml-lang="en-US">Time</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3155066" xml-lang="en-US">All numbers corresponding to the condition. The entered values are formatted accordingly the next time the dialog is called up.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_idN106A0" xml-lang="en-US">Cell range</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_idN106A5" xml-lang="en-US">Allow only values that are given in a cell range. The cell range can be specified explicitly, or as a named database range, or as a named range. The range may consist of one column or one row of cells. If you specify a range of columns and rows, only the first column is used.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_idN106AB" xml-lang="en-US">List</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_idN106B0" xml-lang="en-US">Allow only values or strings specified in a list. Strings and values can be mixed. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid.</paragraph> <paragraph role="note" id="par_id221603980244052">Only up to 255 characters are saved, when using Excel format.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph role="tablecontent" id="par_id3154756" xml-lang="en-US">Text length</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3147339" xml-lang="en-US">Entries whose length corresponds to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id551607384650484" role="tablecontent">Custom</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id101607384677959" role="tablecontent">Only allow values that result in the formula entered in the <emph>Formula</emph> box to return <literal>TRUE</literal>, when the formula is calculated with the entered value. The formula can be any expression that evaluates to a boolean value of <literal>TRUE</literal> or <literal>FALSE</literal>, or returns a numerical value, where a nonzero value is interpreted as <literal>TRUE</literal> and <literal>0</literal> is interpreted as <literal>FALSE</literal>.</paragraph>
<paragraph role="tablecontent" id="par_id461607565255803">Formulas can use relative referencing. For example, if cells <literal>A1:A4</literal> were selected, the cursor is in cell <literal>A1</literal> and <input>ISODD(A1)</input> is entered into the <emph>Formula</emph> box, then only odd numbers could be entered into cells <literal>A1</literal> through <literal>A4</literal>.</paragraph>
</tablecell>
</tablerow>
</table>

<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/allowempty" id="bm_id263985" localize="false"/>
<h2 id="hd_id3154704" xml-lang="en-US">Allow blank cells</h2>
<paragraph role="paragraph" id="par_id3153967" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/allowempty">In conjunction with <emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank cells are shown as invalid data (disabled) or not (enabled).</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/showlist" id="bm_id5339518" localize="false"/>
<h2 id="par_idN10709" xml-lang="en-US">Show selection list</h2>
<paragraph role="paragraph" id="par_idN1070D" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/showlist">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing <switchinline select="sys"><caseinline select="MAC"><keycode>Command+D</keycode></caseinline><defaultinline><keycode>Ctrl+D</keycode></defaultinline></switchinline>.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/sortascend" id="bm_id6317331" localize="false"/>
<h3 id="par_idN10724" xml-lang="en-US">Sort entries ascending</h3>
<paragraph role="paragraph" id="par_idN10728" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/sortascend">Sorts the selection list in ascending order and filters duplicates from the list. If not checked, the order from the data source is taken.</ahelp></paragraph>
<h2 id="par_idN1073F" xml-lang="en-US">Source</h2>
<paragraph role="paragraph" id="par_idN10743" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/min">Enter the cell range that contains the valid values or text.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/minlist" id="bm_id5921506" localize="false"/>
<paragraph role="heading" id="par_idN1075A" xml-lang="en-US" level="2">Entries</paragraph>
<paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/minlist">Enter the entries that will be valid values or text strings.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/data" id="bm_id3147344" localize="false"/>
<paragraph role="heading" id="hd_id3163807" xml-lang="en-US" level="2">Data</paragraph>
<paragraph role="paragraph" id="par_id3144502" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/data">Select the comparative operator that you want to use.</ahelp> The available operators depend on what you selected in the <emph>Allow </emph>box. If you select "between" or "not between", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear. Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum</emph>, or the <emph>Value</emph> input boxes appear.</paragraph>
<paragraph role="heading" id="hd_id3153782" xml-lang="en-US" level="2">Value</paragraph>
<paragraph role="paragraph" id="par_id3153266" xml-lang="en-US">Enter the value for the data validation option that you selected in the <emph>Allow </emph>box.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/min" id="bm_id3149528" localize="false"/>
<h2 id="hd_id3149814" xml-lang="en-US">Minimum</h2>
<paragraph role="paragraph" id="par_id3153199" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/min">Enter the minimum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/max" id="bm_id3150206" localize="false"/>
<paragraph role="heading" id="hd_id3149035" xml-lang="en-US" level="2">Maximum</paragraph>
<paragraph role="paragraph" id="par_id3150089" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/max">Enter the maximum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp></paragraph>
</body>
</helpdocument>