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