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// ********************************************************************** EOF 534