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