xref: /aoo41x/main/sc/source/ui/dbgui/pivot.src (revision 82177cdb)
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