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 23*2f154c07Smseidel 24cdf0e10cSrcweir#include "consdlg.hrc" 25cdf0e10cSrcweirModelessDialog RID_SCDLG_CONSOLIDATE 26cdf0e10cSrcweir{ 27cdf0e10cSrcweir OutputSize = TRUE ; 28cdf0e10cSrcweir HelpId = CMD_SID_OPENDLG_CONSOLIDATE ; 29cdf0e10cSrcweir Hide = TRUE ; 30cdf0e10cSrcweir SVLook = TRUE ; 31*2f154c07Smseidel Size = MAP_APPFONT ( 280, 154 ) ; 32cdf0e10cSrcweir Text [ en-US ] = "Consolidate" ; 33cdf0e10cSrcweir Moveable = TRUE ; 34cdf0e10cSrcweir Closeable = FALSE ; 35cdf0e10cSrcweir ListBox LB_FUNC 36cdf0e10cSrcweir { 37*2f154c07Smseidel HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_FUNC" ; 38cdf0e10cSrcweir Border = TRUE ; 39*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 17 ) ; 40*2f154c07Smseidel Size = MAP_APPFONT ( 212, 90 ) ; 41cdf0e10cSrcweir TabStop = TRUE ; 42cdf0e10cSrcweir DropDown = TRUE ; 43cdf0e10cSrcweir StringList [ en-US ] = 44cdf0e10cSrcweir { 45*2f154c07Smseidel < "Sum" ; Default ; > ; 46*2f154c07Smseidel < "Count" ; Default ; > ; 47*2f154c07Smseidel < "Average" ; Default ; > ; 48*2f154c07Smseidel < "Max" ; Default ; > ; 49*2f154c07Smseidel < "Min" ; Default ; > ; 50*2f154c07Smseidel < "Product" ; Default ; > ; 51*2f154c07Smseidel < "Count (numbers only)" ; Default ; > ; 52*2f154c07Smseidel < "StDev (sample)" ; Default ; > ; 53*2f154c07Smseidel < "StDevP (population)" ; Default ; > ; 54*2f154c07Smseidel < "Var (sample)" ; Default ; > ; 55*2f154c07Smseidel < "VarP (population)" ; Default ; > ; 56cdf0e10cSrcweir }; 57cdf0e10cSrcweir }; 58cdf0e10cSrcweir Edit ED_DATA_AREA 59cdf0e10cSrcweir { 60*2f154c07Smseidel HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA" ; 61cdf0e10cSrcweir Border = TRUE ; 62*2f154c07Smseidel Pos = MAP_APPFONT ( 100, 106 ) ; 63*2f154c07Smseidel Size = MAP_APPFONT ( 104, 12 ) ; 64cdf0e10cSrcweir TabStop = TRUE ; 65cdf0e10cSrcweir }; 66cdf0e10cSrcweir Edit ED_DEST_AREA 67cdf0e10cSrcweir { 68*2f154c07Smseidel HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA" ; 69cdf0e10cSrcweir Border = TRUE ; 70*2f154c07Smseidel Pos = MAP_APPFONT ( 100, 135 ) ; 71*2f154c07Smseidel Size = MAP_APPFONT ( 104, 12 ) ; 72cdf0e10cSrcweir TabStop = TRUE ; 73cdf0e10cSrcweir }; 74cdf0e10cSrcweir ImageButton RB_DATA_AREA 75cdf0e10cSrcweir { 76*2f154c07Smseidel HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA" ; 77*2f154c07Smseidel Pos = MAP_APPFONT ( 206, 105 ) ; 78*2f154c07Smseidel Size = MAP_APPFONT ( 13, 15 ) ; 79cdf0e10cSrcweir TabStop = TRUE ; 80cdf0e10cSrcweir QuickHelpText [ en-US ] = "Shrink" ; 81cdf0e10cSrcweir }; 82cdf0e10cSrcweir ImageButton RB_DEST_AREA 83cdf0e10cSrcweir { 84*2f154c07Smseidel HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA" ; 85*2f154c07Smseidel Pos = MAP_APPFONT ( 206, 134 ) ; 86*2f154c07Smseidel Size = MAP_APPFONT ( 13, 15 ) ; 87cdf0e10cSrcweir TabStop = TRUE ; 88cdf0e10cSrcweir QuickHelpText [ en-US ] = "Shrink" ; 89cdf0e10cSrcweir }; 90cdf0e10cSrcweir ListBox LB_DATA_AREA 91cdf0e10cSrcweir { 92*2f154c07Smseidel HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA" ; 93cdf0e10cSrcweir Border = TRUE ; 94*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 106 ) ; 95*2f154c07Smseidel Size = MAP_APPFONT ( 90, 90 ) ; 96cdf0e10cSrcweir TabStop = TRUE ; 97cdf0e10cSrcweir DropDown = TRUE ; 98cdf0e10cSrcweir }; 99cdf0e10cSrcweir ListBox LB_DEST_AREA 100cdf0e10cSrcweir { 101*2f154c07Smseidel HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA" ; 102cdf0e10cSrcweir Border = TRUE ; 103*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 135 ) ; 104*2f154c07Smseidel Size = MAP_APPFONT ( 90, 90 ) ; 105cdf0e10cSrcweir TabStop = TRUE ; 106cdf0e10cSrcweir DropDown = TRUE ; 107cdf0e10cSrcweir }; 108cdf0e10cSrcweir MultiListBox LB_CONSAREAS 109cdf0e10cSrcweir { 110*2f154c07Smseidel HelpID = "sc:MultiListBox:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS" ; 111cdf0e10cSrcweir SimpleMode = TRUE ; 112cdf0e10cSrcweir Border = TRUE ; 113*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 46 ) ; 114*2f154c07Smseidel Size = MAP_APPFONT ( 212, 43 ) ; 115cdf0e10cSrcweir TabStop = TRUE ; 116cdf0e10cSrcweir }; 117cdf0e10cSrcweir FixedText FT_FUNC 118cdf0e10cSrcweir { 119*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 6 ) ; 120*2f154c07Smseidel Size = MAP_APPFONT ( 212, 8 ) ; 121cdf0e10cSrcweir Text [ en-US ] = "~Function" ; 122cdf0e10cSrcweir }; 123cdf0e10cSrcweir FixedText FT_CONSAREAS 124cdf0e10cSrcweir { 125*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 35 ) ; 126*2f154c07Smseidel Size = MAP_APPFONT ( 212, 8 ) ; 127cdf0e10cSrcweir Text [ en-US ] = "~Consolidation ranges" ; 128cdf0e10cSrcweir }; 129cdf0e10cSrcweir FixedText FT_DATA_AREA 130cdf0e10cSrcweir { 131*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 95 ) ; 132*2f154c07Smseidel Size = MAP_APPFONT ( 212, 8 ) ; 133cdf0e10cSrcweir Text [ en-US ] = "~Source data range" ; 134cdf0e10cSrcweir }; 135cdf0e10cSrcweir FixedText FT_DEST_AREA 136cdf0e10cSrcweir { 137*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 124 ) ; 138*2f154c07Smseidel Size = MAP_APPFONT ( 212, 8 ) ; 139cdf0e10cSrcweir Text [ en-US ] = "Copy results ~to" ; 140cdf0e10cSrcweir }; 141cdf0e10cSrcweir CheckBox BTN_BYROW 142cdf0e10cSrcweir { 143*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW" ; 144*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 165 ) ; 145*2f154c07Smseidel Size = MAP_APPFONT ( 94, 10 ) ; 146cdf0e10cSrcweir Text [ en-US ] = "~Row labels" ; 147cdf0e10cSrcweir TabStop = TRUE ; 148cdf0e10cSrcweir }; 149cdf0e10cSrcweir CheckBox BTN_BYCOL 150cdf0e10cSrcweir { 151*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL" ; 152*2f154c07Smseidel Pos = MAP_APPFONT ( 12, 179 ) ; 153*2f154c07Smseidel Size = MAP_APPFONT ( 94, 10 ) ; 154cdf0e10cSrcweir TabStop = TRUE ; 155cdf0e10cSrcweir Text [ en-US ] = "C~olumn labels" ; 156cdf0e10cSrcweir }; 157*2f154c07Smseidel FixedLine FL_CONSBY 158cdf0e10cSrcweir { 159*2f154c07Smseidel Pos = MAP_APPFONT ( 6, 154 ) ; 160*2f154c07Smseidel Size = MAP_APPFONT ( 103, 8 ) ; 161cdf0e10cSrcweir Text [ en-US ] = "Consolidate by" ; 162cdf0e10cSrcweir }; 163*2f154c07Smseidel FixedLine FL_SEP 164cdf0e10cSrcweir { 165*2f154c07Smseidel Pos = MAP_APPFONT ( 112, 165 ) ; 166*2f154c07Smseidel Size = MAP_APPFONT ( 1, 24 ) ; 167*2f154c07Smseidel }; 168*2f154c07Smseidel FixedLine FL_OPTIONS 169cdf0e10cSrcweir { 170cdf0e10cSrcweir Hide = TRUE ; 171*2f154c07Smseidel Pos = MAP_APPFONT ( 115, 154 ) ; 172*2f154c07Smseidel Size = MAP_APPFONT ( 103, 8 ) ; 173cdf0e10cSrcweir Text [ en-US ] = "Options" ; 174cdf0e10cSrcweir }; 175cdf0e10cSrcweir CheckBox BTN_REFS 176cdf0e10cSrcweir { 177*2f154c07Smseidel HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS" ; 178*2f154c07Smseidel Pos = MAP_APPFONT ( 121, 165 ) ; 179*2f154c07Smseidel Size = MAP_APPFONT ( 94, 10 ) ; 180cdf0e10cSrcweir Text [ en-US ] = "~Link to source data" ; 181cdf0e10cSrcweir TabStop = TRUE ; 182cdf0e10cSrcweir }; 183cdf0e10cSrcweir OKButton BTN_OK 184cdf0e10cSrcweir { 185*2f154c07Smseidel Pos = MAP_APPFONT ( 224, 6 ) ; 186*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 187cdf0e10cSrcweir TabStop = TRUE ; 188cdf0e10cSrcweir DefButton = TRUE ; 189cdf0e10cSrcweir }; 190cdf0e10cSrcweir CancelButton BTN_CANCEL 191cdf0e10cSrcweir { 192*2f154c07Smseidel Pos = MAP_APPFONT ( 224, 23 ) ; 193*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 194cdf0e10cSrcweir TabStop = TRUE ; 195cdf0e10cSrcweir }; 196cdf0e10cSrcweir HelpButton BTN_HELP 197cdf0e10cSrcweir { 198*2f154c07Smseidel Pos = MAP_APPFONT ( 224, 43 ) ; 199*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 200cdf0e10cSrcweir TabStop = TRUE ; 201cdf0e10cSrcweir }; 202cdf0e10cSrcweir MoreButton BTN_MORE 203cdf0e10cSrcweir { 204*2f154c07Smseidel HelpID = "sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE" ; 205*2f154c07Smseidel Pos = MAP_APPFONT ( 224, 134 ) ; 206*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 207cdf0e10cSrcweir TabStop = TRUE ; 208cdf0e10cSrcweir MapUnit = MAP_APPFONT ; 209*2f154c07Smseidel Delta = 41 ; 210cdf0e10cSrcweir }; 211cdf0e10cSrcweir PushButton BTN_REMOVE 212cdf0e10cSrcweir { 213*2f154c07Smseidel HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_REMOVE" ; 214*2f154c07Smseidel Pos = MAP_APPFONT ( 224, 114 ) ; 215*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 216cdf0e10cSrcweir Text [ en-US ] = "~Delete" ; 217cdf0e10cSrcweir TabStop = TRUE ; 218cdf0e10cSrcweir }; 219cdf0e10cSrcweir PushButton BTN_ADD 220cdf0e10cSrcweir { 221*2f154c07Smseidel HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD" ; 222*2f154c07Smseidel Pos = MAP_APPFONT ( 224, 96 ) ; 223*2f154c07Smseidel Size = MAP_APPFONT ( 50, 14 ) ; 224cdf0e10cSrcweir Text [ en-US ] = "~Add" ; 225cdf0e10cSrcweir TabStop = TRUE ; 226cdf0e10cSrcweir }; 227cdf0e10cSrcweir}; 228cdf0e10cSrcweir 229*2f154c07Smseidel// ********************************************************************** EOF 230