xref: /aoo41x/main/sc/source/ui/src/filter.src (revision 49cf81a2)
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 "filter.hrc"
25ModelessDialog RID_SCDLG_FILTER
26{
27	OutputSize = TRUE ;
28	HelpId = CMD_SID_FILTER ;
29	Hide = TRUE ;
30	SVLook = TRUE ;
31	Size = MAP_APPFONT ( 279, 121 ) ;
32	Text [ en-US ] = "Standard Filter" ;
33	Moveable = TRUE ;
34	Closeable = FALSE ;
35	FixedText FT_OP
36	{
37        Pos = MAP_APPFONT ( 12, 14 ) ;
38        Size = MAP_APPFONT ( 44, 8 ) ;
39		Text [ en-US ] = "Operator" ;
40	};
41	FixedText FT_FIELD
42	{
43        Pos = MAP_APPFONT ( 58, 14 ) ;
44        Size = MAP_APPFONT ( 60, 8 ) ;
45		Text [ en-US ] = "Field name" ;
46	};
47	FixedText FT_COND
48	{
49        Pos = MAP_APPFONT ( 122, 14 ) ;
50        Size = MAP_APPFONT ( 47, 8 ) ;
51		Text [ en-US ] = "Condition" ;
52	};
53	FixedText FT_VAL
54	{
55        Pos = MAP_APPFONT ( 201, 14 ) ;
56        Size = MAP_APPFONT ( 60, 8 ) ;
57		Text [ en-US ] = "Value" ;
58	};
59	ListBox LB_OP1
60	{
61	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP1" ;
62		Border = TRUE ;
63        Pos = MAP_APPFONT ( 12, 25 ) ;
64		Size = MAP_APPFONT ( 40, 46 ) ;
65		TabStop = TRUE ;
66		DropDown = TRUE ;
67		StringList [ en-US ] =
68		{
69			< "AND" ; Default ;	> ;
70			< "OR" ; Default ;	> ;
71		};
72	};
73	ListBox LB_OP2
74	{
75	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP2" ;
76		Border = TRUE ;
77        Pos = MAP_APPFONT ( 12, 41 ) ;
78		Size = MAP_APPFONT ( 40, 46 ) ;
79		TabStop = TRUE ;
80		DropDown = TRUE ;
81		StringList [ en-US ] =
82		{
83			< "AND" ; Default ;	> ;
84			< "OR" ; Default ;	> ;
85		};
86	};
87	ListBox LB_OP3
88	{
89	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP3" ;
90		Border = TRUE ;
91        Pos = MAP_APPFONT ( 12, 57 ) ;
92		Size = MAP_APPFONT ( 40, 46 ) ;
93		TabStop = TRUE ;
94		DropDown = TRUE ;
95		StringList [ en-US ] =
96		{
97			< "AND" ; Default ;	> ;
98			< "OR" ; Default ;	> ;
99		};
100	};
101	ListBox LB_OP4
102	{
103	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP4" ;
104		Border = TRUE ;
105        Pos = MAP_APPFONT ( 12, 73 ) ;
106		Size = MAP_APPFONT ( 40, 46 ) ;
107		TabStop = TRUE ;
108		DropDown = TRUE ;
109		StringList [ en-US ] =
110		{
111			< "AND" ; Default ;	> ;
112			< "OR" ; Default ;	> ;
113		};
114	};
115	ListBox LB_FIELD1
116	{
117	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD1" ;
118		Border = TRUE ;
119        Pos = MAP_APPFONT ( 58, 25 ) ;
120		Size = MAP_APPFONT ( 60, 90 ) ;
121		TabStop = TRUE ;
122		DropDown = TRUE ;
123	};
124	ListBox LB_FIELD2
125	{
126	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD2" ;
127		Border = TRUE ;
128        Pos = MAP_APPFONT ( 58, 41 ) ;
129		Size = MAP_APPFONT ( 60, 90 ) ;
130		TabStop = TRUE ;
131		DropDown = TRUE ;
132	};
133	ListBox LB_FIELD3
134	{
135	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD3" ;
136		Border = TRUE ;
137        Pos = MAP_APPFONT ( 58, 57 ) ;
138		Size = MAP_APPFONT ( 60, 90 ) ;
139		TabStop = TRUE ;
140		DropDown = TRUE ;
141	};
142	ListBox LB_FIELD4
143	{
144	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD4" ;
145		Border = TRUE ;
146        Pos = MAP_APPFONT ( 58, 73 ) ;
147		Size = MAP_APPFONT ( 60, 90 ) ;
148		TabStop = TRUE ;
149		DropDown = TRUE ;
150	};
151	ListBox LB_COND1
152	{
153	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND1" ;
154		Border = TRUE ;
155        Pos = MAP_APPFONT ( 122, 25 ) ;
156        Size = MAP_APPFONT ( 75, 145 ) ;
157		TabStop = TRUE ;
158		DropDown = TRUE ;
159		stringlist [ en-US ] =
160		{
161			< "=" ; Default ;					> ;
162			< "<" ; Default ;					> ;
163			< ">" ; Default ;					> ;
164			< "<=" ; Default ;					> ;
165			< ">=" ; Default ;					> ;
166			< "<>" ; Default ;					> ;
167			< "Largest" ; Default ;				> ;
168			< "Smallest" ; Default ;			> ;
169			< "Largest %" ; Default ;			> ;
170			< "Smallest %" ; Default ;			> ;
171            < "Contains" ; Default ;			> ;
172            < "Does not contain" ; Default ;	> ;
173            < "Begins with" ; Default ;			> ;
174            < "Does not begin with" ; Default ;	> ;
175            < "Ends with" ; Default ;			> ;
176            < "Does not end with" ; Default ;	> ;
177		};
178	};
179	ListBox LB_COND2
180	{
181	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND2" ;
182		Border = TRUE ;
183        Pos = MAP_APPFONT ( 122, 41 ) ;
184        Size = MAP_APPFONT ( 75, 145 ) ;
185		TabStop = TRUE ;
186		DropDown = TRUE ;
187		stringlist [ en-US ] =
188		{
189			< "=" ; Default ;					> ;
190			< "<" ; Default ;					> ;
191			< ">" ; Default ;					> ;
192			< "<=" ; Default ;					> ;
193			< ">=" ; Default ;					> ;
194			< "<>" ; Default ;					> ;
195			< "Largest" ; Default ;				> ;
196			< "Smallest" ; Default ;			> ;
197			< "Largest %" ; Default ;			> ;
198			< "Smallest %" ; Default ;			> ;
199            < "Contains" ; Default ;			> ;
200            < "Does not contain" ; Default ;	> ;
201            < "Begins with" ; Default ;			> ;
202            < "Does not begin with" ; Default ;	> ;
203            < "Ends with" ; Default ;			> ;
204            < "Does not end with" ; Default ;	> ;
205		};
206	};
207	ListBox LB_COND3
208	{
209	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND3" ;
210		Border = TRUE ;
211        Pos = MAP_APPFONT ( 122, 57 ) ;
212        Size = MAP_APPFONT ( 75, 145 ) ;
213		TabStop = TRUE ;
214		DropDown = TRUE ;
215		stringlist [ en-US ] =
216		{
217			< "=" ; Default ;					> ;
218			< "<" ; Default ;					> ;
219			< ">" ; Default ;					> ;
220			< "<=" ; Default ;					> ;
221			< ">=" ; Default ;					> ;
222			< "<>" ; Default ;					> ;
223			< "Largest" ; Default ;				> ;
224			< "Smallest" ; Default ;			> ;
225			< "Largest %" ; Default ;			> ;
226			< "Smallest %" ; Default ;			> ;
227            < "Contains" ; Default ;			> ;
228            < "Does not contain" ; Default ;	> ;
229            < "Begins with" ; Default ;			> ;
230            < "Does not begin with" ; Default ;	> ;
231            < "Ends with" ; Default ;			> ;
232            < "Does not end with" ; Default ;	> ;
233		};
234	};
235	ListBox LB_COND4
236	{
237	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND4" ;
238		Border = TRUE ;
239        Pos = MAP_APPFONT ( 122, 73 ) ;
240        Size = MAP_APPFONT ( 75, 145 ) ;
241		TabStop = TRUE ;
242		DropDown = TRUE ;
243		stringlist [ en-US ] =
244		{
245			< "=" ; Default ;					> ;
246			< "<" ; Default ;					> ;
247			< ">" ; Default ;					> ;
248			< "<=" ; Default ;					> ;
249			< ">=" ; Default ;					> ;
250			< "<>" ; Default ;					> ;
251			< "Largest" ; Default ;				> ;
252			< "Smallest" ; Default ;			> ;
253			< "Largest %" ; Default ;			> ;
254			< "Smallest %" ; Default ;			> ;
255            < "Contains" ; Default ;			> ;
256            < "Does not contain" ; Default ;	> ;
257            < "Begins with" ; Default ;			> ;
258            < "Does not begin with" ; Default ;	> ;
259            < "Ends with" ; Default ;			> ;
260            < "Does not end with" ; Default ;	> ;
261		};
262	};
263	ComboBox ED_VAL1
264	{
265	    HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL1" ;
266        Pos = MAP_APPFONT ( 201, 25 ) ;
267		Size = MAP_APPFONT ( 60, 90 ) ;
268		TabStop = TRUE ;
269		DropDown = TRUE ;
270	};
271	ComboBox ED_VAL2
272	{
273	    HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL2" ;
274        Pos = MAP_APPFONT ( 201, 41 ) ;
275		Size = MAP_APPFONT ( 60, 90 ) ;
276		TabStop = TRUE ;
277		DropDown = TRUE ;
278	};
279	ComboBox ED_VAL3
280	{
281	    HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL3" ;
282        Pos = MAP_APPFONT ( 201, 57 ) ;
283		Size = MAP_APPFONT ( 60, 90 ) ;
284		TabStop = TRUE ;
285		DropDown = TRUE ;
286	};
287	ComboBox ED_VAL4
288	{
289	    HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL4" ;
290        Pos = MAP_APPFONT ( 201, 73 ) ;
291		Size = MAP_APPFONT ( 60, 90 ) ;
292		TabStop = TRUE ;
293		DropDown = TRUE ;
294	};
295	ScrollBar LB_SCROLL
296    {
297        Pos = MAP_APPFONT ( 265, 25 ) ;
298        Size = MAP_APPFONT ( 8, 60 ) ;
299        TabStop = TRUE ;
300        VScroll = TRUE ;
301    };
302
303    FixedLine FL_CRITERIA
304	{
305		Pos = MAP_APPFONT ( 6, 3 ) ;
306        Size = MAP_APPFONT ( 267, 8 ) ;
307		Text [ en-US ] = "Filter criteria" ;
308	};
309	CheckBox BTN_CASE
310	{
311	    HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_CASE" ;
312		Hide = TRUE ;
313        Pos = MAP_APPFONT ( 12, 130 ) ;
314        Size = MAP_APPFONT ( 128, 10 ) ;
315		TabStop = TRUE ;
316		Text [ en-US ] = "Case ~sensitive" ;
317	};
318	CheckBox BTN_REGEXP
319	{
320	    HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_REGEXP" ;
321		Hide = TRUE ;
322        Pos = MAP_APPFONT ( 142, 130 ) ;
323        Size = MAP_APPFONT ( 94, 10 ) ;
324		TabStop = TRUE ;
325		Text [ en-US ] = "Regular ~expression" ;
326	};
327	CheckBox BTN_HEADER
328	{
329	    HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_HEADER" ;
330		Hide = TRUE ;
331        Pos = MAP_APPFONT ( 12, 144 ) ;
332        Size = MAP_APPFONT ( 128, 10 ) ;
333		TabStop = TRUE ;
334		Text [ en-US ] = "Range contains ~column labels" ;
335	};
336	CheckBox BTN_UNIQUE
337	{
338	    HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_UNIQUE" ;
339		Hide = TRUE ;
340        Pos = MAP_APPFONT ( 142, 144 ) ;
341        Size = MAP_APPFONT ( 94, 10 ) ;
342		TabStop = TRUE ;
343		Text [ en-US ] = "~No duplication" ;
344	};
345	CheckBox BTN_COPY_RESULT
346	{
347	    HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_COPY_RESULT" ;
348		Hide = TRUE ;
349        Pos = MAP_APPFONT ( 12, 158 ) ;
350        Size = MAP_APPFONT ( 128, 10 ) ;
351		TabStop = TRUE ;
352		Text [ en-US ] = "Copy ~results to..." ;
353	};
354	CheckBox BTN_DEST_PERS
355	{
356	    HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_DEST_PERS" ;
357		Hide = TRUE ;
358        Pos = MAP_APPFONT ( 142, 158 ) ;
359        Size = MAP_APPFONT ( 94, 10 ) ;
360		TabStop = TRUE ;
361		Text [ en-US ] = "~Keep filter criteria" ;
362	};
363	ListBox LB_COPY_AREA
364	{
365	    HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COPY_AREA" ;
366		Border = TRUE ;
367		Hide = TRUE ;
368        Pos = MAP_APPFONT ( 21, 170 ) ;
369        Size = MAP_APPFONT ( 110, 90 ) ;
370		TabStop = TRUE ;
371		DropDown = TRUE ;
372	};
373	Edit ED_COPY_AREA
374	{
375	    HelpID = "sc:Edit:RID_SCDLG_FILTER:ED_COPY_AREA" ;
376		Border = TRUE ;
377		Hide = TRUE ;
378        Pos = MAP_APPFONT ( 136, 170 ) ;
379        Size = MAP_APPFONT ( 110, 12 ) ;
380		TabStop = TRUE ;
381	};
382	ImageButton RB_COPY_AREA
383	{
384	    HelpID = "sc:ImageButton:RID_SCDLG_FILTER:RB_COPY_AREA" ;
385        Pos = MAP_APPFONT ( 248, 169 ) ;
386		Size = MAP_APPFONT ( 13, 15 ) ;
387		TabStop = FALSE ;
388		QuickHelpText [ en-US ] = "Shrink" ;
389	};
390    FixedLine FL_OPTIONS
391	{
392		Hide = TRUE ;
393        Pos = MAP_APPFONT ( 6, 118 ) ;
394        Size = MAP_APPFONT ( 267, 8 ) ;
395	};
396	FixedText FT_DBAREA
397	{
398		Hide = TRUE ;
399        Pos = MAP_APPFONT ( 66, 188 ) ;
400        Size = MAP_APPFONT ( 167, 8 ) ;
401		Left = TRUE ;
402		Text [ en-US ] = "dummy" ;
403	};
404	FixedText FT_DBAREA_LABEL
405	{
406		Hide = TRUE ;
407        Pos = MAP_APPFONT ( 6, 188 ) ;
408        Size = MAP_APPFONT ( 58, 8 ) ;
409		Text [ en-US ] = "Data range:" ;
410	};
411	OKButton BTN_OK
412	{
413		Pos = MAP_APPFONT ( 168, 101 ) ;
414		Size = MAP_APPFONT ( 50, 14 ) ;
415		TabStop = TRUE ;
416		DefButton = TRUE ;
417	};
418	CancelButton BTN_CANCEL
419	{
420		Pos = MAP_APPFONT ( 223, 101 ) ;
421		Size = MAP_APPFONT ( 50, 14 ) ;
422		TabStop = TRUE ;
423	};
424	HelpButton BTN_HELP
425	{
426		Pos = MAP_APPFONT ( 113, 101 ) ;
427		Size = MAP_APPFONT ( 50, 14 ) ;
428		TabStop = TRUE ;
429	};
430	MoreButton BTN_MORE
431	{
432		HelpID = "sc:MoreButton:RID_SCDLG_FILTER:BTN_MORE" ;
433		Pos = MAP_APPFONT ( 6, 101 ) ;
434		Size = MAP_APPFONT ( 65, 14 ) ;
435		TabStop = TRUE ;
436		MapUnit = MAP_APPFONT ;
437		Delta = 81 ;
438	};
439	FixedLine FL_SEPARATOR
440	{
441		Pos = MAP_APPFONT ( 0, 91 ) ;
442		Size = MAP_APPFONT ( 279, 6 ) ;
443	};
444};
445//============================================================================
446ModelessDialog RID_SCDLG_SPEC_FILTER
447{
448	OutputSize = TRUE ;
449	HelpId = CMD_SID_SPECIAL_FILTER ;
450	Hide = TRUE ;
451	SVLook = TRUE ;
452	Size = MAP_APPFONT ( 278, 83 ) ;
453	Text [ en-US ] = "Advanced Filter" ;
454	Moveable = TRUE ;
455	Closeable = FALSE ;
456	FixedText FT_CRITERIA_AREA
457	{
458		Pos = MAP_APPFONT ( 6, 3 ) ;
459		Size = MAP_APPFONT ( 210, 8 ) ;
460		Text [ en-US ] = "Read ~filter criteria from" ;
461	};
462	ListBox LB_CRITERIA_AREA
463	{
464		HelpID = "sc:ListBox:RID_SCDLG_SPEC_FILTER:LB_CRITERIA_AREA" ;
465		Border = TRUE ;
466		Pos = MAP_APPFONT ( 6, 14 ) ;
467		Size = MAP_APPFONT ( 90, 90 ) ;
468		TabStop = TRUE ;
469		DropDown = TRUE ;
470	};
471	Edit ED_CRITERIA_AREA
472	{
473		HelpID = "sc:Edit:RID_SCDLG_SPEC_FILTER:ED_CRITERIA_AREA" ;
474		Border = TRUE ;
475		Pos = MAP_APPFONT ( 100, 14 ) ;
476		Size = MAP_APPFONT ( 99, 12 ) ;
477		TabStop = TRUE ;
478	};
479	ImageButton RB_CRITERIA_AREA
480	{
481	    HelpID = "sc:ImageButton:RID_SCDLG_SPEC_FILTER:RB_CRITERIA_AREA" ;
482        Pos = MAP_APPFONT ( 201, 13 ) ;
483		Size = MAP_APPFONT ( 13, 15 ) ;
484		TabStop = FALSE ;
485		QuickHelpText [ en-US ] = "Shrink" ;
486	};
487	CheckBox BTN_CASE
488	{
489	    HelpID = "sc:CheckBox:RID_SCDLG_SPEC_FILTER:BTN_CASE" ;
490		Hide = TRUE ;
491        Pos = MAP_APPFONT ( 12, 43 ) ;
492        Size = MAP_APPFONT ( 128, 10 ) ;
493		TabStop = TRUE ;
494		Text [ en-US ] = "~Case sensitive" ;
495	};
496	CheckBox BTN_REGEXP
497	{
498	    HelpID = "sc:CheckBox:RID_SCDLG_SPEC_FILTER:BTN_REGEXP" ;
499		Hide = TRUE ;
500        Pos = MAP_APPFONT ( 142, 43 ) ;
501        Size = MAP_APPFONT ( 74, 10 ) ;
502		TabStop = TRUE ;
503		Text [ en-US ] = "Regular ~expressions" ;
504	};
505	CheckBox BTN_HEADER
506	{
507	    HelpID = "sc:CheckBox:RID_SCDLG_SPEC_FILTER:BTN_HEADER" ;
508		Hide = TRUE ;
509        Pos = MAP_APPFONT ( 12, 57 ) ;
510        Size = MAP_APPFONT ( 128, 10 ) ;
511		TabStop = TRUE ;
512		Text [ en-US ] = "Range c~ontains column labels" ;
513	};
514	CheckBox BTN_UNIQUE
515	{
516	    HelpID = "sc:CheckBox:RID_SCDLG_SPEC_FILTER:BTN_UNIQUE" ;
517		Hide = TRUE ;
518        Pos = MAP_APPFONT ( 142, 57 ) ;
519        Size = MAP_APPFONT ( 74, 10 ) ;
520		TabStop = TRUE ;
521		Text [ en-US ] = "~No duplication" ;
522	};
523	CheckBox BTN_COPY_RESULT
524	{
525	    HelpID = "sc:CheckBox:RID_SCDLG_SPEC_FILTER:BTN_COPY_RESULT" ;
526		Hide = TRUE ;
527        Pos = MAP_APPFONT ( 12, 71 ) ;
528        Size = MAP_APPFONT ( 128, 10 ) ;
529		TabStop = TRUE ;
530		Text [ en-US ] = "Co~py results to" ;
531	};
532	CheckBox BTN_DEST_PERS
533	{
534	    HelpID = "sc:CheckBox:RID_SCDLG_SPEC_FILTER:BTN_DEST_PERS" ;
535		Hide = TRUE ;
536        Pos = MAP_APPFONT ( 142, 71 ) ;
537        Size = MAP_APPFONT ( 74, 10 ) ;
538		TabStop = TRUE ;
539		Text [ en-US ] = "~Keep filter criteria" ;
540	};
541	ListBox LB_COPY_AREA
542	{
543	    HelpID = "sc:ListBox:RID_SCDLG_SPEC_FILTER:LB_COPY_AREA" ;
544		Border = TRUE ;
545		Hide = TRUE ;
546        Pos = MAP_APPFONT ( 20, 83 ) ;
547        Size = MAP_APPFONT ( 76, 90 ) ;
548		TabStop = TRUE ;
549		DropDown = TRUE ;
550	};
551	Edit ED_COPY_AREA
552	{
553	    HelpID = "sc:Edit:RID_SCDLG_SPEC_FILTER:ED_COPY_AREA" ;
554		Border = TRUE ;
555		Hide = TRUE ;
556        Pos = MAP_APPFONT ( 100, 83 ) ;
557        Size = MAP_APPFONT ( 99, 12 ) ;
558		TabStop = TRUE ;
559	};
560	ImageButton RB_COPY_AREA
561	{
562	    HelpID = "sc:ImageButton:RID_SCDLG_SPEC_FILTER:RB_COPY_AREA" ;
563        Pos = MAP_APPFONT ( 201, 82 ) ;
564		Size = MAP_APPFONT ( 13, 15 ) ;
565		TabStop = FALSE ;
566		QuickHelpText [ en-US ] = "Shrink" ;
567	};
568    FixedLine FL_OPTIONS
569	{
570		Hide = TRUE ;
571        Pos = MAP_APPFONT ( 6, 32 ) ;
572        Size = MAP_APPFONT ( 210, 8 ) ;
573		Text [ en-US ] = "Options" ;
574	};
575	FixedText FT_DBAREA
576	{
577		Hide = TRUE ;
578        Pos = MAP_APPFONT ( 58, 101 ) ;
579        Size = MAP_APPFONT ( 155, 8 ) ;
580		Left = TRUE ;
581		Text [ en-US ] = "dummy" ;
582	};
583	FixedText FT_DBAREA_LABEL
584	{
585		Hide = TRUE ;
586        Pos = MAP_APPFONT ( 6, 101 ) ;
587        Size = MAP_APPFONT ( 50, 8 ) ;
588		Text [ en-US ] = "Data range:" ;
589	};
590	OKButton BTN_OK
591	{
592		Pos = MAP_APPFONT ( 222, 6 ) ;
593		Size = MAP_APPFONT ( 50, 14 ) ;
594		TabStop = TRUE ;
595		DefButton = TRUE ;
596	};
597	CancelButton BTN_CANCEL
598	{
599		Pos = MAP_APPFONT ( 222, 23 ) ;
600		Size = MAP_APPFONT ( 50, 14 ) ;
601		TabStop = TRUE ;
602	};
603	HelpButton BTN_HELP
604	{
605		Pos = MAP_APPFONT ( 222, 43 ) ;
606		Size = MAP_APPFONT ( 50, 14 ) ;
607		TabStop = TRUE ;
608	};
609	MoreButton BTN_MORE
610	{
611	    HelpID = "sc:MoreButton:RID_SCDLG_SPEC_FILTER:BTN_MORE" ;
612		Pos = MAP_APPFONT ( 223, 63 ) ;
613		Size = MAP_APPFONT ( 50, 14 ) ;
614		TabStop = TRUE ;
615		MapUnit = MAP_APPFONT ;
616        Delta = 32 ;
617	};
618};
619//============================================================================
620ModalDialog RID_SCDLG_PIVOTFILTER
621{
622	OutputSize = TRUE ;
623	HelpId = HID_SC_PIVOTFILTER ;
624	Hide = TRUE ;
625	SVLook = TRUE ;
626    Size = MAP_APPFONT ( 298, 83 ) ;
627	Text [ en-US ] = "Filter" ;
628	Moveable = TRUE ;
629	Closeable = FALSE ;
630	FixedText FT_OP
631	{
632        Pos = MAP_APPFONT ( 12, 14 ) ;
633        Size = MAP_APPFONT ( 40, 8 ) ;
634		Text [ en-US ] = "Operator" ;
635	};
636	FixedText FT_FIELD
637	{
638        Pos = MAP_APPFONT ( 58, 14 ) ;
639        Size = MAP_APPFONT ( 60, 8 ) ;
640		Text [ en-US ] = "Field name" ;
641	};
642	FixedText FT_COND
643	{
644        Pos = MAP_APPFONT ( 122, 14 ) ;
645        Size = MAP_APPFONT ( 47, 8 ) ;
646		Text [ en-US ] = "Condition" ;
647	};
648	FixedText FT_VAL
649	{
650        Pos = MAP_APPFONT ( 173, 14 ) ;
651        Size = MAP_APPFONT ( 60, 8 ) ;
652		Text [ en-US ] = "Value" ;
653	};
654	ListBox LB_OP1
655	{
656	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_OP1" ;
657		Border = TRUE ;
658        Pos = MAP_APPFONT ( 12, 41 ) ;
659		Size = MAP_APPFONT ( 40, 46 ) ;
660		TabStop = TRUE ;
661		DropDown = TRUE ;
662		StringList [ en-US ] =
663		{
664			< "AND" ; Default ;	> ;
665			< "OR" ; Default ;	> ;
666		};
667	};
668	ListBox LB_OP2
669	{
670	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_OP2" ;
671		Border = TRUE ;
672        Pos = MAP_APPFONT ( 12, 57 ) ;
673		Size = MAP_APPFONT ( 40, 46 ) ;
674		TabStop = TRUE ;
675		DropDown = TRUE ;
676		StringList [ en-US ] =
677		{
678			< "AND" ; Default ;	> ;
679			< "OR" ; Default ;	> ;
680		};
681	};
682	ListBox LB_FIELD1
683	{
684	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD1" ;
685		Border = TRUE ;
686        Pos = MAP_APPFONT ( 58, 25 ) ;
687		Size = MAP_APPFONT ( 60, 90 ) ;
688		TabStop = TRUE ;
689		DropDown = TRUE ;
690	};
691	ListBox LB_FIELD2
692	{
693	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD2" ;
694		Border = TRUE ;
695        Pos = MAP_APPFONT ( 58, 41 ) ;
696		Size = MAP_APPFONT ( 60, 90 ) ;
697		TabStop = TRUE ;
698		DropDown = TRUE ;
699	};
700	ListBox LB_FIELD3
701	{
702	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_FIELD3" ;
703		Border = TRUE ;
704        Pos = MAP_APPFONT ( 58, 57 ) ;
705		Size = MAP_APPFONT ( 60, 90 ) ;
706		TabStop = TRUE ;
707		DropDown = TRUE ;
708	};
709	ListBox LB_COND1
710	{
711	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND1" ;
712		Border = TRUE ;
713        Pos = MAP_APPFONT ( 122, 25 ) ;
714        Size = MAP_APPFONT ( 47, 65 ) ;
715		TabStop = TRUE ;
716		DropDown = TRUE ;
717		StringList [ en-US ] =
718		{
719			< "=" ; Default ;	> ;
720			< "<" ; Default ;	> ;
721			< ">" ; Default ;	> ;
722			< "<=" ; Default ;	> ;
723			< ">=" ; Default ;	> ;
724			< "<>" ; Default ;	> ;
725		};
726	};
727	ListBox LB_COND2
728	{
729	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND2" ;
730		Border = TRUE ;
731        Pos = MAP_APPFONT ( 122, 41 ) ;
732        Size = MAP_APPFONT ( 47, 65 ) ;
733		TabStop = TRUE ;
734		DropDown = TRUE ;
735		StringList [ en-US ] =
736		{
737			< "=" ; Default ;	> ;
738			< "<" ; Default ;	> ;
739			< ">" ; Default ;	> ;
740			< "<=" ; Default ;	> ;
741			< ">=" ; Default ;	> ;
742			< "<>" ; Default ;	> ;
743		};
744	};
745	ListBox LB_COND3
746	{
747	    HelpID = "sc:ListBox:RID_SCDLG_PIVOTFILTER:LB_COND3" ;
748		Border = TRUE ;
749        Pos = MAP_APPFONT ( 122, 57 ) ;
750        Size = MAP_APPFONT ( 47, 65 ) ;
751		TabStop = TRUE ;
752		DropDown = TRUE ;
753		StringList [ en-US ] =
754		{
755			< "=" ; Default ;	> ;
756			< "<" ; Default ;	> ;
757			< ">" ; Default ;	> ;
758			< "<=" ; Default ;	> ;
759			< ">=" ; Default ;	> ;
760			< "<>" ; Default ;	> ;
761		};
762	};
763	ComboBox ED_VAL1
764	{
765	    HelpID = "sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL1" ;
766        Pos = MAP_APPFONT ( 173, 25 ) ;
767		Size = MAP_APPFONT ( 60, 90 ) ;
768		TabStop = TRUE ;
769		DropDown = TRUE ;
770	};
771	ComboBox ED_VAL2
772	{
773	    HelpID = "sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL2" ;
774        Pos = MAP_APPFONT ( 173, 41 ) ;
775		Size = MAP_APPFONT ( 60, 90 ) ;
776		TabStop = TRUE ;
777		DropDown = TRUE ;
778	};
779	ComboBox ED_VAL3
780	{
781	    HelpID = "sc:ComboBox:RID_SCDLG_PIVOTFILTER:ED_VAL3" ;
782        Pos = MAP_APPFONT ( 173, 57 ) ;
783		Size = MAP_APPFONT ( 60, 90 ) ;
784		TabStop = TRUE ;
785		DropDown = TRUE ;
786	};
787    FixedLine FL_CRITERIA
788	{
789		Pos = MAP_APPFONT ( 6, 3 ) ;
790        Size = MAP_APPFONT ( 230, 8 ) ;
791		Text [ en-US ] = "Filter criteria" ;
792	};
793	CheckBox BTN_CASE
794	{
795	    HelpID = "sc:CheckBox:RID_SCDLG_PIVOTFILTER:BTN_CASE" ;
796		Hide = TRUE ;
797        Pos = MAP_APPFONT ( 12, 86 ) ;
798        Size = MAP_APPFONT ( 221, 10 ) ;
799		TabStop = TRUE ;
800		Text [ en-US ] = "~Case sensitive" ;
801	};
802	CheckBox BTN_REGEXP
803	{
804	    HelpID = "sc:CheckBox:RID_SCDLG_PIVOTFILTER:BTN_REGEXP" ;
805		Hide = TRUE ;
806        Pos = MAP_APPFONT ( 12, 100 ) ;
807        Size = MAP_APPFONT ( 221, 10 ) ;
808		TabStop = TRUE ;
809		Text [ en-US ] = "~Regular expression" ;
810	};
811	CheckBox BTN_UNIQUE
812	{
813	    HelpID = "sc:CheckBox:RID_SCDLG_PIVOTFILTER:BTN_UNIQUE" ;
814		Hide = TRUE ;
815        Pos = MAP_APPFONT ( 12, 114 ) ;
816        Size = MAP_APPFONT ( 221, 10 ) ;
817		TabStop = TRUE ;
818		Text [ en-US ] = "~No duplication" ;
819	};
820    FixedLine FL_OPTIONS
821	{
822		Hide = TRUE ;
823        Pos = MAP_APPFONT ( 6, 75 ) ;
824        Size = MAP_APPFONT ( 230, 8 ) ;
825		Text [ en-US ] = "Options" ;
826	};
827	FixedText FT_DBAREA
828	{
829		Hide = TRUE ;
830        Pos = MAP_APPFONT ( 70, 130 ) ;
831        Size = MAP_APPFONT ( 166, 8 ) ;
832		Left = TRUE ;
833		Text [ en-US ] = "dummy" ;
834	};
835	FixedText FT_DBAREA_LABEL
836	{
837		Hide = TRUE ;
838        Pos = MAP_APPFONT ( 6, 130 ) ;
839        Size = MAP_APPFONT ( 58, 8 ) ;
840		Text [ en-US ] = "Data range:" ;
841	};
842	OKButton BTN_OK
843	{
844        Pos = MAP_APPFONT ( 242, 6 ) ;
845		Size = MAP_APPFONT ( 50, 14 ) ;
846		TabStop = TRUE ;
847		DefButton = TRUE ;
848	};
849	CancelButton BTN_CANCEL
850	{
851        Pos = MAP_APPFONT ( 242, 23 ) ;
852		Size = MAP_APPFONT ( 50, 14 ) ;
853		TabStop = TRUE ;
854	};
855	HelpButton BTN_HELP
856	{
857        Pos = MAP_APPFONT ( 242, 43 ) ;
858		Size = MAP_APPFONT ( 50, 14 ) ;
859		TabStop = TRUE ;
860	};
861	MoreButton BTN_MORE
862	{
863	    HelpID = "sc:MoreButton:RID_SCDLG_PIVOTFILTER:BTN_MORE" ;
864        Pos = MAP_APPFONT ( 242, 63 ) ;
865		Size = MAP_APPFONT ( 50, 14 ) ;
866		TabStop = TRUE ;
867		MapUnit = MAP_APPFONT ;
868        Delta = 61 ;
869	};
870};
871
872String STR_COPY_AREA_TO
873{
874	Text [ en-US ] = "Copy results to" ;
875};
876String RID_FILTER_OPERATOR
877{
878	Text [ en-US ] = "Operator" ;
879};
880String RID_FILTER_FIELDNAME
881{
882	Text [ en-US ] = "Field Name" ;
883};
884String RID_FILTER_CONDITION
885{
886	Text [ en-US ] = "Condition" ;
887};
888String RID_FILTER_VALUE
889{
890	Text [ en-US ] = "Value" ;
891};
892
893// ********************************************************************** EOF
894