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