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> 14 <child> 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> 22 </object> 23 <packing> 24 <property name="left-attach">0</property> 25 <property name="top-attach">0</property> 26 </packing> 27 </child> 28 <child> 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> 36 </object> 37 <packing> 38 <property name="left-attach">0</property> 39 <property name="top-attach">4</property> 40 </packing> 41 </child> 42 <child> 43 <object class="GtkComboBoxText" id="allow"> 44 <property name="visible">True</property> 45 <property name="can-focus">False</property> 46 <items> 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> 56 </items> 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> 60 </object> 61 </child> 62 </object> 63 <packing> 64 <property name="left-attach">1</property> 65 <property name="top-attach">0</property> 66 </packing> 67 </child> 68 <child> 69 <object class="GtkComboBoxText" id="data"> 70 <property name="can-focus">False</property> 71 <property name="no-show-all">True</property> 72 <items> 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> 81 </items> 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> 85 </object> 86 </child> 87 </object> 88 <packing> 89 <property name="left-attach">1</property> 90 <property name="top-attach">4</property> 91 </packing> 92 </child> 93 <child> 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> 101 </object> 102 <packing> 103 <property name="left-attach">0</property> 104 <property name="top-attach">5</property> 105 </packing> 106 </child> 107 <child> 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> 113 <child> 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> 120 <child> 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> 130 </object> 131 </child> 132 </object> 133 <packing> 134 <property name="left-attach">0</property> 135 <property name="top-attach">0</property> 136 </packing> 137 </child> 138 <child> 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> 145 </object> 146 <packing> 147 <property name="left-attach">1</property> 148 <property name="top-attach">0</property> 149 </packing> 150 </child> 151 </object> 152 <packing> 153 <property name="left-attach">0</property> 154 <property name="top-attach">0</property> 155 </packing> 156 </child> 157 <child> 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> 164 <child> 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> 173 </object> 174 </child> 175 </object> 176 </child> 177 </object> 178 <packing> 179 <property name="left-attach">0</property> 180 <property name="top-attach">1</property> 181 </packing> 182 </child> 183 </object> 184 <packing> 185 <property name="left-attach">1</property> 186 <property name="top-attach">5</property> 187 </packing> 188 </child> 189 <child> 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> 197 </object> 198 <packing> 199 <property name="left-attach">0</property> 200 <property name="top-attach">7</property> 201 </packing> 202 </child> 203 <child> 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> 214 </object> 215 </child> 216 </object> 217 <packing> 218 <property name="left-attach">1</property> 219 <property name="top-attach">1</property> 220 </packing> 221 </child> 222 <child> 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. The list can also be opened by selecting the cell and pressing Ctrl+D.</property> 233 </object> 234 </child> 235 </object> 236 <packing> 237 <property name="left-attach">1</property> 238 <property name="top-attach">2</property> 239 </packing> 240 </child> 241 <child> 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> 254 </object> 255 </child> 256 </object> 257 <packing> 258 <property name="left-attach">1</property> 259 <property name="top-attach">3</property> 260 </packing> 261 </child> 262 <child> 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> 271 <attributes> 272 <attribute name="scale" value="0.9"/> 273 </attributes> 274 </object> 275 <packing> 276 <property name="left-attach">1</property> 277 <property name="top-attach">6</property> 278 </packing> 279 </child> 280 <child> 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> 290 </object> 291 </child> 292 </object> 293 <packing> 294 <property name="left-attach">1</property> 295 <property name="top-attach">7</property> 296 </packing> 297 </child> 298 <child> 299 <placeholder/> 300 </child> 301 <child> 302 <placeholder/> 303 </child> 304 <child> 305 <placeholder/> 306 </child> 307 <child> 308 <placeholder/> 309 </child> 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> 313 </object> 314 </child> 315 </object> 316 <object class="GtkSizeGroup" id="sizegroup1"> 317 <widgets> 318 <widget name="label1"/> 319 <widget name="valueft"/> 320 <widget name="minft"/> 321 <widget name="maxft"/> 322 </widgets> 323 </object> 324</interface> 325