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