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