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