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 ~empty 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 - OFFSET_X, 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// ********************************************************************** EOF 381