1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <!-- Generated with glade 3.40.0 -->
3 <interface domain=
"sc">
4 <requires lib=
"gtk+" version=
"3.20"/>
5 <!-- n-columns=2 n-rows=8 -->
6 <object class=
"GtkGrid" id=
"ValidationCriteriaPage">
7 <property name=
"visible">True
</property>
8 <property name=
"can-focus">False
</property>
9 <property name=
"hexpand">True
</property>
10 <property name=
"vexpand">True
</property>
11 <property name=
"border-width">6</property>
12 <property name=
"row-spacing">6</property>
13 <property name=
"column-spacing">12</property>
15 <object class=
"GtkLabel" id=
"label1">
16 <property name=
"visible">True
</property>
17 <property name=
"can-focus">False
</property>
18 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|label1">_Allow:
</property>
19 <property name=
"use-underline">True
</property>
20 <property name=
"mnemonic-widget">allow
</property>
21 <property name=
"xalign">0</property>
24 <property name=
"left-attach">0</property>
25 <property name=
"top-attach">0</property>
29 <object class=
"GtkLabel" id=
"valueft">
30 <property name=
"can-focus">False
</property>
31 <property name=
"no-show-all">True
</property>
32 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|valueft">_Data:
</property>
33 <property name=
"use-underline">True
</property>
34 <property name=
"mnemonic-widget">data
</property>
35 <property name=
"xalign">0</property>
38 <property name=
"left-attach">0</property>
39 <property name=
"top-attach">4</property>
43 <object class=
"GtkComboBoxText" id=
"allow">
44 <property name=
"visible">True
</property>
45 <property name=
"can-focus">False
</property>
47 <item id=
"0" translatable=
"yes" context=
"validationcriteriapage|liststore1">All values
</item>
48 <item id=
"1" translatable=
"yes" context=
"validationcriteriapage|liststore1">Whole Numbers
</item>
49 <item id=
"2" translatable=
"yes" context=
"validationcriteriapage|liststore1">Decimal
</item>
50 <item id=
"3" translatable=
"yes" context=
"validationcriteriapage|liststore1">Date
</item>
51 <item id=
"4" translatable=
"yes" context=
"validationcriteriapage|liststore1">Time
</item>
52 <item id=
"5" translatable=
"yes" context=
"validationcriteriapage|liststore1">Cell range
</item>
53 <item id=
"6" translatable=
"yes" context=
"validationcriteriapage|liststore1">List
</item>
54 <item id=
"7" translatable=
"yes" context=
"validationcriteriapage|liststore1">Text length
</item>
55 <item id=
"8" translatable=
"yes" context=
"validationcriteriapage|liststore1">Custom
</item>
57 <child internal-child=
"accessible">
58 <object class=
"AtkObject" id=
"allow-atkobject">
59 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|allow">Click a validation option for the selected cell(s).
</property>
64 <property name=
"left-attach">1</property>
65 <property name=
"top-attach">0</property>
69 <object class=
"GtkComboBoxText" id=
"data">
70 <property name=
"can-focus">False
</property>
71 <property name=
"no-show-all">True
</property>
73 <item id=
"0" translatable=
"yes" context=
"validationcriteriapage|liststore2">equal
</item>
74 <item id=
"1" translatable=
"yes" context=
"validationcriteriapage|liststore2">less than
</item>
75 <item id=
"2" translatable=
"yes" context=
"validationcriteriapage|liststore2">greater than
</item>
76 <item id=
"3" translatable=
"yes" context=
"validationcriteriapage|liststore2">less than or equal
</item>
77 <item id=
"4" translatable=
"yes" context=
"validationcriteriapage|liststore2">greater than or equal to
</item>
78 <item id=
"5" translatable=
"yes" context=
"validationcriteriapage|liststore2">not equal
</item>
79 <item id=
"6" translatable=
"yes" context=
"validationcriteriapage|liststore2">valid range
</item>
80 <item id=
"7" translatable=
"yes" context=
"validationcriteriapage|liststore2">invalid range
</item>
82 <child internal-child=
"accessible">
83 <object class=
"AtkObject" id=
"data-atkobject">
84 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|data">Select the comparison operator that you want to use.
</property>
89 <property name=
"left-attach">1</property>
90 <property name=
"top-attach">4</property>
94 <object class=
"GtkLabel" id=
"minft">
95 <property name=
"visible">True
</property>
96 <property name=
"can-focus">False
</property>
97 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|minft">_Minimum:
</property>
98 <property name=
"use-underline">True
</property>
99 <property name=
"mnemonic-widget">mingrid
</property>
100 <property name=
"xalign">0</property>
103 <property name=
"left-attach">0</property>
104 <property name=
"top-attach">5</property>
108 <!-- n-columns=1 n-rows=2 -->
109 <object class=
"GtkGrid" id=
"mingrid">
110 <property name=
"visible">True
</property>
111 <property name=
"can-focus">False
</property>
112 <property name=
"hexpand">True
</property>
114 <!-- n-columns=2 n-rows=1 -->
115 <object class=
"GtkGrid" id=
"refgrid">
116 <property name=
"visible">True
</property>
117 <property name=
"can-focus">False
</property>
118 <property name=
"hexpand">True
</property>
119 <property name=
"column-spacing">12</property>
121 <object class=
"GtkEntry" id=
"min">
122 <property name=
"can-focus">True
</property>
123 <property name=
"no-show-all">True
</property>
124 <property name=
"hexpand">True
</property>
125 <property name=
"activates-default">True
</property>
126 <property name=
"truncate-multiline">True
</property>
127 <child internal-child=
"accessible">
128 <object class=
"AtkObject" id=
"min-atkobject">
129 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|min">Enter the minimum value for the data validation option that you selected in the Allow box.
</property>
134 <property name=
"left-attach">0</property>
135 <property name=
"top-attach">0</property>
139 <object class=
"GtkButton" id=
"validref">
140 <property name=
"can-focus">True
</property>
141 <property name=
"receives-default">True
</property>
142 <property name=
"no-show-all">True
</property>
143 <property name=
"halign">center
</property>
144 <property name=
"valign">center
</property>
147 <property name=
"left-attach">1</property>
148 <property name=
"top-attach">0</property>
153 <property name=
"left-attach">0</property>
154 <property name=
"top-attach">0</property>
158 <object class=
"GtkScrolledWindow" id=
"scrolledwindow2">
159 <property name=
"visible">True
</property>
160 <property name=
"can-focus">True
</property>
161 <property name=
"hexpand">True
</property>
162 <property name=
"vexpand">True
</property>
163 <property name=
"shadow-type">in
</property>
165 <object class=
"GtkTextView" id=
"minlist">
166 <property name=
"visible">True
</property>
167 <property name=
"can-focus">True
</property>
168 <property name=
"hexpand">True
</property>
169 <property name=
"vexpand">True
</property>
170 <child internal-child=
"accessible">
171 <object class=
"AtkObject" id=
"minlist-atkobject">
172 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|minlist">Enter the entries that will be valid values or text strings.
</property>
179 <property name=
"left-attach">0</property>
180 <property name=
"top-attach">1</property>
185 <property name=
"left-attach">1</property>
186 <property name=
"top-attach">5</property>
190 <object class=
"GtkLabel" id=
"maxft">
191 <property name=
"can-focus">False
</property>
192 <property name=
"no-show-all">True
</property>
193 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|maxft">Ma_ximum:
</property>
194 <property name=
"use-underline">True
</property>
195 <property name=
"mnemonic-widget">max
</property>
196 <property name=
"xalign">0</property>
199 <property name=
"left-attach">0</property>
200 <property name=
"top-attach">7</property>
204 <object class=
"GtkCheckButton" id=
"allowempty">
205 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|allowempty">Allow _empty cells
</property>
206 <property name=
"visible">True
</property>
207 <property name=
"can-focus">True
</property>
208 <property name=
"receives-default">False
</property>
209 <property name=
"use-underline">True
</property>
210 <property name=
"draw-indicator">True
</property>
211 <child internal-child=
"accessible">
212 <object class=
"AtkObject" id=
"allowempty-atkobject">
213 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|allowempty">In conjunction with Tools - Detective - Mark invalid Data, this defines that blank cells are shown as invalid data (disabled) or not (enabled).
</property>
218 <property name=
"left-attach">1</property>
219 <property name=
"top-attach">1</property>
223 <object class=
"GtkCheckButton" id=
"showlist">
224 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|showlist">Show selection _list
</property>
225 <property name=
"visible">True
</property>
226 <property name=
"can-focus">True
</property>
227 <property name=
"receives-default">False
</property>
228 <property name=
"use-underline">True
</property>
229 <property name=
"draw-indicator">True
</property>
230 <child internal-child=
"accessible">
231 <object class=
"AtkObject" id=
"showlist-atkobject">
232 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|showlist">Shows a list of all valid strings or values to select from.
</property>
237 <property name=
"left-attach">1</property>
238 <property name=
"top-attach">2</property>
242 <object class=
"GtkCheckButton" id=
"sortascend">
243 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|sortascend">Sor_t entries ascending
</property>
244 <property name=
"visible">True
</property>
245 <property name=
"can-focus">True
</property>
246 <property name=
"receives-default">False
</property>
247 <property name=
"margin-start">12</property>
248 <property name=
"use-underline">True
</property>
249 <property name=
"active">True
</property>
250 <property name=
"draw-indicator">True
</property>
251 <child internal-child=
"accessible">
252 <object class=
"AtkObject" id=
"sortascend-atkobject">
253 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|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.
</property>
258 <property name=
"left-attach">1</property>
259 <property name=
"top-attach">3</property>
263 <object class=
"GtkLabel" id=
"hintft">
264 <property name=
"can-focus">False
</property>
265 <property name=
"no-show-all">True
</property>
266 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|hintft">A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array.
</property>
267 <property name=
"wrap">True
</property>
268 <property name=
"max-width-chars">50</property>
269 <property name=
"xalign">0</property>
270 <property name=
"yalign">0</property>
272 <attribute name=
"scale" value=
"0.9"/>
276 <property name=
"left-attach">1</property>
277 <property name=
"top-attach">6</property>
281 <object class=
"GtkEntry" id=
"max">
282 <property name=
"can-focus">True
</property>
283 <property name=
"no-show-all">True
</property>
284 <property name=
"hexpand">True
</property>
285 <property name=
"activates-default">True
</property>
286 <property name=
"truncate-multiline">True
</property>
287 <child internal-child=
"accessible">
288 <object class=
"AtkObject" id=
"max-atkobject">
289 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|max">Enter the maximum value for the data validation option that you selected in the Allow box.
</property>
294 <property name=
"left-attach">1</property>
295 <property name=
"top-attach">7</property>
310 <child internal-child=
"accessible">
311 <object class=
"AtkObject" id=
"ValidationCriteriaPage-atkobject">
312 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|ValidationCriteriaPage">Specify the validation rules for the selected cell(s).
</property>
316 <object class=
"GtkSizeGroup" id=
"sizegroup1">
318 <widget name=
"label1"/>
319 <widget name=
"valueft"/>
320 <widget name=
"minft"/>
321 <widget name=
"maxft"/>