1/************************************************************************* 2 * 3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4 * 5 * Copyright 2000, 2010 Oracle and/or its affiliates. 6 * 7 * OpenOffice.org - a multi-platform office productivity suite 8 * 9 * This file is part of OpenOffice.org. 10 * 11 * OpenOffice.org is free software: you can redistribute it and/or modify 12 * it under the terms of the GNU Lesser General Public License version 3 13 * only, as published by the Free Software Foundation. 14 * 15 * OpenOffice.org is distributed in the hope that it will be useful, 16 * but WITHOUT ANY WARRANTY; without even the implied warranty of 17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18 * GNU Lesser General Public License version 3 for more details 19 * (a copy is included in the LICENSE file that accompanied this code). 20 * 21 * You should have received a copy of the GNU Lesser General Public License 22 * version 3 along with OpenOffice.org. If not, see 23 * <http://www.openoffice.org/license.html> 24 * for a copy of the LGPLv3 License. 25 * 26 ************************************************************************/ 27 28#include "validate.hrc" 29 30 31TabDialog TAB_DLG_VALIDATION 32{ 33 OutputSize = TRUE ; 34 SVLook = TRUE ; 35 Size = MAP_APPFONT ( 289 , 176 ) ; 36 Moveable = TRUE ; 37 TabControl 1 38 { 39 OutputSize = TRUE ; 40 Size = MAP_APPFONT ( 260 , 135 ) ; 41 PageList = 42 { 43 PageItem 44 { 45 Identifier = TP_VALIDATION_VALUES ; 46 PageResID = TP_VALIDATION_VALUES ; 47 Text [ en-US ] = "Criteria"; 48 }; 49 PageItem 50 { 51 Identifier = TP_VALIDATION_INPUTHELP ; 52 PageResID = TP_VALIDATION_INPUTHELP ; 53 Text [ en-US ] = "Input Help" ; 54 }; 55 PageItem 56 { 57 Identifier = TP_VALIDATION_ERROR ; 58 PageResID = TP_VALIDATION_ERROR ; 59 Text [ en-US ] = "Error Alert" ; 60 }; 61 }; 62 }; 63 Text [ en-US ] = "Validity" ; 64}; 65//<!--Added by PengYunQuan for Validity Cell Range Picker 66#define OFFSET_X 30 67//-->Added by PengYunQuan for Validity Cell Range Picker 68TabPage TP_VALIDATION_VALUES 69{ 70 HelpID = "sc:TabPage:TP_VALIDATION_VALUES"; 71 Hide = TRUE ; 72 SVLook = TRUE ; 73 Size = MAP_APPFONT ( 260 , 185 ) ; 74 Text [ en-US ] = "Values" ; 75 FixedText FT_ALLOW 76 { 77 Pos = MAP_APPFONT ( 6 , 16 ) ; 78 //<!--Modified by PengYunQuan for Validity Cell Range Picker 79 //Size = MAP_APPFONT ( 70 , 8 ) ; 80 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 81 //-->Modified by PengYunQuan for Validity Cell Range Picker 82 Text [ en-US ] = "~Allow" ; 83 }; 84 ListBox LB_ALLOW 85 { 86 HelpID = "sc:ListBox:TP_VALIDATION_VALUES:LB_ALLOW"; 87 Border = TRUE ; 88 //<!--Modified by PengYunQuan for Validity Cell Range Picker 89 //Pos = MAP_APPFONT ( 80 , 14 ) ; 90 Pos = MAP_APPFONT ( 80 - OFFSET_X , 14 ) ; 91 //-->Modified by PengYunQuan for Validity Cell Range Picker 92 Size = MAP_APPFONT ( 90 , 80 ) ; 93 TabStop = TRUE ; 94 DropDown = TRUE ; 95 StringList [ en-US ] = 96 { 97 < "All values" ; SC_VALIDDLG_ALLOW_ANY ; > ; 98 < "Whole Numbers" ; SC_VALIDDLG_ALLOW_WHOLE ; > ; 99 < "Decimal" ; SC_VALIDDLG_ALLOW_DECIMAL ; > ; 100 < "Date" ; SC_VALIDDLG_ALLOW_DATE ; > ; 101 < "Time" ; SC_VALIDDLG_ALLOW_TIME ; > ; 102 < "Cell range" ; SC_VALIDDLG_ALLOW_RANGE ; > ; 103 < "List" ; SC_VALIDDLG_ALLOW_LIST ; > ; 104 < "Text length" ; SC_VALIDDLG_ALLOW_TEXTLEN ; > ; 105 }; 106 }; 107 FixedText FT_VALUE 108 { 109 Pos = MAP_APPFONT ( 6 , 58 ) ; 110 //<!--Modified by PengYunQuan for Validity Cell Range Picker 111 //Size = MAP_APPFONT ( 70 , 8 ) ; 112 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 113 //-->Modified by PengYunQuan for Validity Cell Range Picker 114 Text [ en-US ] = "~Data" ; 115 }; 116 ListBox LB_VALUE 117 { 118 HelpID = "sc:ListBox:TP_VALIDATION_VALUES:LB_VALUE"; 119 Border = TRUE ; 120 //<!--Modified by PengYunQuan for Validity Cell Range Picker 121 //Pos = MAP_APPFONT ( 80 , 56 ) ; 122 Pos = MAP_APPFONT ( 80 - OFFSET_X , 56 ) ; 123 //-->Modified by PengYunQuan for Validity Cell Range Picker 124 Size = MAP_APPFONT ( 90 , 90 ) ; 125 TabStop = TRUE ; 126 DropDown = TRUE ; 127 // Reihenfolge entspricht enum ScConditionMode 128 StringList [ en-US ] = 129 { 130 < "equal" ; SC_VALIDDLG_DATA_EQUAL ; > ; 131 < "less than" ; SC_VALIDDLG_DATA_LESS ; > ; 132 < "greater than" ; SC_VALIDDLG_DATA_GREATER ; > ; 133 < "less than or equal" ; SC_VALIDDLG_DATA_EQLESS ; > ; 134 < "greater than or equal to" ; SC_VALIDDLG_DATA_EQGREATER ; > ; 135 < "not equal" ; SC_VALIDDLG_DATA_NOTEQUAL ; > ; 136 < "between" ; SC_VALIDDLG_DATA_BETWEEN ; > ; 137 < "not between" ; SC_VALIDDLG_DATA_NOTBETWEEN ; > ; 138 }; 139 }; 140 FixedText FT_MIN 141 { 142 Pos = MAP_APPFONT ( 6 , 76 ) ; 143 //<!--Modified by PengYunQuan for Validity Cell Range Picker 144 //Size = MAP_APPFONT ( 70 , 8 ) ; 145 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 146 //-->Modified by PengYunQuan for Validity Cell Range Picker 147 Text [ en-US ] = "~Minimum" ; 148 }; 149 Edit EDT_MIN 150 { 151 HelpID = "sc:Edit:TP_VALIDATION_VALUES:EDT_MIN"; 152 Border = TRUE ; 153 //<!--Modified by PengYunQuan for Validity Cell Range Picker 154 //Pos = MAP_APPFONT ( 80 , 74 ) ; 155 //Size = MAP_APPFONT ( 174 , 12 ) ; 156 Pos = MAP_APPFONT ( 80 - OFFSET_X , 74 ) ; 157 Size = MAP_APPFONT ( 90 , 12 ) ; 158 //-->Modified by PengYunQuan for Validity Cell Range Picker 159 TabStop = TRUE ; 160 }; 161 MultiLineEdit EDT_LIST 162 { 163 HelpID = "sc:MultiLineEdit:TP_VALIDATION_VALUES:EDT_LIST"; 164 Border = TRUE ; 165 //<!--Modified by PengYunQuan for Validity Cell Range Picker 166 //Pos = MAP_APPFONT ( 80 , 74 ) ; 167 //Size = MAP_APPFONT ( 174 , 105 ) ; 168 Pos = MAP_APPFONT ( 80 - OFFSET_X , 74 ) ; 169 Size = MAP_APPFONT ( 174 + OFFSET_X , 105 ) ; 170 //-->Modified by PengYunQuan for Validity Cell Range Picker 171 VScroll = TRUE ; 172 IgnoreTab = TRUE ; 173 }; 174 FixedText FT_MAX 175 { 176 Pos = MAP_APPFONT ( 6 , 92 ) ; 177 //<!--Modified by PengYunQuan for Validity Cell Range Picker 178 //Size = MAP_APPFONT ( 70 , 8 ) ; 179 Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ; 180 //-->Modified by PengYunQuan for Validity Cell Range Picker 181 Text [ en-US ] = "Ma~ximum" ; 182 }; 183 Edit EDT_MAX 184 { 185 HelpID = "sc:Edit:TP_VALIDATION_VALUES:EDT_MAX"; 186 Border = TRUE ; 187 //<!--Modified by PengYunQuan for Validity Cell Range Picker 188 //Pos = MAP_APPFONT ( 80 , 90 ) ; 189 //Size = MAP_APPFONT ( 174 , 12 ) ; 190 Pos = MAP_APPFONT ( 80 - OFFSET_X , 90 ) ; 191 Size = MAP_APPFONT ( 90 , 12 ) ; 192 //-->Modified by PengYunQuan for Validity Cell Range Picker 193 TabStop = TRUE ; 194 }; 195 CheckBox TSB_ALLOW_BLANKS 196 { 197 HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS"; 198 //<!--Modified by PengYunQuan for Validity Cell Range Picker 199 //Pos = MAP_APPFONT ( 80 , 30 ) ; 200 Pos = MAP_APPFONT ( 80 - OFFSET_X , 30 ) ; 201 //-->Modified by PengYunQuan for Validity Cell Range Picker 202 Size = MAP_APPFONT ( 174 , 10 ) ; 203 TabStop = TRUE ; 204 Text [ en-US ] = "Allow ~blank cells" ; 205 }; 206 CheckBox CB_SHOWLIST 207 { 208 HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:CB_SHOWLIST"; 209 //<!--Modified by PengYunQuan for Validity Cell Range Picker 210 //Pos = MAP_APPFONT ( 80 , 44 ) ; 211 Pos = MAP_APPFONT ( 80 - OFFSET_X , 44 ) ; 212 //-->Modified by PengYunQuan for Validity Cell Range Picker 213 Size = MAP_APPFONT ( 174 , 10 ) ; 214 TabStop = TRUE ; 215 Text [ en-US ] = "Show selection ~list" ; 216 }; 217 CheckBox CB_SORTLIST 218 { 219 HelpID = "sc:CheckBox:TP_VALIDATION_VALUES:CB_SORTLIST"; 220 //<!--Modified by PengYunQuan for Validity Cell Range Picker 221 //Pos = MAP_APPFONT ( 90 , 58 ) ; 222 Pos = MAP_APPFONT ( 90 - OFFSET_X , 58 ) ; 223 //-->Modified by PengYunQuan for Validity Cell Range Picker 224 Size = MAP_APPFONT ( 164 , 10 ) ; 225 TabStop = TRUE ; 226 Text [ en-US ] = "Sor~t entries ascending" ; 227 }; 228 FixedText FT_SOURCEHINT 229 { 230 Pos = MAP_APPFONT ( 80 , 90 ) ; 231 Size = MAP_APPFONT ( 174 , 64 ) ; 232 WordBreak = TRUE ; 233 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."; 234 }; 235 //<!--Added by PengYunQuan for Validity Cell Range Picker 236 ImageButton RB_VALIDITY_REF 237 { 238 HelpID = "sc:ImageButton:TP_VALIDATION_VALUES:RB_VALIDITY_REF"; 239 Pos = MAP_APPFONT ( 142 , 73 ) ; 240 Size = MAP_APPFONT ( 13 , 14 ) ; 241 TabStop = TRUE ; 242 QuickHelpText [ en-US ] = "Shrink" ; 243 }; 244 //-->Added by PengYunQuan for Validity Cell Range Picker 245}; 246 247TabPage TP_VALIDATION_INPUTHELP 248{ 249 HelpID = "sc:TabPage:TP_VALIDATION_INPUTHELP"; 250 Hide = TRUE ; 251 SVLook = TRUE ; 252 Size = MAP_APPFONT ( 260 , 185 ) ; 253 Text = "Eingabehilfe" ; 254 TriStateBox TSB_HELP 255 { 256 HelpID = "sc:TriStateBox:TP_VALIDATION_INPUTHELP:TSB_HELP"; 257 Pos = MAP_APPFONT ( 6 , 6 ) ; 258 Size = MAP_APPFONT ( 248 , 10 ) ; 259 TabStop = TRUE ; 260 Text [ en-US ] = "~Show input help when cell is selected" ; 261 }; 262 FixedLine FL_CONTENT 263 { 264 Pos = MAP_APPFONT ( 6 , 22 ) ; 265 Size = MAP_APPFONT ( 248 , 8 ) ; 266 Text [ en-US ] = "Contents" ; 267 }; 268 FixedText FT_TITLE 269 { 270 Pos = MAP_APPFONT ( 12 , 35 ) ; 271 Size = MAP_APPFONT ( 64 , 8 ) ; 272 Text [ en-US ] = "~Title" ; 273 }; 274 FixedText FT_INPUTHELP 275 { 276 Pos = MAP_APPFONT ( 12 , 53 ) ; 277 Size = MAP_APPFONT ( 64 , 8 ) ; 278 Text [ en-US ] = "~Input help" ; 279 }; 280 Edit EDT_TITLE 281 { 282 HelpID = "sc:Edit:TP_VALIDATION_INPUTHELP:EDT_TITLE"; 283 Border = TRUE ; 284 Pos = MAP_APPFONT ( 80 , 33 ) ; 285 Size = MAP_APPFONT ( 171 , 12 ) ; 286 TabStop = TRUE ; 287 }; 288 MultiLineEdit EDT_INPUTHELP 289 { 290 HelpID = "sc:MultiLineEdit:TP_VALIDATION_INPUTHELP:EDT_INPUTHELP"; 291 Border = TRUE ; 292 Pos = MAP_APPFONT ( 80 , 51 ) ; 293 Size = MAP_APPFONT ( 171 , 128 ) ; 294 TabStop = TRUE ; 295 VScroll = TRUE ; 296 IgnoreTab = TRUE ; 297 }; 298}; 299 300TabPage TP_VALIDATION_ERROR 301{ 302 HelpID = "sc:TabPage:TP_VALIDATION_ERROR"; 303 Hide = TRUE ; 304 SVLook = TRUE ; 305 Size = MAP_APPFONT ( 260 , 185 ) ; 306 FixedLine FL_CONTENT 307 { 308 Pos = MAP_APPFONT ( 6 , 22 ) ; 309 Size = MAP_APPFONT ( 248 , 8 ) ; 310 Text [ en-US ] = "Contents" ; 311 }; 312 TriStateBox TSB_SHOW 313 { 314 HelpID = "sc:TriStateBox:TP_VALIDATION_ERROR:TSB_SHOW"; 315 Pos = MAP_APPFONT ( 6 , 6 ) ; 316 Size = MAP_APPFONT ( 248 , 10 ) ; 317 TabStop = TRUE ; 318 Text [ en-US ] = "Show error ~message when invalid values are entered" ; 319 }; 320 MultiLineEdit EDT_ERROR 321 { 322 HelpID = "sc:MultiLineEdit:TP_VALIDATION_ERROR:EDT_ERROR"; 323 Border = TRUE ; 324 Pos = MAP_APPFONT ( 80 , 69 ) ; 325 Size = MAP_APPFONT ( 171 , 110 ) ; 326 TabStop = TRUE ; 327 VScroll = TRUE ; 328 IgnoreTab = TRUE ; 329 }; 330 Edit EDT_TITLE 331 { 332 HelpID = "sc:Edit:TP_VALIDATION_ERROR:EDT_TITLE"; 333 Border = TRUE ; 334 Pos = MAP_APPFONT ( 80 , 51 ) ; 335 Size = MAP_APPFONT ( 171 , 12 ) ; 336 TabStop = TRUE ; 337 }; 338 FixedText FT_ERROR 339 { 340 Pos = MAP_APPFONT ( 12 , 71 ) ; 341 Size = MAP_APPFONT ( 64 , 8 ) ; 342 Text [ en-US ] = "~Error message" ; 343 }; 344 FixedText FT_TITLE 345 { 346 Pos = MAP_APPFONT ( 12 , 53 ) ; 347 Size = MAP_APPFONT ( 64 , 8 ) ; 348 Text [ en-US ] = "~Title" ; 349 }; 350 FixedText FT_ACTION 351 { 352 Pos = MAP_APPFONT ( 12 , 35 ) ; 353 Size = MAP_APPFONT ( 64 , 8 ) ; 354 Text [ en-US ] = "~Action" ; 355 }; 356 ListBox LB_ACTION 357 { 358 HelpID = "sc:ListBox:TP_VALIDATION_ERROR:LB_ACTION"; 359 Border = TRUE ; 360 Pos = MAP_APPFONT ( 80 , 33 ) ; 361 Size = MAP_APPFONT ( 107 , 76 ) ; 362 TabStop = TRUE ; 363 DropDown = TRUE ; 364 // Reihenfolge entspricht enum ScValidErrorStyle 365 StringList [ en-US ] = 366 { 367 < "Stop" ; Default ; > ; 368 < "Warning" ; Default ; > ; 369 < "Information" ; Default ; > ; 370 < "Macro" ; Default ; > ; 371 }; 372 }; 373 PushButton BTN_SEARCH 374 { 375 HelpID = "sc:PushButton:TP_VALIDATION_ERROR:BTN_SEARCH"; 376 Pos = MAP_APPFONT ( 191 , 32 ) ; 377 Size = MAP_APPFONT ( 60 , 14 ) ; 378 TabStop = TRUE ; 379 Text [ en-US ] = "~Browse..." ; 380 }; 381 Text [ en-US ] = "Error Alert" ; 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 425 426 427 428