1/************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24#include "validate.hrc" 25 26 27TabDialog TAB_DLG_VALIDATION 28{ 29 OutputSize = TRUE ; 30 SVLook = TRUE ; 31 Size = MAP_APPFONT ( 289 , 176 ) ; 32 Moveable = TRUE ; 33 TabControl 1 34 { 35 OutputSize = TRUE ; 36 Size = MAP_APPFONT ( 260 , 135 ) ; 37 PageList = 38 { 39 PageItem 40 { 41 Identifier = TP_VALIDATION_VALUES ; 42 PageResID = TP_VALIDATION_VALUES ; 43 Text [ en-US ] = "Criteria"; 44 }; 45 PageItem 46 { 47 Identifier = TP_VALIDATION_INPUTHELP ; 48 PageResID = TP_VALIDATION_INPUTHELP ; 49 Text [ en-US ] = "Input Help" ; 50 }; 51 PageItem 52 { 53 Identifier = TP_VALIDATION_ERROR ; 54 PageResID = TP_VALIDATION_ERROR ; 55 Text [ en-US ] = "Error Alert" ; 56 }; 57 }; 58 }; 59 Text [ en-US ] = "Validity" ; 60}; 61//<!--Added by PengYunQuan for Validity Cell Range Picker 62#define OFFSET_X 30 63//-->Added by PengYunQuan for Validity Cell Range Picker 64TabPage TP_VALIDATION_VALUES 65{ 66 HelpID = "sc:TabPage:TP_VALIDATION_VALUES"; 67 Hide = TRUE ; 68 SVLook = TRUE ; 69 Size = MAP_APPFONT ( 260 , 185 ) ; 70 Text [ en-US ] = "Values" ; 71 FixedText FT_ALLOW 72 { 73 Pos = MAP_APPFONT ( 6 , 16 ) ; 74 //<!--Modified by PengYunQuan for Validity Cell Range Picker 75 //Size = MAP_APPFONT ( 70 , 8 ) ; 76 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 77 //-->Modified by PengYunQuan for Validity Cell Range Picker 78 Text [ en-US ] = "~Allow" ; 79 }; 80 ListBox LB_ALLOW 81 { 82 HelpID = "sc:ListBox:TP_VALIDATION_VALUES:LB_ALLOW"; 83 Border = TRUE ; 84 //<!--Modified by PengYunQuan for Validity Cell Range Picker 85 //Pos = MAP_APPFONT ( 80 , 14 ) ; 86 Pos = MAP_APPFONT ( 80 - OFFSET_X , 14 ) ; 87 //-->Modified by PengYunQuan for Validity Cell Range Picker 88 Size = MAP_APPFONT ( 90 , 80 ) ; 89 TabStop = TRUE ; 90 DropDown = TRUE ; 91 StringList [ en-US ] = 92 { 93 < "All values" ; SC_VALIDDLG_ALLOW_ANY ; > ; 94 < "Whole Numbers" ; SC_VALIDDLG_ALLOW_WHOLE ; > ; 95 < "Decimal" ; SC_VALIDDLG_ALLOW_DECIMAL ; > ; 96 < "Date" ; SC_VALIDDLG_ALLOW_DATE ; > ; 97 < "Time" ; SC_VALIDDLG_ALLOW_TIME ; > ; 98 < "Cell range" ; SC_VALIDDLG_ALLOW_RANGE ; > ; 99 < "List" ; SC_VALIDDLG_ALLOW_LIST ; > ; 100 < "Text length" ; SC_VALIDDLG_ALLOW_TEXTLEN ; > ; 101 }; 102 }; 103 FixedText FT_VALUE 104 { 105 Pos = MAP_APPFONT ( 6 , 58 ) ; 106 //<!--Modified by PengYunQuan for Validity Cell Range Picker 107 //Size = MAP_APPFONT ( 70 , 8 ) ; 108 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 109 //-->Modified by PengYunQuan for Validity Cell Range Picker 110 Text [ en-US ] = "~Data" ; 111 }; 112 ListBox LB_VALUE 113 { 114 HelpID = "sc:ListBox:TP_VALIDATION_VALUES:LB_VALUE"; 115 Border = TRUE ; 116 //<!--Modified by PengYunQuan for Validity Cell Range Picker 117 //Pos = MAP_APPFONT ( 80 , 56 ) ; 118 Pos = MAP_APPFONT ( 80 - OFFSET_X , 56 ) ; 119 //-->Modified by PengYunQuan for Validity Cell Range Picker 120 Size = MAP_APPFONT ( 90 , 90 ) ; 121 TabStop = TRUE ; 122 DropDown = TRUE ; 123 // Reihenfolge entspricht enum ScConditionMode 124 StringList [ en-US ] = 125 { 126 < "equal" ; SC_VALIDDLG_DATA_EQUAL ; > ; 127 < "less than" ; SC_VALIDDLG_DATA_LESS ; > ; 128 < "greater than" ; SC_VALIDDLG_DATA_GREATER ; > ; 129 < "less than or equal" ; SC_VALIDDLG_DATA_EQLESS ; > ; 130 < "greater than or equal to" ; SC_VALIDDLG_DATA_EQGREATER ; > ; 131 < "not equal" ; SC_VALIDDLG_DATA_NOTEQUAL ; > ; 132 < "between" ; SC_VALIDDLG_DATA_BETWEEN ; > ; 133 < "not between" ; SC_VALIDDLG_DATA_NOTBETWEEN ; > ; 134 }; 135 }; 136 FixedText FT_MIN 137 { 138 Pos = MAP_APPFONT ( 6 , 76 ) ; 139 //<!--Modified by PengYunQuan for Validity Cell Range Picker 140 //Size = MAP_APPFONT ( 70 , 8 ) ; 141 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 142 //-->Modified by PengYunQuan for Validity Cell Range Picker 143 Text [ en-US ] = "~Minimum" ; 144 }; 145 Edit EDT_MIN 146 { 147 HelpID = "sc:Edit:TP_VALIDATION_VALUES:EDT_MIN"; 148 Border = TRUE ; 149 //<!--Modified by PengYunQuan for Validity Cell Range Picker 150 //Pos = MAP_APPFONT ( 80 , 74 ) ; 151 //Size = MAP_APPFONT ( 174 , 12 ) ; 152 Pos = MAP_APPFONT ( 80 - OFFSET_X , 74 ) ; 153 Size = MAP_APPFONT ( 90 , 12 ) ; 154 //-->Modified by PengYunQuan for Validity Cell Range Picker 155 TabStop = TRUE ; 156 }; 157 MultiLineEdit EDT_LIST 158 { 159 HelpID = "sc:MultiLineEdit:TP_VALIDATION_VALUES:EDT_LIST"; 160 Border = TRUE ; 161 //<!--Modified by PengYunQuan for Validity Cell Range Picker 162 //Pos = MAP_APPFONT ( 80 , 74 ) ; 163 //Size = MAP_APPFONT ( 174 , 105 ) ; 164 Pos = MAP_APPFONT ( 80 - OFFSET_X , 74 ) ; 165 Size = MAP_APPFONT ( 174 + OFFSET_X , 105 ) ; 166 //-->Modified by PengYunQuan for Validity Cell Range Picker 167 VScroll = TRUE ; 168 IgnoreTab = TRUE ; 169 }; 170 FixedText FT_MAX 171 { 172 Pos = MAP_APPFONT ( 6 , 92 ) ; 173 //<!--Modified by PengYunQuan for Validity Cell Range Picker 174 //Size = MAP_APPFONT ( 70 , 8 ) ; 175 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 176 //-->Modified by PengYunQuan for Validity Cell Range Picker 177 Text [ en-US ] = "Ma~ximum" ; 178 }; 179 Edit EDT_MAX 180 { 181 HelpID = "sc:Edit:TP_VALIDATION_VALUES:EDT_MAX"; 182 Border = TRUE ; 183 //<!--Modified by PengYunQuan for Validity Cell Range Picker 184 //Pos = MAP_APPFONT ( 80 , 90 ) ; 185 //Size = MAP_APPFONT ( 174 , 12 ) ; 186 Pos = MAP_APPFONT ( 80 - OFFSET_X , 90 ) ; 187 Size = MAP_APPFONT ( 90 , 12 ) ; 188 //-->Modified by PengYunQuan for Validity Cell Range Picker 189 TabStop = TRUE ; 190 }; 191 CheckBox TSB_ALLOW_BLANKS 192 { 193 HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS"; 194 //<!--Modified by PengYunQuan for Validity Cell Range Picker 195 //Pos = MAP_APPFONT ( 80 , 30 ) ; 196 Pos = MAP_APPFONT ( 80 - OFFSET_X , 30 ) ; 197 //-->Modified by PengYunQuan for Validity Cell Range Picker 198 Size = MAP_APPFONT ( 174 , 10 ) ; 199 TabStop = TRUE ; 200 Text [ en-US ] = "Allow ~blank cells" ; 201 }; 202 CheckBox CB_SHOWLIST 203 { 204 HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:CB_SHOWLIST"; 205 //<!--Modified by PengYunQuan for Validity Cell Range Picker 206 //Pos = MAP_APPFONT ( 80 , 44 ) ; 207 Pos = MAP_APPFONT ( 80 - OFFSET_X , 44 ) ; 208 //-->Modified by PengYunQuan for Validity Cell Range Picker 209 Size = MAP_APPFONT ( 174 , 10 ) ; 210 TabStop = TRUE ; 211 Text [ en-US ] = "Show selection ~list" ; 212 }; 213 CheckBox CB_SORTLIST 214 { 215 HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:CB_SORTLIST"; 216 //<!--Modified by PengYunQuan for Validity Cell Range Picker 217 //Pos = MAP_APPFONT ( 90 , 58 ) ; 218 Pos = MAP_APPFONT ( 90 - OFFSET_X , 58 ) ; 219 //-->Modified by PengYunQuan for Validity Cell Range Picker 220 Size = MAP_APPFONT ( 164 , 10 ) ; 221 TabStop = TRUE ; 222 Text [ en-US ] = "Sor~t entries ascending" ; 223 }; 224 FixedText FT_SOURCEHINT 225 { 226 Pos = MAP_APPFONT ( 80 , 90 ) ; 227 Size = MAP_APPFONT ( 174 , 64 ) ; 228 WordBreak = TRUE ; 229 Text [ en-US ] = "A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array."; 230 }; 231 //<!--Added by PengYunQuan for Validity Cell Range Picker 232 ImageButton RB_VALIDITY_REF 233 { 234 HelpID = "sc:ImageButton:TP_VALIDATION_VALUES:RB_VALIDITY_REF"; 235 Pos = MAP_APPFONT ( 142 , 73 ) ; 236 Size = MAP_APPFONT ( 13 , 14 ) ; 237 TabStop = TRUE ; 238 QuickHelpText [ en-US ] = "Shrink" ; 239 }; 240 //-->Added by PengYunQuan for Validity Cell Range Picker 241}; 242 243TabPage TP_VALIDATION_INPUTHELP 244{ 245 HelpID = "sc:TabPage:TP_VALIDATION_INPUTHELP"; 246 Hide = TRUE ; 247 SVLook = TRUE ; 248 Size = MAP_APPFONT ( 260 , 185 ) ; 249 Text = "Eingabehilfe" ; 250 TriStateBox TSB_HELP 251 { 252 HelpID = "sc:TriStateBox:TP_VALIDATION_INPUTHELP:TSB_HELP"; 253 Pos = MAP_APPFONT ( 6 , 6 ) ; 254 Size = MAP_APPFONT ( 248 , 10 ) ; 255 TabStop = TRUE ; 256 Text [ en-US ] = "~Show input help when cell is selected" ; 257 }; 258 FixedLine FL_CONTENT 259 { 260 Pos = MAP_APPFONT ( 6 , 22 ) ; 261 Size = MAP_APPFONT ( 248 , 8 ) ; 262 Text [ en-US ] = "Contents" ; 263 }; 264 FixedText FT_TITLE 265 { 266 Pos = MAP_APPFONT ( 12 , 35 ) ; 267 Size = MAP_APPFONT ( 64 , 8 ) ; 268 Text [ en-US ] = "~Title" ; 269 }; 270 FixedText FT_INPUTHELP 271 { 272 Pos = MAP_APPFONT ( 12 , 53 ) ; 273 Size = MAP_APPFONT ( 64 , 8 ) ; 274 Text [ en-US ] = "~Input help" ; 275 }; 276 Edit EDT_TITLE 277 { 278 HelpID = "sc:Edit:TP_VALIDATION_INPUTHELP:EDT_TITLE"; 279 Border = TRUE ; 280 Pos = MAP_APPFONT ( 80 , 33 ) ; 281 Size = MAP_APPFONT ( 171 , 12 ) ; 282 TabStop = TRUE ; 283 }; 284 MultiLineEdit EDT_INPUTHELP 285 { 286 HelpID = "sc:MultiLineEdit:TP_VALIDATION_INPUTHELP:EDT_INPUTHELP"; 287 Border = TRUE ; 288 Pos = MAP_APPFONT ( 80 , 51 ) ; 289 Size = MAP_APPFONT ( 171 , 128 ) ; 290 TabStop = TRUE ; 291 VScroll = TRUE ; 292 IgnoreTab = TRUE ; 293 }; 294}; 295 296TabPage TP_VALIDATION_ERROR 297{ 298 HelpID = "sc:TabPage:TP_VALIDATION_ERROR"; 299 Hide = TRUE ; 300 SVLook = TRUE ; 301 Size = MAP_APPFONT ( 260 , 185 ) ; 302 FixedLine FL_CONTENT 303 { 304 Pos = MAP_APPFONT ( 6 , 22 ) ; 305 Size = MAP_APPFONT ( 248 , 8 ) ; 306 Text [ en-US ] = "Contents" ; 307 }; 308 TriStateBox TSB_SHOW 309 { 310 HelpID = "sc:TriStateBox:TP_VALIDATION_ERROR:TSB_SHOW"; 311 Pos = MAP_APPFONT ( 6 , 6 ) ; 312 Size = MAP_APPFONT ( 248 , 10 ) ; 313 TabStop = TRUE ; 314 Text [ en-US ] = "Show error ~message when invalid values are entered" ; 315 }; 316 MultiLineEdit EDT_ERROR 317 { 318 HelpID = "sc:MultiLineEdit:TP_VALIDATION_ERROR:EDT_ERROR"; 319 Border = TRUE ; 320 Pos = MAP_APPFONT ( 80 , 69 ) ; 321 Size = MAP_APPFONT ( 171 , 110 ) ; 322 TabStop = TRUE ; 323 VScroll = TRUE ; 324 IgnoreTab = TRUE ; 325 }; 326 Edit EDT_TITLE 327 { 328 HelpID = "sc:Edit:TP_VALIDATION_ERROR:EDT_TITLE"; 329 Border = TRUE ; 330 Pos = MAP_APPFONT ( 80 , 51 ) ; 331 Size = MAP_APPFONT ( 171 , 12 ) ; 332 TabStop = TRUE ; 333 }; 334 FixedText FT_ERROR 335 { 336 Pos = MAP_APPFONT ( 12 , 71 ) ; 337 Size = MAP_APPFONT ( 64 , 8 ) ; 338 Text [ en-US ] = "~Error message" ; 339 }; 340 FixedText FT_TITLE 341 { 342 Pos = MAP_APPFONT ( 12 , 53 ) ; 343 Size = MAP_APPFONT ( 64 , 8 ) ; 344 Text [ en-US ] = "~Title" ; 345 }; 346 FixedText FT_ACTION 347 { 348 Pos = MAP_APPFONT ( 12 , 35 ) ; 349 Size = MAP_APPFONT ( 64 , 8 ) ; 350 Text [ en-US ] = "~Action" ; 351 }; 352 ListBox LB_ACTION 353 { 354 HelpID = "sc:ListBox:TP_VALIDATION_ERROR:LB_ACTION"; 355 Border = TRUE ; 356 Pos = MAP_APPFONT ( 80 , 33 ) ; 357 Size = MAP_APPFONT ( 107 , 76 ) ; 358 TabStop = TRUE ; 359 DropDown = TRUE ; 360 // Reihenfolge entspricht enum ScValidErrorStyle 361 StringList [ en-US ] = 362 { 363 < "Stop" ; Default ; > ; 364 < "Warning" ; Default ; > ; 365 < "Information" ; Default ; > ; 366 < "Macro" ; Default ; > ; 367 }; 368 }; 369 PushButton BTN_SEARCH 370 { 371 HelpID = "sc:PushButton:TP_VALIDATION_ERROR:BTN_SEARCH"; 372 Pos = MAP_APPFONT ( 191 , 32 ) ; 373 Size = MAP_APPFONT ( 60 , 14 ) ; 374 TabStop = TRUE ; 375 Text [ en-US ] = "~Browse..." ; 376 }; 377 Text [ en-US ] = "Error Alert" ; 378}; 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424