182177cdbSAndrew Rist/************************************************************** 2*2f154c07Smseidel * 382177cdbSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 482177cdbSAndrew Rist * or more contributor license agreements. See the NOTICE file 582177cdbSAndrew Rist * distributed with this work for additional information 682177cdbSAndrew Rist * regarding copyright ownership. The ASF licenses this file 782177cdbSAndrew Rist * to you under the Apache License, Version 2.0 (the 882177cdbSAndrew Rist * "License"); you may not use this file except in compliance 982177cdbSAndrew Rist * with the License. You may obtain a copy of the License at 10*2f154c07Smseidel * 1182177cdbSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*2f154c07Smseidel * 1382177cdbSAndrew Rist * Unless required by applicable law or agreed to in writing, 1482177cdbSAndrew Rist * software distributed under the License is distributed on an 1582177cdbSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1682177cdbSAndrew Rist * KIND, either express or implied. See the License for the 1782177cdbSAndrew Rist * specific language governing permissions and limitations 1882177cdbSAndrew Rist * under the License. 19*2f154c07Smseidel * 2082177cdbSAndrew Rist *************************************************************/ 2182177cdbSAndrew Rist 2282177cdbSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir#include "pivot.hrc" 25cdf0e10cSrcweir 26cdf0e10cSrcweirModelessDialog RID_SCDLG_PIVOT_LAYOUT 27cdf0e10cSrcweir{ 28cdf0e10cSrcweir OutputSize = TRUE ; 29cdf0e10cSrcweir HelpId = CMD_SID_OPENDLG_PIVOTTABLE ; 30*2f154c07Smseidel Size = MAP_APPFONT ( 348, 186 ) ; 31cdf0e10cSrcweir Hide = TRUE ; 32cdf0e10cSrcweir SVLook = TRUE ; 33cdf0e10cSrcweir Moveable = TRUE ; 34cdf0e10cSrcweir Closeable = FALSE ; 35cdf0e10cSrcweir Text [ en-US ] = "Pivot Table" ; 36cdf0e10cSrcweir 37*2f154c07Smseidel FixedText FT_PAGE 38*2f154c07Smseidel { 39*2f154c07Smseidel Pos = MAP_APPFONT ( 194, 168 ) ; 40*2f154c07Smseidel Size = MAP_APPFONT ( 37, 8 ) ; 41*2f154c07Smseidel Text [ en-US ] = "Page Fields" ; 42*2f154c07Smseidel }; 43*2f154c07Smseidel ScrollBar SCROLL_PAGE 44*2f154c07Smseidel { 45*2f154c07Smseidel Pos = MAP_APPFONT ( 198, 14 ) ; 46*2f154c07Smseidel Size = MAP_APPFONT ( 8, 24 ) ; 47*2f154c07Smseidel HScroll = FALSE ; 48*2f154c07Smseidel TabStop = FALSE ; 49*2f154c07Smseidel }; 50*2f154c07Smseidel Control WND_PAGE 51*2f154c07Smseidel { 52*2f154c07Smseidel Pos = MAP_APPFONT ( 18, 14 ) ; 53*2f154c07Smseidel Size = MAP_APPFONT ( 180, 24 ) ; 54*2f154c07Smseidel TabStop = TRUE ; 55*2f154c07Smseidel }; 56*2f154c07Smseidel FixedText FT_COL 57*2f154c07Smseidel { 58*2f154c07Smseidel Pos = MAP_APPFONT ( 231, 168 ) ; 59*2f154c07Smseidel Size = MAP_APPFONT ( 37, 8 ) ; 60*2f154c07Smseidel Text [ en-US ] = "Column Fields" ; 61*2f154c07Smseidel }; 62*2f154c07Smseidel ScrollBar SCROLL_COL 63*2f154c07Smseidel { 64*2f154c07Smseidel Pos = MAP_APPFONT ( 198, 42 ) ; 65*2f154c07Smseidel Size = MAP_APPFONT ( 8, 24 ) ; 66*2f154c07Smseidel HScroll = FALSE ; 67*2f154c07Smseidel TabStop = FALSE ; 68*2f154c07Smseidel }; 69*2f154c07Smseidel Control WND_COL 70*2f154c07Smseidel { 71*2f154c07Smseidel Pos = MAP_APPFONT ( 54, 42 ) ; 72*2f154c07Smseidel Size = MAP_APPFONT ( 144, 24 ) ; 73*2f154c07Smseidel TabStop = TRUE ; 74*2f154c07Smseidel }; 75*2f154c07Smseidel FixedText FT_ROW 76*2f154c07Smseidel { 77*2f154c07Smseidel Pos = MAP_APPFONT ( 194, 176 ) ; 78*2f154c07Smseidel Size = MAP_APPFONT ( 37, 8 ) ; 79*2f154c07Smseidel Text [ en-US ] = "Row\nFields" ; 80*2f154c07Smseidel }; 81*2f154c07Smseidel ScrollBar SCROLL_ROW 82*2f154c07Smseidel { 83*2f154c07Smseidel Pos = MAP_APPFONT ( 42, 70 ) ; 84*2f154c07Smseidel Size = MAP_APPFONT ( 8, 96 ) ; 85*2f154c07Smseidel HScroll = FALSE ; 86*2f154c07Smseidel TabStop = FALSE ; 87*2f154c07Smseidel }; 88*2f154c07Smseidel Control WND_ROW 89*2f154c07Smseidel { 90*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 70 ) ; 91*2f154c07Smseidel Size = MAP_APPFONT ( 36, 96 ) ; 92*2f154c07Smseidel TabStop = TRUE ; 93*2f154c07Smseidel }; 94*2f154c07Smseidel FixedText FT_DATA 95*2f154c07Smseidel { 96*2f154c07Smseidel Pos = MAP_APPFONT ( 231, 176 ) ; 97*2f154c07Smseidel Size = MAP_APPFONT ( 37, 8 ) ; 98*2f154c07Smseidel Text [ en-US ] = "Data Fields" ; 99*2f154c07Smseidel }; 100*2f154c07Smseidel ScrollBar SCROLL_DATA 101*2f154c07Smseidel { 102*2f154c07Smseidel Pos = MAP_APPFONT ( 198, 70 ) ; 103*2f154c07Smseidel Size = MAP_APPFONT ( 8, 96 ) ; 104*2f154c07Smseidel HScroll = FALSE ; 105*2f154c07Smseidel TabStop = FALSE ; 106*2f154c07Smseidel }; 107*2f154c07Smseidel Control WND_DATA 108*2f154c07Smseidel { 109*2f154c07Smseidel Pos = MAP_APPFONT ( 54, 70 ) ; 110*2f154c07Smseidel Size = MAP_APPFONT ( 144, 96 ) ; 111*2f154c07Smseidel TabStop = TRUE ; 112*2f154c07Smseidel }; 113*2f154c07Smseidel Control WND_SELECT 114*2f154c07Smseidel { 115*2f154c07Smseidel Pos = MAP_APPFONT ( 212, 14 ) ; 116*2f154c07Smseidel Size = MAP_APPFONT ( 74, 138 ) ; 117*2f154c07Smseidel TabStop = TRUE ; 118cdf0e10cSrcweir }; 119cdf0e10cSrcweir String STR_SELECT 120cdf0e10cSrcweir { 121*2f154c07Smseidel Text [ en-US ] = "Selection area" ; 122*2f154c07Smseidel }; 123*2f154c07Smseidel ScrollBar WND_HSCROLL 124*2f154c07Smseidel { 125*2f154c07Smseidel Pos = MAP_APPFONT ( 212, 154 ) ; 126*2f154c07Smseidel Size = MAP_APPFONT ( 74, 8 ) ; 127*2f154c07Smseidel HScroll = TRUE ; 128*2f154c07Smseidel TabStop = FALSE ; 129cdf0e10cSrcweir }; 130cdf0e10cSrcweir FixedText FT_INFO 131cdf0e10cSrcweir { 132*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 172 ) ; 133*2f154c07Smseidel Size = MAP_APPFONT ( 280, 8 ) ; 134cdf0e10cSrcweir WordBreak = TRUE ; 135cdf0e10cSrcweir Text [ en-US ] = "Drag the fields from the right into the desired position." ; 136cdf0e10cSrcweir }; 137*2f154c07Smseidel FixedLine FL_LAYOUT 138cdf0e10cSrcweir { 139*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 3 ) ; 140*2f154c07Smseidel Size = MAP_APPFONT ( 200, 8 ) ; 141*2f154c07Smseidel Text [ en-US ] = "Layout" ; 142cdf0e10cSrcweir }; 143*2f154c07Smseidel FixedLine FL_SELECT 144cdf0e10cSrcweir { 145*2f154c07Smseidel Pos = MAP_APPFONT ( 212, 3 ) ; 146*2f154c07Smseidel Size = MAP_APPFONT ( 74, 8 ) ; 147*2f154c07Smseidel Text [ en-US ] = "Fields" ; 148cdf0e10cSrcweir }; 149cdf0e10cSrcweir OKButton BTN_OK 150cdf0e10cSrcweir { 151*2f154c07Smseidel Pos = MAP_APPFONT ( 292, 6 ) ; 152*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 153cdf0e10cSrcweir TabStop = TRUE ; 154cdf0e10cSrcweir DefButton = TRUE ; 155cdf0e10cSrcweir }; 156cdf0e10cSrcweir CancelButton BTN_CANCEL 157cdf0e10cSrcweir { 158*2f154c07Smseidel Pos = MAP_APPFONT ( 292, 23 ) ; 159*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 160cdf0e10cSrcweir TabStop = TRUE ; 161cdf0e10cSrcweir }; 162cdf0e10cSrcweir HelpButton BTN_HELP 163cdf0e10cSrcweir { 164*2f154c07Smseidel Pos = MAP_APPFONT ( 292, 43 ) ; 165*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 166cdf0e10cSrcweir TabStop = TRUE ; 167cdf0e10cSrcweir }; 168*2f154c07Smseidel PushButton BTN_REMOVE 169cdf0e10cSrcweir { 170*2f154c07Smseidel HelpID = "sc:PushButton:RID_SCDLG_PIVOT_LAYOUT:BTN_REMOVE" ; 171*2f154c07Smseidel Pos = MAP_APPFONT ( 292, 63 ) ; 172*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 173cdf0e10cSrcweir TabStop = TRUE ; 174*2f154c07Smseidel Text [ en-US ] = "Remove" ; 175cdf0e10cSrcweir }; 176*2f154c07Smseidel PushButton BTN_OPTIONS 177cdf0e10cSrcweir { 178*2f154c07Smseidel HelpID = "sc:PushButton:RID_SCDLG_PIVOT_LAYOUT:BTN_OPTIONS" ; 179*2f154c07Smseidel Pos = MAP_APPFONT ( 292, 80 ) ; 180*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 181cdf0e10cSrcweir TabStop = TRUE ; 182*2f154c07Smseidel Text [ en-US ] = "Options..." ; 183cdf0e10cSrcweir }; 184cdf0e10cSrcweir MoreButton BTN_MORE 185cdf0e10cSrcweir { 186*2f154c07Smseidel HelpID = "sc:MoreButton:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE" ; 187*2f154c07Smseidel Pos = MAP_APPFONT ( 292, 166 ) ; 188*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 189cdf0e10cSrcweir TabStop = TRUE ; 190cdf0e10cSrcweir MapUnit = MAP_APPFONT ; 191*2f154c07Smseidel Delta = 90 ; 192cdf0e10cSrcweir }; 193*2f154c07Smseidel FixedLine FL_OUTPUT 194cdf0e10cSrcweir { 195*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 186 ) ; 196*2f154c07Smseidel Size = MAP_APPFONT ( 280, 8 ) ; 197cdf0e10cSrcweir Text [ en-US ] = "Result" ; 198cdf0e10cSrcweir Hide = TRUE ; 199cdf0e10cSrcweir }; 200cdf0e10cSrcweir 201*2f154c07Smseidel FixedText FT_INAREA 202*2f154c07Smseidel { 203*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 199 ) ; 204*2f154c07Smseidel Size = MAP_APPFONT ( 59, 8 ) ; 205*2f154c07Smseidel Hide = TRUE ; 206*2f154c07Smseidel Text [ en-US ] = "Selection from" ; 207*2f154c07Smseidel }; 208*2f154c07Smseidel Edit ED_INAREA 209*2f154c07Smseidel { 210*2f154c07Smseidel HelpID = "sc:Edit:RID_SCDLG_PIVOT_LAYOUT:ED_INAREA" ; 211*2f154c07Smseidel Border = TRUE ; 212*2f154c07Smseidel Pos = MAP_APPFONT ( 73, 197 ) ; 213*2f154c07Smseidel Size = MAP_APPFONT ( 109, 12 ) ; 214*2f154c07Smseidel TabStop = TRUE ; 215*2f154c07Smseidel Hide = TRUE ; 216*2f154c07Smseidel }; 217*2f154c07Smseidel ImageButton RB_INAREA 218cdf0e10cSrcweir { 219*2f154c07Smseidel HelpID = "sc:ImageButton:RID_SCDLG_PIVOT_LAYOUT:RB_INAREA" ; 220*2f154c07Smseidel Pos = MAP_APPFONT ( 186, 196 ) ; 221*2f154c07Smseidel Size = MAP_APPFONT ( 13, 15 ) ; 222*2f154c07Smseidel TabStop = TRUE ; 223cdf0e10cSrcweir Hide = TRUE ; 224*2f154c07Smseidel QuickHelpText [ en-US ] = "Shrink" ; 225*2f154c07Smseidel }; 226cdf0e10cSrcweir 227cdf0e10cSrcweir FixedText FT_OUTAREA 228cdf0e10cSrcweir { 229*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 217 ) ; 230*2f154c07Smseidel Size = MAP_APPFONT ( 59, 8 ) ; 231cdf0e10cSrcweir Hide = TRUE ; 232cdf0e10cSrcweir Text [ en-US ] = "Results to" ; 233cdf0e10cSrcweir }; 234cdf0e10cSrcweir ListBox LB_OUTAREA 235cdf0e10cSrcweir { 236*2f154c07Smseidel HelpID = "sc:ListBox:RID_SCDLG_PIVOT_LAYOUT:LB_OUTAREA" ; 237cdf0e10cSrcweir Border = TRUE ; 238*2f154c07Smseidel Pos = MAP_APPFONT ( 73, 215 ) ; 239*2f154c07Smseidel Size = MAP_APPFONT ( 75, 90 ) ; 240cdf0e10cSrcweir TabStop = TRUE ; 241cdf0e10cSrcweir DropDown = TRUE ; 242cdf0e10cSrcweir Hide = TRUE ; 243cdf0e10cSrcweir }; 244cdf0e10cSrcweir Edit ED_OUTAREA 245cdf0e10cSrcweir { 246*2f154c07Smseidel HelpID = "sc:Edit:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA" ; 247cdf0e10cSrcweir Border = TRUE ; 248*2f154c07Smseidel Pos = MAP_APPFONT ( 152, 215 ) ; 249*2f154c07Smseidel Size = MAP_APPFONT ( 109, 12 ) ; 250cdf0e10cSrcweir TabStop = TRUE ; 251cdf0e10cSrcweir Hide = TRUE ; 252cdf0e10cSrcweir }; 253cdf0e10cSrcweir ImageButton RB_OUTAREA 254cdf0e10cSrcweir { 255*2f154c07Smseidel HelpID = "sc:ImageButton:RID_SCDLG_PIVOT_LAYOUT:RB_OUTAREA" ; 256*2f154c07Smseidel Pos = MAP_APPFONT ( 265, 214 ) ; 257*2f154c07Smseidel Size = MAP_APPFONT ( 13, 15 ) ; 258*2f154c07Smseidel TabStop = TRUE ; 259*2f154c07Smseidel Hide = TRUE ; 260cdf0e10cSrcweir QuickHelpText [ en-US ] = "Shrink" ; 261cdf0e10cSrcweir }; 262cdf0e10cSrcweir CheckBox BTN_IGNEMPTYROWS 263cdf0e10cSrcweir { 264*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS" ; 265*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 233 ) ; 266*2f154c07Smseidel Size = MAP_APPFONT ( 136, 10 ) ; 267cdf0e10cSrcweir TabStop = TRUE ; 268cdf0e10cSrcweir Hide = TRUE ; 269cdf0e10cSrcweir Text [ en-US ] = "Ignore ~empty rows" ; 270cdf0e10cSrcweir }; 271cdf0e10cSrcweir CheckBox BTN_DETECTCAT 272cdf0e10cSrcweir { 273*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_DETECTCAT" ; 274*2f154c07Smseidel Pos = MAP_APPFONT ( 152, 233 ) ; 275*2f154c07Smseidel Size = MAP_APPFONT ( 128, 10 ) ; 276cdf0e10cSrcweir TabStop = TRUE ; 277cdf0e10cSrcweir Hide = TRUE ; 278cdf0e10cSrcweir Text [ en-US ] = "~Identify categories" ; 279cdf0e10cSrcweir }; 280cdf0e10cSrcweir CheckBox BTN_TOTALCOL 281cdf0e10cSrcweir { 282*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALCOL" ; 283*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 247 ) ; 284*2f154c07Smseidel Size = MAP_APPFONT ( 136, 10 ) ; 285cdf0e10cSrcweir TabStop = TRUE ; 286cdf0e10cSrcweir Hide = TRUE ; 287*2f154c07Smseidel Text [ en-US ] = "Total columns" ; 288cdf0e10cSrcweir }; 289cdf0e10cSrcweir CheckBox BTN_TOTALROW 290cdf0e10cSrcweir { 291*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALROW" ; 292*2f154c07Smseidel Pos = MAP_APPFONT ( 152, 247 ) ; 293*2f154c07Smseidel Size = MAP_APPFONT ( 128, 10 ) ; 294cdf0e10cSrcweir TabStop = TRUE ; 295cdf0e10cSrcweir Hide = TRUE ; 296cdf0e10cSrcweir Text [ en-US ] = "~Total rows" ; 297cdf0e10cSrcweir }; 298*2f154c07Smseidel CheckBox BTN_FILTER 299*2f154c07Smseidel { 300*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_FILTER" ; 301*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 261 ) ; 302*2f154c07Smseidel Size = MAP_APPFONT ( 136, 10 ) ; 303*2f154c07Smseidel TabStop = TRUE ; 304*2f154c07Smseidel Hide = TRUE ; 305*2f154c07Smseidel Text [ en-US ] = "~Add filter" ; 306*2f154c07Smseidel }; 307*2f154c07Smseidel CheckBox BTN_DRILLDOWN 308*2f154c07Smseidel { 309*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_DRILLDOWN" ; 310*2f154c07Smseidel Pos = MAP_APPFONT ( 152, 261 ) ; 311*2f154c07Smseidel Size = MAP_APPFONT ( 128, 10 ) ; 312*2f154c07Smseidel TabStop = TRUE ; 313*2f154c07Smseidel Hide = TRUE ; 314*2f154c07Smseidel Text [ en-US ] = "Ena~ble drill to details" ; 315*2f154c07Smseidel }; 316cdf0e10cSrcweir String PIVOTSTR_SUM 317cdf0e10cSrcweir { 318cdf0e10cSrcweir Text [ en-US ] = "Sum - " ; 319cdf0e10cSrcweir }; 320cdf0e10cSrcweir String PIVOTSTR_COUNT 321cdf0e10cSrcweir { 322cdf0e10cSrcweir Text [ en-US ] = "Count - " ; 323cdf0e10cSrcweir }; 324cdf0e10cSrcweir String PIVOTSTR_AVG 325cdf0e10cSrcweir { 326cdf0e10cSrcweir Text [ en-US ] = "Mean - " ; 327cdf0e10cSrcweir }; 328cdf0e10cSrcweir String PIVOTSTR_MAX 329cdf0e10cSrcweir { 330cdf0e10cSrcweir Text [ en-US ] = "Max - " ; 331cdf0e10cSrcweir }; 332cdf0e10cSrcweir String PIVOTSTR_MIN 333cdf0e10cSrcweir { 334cdf0e10cSrcweir Text [ en-US ] = "Min - " ; 335cdf0e10cSrcweir }; 336cdf0e10cSrcweir String PIVOTSTR_PROD 337cdf0e10cSrcweir { 338cdf0e10cSrcweir Text [ en-US ] = "Product - " ; 339cdf0e10cSrcweir }; 340cdf0e10cSrcweir String PIVOTSTR_COUNT2 341cdf0e10cSrcweir { 342cdf0e10cSrcweir Text [ en-US ] = "Count - " ; 343cdf0e10cSrcweir }; 344cdf0e10cSrcweir String PIVOTSTR_DEV 345cdf0e10cSrcweir { 346cdf0e10cSrcweir Text [ en-US ] = "StDev - " ; 347cdf0e10cSrcweir }; 348cdf0e10cSrcweir String PIVOTSTR_DEV2 349cdf0e10cSrcweir { 350cdf0e10cSrcweir Text [ en-US ] = "StDevP - " ; 351cdf0e10cSrcweir }; 352cdf0e10cSrcweir String PIVOTSTR_VAR 353cdf0e10cSrcweir { 354cdf0e10cSrcweir Text [ en-US ] = "Var - " ; 355cdf0e10cSrcweir }; 356cdf0e10cSrcweir String PIVOTSTR_VAR2 357cdf0e10cSrcweir { 358cdf0e10cSrcweir Text [ en-US ] = "VarP - " ; 359cdf0e10cSrcweir }; 360cdf0e10cSrcweir}; 361cdf0e10cSrcweir 362*2f154c07Smseidel// ********************************************************************** EOF 363