1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <!-- Generated with glade 3.36.0 -->
3 <interface domain=
"sc">
4 <requires lib=
"gtk+" version=
"3.20"/>
5 <!-- n-columns=1 n-rows=1 -->
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 comparative 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=1 -->
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=1 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=
"xalign">0</property>
211 <property name=
"draw_indicator">True
</property>
212 <child internal-child=
"accessible">
213 <object class=
"AtkObject" id=
"allowempty-atkobject">
214 <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>
219 <property name=
"left_attach">1</property>
220 <property name=
"top_attach">1</property>
224 <object class=
"GtkCheckButton" id=
"showlist">
225 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|showlist">Show selection _list
</property>
226 <property name=
"visible">True
</property>
227 <property name=
"can_focus">True
</property>
228 <property name=
"receives_default">False
</property>
229 <property name=
"use_underline">True
</property>
230 <property name=
"xalign">0</property>
231 <property name=
"draw_indicator">True
</property>
232 <child internal-child=
"accessible">
233 <object class=
"AtkObject" id=
"showlist-atkobject">
234 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"validationcriteriapage|extended_tip|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 Ctrl+D.
</property>
239 <property name=
"left_attach">1</property>
240 <property name=
"top_attach">2</property>
244 <object class=
"GtkCheckButton" id=
"sortascend">
245 <property name=
"label" translatable=
"yes" context=
"validationcriteriapage|sortascend">Sor_t entries ascending
</property>
246 <property name=
"visible">True
</property>
247 <property name=
"can_focus">True
</property>
248 <property name=
"receives_default">False
</property>
249 <property name=
"margin_left">12</property>
250 <property name=
"use_underline">True
</property>
251 <property name=
"xalign">0</property>
252 <property name=
"active">True
</property>
253 <property name=
"draw_indicator">True
</property>
254 <child internal-child=
"accessible">
255 <object class=
"AtkObject" id=
"sortascend-atkobject">
256 <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>
261 <property name=
"left_attach">1</property>
262 <property name=
"top_attach">3</property>
266 <object class=
"GtkLabel" id=
"hintft">
267 <property name=
"can_focus">False
</property>
268 <property name=
"no_show_all">True
</property>
269 <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>
270 <property name=
"wrap">True
</property>
271 <property name=
"max_width_chars">50</property>
272 <property name=
"xalign">0</property>
273 <property name=
"yalign">0</property>
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"/>