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