1/************************************************************************* 2 * 3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4 * 5 * Copyright 2000, 2010 Oracle and/or its affiliates. 6 * 7 * OpenOffice.org - a multi-platform office productivity suite 8 * 9 * This file is part of OpenOffice.org. 10 * 11 * OpenOffice.org is free software: you can redistribute it and/or modify 12 * it under the terms of the GNU Lesser General Public License version 3 13 * only, as published by the Free Software Foundation. 14 * 15 * OpenOffice.org is distributed in the hope that it will be useful, 16 * but WITHOUT ANY WARRANTY; without even the implied warranty of 17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18 * GNU Lesser General Public License version 3 for more details 19 * (a copy is included in the LICENSE file that accompanied this code). 20 * 21 * You should have received a copy of the GNU Lesser General Public License 22 * version 3 along with OpenOffice.org. If not, see 23 * <http://www.openoffice.org/license.html> 24 * for a copy of the LGPLv3 License. 25 * 26 ************************************************************************/ 27#include "consdlg.hrc" 28ModelessDialog RID_SCDLG_CONSOLIDATE 29{ 30 OutputSize = TRUE ; 31 HelpId = CMD_SID_OPENDLG_CONSOLIDATE ; 32 Hide = TRUE ; 33 SVLook = TRUE ; 34 Size = MAP_APPFONT ( 280 , 154 ) ; 35 Text [ en-US ] = "Consolidate" ; 36 Moveable = TRUE ; 37 Closeable = FALSE ; 38 ListBox LB_FUNC 39 { 40 HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_FUNC"; 41 Border = TRUE ; 42 Pos = MAP_APPFONT ( 6 , 17 ) ; 43 Size = MAP_APPFONT ( 212 , 90 ) ; 44 TabStop = TRUE ; 45 DropDown = TRUE ; 46 StringList [ en-US ] = 47 { 48 < "Sum" ; Default ; > ; 49 < "Count" ; Default ; > ; 50 < "Average" ; Default ; > ; 51 < "Max" ; Default ; > ; 52 < "Min" ; Default ; > ; 53 < "Product" ; Default ; > ; 54 < "Count (numbers only)" ; Default ; > ; 55 < "StDev (sample)" ; Default ; > ; 56 < "StDevP (population)" ; Default ; > ; 57 < "Var (sample)" ; Default ; > ; 58 < "VarP (population)" ; Default ; > ; 59 }; 60 }; 61 Edit ED_DATA_AREA 62 { 63 HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA"; 64 Border = TRUE ; 65 Pos = MAP_APPFONT ( 100 , 106 ) ; 66 Size = MAP_APPFONT ( 104 , 12 ) ; 67 TabStop = TRUE ; 68 }; 69 Edit ED_DEST_AREA 70 { 71 HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA"; 72 Border = TRUE ; 73 Pos = MAP_APPFONT ( 100 , 135 ) ; 74 Size = MAP_APPFONT ( 104 , 12 ) ; 75 TabStop = TRUE ; 76 }; 77 ImageButton RB_DATA_AREA 78 { 79 HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA"; 80 Pos = MAP_APPFONT ( 206 , 105 ) ; 81 Size = MAP_APPFONT ( 13 , 15 ) ; 82 TabStop = TRUE ; 83 QuickHelpText [ en-US ] = "Shrink" ; 84 }; 85 ImageButton RB_DEST_AREA 86 { 87 HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA"; 88 Pos = MAP_APPFONT ( 206 , 134 ) ; 89 Size = MAP_APPFONT ( 13 , 15 ) ; 90 TabStop = TRUE ; 91 QuickHelpText [ en-US ] = "Shrink" ; 92 }; 93 ListBox LB_DATA_AREA 94 { 95 HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA"; 96 Border = TRUE ; 97 Pos = MAP_APPFONT ( 6 , 106 ) ; 98 Size = MAP_APPFONT ( 90 , 90 ) ; 99 TabStop = TRUE ; 100 DropDown = TRUE ; 101 }; 102 ListBox LB_DEST_AREA 103 { 104 HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA"; 105 Border = TRUE ; 106 Pos = MAP_APPFONT ( 6 , 135 ) ; 107 Size = MAP_APPFONT ( 90 , 90 ) ; 108 TabStop = TRUE ; 109 DropDown = TRUE ; 110 }; 111 MultiListBox LB_CONSAREAS 112 { 113 HelpID = "sc:MultiListBox:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS"; 114 SimpleMode = TRUE ; 115 Border = TRUE ; 116 Pos = MAP_APPFONT ( 6 , 46 ) ; 117 Size = MAP_APPFONT ( 212 , 43 ) ; 118 TabStop = TRUE ; 119 }; 120 FixedText FT_FUNC 121 { 122 Pos = MAP_APPFONT ( 6 , 6 ) ; 123 Size = MAP_APPFONT ( 212 , 8 ) ; 124 Text [ en-US ] = "~Function" ; 125 }; 126 FixedText FT_CONSAREAS 127 { 128 Pos = MAP_APPFONT ( 6 , 35 ) ; 129 Size = MAP_APPFONT ( 212 , 8 ) ; 130 Text [ en-US ] = "~Consolidation ranges" ; 131 }; 132 FixedText FT_DATA_AREA 133 { 134 Pos = MAP_APPFONT ( 6 , 95 ) ; 135 Size = MAP_APPFONT ( 212 , 8 ) ; 136 Text [ en-US ] = "~Source data range" ; 137 }; 138 FixedText FT_DEST_AREA 139 { 140 Pos = MAP_APPFONT ( 6 , 124 ) ; 141 Size = MAP_APPFONT ( 212 , 8 ) ; 142 Text [ en-US ] = "Copy results ~to" ; 143 }; 144 CheckBox BTN_BYROW 145 { 146 HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW"; 147 Pos = MAP_APPFONT ( 12 , 165 ) ; 148 Size = MAP_APPFONT ( 94 , 10 ) ; 149 Text [ en-US ] = "~Row labels" ; 150 TabStop = TRUE ; 151 }; 152 CheckBox BTN_BYCOL 153 { 154 HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL"; 155 Pos = MAP_APPFONT ( 12 , 179 ) ; 156 Size = MAP_APPFONT ( 94 , 10 ) ; 157 TabStop = TRUE ; 158 Text [ en-US ] = "C~olumn labels" ; 159 }; 160 FixedLine FL_CONSBY 161 { 162 Pos = MAP_APPFONT ( 6 , 154 ) ; 163 Size = MAP_APPFONT ( 103 , 8 ) ; 164 Text [ en-US ] = "Consolidate by" ; 165 }; 166 FixedLine FL_SEP 167 { 168 Pos = MAP_APPFONT ( 112 , 165 ) ; 169 Size = MAP_APPFONT ( 1 , 24 ) ; 170 }; 171 FixedLine FL_OPTIONS 172 { 173 Hide = TRUE ; 174 Pos = MAP_APPFONT ( 115 , 154 ) ; 175 Size = MAP_APPFONT ( 103 , 8 ) ; 176 Text [ en-US ] = "Options" ; 177 }; 178 CheckBox BTN_REFS 179 { 180 HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS"; 181 Pos = MAP_APPFONT ( 121 , 165 ) ; 182 Size = MAP_APPFONT ( 94 , 10 ) ; 183 Text [ en-US ] = "~Link to source data" ; 184 TabStop = TRUE ; 185 }; 186 OKButton BTN_OK 187 { 188 Pos = MAP_APPFONT ( 224 , 6 ) ; 189 Size = MAP_APPFONT ( 50 , 14 ) ; 190 TabStop = TRUE ; 191 DefButton = TRUE ; 192 }; 193 CancelButton BTN_CANCEL 194 { 195 Pos = MAP_APPFONT ( 224 , 23 ) ; 196 Size = MAP_APPFONT ( 50 , 14 ) ; 197 TabStop = TRUE ; 198 }; 199 HelpButton BTN_HELP 200 { 201 Pos = MAP_APPFONT ( 224 , 43 ) ; 202 Size = MAP_APPFONT ( 50 , 14 ) ; 203 TabStop = TRUE ; 204 }; 205 MoreButton BTN_MORE 206 { 207 HelpID = "sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE"; 208 Pos = MAP_APPFONT ( 224 , 134 ) ; 209 Size = MAP_APPFONT ( 50 , 14 ) ; 210 TabStop = TRUE ; 211 MapUnit = MAP_APPFONT ; 212 Delta = 41 ; 213 }; 214 PushButton BTN_REMOVE 215 { 216 HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_REMOVE"; 217 Pos = MAP_APPFONT ( 224 , 114 ) ; 218 Size = MAP_APPFONT ( 50 , 14 ) ; 219 Text [ en-US ] = "~Delete" ; 220 TabStop = TRUE ; 221 }; 222 PushButton BTN_ADD 223 { 224 HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD"; 225 Pos = MAP_APPFONT ( 224 , 96 ) ; 226 Size = MAP_APPFONT ( 50 , 14 ) ; 227 Text [ en-US ] = "~Add" ; 228 TabStop = TRUE ; 229 }; 230}; 231 232