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