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#include "pivot.hrc" 23 24ModelessDialog RID_SCDLG_PIVOT_LAYOUT 25{ 26 OutputSize = TRUE ; 27 HelpId = CMD_SID_OPENDLG_PIVOTTABLE ; 28 Size = MAP_APPFONT ( 348, 186 ) ; 29 Hide = TRUE ; 30 SVLook = TRUE ; 31 Moveable = TRUE ; 32 Closeable = FALSE ; 33 Text [ en-US ] = "Pivot Table" ; 34 35 FixedText FT_PAGE 36 { 37 Pos = MAP_APPFONT ( 194, 168 ) ; 38 Size = MAP_APPFONT ( 37, 8 ) ; 39 Text [ en-US ] = "Page Fields" ; 40 }; 41 ScrollBar SCROLL_PAGE 42 { 43 Pos = MAP_APPFONT ( 198, 14 ) ; 44 Size = MAP_APPFONT ( 8, 24 ) ; 45 HScroll = FALSE ; 46 TabStop = FALSE ; 47 }; 48 Control WND_PAGE 49 { 50 Pos = MAP_APPFONT ( 18, 14 ) ; 51 Size = MAP_APPFONT ( 180, 24 ) ; 52 TabStop = TRUE ; 53 }; 54 FixedText FT_COL 55 { 56 Pos = MAP_APPFONT ( 231, 168 ) ; 57 Size = MAP_APPFONT ( 37, 8 ) ; 58 Text [ en-US ] = "Column Fields" ; 59 }; 60 ScrollBar SCROLL_COL 61 { 62 Pos = MAP_APPFONT ( 198, 42 ) ; 63 Size = MAP_APPFONT ( 8, 24 ) ; 64 HScroll = FALSE ; 65 TabStop = FALSE ; 66 }; 67 Control WND_COL 68 { 69 Pos = MAP_APPFONT ( 54, 42 ) ; 70 Size = MAP_APPFONT ( 144, 24 ) ; 71 TabStop = TRUE ; 72 }; 73 FixedText FT_ROW 74 { 75 Pos = MAP_APPFONT ( 194, 176 ) ; 76 Size = MAP_APPFONT ( 37, 8 ) ; 77 Text [ en-US ] = "Row\nFields" ; 78 }; 79 ScrollBar SCROLL_ROW 80 { 81 Pos = MAP_APPFONT ( 42, 70 ) ; 82 Size = MAP_APPFONT ( 8, 96 ) ; 83 HScroll = FALSE ; 84 TabStop = FALSE ; 85 }; 86 Control WND_ROW 87 { 88 Pos = MAP_APPFONT ( 6, 70 ) ; 89 Size = MAP_APPFONT ( 36, 96 ) ; 90 TabStop = TRUE ; 91 }; 92 FixedText FT_DATA 93 { 94 Pos = MAP_APPFONT ( 231, 176 ) ; 95 Size = MAP_APPFONT ( 37, 8 ) ; 96 Text [ en-US ] = "Data Fields" ; 97 }; 98 ScrollBar SCROLL_DATA 99 { 100 Pos = MAP_APPFONT ( 198, 70 ) ; 101 Size = MAP_APPFONT ( 8, 96 ) ; 102 HScroll = FALSE ; 103 TabStop = FALSE ; 104 }; 105 Control WND_DATA 106 { 107 Pos = MAP_APPFONT ( 54, 70 ) ; 108 Size = MAP_APPFONT ( 144, 96 ) ; 109 TabStop = TRUE ; 110 }; 111 Control WND_SELECT 112 { 113 Pos = MAP_APPFONT ( 212, 14 ) ; 114 Size = MAP_APPFONT ( 74, 138 ) ; 115 TabStop = TRUE ; 116 }; 117 String STR_SELECT 118 { 119 Text [ en-US ] = "Selection area" ; 120 }; 121 ScrollBar WND_HSCROLL 122 { 123 Pos = MAP_APPFONT ( 212, 154 ) ; 124 Size = MAP_APPFONT ( 74, 8 ) ; 125 HScroll = TRUE ; 126 TabStop = FALSE ; 127 }; 128 FixedText FT_INFO 129 { 130 Pos = MAP_APPFONT ( 6, 172 ) ; 131 Size = MAP_APPFONT ( 280, 8 ) ; 132 WordBreak = TRUE ; 133 Text [ en-US ] = "Drag the fields from the right into the desired position." ; 134 }; 135 FixedLine FL_LAYOUT 136 { 137 Pos = MAP_APPFONT ( 6, 3 ) ; 138 Size = MAP_APPFONT ( 200, 8 ) ; 139 Text [ en-US ] = "Layout" ; 140 }; 141 FixedLine FL_SELECT 142 { 143 Pos = MAP_APPFONT ( 212, 3 ) ; 144 Size = MAP_APPFONT ( 74, 8 ) ; 145 Text [ en-US ] = "Fields" ; 146 }; 147 OKButton BTN_OK 148 { 149 Pos = MAP_APPFONT ( 292, 6 ) ; 150 Size = MAP_APPFONT ( 50, 14 ) ; 151 TabStop = TRUE ; 152 DefButton = TRUE ; 153 }; 154 CancelButton BTN_CANCEL 155 { 156 Pos = MAP_APPFONT ( 292, 23 ) ; 157 Size = MAP_APPFONT ( 50, 14 ) ; 158 TabStop = TRUE ; 159 }; 160 HelpButton BTN_HELP 161 { 162 Pos = MAP_APPFONT ( 292, 43 ) ; 163 Size = MAP_APPFONT ( 50, 14 ) ; 164 TabStop = TRUE ; 165 }; 166 PushButton BTN_REMOVE 167 { 168 HelpID = "sc:PushButton:RID_SCDLG_PIVOT_LAYOUT:BTN_REMOVE" ; 169 Pos = MAP_APPFONT ( 292, 63 ) ; 170 Size = MAP_APPFONT ( 50, 14 ) ; 171 TabStop = TRUE ; 172 Text [ en-US ] = "Remove" ; 173 }; 174 PushButton BTN_OPTIONS 175 { 176 HelpID = "sc:PushButton:RID_SCDLG_PIVOT_LAYOUT:BTN_OPTIONS" ; 177 Pos = MAP_APPFONT ( 292, 80 ) ; 178 Size = MAP_APPFONT ( 50, 14 ) ; 179 TabStop = TRUE ; 180 Text [ en-US ] = "Options..." ; 181 }; 182 MoreButton BTN_MORE 183 { 184 HelpID = "sc:MoreButton:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE" ; 185 Pos = MAP_APPFONT ( 292, 166 ) ; 186 Size = MAP_APPFONT ( 50, 14 ) ; 187 TabStop = TRUE ; 188 MapUnit = MAP_APPFONT ; 189 Delta = 90 ; 190 }; 191 FixedLine FL_OUTPUT 192 { 193 Pos = MAP_APPFONT ( 6, 186 ) ; 194 Size = MAP_APPFONT ( 280, 8 ) ; 195 Text [ en-US ] = "Result" ; 196 Hide = TRUE ; 197 }; 198 199 FixedText FT_INAREA 200 { 201 Pos = MAP_APPFONT ( 12, 199 ) ; 202 Size = MAP_APPFONT ( 59, 8 ) ; 203 Hide = TRUE ; 204 Text [ en-US ] = "Selection from" ; 205 }; 206 Edit ED_INAREA 207 { 208 HelpID = "sc:Edit:RID_SCDLG_PIVOT_LAYOUT:ED_INAREA" ; 209 Border = TRUE ; 210 Pos = MAP_APPFONT ( 73, 197 ) ; 211 Size = MAP_APPFONT ( 109, 12 ) ; 212 TabStop = TRUE ; 213 Hide = TRUE ; 214 }; 215 ImageButton RB_INAREA 216 { 217 HelpID = "sc:ImageButton:RID_SCDLG_PIVOT_LAYOUT:RB_INAREA" ; 218 Pos = MAP_APPFONT ( 186, 196 ) ; 219 Size = MAP_APPFONT ( 13, 15 ) ; 220 TabStop = TRUE ; 221 Hide = TRUE ; 222 QuickHelpText [ en-US ] = "Shrink" ; 223 }; 224 225 FixedText FT_OUTAREA 226 { 227 Pos = MAP_APPFONT ( 12, 217 ) ; 228 Size = MAP_APPFONT ( 59, 8 ) ; 229 Hide = TRUE ; 230 Text [ en-US ] = "Results to" ; 231 }; 232 ListBox LB_OUTAREA 233 { 234 HelpID = "sc:ListBox:RID_SCDLG_PIVOT_LAYOUT:LB_OUTAREA" ; 235 Border = TRUE ; 236 Pos = MAP_APPFONT ( 73, 215 ) ; 237 Size = MAP_APPFONT ( 75, 90 ) ; 238 TabStop = TRUE ; 239 DropDown = TRUE ; 240 Hide = TRUE ; 241 }; 242 Edit ED_OUTAREA 243 { 244 HelpID = "sc:Edit:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA" ; 245 Border = TRUE ; 246 Pos = MAP_APPFONT ( 152, 215 ) ; 247 Size = MAP_APPFONT ( 109, 12 ) ; 248 TabStop = TRUE ; 249 Hide = TRUE ; 250 }; 251 ImageButton RB_OUTAREA 252 { 253 HelpID = "sc:ImageButton:RID_SCDLG_PIVOT_LAYOUT:RB_OUTAREA" ; 254 Pos = MAP_APPFONT ( 265, 214 ) ; 255 Size = MAP_APPFONT ( 13, 15 ) ; 256 TabStop = TRUE ; 257 Hide = TRUE ; 258 QuickHelpText [ en-US ] = "Shrink" ; 259 }; 260 CheckBox BTN_IGNEMPTYROWS 261 { 262 HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS" ; 263 Pos = MAP_APPFONT ( 12, 233 ) ; 264 Size = MAP_APPFONT ( 136, 10 ) ; 265 TabStop = TRUE ; 266 Hide = TRUE ; 267 Text [ en-US ] = "Ignore ~empty rows" ; 268 }; 269 CheckBox BTN_DETECTCAT 270 { 271 HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_DETECTCAT" ; 272 Pos = MAP_APPFONT ( 152, 233 ) ; 273 Size = MAP_APPFONT ( 128, 10 ) ; 274 TabStop = TRUE ; 275 Hide = TRUE ; 276 Text [ en-US ] = "~Identify categories" ; 277 }; 278 CheckBox BTN_TOTALCOL 279 { 280 HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALCOL" ; 281 Pos = MAP_APPFONT ( 12, 247 ) ; 282 Size = MAP_APPFONT ( 136, 10 ) ; 283 TabStop = TRUE ; 284 Hide = TRUE ; 285 Text [ en-US ] = "Total columns" ; 286 }; 287 CheckBox BTN_TOTALROW 288 { 289 HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALROW" ; 290 Pos = MAP_APPFONT ( 152, 247 ) ; 291 Size = MAP_APPFONT ( 128, 10 ) ; 292 TabStop = TRUE ; 293 Hide = TRUE ; 294 Text [ en-US ] = "~Total rows" ; 295 }; 296 CheckBox BTN_FILTER 297 { 298 HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_FILTER" ; 299 Pos = MAP_APPFONT ( 12, 261 ) ; 300 Size = MAP_APPFONT ( 136, 10 ) ; 301 TabStop = TRUE ; 302 Hide = TRUE ; 303 Text [ en-US ] = "~Add filter" ; 304 }; 305 CheckBox BTN_DRILLDOWN 306 { 307 HelpID = "sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_DRILLDOWN" ; 308 Pos = MAP_APPFONT ( 152, 261 ) ; 309 Size = MAP_APPFONT ( 128, 10 ) ; 310 TabStop = TRUE ; 311 Hide = TRUE ; 312 Text [ en-US ] = "Ena~ble drill to details" ; 313 }; 314 String PIVOTSTR_SUM 315 { 316 Text [ en-US ] = "Sum - " ; 317 }; 318 String PIVOTSTR_COUNT 319 { 320 Text [ en-US ] = "Count - " ; 321 }; 322 String PIVOTSTR_AVG 323 { 324 Text [ en-US ] = "Mean - " ; 325 }; 326 String PIVOTSTR_MAX 327 { 328 Text [ en-US ] = "Max - " ; 329 }; 330 String PIVOTSTR_MIN 331 { 332 Text [ en-US ] = "Min - " ; 333 }; 334 String PIVOTSTR_PROD 335 { 336 Text [ en-US ] = "Product - " ; 337 }; 338 String PIVOTSTR_COUNT2 339 { 340 Text [ en-US ] = "Count - " ; 341 }; 342 String PIVOTSTR_DEV 343 { 344 Text [ en-US ] = "StDev - " ; 345 }; 346 String PIVOTSTR_DEV2 347 { 348 Text [ en-US ] = "StDevP - " ; 349 }; 350 String PIVOTSTR_VAR 351 { 352 Text [ en-US ] = "Var - " ; 353 }; 354 String PIVOTSTR_VAR2 355 { 356 Text [ en-US ] = "VarP - " ; 357 }; 358}; 359 360// ********************************************************************** EOF 361