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