1*b1cdbd2cSJim Jagielski/************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski#include "consdlg.hrc" 24*b1cdbd2cSJim JagielskiModelessDialog RID_SCDLG_CONSOLIDATE 25*b1cdbd2cSJim Jagielski{ 26*b1cdbd2cSJim Jagielski OutputSize = TRUE ; 27*b1cdbd2cSJim Jagielski HelpId = CMD_SID_OPENDLG_CONSOLIDATE ; 28*b1cdbd2cSJim Jagielski Hide = TRUE ; 29*b1cdbd2cSJim Jagielski SVLook = TRUE ; 30*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 280 , 154 ) ; 31*b1cdbd2cSJim Jagielski Text [ en-US ] = "Consolidate" ; 32*b1cdbd2cSJim Jagielski Moveable = TRUE ; 33*b1cdbd2cSJim Jagielski Closeable = FALSE ; 34*b1cdbd2cSJim Jagielski ListBox LB_FUNC 35*b1cdbd2cSJim Jagielski { 36*b1cdbd2cSJim Jagielski HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_FUNC"; 37*b1cdbd2cSJim Jagielski Border = TRUE ; 38*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 17 ) ; 39*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 212 , 90 ) ; 40*b1cdbd2cSJim Jagielski TabStop = TRUE ; 41*b1cdbd2cSJim Jagielski DropDown = TRUE ; 42*b1cdbd2cSJim Jagielski StringList [ en-US ] = 43*b1cdbd2cSJim Jagielski { 44*b1cdbd2cSJim Jagielski < "Sum" ; Default ; > ; 45*b1cdbd2cSJim Jagielski < "Count" ; Default ; > ; 46*b1cdbd2cSJim Jagielski < "Average" ; Default ; > ; 47*b1cdbd2cSJim Jagielski < "Max" ; Default ; > ; 48*b1cdbd2cSJim Jagielski < "Min" ; Default ; > ; 49*b1cdbd2cSJim Jagielski < "Product" ; Default ; > ; 50*b1cdbd2cSJim Jagielski < "Count (numbers only)" ; Default ; > ; 51*b1cdbd2cSJim Jagielski < "StDev (sample)" ; Default ; > ; 52*b1cdbd2cSJim Jagielski < "StDevP (population)" ; Default ; > ; 53*b1cdbd2cSJim Jagielski < "Var (sample)" ; Default ; > ; 54*b1cdbd2cSJim Jagielski < "VarP (population)" ; Default ; > ; 55*b1cdbd2cSJim Jagielski }; 56*b1cdbd2cSJim Jagielski }; 57*b1cdbd2cSJim Jagielski Edit ED_DATA_AREA 58*b1cdbd2cSJim Jagielski { 59*b1cdbd2cSJim Jagielski HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA"; 60*b1cdbd2cSJim Jagielski Border = TRUE ; 61*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 100 , 106 ) ; 62*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 104 , 12 ) ; 63*b1cdbd2cSJim Jagielski TabStop = TRUE ; 64*b1cdbd2cSJim Jagielski }; 65*b1cdbd2cSJim Jagielski Edit ED_DEST_AREA 66*b1cdbd2cSJim Jagielski { 67*b1cdbd2cSJim Jagielski HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA"; 68*b1cdbd2cSJim Jagielski Border = TRUE ; 69*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 100 , 135 ) ; 70*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 104 , 12 ) ; 71*b1cdbd2cSJim Jagielski TabStop = TRUE ; 72*b1cdbd2cSJim Jagielski }; 73*b1cdbd2cSJim Jagielski ImageButton RB_DATA_AREA 74*b1cdbd2cSJim Jagielski { 75*b1cdbd2cSJim Jagielski HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA"; 76*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 206 , 105 ) ; 77*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 13 , 15 ) ; 78*b1cdbd2cSJim Jagielski TabStop = TRUE ; 79*b1cdbd2cSJim Jagielski QuickHelpText [ en-US ] = "Shrink" ; 80*b1cdbd2cSJim Jagielski }; 81*b1cdbd2cSJim Jagielski ImageButton RB_DEST_AREA 82*b1cdbd2cSJim Jagielski { 83*b1cdbd2cSJim Jagielski HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA"; 84*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 206 , 134 ) ; 85*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 13 , 15 ) ; 86*b1cdbd2cSJim Jagielski TabStop = TRUE ; 87*b1cdbd2cSJim Jagielski QuickHelpText [ en-US ] = "Shrink" ; 88*b1cdbd2cSJim Jagielski }; 89*b1cdbd2cSJim Jagielski ListBox LB_DATA_AREA 90*b1cdbd2cSJim Jagielski { 91*b1cdbd2cSJim Jagielski HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA"; 92*b1cdbd2cSJim Jagielski Border = TRUE ; 93*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 106 ) ; 94*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 90 , 90 ) ; 95*b1cdbd2cSJim Jagielski TabStop = TRUE ; 96*b1cdbd2cSJim Jagielski DropDown = TRUE ; 97*b1cdbd2cSJim Jagielski }; 98*b1cdbd2cSJim Jagielski ListBox LB_DEST_AREA 99*b1cdbd2cSJim Jagielski { 100*b1cdbd2cSJim Jagielski HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA"; 101*b1cdbd2cSJim Jagielski Border = TRUE ; 102*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 135 ) ; 103*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 90 , 90 ) ; 104*b1cdbd2cSJim Jagielski TabStop = TRUE ; 105*b1cdbd2cSJim Jagielski DropDown = TRUE ; 106*b1cdbd2cSJim Jagielski }; 107*b1cdbd2cSJim Jagielski MultiListBox LB_CONSAREAS 108*b1cdbd2cSJim Jagielski { 109*b1cdbd2cSJim Jagielski HelpID = "sc:MultiListBox:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS"; 110*b1cdbd2cSJim Jagielski SimpleMode = TRUE ; 111*b1cdbd2cSJim Jagielski Border = TRUE ; 112*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 46 ) ; 113*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 212 , 43 ) ; 114*b1cdbd2cSJim Jagielski TabStop = TRUE ; 115*b1cdbd2cSJim Jagielski }; 116*b1cdbd2cSJim Jagielski FixedText FT_FUNC 117*b1cdbd2cSJim Jagielski { 118*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 6 ) ; 119*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 212 , 8 ) ; 120*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Function" ; 121*b1cdbd2cSJim Jagielski }; 122*b1cdbd2cSJim Jagielski FixedText FT_CONSAREAS 123*b1cdbd2cSJim Jagielski { 124*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 35 ) ; 125*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 212 , 8 ) ; 126*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Consolidation ranges" ; 127*b1cdbd2cSJim Jagielski }; 128*b1cdbd2cSJim Jagielski FixedText FT_DATA_AREA 129*b1cdbd2cSJim Jagielski { 130*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 95 ) ; 131*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 212 , 8 ) ; 132*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Source data range" ; 133*b1cdbd2cSJim Jagielski }; 134*b1cdbd2cSJim Jagielski FixedText FT_DEST_AREA 135*b1cdbd2cSJim Jagielski { 136*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 124 ) ; 137*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 212 , 8 ) ; 138*b1cdbd2cSJim Jagielski Text [ en-US ] = "Copy results ~to" ; 139*b1cdbd2cSJim Jagielski }; 140*b1cdbd2cSJim Jagielski CheckBox BTN_BYROW 141*b1cdbd2cSJim Jagielski { 142*b1cdbd2cSJim Jagielski HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW"; 143*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 12 , 165 ) ; 144*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 94 , 10 ) ; 145*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Row labels" ; 146*b1cdbd2cSJim Jagielski TabStop = TRUE ; 147*b1cdbd2cSJim Jagielski }; 148*b1cdbd2cSJim Jagielski CheckBox BTN_BYCOL 149*b1cdbd2cSJim Jagielski { 150*b1cdbd2cSJim Jagielski HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL"; 151*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 12 , 179 ) ; 152*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 94 , 10 ) ; 153*b1cdbd2cSJim Jagielski TabStop = TRUE ; 154*b1cdbd2cSJim Jagielski Text [ en-US ] = "C~olumn labels" ; 155*b1cdbd2cSJim Jagielski }; 156*b1cdbd2cSJim Jagielski FixedLine FL_CONSBY 157*b1cdbd2cSJim Jagielski { 158*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 6 , 154 ) ; 159*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 103 , 8 ) ; 160*b1cdbd2cSJim Jagielski Text [ en-US ] = "Consolidate by" ; 161*b1cdbd2cSJim Jagielski }; 162*b1cdbd2cSJim Jagielski FixedLine FL_SEP 163*b1cdbd2cSJim Jagielski { 164*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 112 , 165 ) ; 165*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 1 , 24 ) ; 166*b1cdbd2cSJim Jagielski }; 167*b1cdbd2cSJim Jagielski FixedLine FL_OPTIONS 168*b1cdbd2cSJim Jagielski { 169*b1cdbd2cSJim Jagielski Hide = TRUE ; 170*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 115 , 154 ) ; 171*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 103 , 8 ) ; 172*b1cdbd2cSJim Jagielski Text [ en-US ] = "Options" ; 173*b1cdbd2cSJim Jagielski }; 174*b1cdbd2cSJim Jagielski CheckBox BTN_REFS 175*b1cdbd2cSJim Jagielski { 176*b1cdbd2cSJim Jagielski HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS"; 177*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 121 , 165 ) ; 178*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 94 , 10 ) ; 179*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Link to source data" ; 180*b1cdbd2cSJim Jagielski TabStop = TRUE ; 181*b1cdbd2cSJim Jagielski }; 182*b1cdbd2cSJim Jagielski OKButton BTN_OK 183*b1cdbd2cSJim Jagielski { 184*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 224 , 6 ) ; 185*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 50 , 14 ) ; 186*b1cdbd2cSJim Jagielski TabStop = TRUE ; 187*b1cdbd2cSJim Jagielski DefButton = TRUE ; 188*b1cdbd2cSJim Jagielski }; 189*b1cdbd2cSJim Jagielski CancelButton BTN_CANCEL 190*b1cdbd2cSJim Jagielski { 191*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 224 , 23 ) ; 192*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 50 , 14 ) ; 193*b1cdbd2cSJim Jagielski TabStop = TRUE ; 194*b1cdbd2cSJim Jagielski }; 195*b1cdbd2cSJim Jagielski HelpButton BTN_HELP 196*b1cdbd2cSJim Jagielski { 197*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 224 , 43 ) ; 198*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 50 , 14 ) ; 199*b1cdbd2cSJim Jagielski TabStop = TRUE ; 200*b1cdbd2cSJim Jagielski }; 201*b1cdbd2cSJim Jagielski MoreButton BTN_MORE 202*b1cdbd2cSJim Jagielski { 203*b1cdbd2cSJim Jagielski HelpID = "sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE"; 204*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 224 , 134 ) ; 205*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 50 , 14 ) ; 206*b1cdbd2cSJim Jagielski TabStop = TRUE ; 207*b1cdbd2cSJim Jagielski MapUnit = MAP_APPFONT ; 208*b1cdbd2cSJim Jagielski Delta = 41 ; 209*b1cdbd2cSJim Jagielski }; 210*b1cdbd2cSJim Jagielski PushButton BTN_REMOVE 211*b1cdbd2cSJim Jagielski { 212*b1cdbd2cSJim Jagielski HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_REMOVE"; 213*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 224 , 114 ) ; 214*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 50 , 14 ) ; 215*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Delete" ; 216*b1cdbd2cSJim Jagielski TabStop = TRUE ; 217*b1cdbd2cSJim Jagielski }; 218*b1cdbd2cSJim Jagielski PushButton BTN_ADD 219*b1cdbd2cSJim Jagielski { 220*b1cdbd2cSJim Jagielski HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD"; 221*b1cdbd2cSJim Jagielski Pos = MAP_APPFONT ( 224 , 96 ) ; 222*b1cdbd2cSJim Jagielski Size = MAP_APPFONT ( 50 , 14 ) ; 223*b1cdbd2cSJim Jagielski Text [ en-US ] = "~Add" ; 224*b1cdbd2cSJim Jagielski TabStop = TRUE ; 225*b1cdbd2cSJim Jagielski }; 226*b1cdbd2cSJim Jagielski}; 227*b1cdbd2cSJim Jagielski 228