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 "pvfundlg.hrc" 25 26StringArray SCSTR_DPFUNCLISTBOX 27{ 28 ItemList [ en-US ] = 29 { 30 < "Sum" ; Default ; > ; 31 < "Count" ; Default ; > ; 32 < "Average" ; Default ; > ; 33 < "Max" ; Default ; > ; 34 < "Min" ; Default ; > ; 35 < "Product" ; Default ; > ; 36 < "Count (Numbers only)" ; Default ; > ; 37 < "StDev (Sample)" ; Default ; > ; 38 < "StDevP (Population)" ; Default ; > ; 39 < "Var (Sample)" ; Default ; > ; 40 < "VarP (Population)" ; Default ; > ; 41 }; 42}; 43 44// ---------------------------------------------------------------------------- 45 46ModalDialog RID_SCDLG_DPDATAFIELD 47{ 48 OutputSize = TRUE ; 49 HelpId = HID_SC_DPDATAFIELD ; 50 SVLook = TRUE ; 51 Size = MAP_APPFONT ( 220 , 99 ) ; 52 Moveable = TRUE ; 53 Closeable = FALSE ; 54 Hide = TRUE ; 55 FixedLine FL_FUNC 56 { 57 Pos = MAP_APPFONT ( 6 , 3 ) ; 58 Size = MAP_APPFONT ( 152 , 8 ) ; 59 Text [ en-US ] = "~Function" ; 60 }; 61 MultiListBox LB_FUNC 62 { 63 HelpID = "sc:MultiListBox:RID_SCDLG_DPDATAFIELD:LB_FUNC"; 64 Border = TRUE ; 65 Pos = MAP_APPFONT ( 12 , 14 ) ; 66 Size = MAP_APPFONT ( 140 , 65 ) ; 67 TabStop = TRUE ; 68 AutoHScroll = TRUE ; 69 SimpleMode = TRUE ; 70 }; 71 FixedText FT_NAMELABEL 72 { 73 Pos = MAP_APPFONT ( 6 , 85 ) ; 74 Size = MAP_APPFONT ( 25 , 8 ) ; 75 Text [ en-US ] = "Name:" ; 76 }; 77 FixedText FT_NAME 78 { 79 Pos = MAP_APPFONT ( 32 , 85 ) ; 80 Size = MAP_APPFONT ( 126 , 8 ) ; 81 }; 82 FixedLine FL_DISPLAY 83 { 84 Pos = MAP_APPFONT( 6, 99 ); 85 Size = MAP_APPFONT( 152, 8 ); 86 Text [ en-US ] = "Displayed value"; 87 }; 88 FixedText FT_TYPE 89 { 90 Pos = MAP_APPFONT( 12, 112 ); 91 Size = MAP_APPFONT( 60, 8 ); 92 Text [ en-US ] = "~Type"; 93 }; 94 ListBox LB_TYPE 95 { 96 HelpID = "sc:ListBox:RID_SCDLG_DPDATAFIELD:LB_TYPE"; 97 Pos = MAP_APPFONT( 75, 110 ); 98 Size = MAP_APPFONT( 77, 120 ); 99 TabStop = TRUE; 100 Border = TRUE; 101 DropDown = TRUE; 102 StringList [ en-US ] = 103 { 104 < "Normal"; Default; >; 105 < "Difference from"; Default; >; 106 < "% of"; Default; >; 107 < "% difference from"; Default; >; 108 < "Running total in"; Default; >; 109 < "% of row"; Default; >; 110 < "% of column"; Default; >; 111 < "% of total"; Default; >; 112 < "Index"; Default; >; 113 }; 114 }; 115 FixedText FT_BASEFIELD 116 { 117 Pos = MAP_APPFONT( 12, 128 ); 118 Size = MAP_APPFONT( 60, 8 ); 119 Text [ en-US ] = "~Base field"; 120 }; 121 ListBox LB_BASEFIELD 122 { 123 HelpID = "sc:ListBox:RID_SCDLG_DPDATAFIELD:LB_BASEFIELD"; 124 Pos = MAP_APPFONT( 75, 126 ); 125 Size = MAP_APPFONT( 77, 120 ); 126 TabStop = TRUE; 127 Border = TRUE; 128 DropDown = TRUE; 129 }; 130 FixedText FT_BASEITEM 131 { 132 Pos = MAP_APPFONT( 12, 144 ); 133 Size = MAP_APPFONT( 60, 8 ); 134 Text [ en-US ] = "Ba~se item"; 135 }; 136 ListBox LB_BASEITEM 137 { 138 HelpID = "sc:ListBox:RID_SCDLG_DPDATAFIELD:LB_BASEITEM"; 139 Pos = MAP_APPFONT( 75, 142 ); 140 Size = MAP_APPFONT( 77, 120 ); 141 TabStop = TRUE; 142 Border = TRUE; 143 DropDown = TRUE; 144 StringList [ en-US ] = 145 { 146 < "- previous item -"; Default; >; 147 < "- next item -"; Default; >; 148 }; 149 }; 150 OKButton BTN_OK 151 { 152 Pos = MAP_APPFONT ( 164 , 6 ) ; 153 Size = MAP_APPFONT ( 50 , 14 ) ; 154 TabStop = TRUE ; 155 DefButton = TRUE ; 156 }; 157 CancelButton BTN_CANCEL 158 { 159 Pos = MAP_APPFONT ( 164 , 23 ) ; 160 Size = MAP_APPFONT ( 50 , 14 ) ; 161 TabStop = TRUE ; 162 }; 163 HelpButton BTN_HELP 164 { 165 Pos = MAP_APPFONT ( 164 , 43 ) ; 166 Size = MAP_APPFONT ( 50 , 14 ) ; 167 TabStop = TRUE ; 168 }; 169 MoreButton BTN_MORE 170 { 171 HelpID = "sc:MoreButton:RID_SCDLG_DPDATAFIELD:BTN_MORE"; 172 Pos = MAP_APPFONT ( 164 , 79 ) ; 173 Size = MAP_APPFONT ( 50 , 14 ) ; 174 TabStop = TRUE ; 175 MapUnit = MAP_APPFONT ; 176 Delta = 61 ; 177 }; 178 Text [ en-US ] = "Data Field" ; 179}; 180 181// ---------------------------------------------------------------------------- 182 183ModalDialog RID_SCDLG_PIVOTSUBT 184{ 185 OutputSize = TRUE ; 186 HelpId = HID_SC_PIVOTSUBT ; 187 SVLook = TRUE ; 188 Size = MAP_APPFONT ( 220 , 155 ) ; 189 Text [ en-US ] = "Data Field" ; 190 Moveable = TRUE ; 191 Closeable = FALSE ; 192 Hide = TRUE ; 193 RadioButton RB_NONE 194 { 195 HelpID = "sc:RadioButton:RID_SCDLG_PIVOTSUBT:RB_NONE"; 196 Pos = MAP_APPFONT ( 12 , 14 ) ; 197 Size = MAP_APPFONT ( 140 , 10 ) ; 198 Text [ en-US ] = "~None" ; 199 TabStop = TRUE ; 200 }; 201 RadioButton RB_AUTO 202 { 203 HelpID = "sc:RadioButton:RID_SCDLG_PIVOTSUBT:RB_AUTO"; 204 Pos = MAP_APPFONT ( 12 , 28 ) ; 205 Size = MAP_APPFONT ( 140 , 10 ) ; 206 Text [ en-US ] = "~Automatic" ; 207 TabStop = TRUE ; 208 }; 209 RadioButton RB_USER 210 { 211 HelpID = "sc:RadioButton:RID_SCDLG_PIVOTSUBT:RB_USER"; 212 Pos = MAP_APPFONT ( 12 , 42 ) ; 213 Size = MAP_APPFONT ( 140 , 10 ) ; 214 Text [ en-US ] = "~User-defined" ; 215 TabStop = TRUE ; 216 }; 217 MultiListBox LB_FUNC 218 { 219 HelpID = "sc:MultiListBox:RID_SCDLG_PIVOTSUBT:LB_FUNC"; 220 Border = TRUE ; 221 Pos = MAP_APPFONT ( 12 , 56 ) ; 222 Size = MAP_APPFONT ( 140 , 65 ) ; 223 TabStop = TRUE ; 224 AutoHScroll = TRUE ; 225 SimpleMode = TRUE ; 226 }; 227 FixedLine FL_FUNC 228 { 229 Pos = MAP_APPFONT ( 6 , 3 ) ; 230 Size = MAP_APPFONT ( 152 , 8 ) ; 231 Text [ en-US ] = "Subtotals" ; 232 }; 233 CheckBox CB_SHOWALL 234 { 235 HelpID = "sc:CheckBox:RID_SCDLG_PIVOTSUBT:CB_SHOWALL"; 236 Pos = MAP_APPFONT ( 6 , 127 ) ; 237 Size = MAP_APPFONT ( 152 , 10 ) ; 238 Text [ en-US ] = "Show it~ems without data"; 239 TabStop = TRUE ; 240 }; 241 FixedText FT_NAMELABEL 242 { 243 Pos = MAP_APPFONT ( 6 , 141 ) ; 244 Size = MAP_APPFONT ( 25 , 8 ) ; 245 Text [ en-US ] = "Name:" ; 246 }; 247 FixedText FT_NAME 248 { 249 Pos = MAP_APPFONT ( 32 , 141 ) ; 250 Size = MAP_APPFONT ( 126 , 8 ) ; 251 }; 252 OKButton BTN_OK 253 { 254 Pos = MAP_APPFONT ( 164 , 6 ) ; 255 Size = MAP_APPFONT ( 50 , 14 ) ; 256 TabStop = TRUE ; 257 DefButton = TRUE ; 258 }; 259 CancelButton BTN_CANCEL 260 { 261 Pos = MAP_APPFONT ( 164 , 23 ) ; 262 Size = MAP_APPFONT ( 50 , 14 ) ; 263 TabStop = TRUE ; 264 }; 265 HelpButton BTN_HELP 266 { 267 Pos = MAP_APPFONT ( 164 , 43 ) ; 268 Size = MAP_APPFONT ( 50 , 14 ) ; 269 TabStop = TRUE ; 270 }; 271 PushButton BTN_OPTIONS 272 { 273 HelpID = "sc:PushButton:RID_SCDLG_PIVOTSUBT:BTN_OPTIONS"; 274 Pos = MAP_APPFONT ( 164 , 135 ) ; 275 Size = MAP_APPFONT ( 50 , 14 ) ; 276 TabStop = TRUE ; 277 Text [ en-US ] = "~Options..."; 278 }; 279}; 280 281// ---------------------------------------------------------------------------- 282 283ModalDialog RID_SCDLG_DPSUBTOTAL_OPT 284{ 285 OutputSize = TRUE; 286 HelpId = HID_SC_DPSUBT_OPT; 287 SVLook = TRUE; 288 Size = MAP_APPFONT( 266, 240 ); 289 Moveable = TRUE; 290 Closeable = FALSE; 291 Hide = TRUE; 292 FixedLine FL_SORT_BY 293 { 294 Pos = MAP_APPFONT( 6, 3 ); 295 Size = MAP_APPFONT( 198, 8 ); 296 Text [ en-US ] = "Sort ~by"; 297 }; 298 ListBox LB_SORT_BY 299 { 300 HelpID = "sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_SORT_BY"; 301 Pos = MAP_APPFONT( 12, 26 ); 302 Size = MAP_APPFONT( 96, 120 ); 303 TabStop = TRUE; 304 Border = TRUE; 305 DropDown = TRUE; 306 }; 307 RadioButton RB_SORT_ASC 308 { 309 HelpID = "sc:RadioButton:RID_SCDLG_DPSUBTOTAL_OPT:RB_SORT_ASC"; 310 Pos = MAP_APPFONT( 114, 14 ); 311 Size = MAP_APPFONT( 84, 10 ); 312 TabStop = TRUE; 313 Text [ en-US ] = "~Ascending"; 314 }; 315 RadioButton RB_SORT_DESC 316 { 317 HelpID = "sc:RadioButton:RID_SCDLG_DPSUBTOTAL_OPT:RB_SORT_DESC"; 318 Pos = MAP_APPFONT( 114, 28 ); 319 Size = MAP_APPFONT( 84, 10 ); 320 TabStop = TRUE; 321 Text [ en-US ] = "~Descending"; 322 }; 323 RadioButton RB_SORT_MAN 324 { 325 HelpID = "sc:RadioButton:RID_SCDLG_DPSUBTOTAL_OPT:RB_SORT_MAN"; 326 Pos = MAP_APPFONT( 114, 42 ); 327 Size = MAP_APPFONT( 84, 10 ); 328 TabStop = TRUE; 329 Text [ en-US ] = "~Manual"; 330 }; 331 FixedLine FL_LAYOUT 332 { 333 Pos = MAP_APPFONT( 6, 56 ); 334 Size = MAP_APPFONT( 198, 8 ); 335 Text [ en-US ] = "Display options"; 336 }; 337 FixedText FT_LAYOUT 338 { 339 Pos = MAP_APPFONT( 12, 69 ); 340 Size = MAP_APPFONT( 70, 8 ); 341 Text [ en-US ] = "~Layout"; 342 }; 343 ListBox LB_LAYOUT 344 { 345 HelpID = "sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_LAYOUT"; 346 Pos = MAP_APPFONT( 84, 67 ); 347 Size = MAP_APPFONT( 114, 120 ); 348 TabStop = TRUE; 349 Border = TRUE; 350 DropDown = TRUE; 351 StringList [ en-US ] = 352 { 353 < "Tabular layout"; Default; >; 354 < "Outline layout with subtotals at the top"; Default; >; 355 < "Outline layout with subtotals at the bottom"; Default; >; 356 }; 357 }; 358 CheckBox CB_LAYOUT_EMPTY 359 { 360 HelpID = "sc:CheckBox:RID_SCDLG_DPSUBTOTAL_OPT:CB_LAYOUT_EMPTY"; 361 Pos = MAP_APPFONT( 12, 85 ); 362 Size = MAP_APPFONT( 186, 10 ); 363 TabStop = TRUE; 364 Text [ en-US ] = "~Empty line after each item"; 365 }; 366 FixedLine FL_AUTOSHOW 367 { 368 Pos = MAP_APPFONT( 6, 99 ); 369 Size = MAP_APPFONT( 198, 8 ); 370 Text [ en-US ] = "Show automatically"; 371 }; 372 CheckBox CB_SHOW 373 { 374 HelpID = "sc:CheckBox:RID_SCDLG_DPSUBTOTAL_OPT:CB_SHOW"; 375 Pos = MAP_APPFONT( 12, 112 ); 376 Size = MAP_APPFONT( 70, 10 ); 377 TabStop = TRUE; 378 Text[ en-US ] = "~Show"; 379 }; 380 NumericField NF_SHOW 381 { 382 HelpID = "sc:NumericField:RID_SCDLG_DPSUBTOTAL_OPT:NF_SHOW"; 383 Pos = MAP_APPFONT( 84, 110 ); 384 Size = MAP_APPFONT( 30, 12 ); 385 TabStop = TRUE; 386 Border = TRUE; 387 Repeat = TRUE; 388 Spin = TRUE; 389 Minimum = 1; 390 Maximum = 999; 391 SpinSize = 1; 392 StrictFormat = TRUE; 393 }; 394 FixedText FT_SHOW 395 { 396 Pos = MAP_APPFONT( 118, 112 ); 397 Size = MAP_APPFONT( 80, 8 ); 398 Text [ en-US ] = "items"; 399 }; 400 FixedText FT_SHOW_FROM 401 { 402 Pos = MAP_APPFONT( 22, 128 ); 403 Size = MAP_APPFONT( 60, 8 ); 404 Text [ en-US ] = "~From"; 405 }; 406 ListBox LB_SHOW_FROM 407 { 408 HelpID = "sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_SHOW_FROM"; 409 Pos = MAP_APPFONT( 84, 126 ); 410 Size = MAP_APPFONT( 114, 50 ); 411 TabStop = TRUE; 412 Border = TRUE; 413 DropDown = TRUE; 414 StringList [ en-US ] = 415 { 416 < "Top"; Default; >; 417 < "Bottom"; Default; >; 418 }; 419 }; 420 FixedText FT_SHOW_USING 421 { 422 Pos = MAP_APPFONT( 22, 144 ); 423 Size = MAP_APPFONT( 60, 8 ); 424 Text [ en-US ] = "~Using field"; 425 }; 426 ListBox LB_SHOW_USING 427 { 428 HelpID = "sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_SHOW_USING"; 429 Pos = MAP_APPFONT( 84, 142 ); 430 Size = MAP_APPFONT( 114, 120 ); 431 TabStop = TRUE; 432 Border = TRUE; 433 DropDown = TRUE; 434 }; 435 FixedLine FL_HIDE 436 { 437 Pos = MAP_APPFONT( 6, 160 ); 438 Size = MAP_APPFONT( 198, 8 ); 439 Text [ en-US ] = "Hide i~tems"; 440 }; 441 Control CT_HIDE 442 { 443 Pos = MAP_APPFONT( 12, 171 ); 444 Size = MAP_APPFONT( 186, 45 ); 445 TabStop = TRUE; 446 Border = TRUE; 447 }; 448 FixedText FT_HIERARCHY 449 { 450 Pos = MAP_APPFONT( 6, 224 ); 451 Size = MAP_APPFONT( 76, 8 ); 452 Text [ en-US ] = "Hierarch~y"; 453 }; 454 ListBox LB_HIERARCHY 455 { 456 HelpID = "sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_HIERARCHY"; 457 Pos = MAP_APPFONT( 84, 222 ); 458 Size = MAP_APPFONT( 114, 120 ); 459 TabStop = TRUE; 460 Border = TRUE; 461 DropDown = TRUE; 462 }; 463 OKButton BTN_OK 464 { 465 Pos = MAP_APPFONT( 210, 6 ); 466 Size = MAP_APPFONT( 50, 14 ); 467 TabStop = TRUE; 468 DefButton = TRUE; 469 }; 470 CancelButton BTN_CANCEL 471 { 472 Pos = MAP_APPFONT( 210, 23 ); 473 Size = MAP_APPFONT( 50, 14 ); 474 TabStop = TRUE; 475 }; 476 HelpButton BTN_HELP 477 { 478 Pos = MAP_APPFONT( 210, 43 ); 479 Size = MAP_APPFONT( 50, 14 ); 480 TabStop = TRUE; 481 }; 482 Text [ en-US ] = "Data Field Options"; 483}; 484 485// ---------------------------------------------------------------------------- 486 487ModalDialog RID_SCDLG_DPSHOWDETAIL 488{ 489 OutputSize = TRUE; 490 HelpId = HID_SC_DPSHOWDETAIL; 491 SVLook = TRUE; 492 Size = MAP_APPFONT( 200, 116 ); 493 Moveable = TRUE; 494 Closeable = FALSE; 495 FixedText FT_DIMS 496 { 497 Pos = MAP_APPFONT( 6, 3 ); 498 Size = MAP_APPFONT( 132, 24 ); 499 WordBreak = TRUE; 500 Text [ en-US ] = "~Choose the field containing the detail you want to show"; 501 }; 502 ListBox LB_DIMS 503 { 504 HelpID = "sc:ListBox:RID_SCDLG_DPSHOWDETAIL:LB_DIMS"; 505 Pos = MAP_APPFONT( 6, 30 ); 506 Size = MAP_APPFONT( 132, 80 ); 507 TabStop = TRUE; 508 Border = TRUE; 509 DropDown = FALSE; 510 }; 511 OKButton BTN_OK 512 { 513 Pos = MAP_APPFONT( 144, 6 ); 514 Size = MAP_APPFONT( 50, 14 ); 515 TabStop = TRUE; 516 DefButton = TRUE; 517 }; 518 CancelButton BTN_CANCEL 519 { 520 Pos = MAP_APPFONT( 144, 23 ); 521 Size = MAP_APPFONT( 50, 14 ); 522 TabStop = TRUE; 523 }; 524 HelpButton BTN_HELP 525 { 526 Pos = MAP_APPFONT( 144, 43 ); 527 Size = MAP_APPFONT( 50, 14 ); 528 TabStop = TRUE; 529 }; 530 Text [ en-US ] = "Show Detail"; 531}; 532 533// ---------------------------------------------------------------------------- 534 535