xref: /aoo41x/main/sc/source/ui/dbgui/consdlg.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#include "consdlg.hrc"
24ModelessDialog RID_SCDLG_CONSOLIDATE
25{
26	OutputSize = TRUE ;
27	HelpId = CMD_SID_OPENDLG_CONSOLIDATE ;
28	Hide = TRUE ;
29	SVLook = TRUE ;
30	Size = MAP_APPFONT ( 280 , 154 ) ;
31	Text [ en-US ] = "Consolidate" ;
32	Moveable = TRUE ;
33	Closeable = FALSE ;
34	ListBox LB_FUNC
35	{
36	    HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_FUNC";
37		Border = TRUE ;
38        Pos = MAP_APPFONT ( 6 , 17 ) ;
39        Size = MAP_APPFONT ( 212 , 90 ) ;
40		TabStop = TRUE ;
41		DropDown = TRUE ;
42		StringList [ en-US ] =
43		{
44			< "Sum" ; Default ; > ;
45			< "Count" ; Default ; > ;
46			< "Average" ; Default ; > ;
47			< "Max" ; Default ; > ;
48			< "Min" ; Default ; > ;
49			< "Product" ; Default ; > ;
50			< "Count (numbers only)" ; Default ; > ;
51			< "StDev (sample)" ; Default ; > ;
52			< "StDevP (population)" ; Default ; > ;
53			< "Var (sample)" ; Default ; > ;
54			< "VarP (population)" ; Default ; > ;
55		};
56	};
57	Edit ED_DATA_AREA
58	{
59	    HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA";
60		Border = TRUE ;
61        Pos = MAP_APPFONT ( 100 , 106 ) ;
62        Size = MAP_APPFONT ( 104 , 12 ) ;
63		TabStop = TRUE ;
64	};
65	Edit ED_DEST_AREA
66	{
67	    HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA";
68		Border = TRUE ;
69        Pos = MAP_APPFONT ( 100 , 135 ) ;
70        Size = MAP_APPFONT ( 104 , 12 ) ;
71		TabStop = TRUE ;
72	};
73	ImageButton RB_DATA_AREA
74	{
75	    HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA";
76        Pos = MAP_APPFONT ( 206 , 105 ) ;
77		Size = MAP_APPFONT ( 13 , 15 ) ;
78		TabStop = TRUE ;
79		QuickHelpText [ en-US ] = "Shrink" ;
80	};
81	ImageButton RB_DEST_AREA
82	{
83	    HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA";
84        Pos = MAP_APPFONT ( 206 , 134 ) ;
85		Size = MAP_APPFONT ( 13 , 15 ) ;
86		TabStop = TRUE ;
87		QuickHelpText [ en-US ] = "Shrink" ;
88	};
89	ListBox LB_DATA_AREA
90	{
91	    HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA";
92		Border = TRUE ;
93		Pos = MAP_APPFONT ( 6 , 106 ) ;
94        Size = MAP_APPFONT ( 90 , 90 ) ;
95		TabStop = TRUE ;
96		DropDown = TRUE ;
97	};
98	ListBox LB_DEST_AREA
99	{
100	    HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA";
101		Border = TRUE ;
102        Pos = MAP_APPFONT ( 6 , 135 ) ;
103        Size = MAP_APPFONT ( 90 , 90 ) ;
104		TabStop = TRUE ;
105		DropDown = TRUE ;
106	};
107	MultiListBox LB_CONSAREAS
108	{
109	    HelpID = "sc:MultiListBox:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS";
110		SimpleMode = TRUE ;
111		Border = TRUE ;
112        Pos = MAP_APPFONT ( 6 , 46 ) ;
113        Size = MAP_APPFONT ( 212 , 43 ) ;
114		TabStop = TRUE ;
115	};
116	FixedText FT_FUNC
117	{
118        Pos = MAP_APPFONT ( 6 , 6 ) ;
119        Size = MAP_APPFONT ( 212 , 8 ) ;
120		Text [ en-US ] = "~Function" ;
121	};
122	FixedText FT_CONSAREAS
123	{
124        Pos = MAP_APPFONT ( 6 , 35 ) ;
125        Size = MAP_APPFONT ( 212 , 8 ) ;
126		Text [ en-US ] = "~Consolidation ranges" ;
127	};
128	FixedText FT_DATA_AREA
129	{
130        Pos = MAP_APPFONT ( 6 , 95 ) ;
131        Size = MAP_APPFONT ( 212 , 8 ) ;
132		Text [ en-US ] = "~Source data range" ;
133	};
134	FixedText FT_DEST_AREA
135	{
136		Pos = MAP_APPFONT ( 6 , 124 ) ;
137        Size = MAP_APPFONT ( 212 , 8 ) ;
138		Text [ en-US ] = "Copy results ~to" ;
139	};
140	CheckBox BTN_BYROW
141	{
142	    HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW";
143        Pos = MAP_APPFONT ( 12 , 165 ) ;
144        Size = MAP_APPFONT ( 94 , 10 ) ;
145		Text [ en-US ] = "~Row labels" ;
146		TabStop = TRUE ;
147	};
148	CheckBox BTN_BYCOL
149	{
150	    HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL";
151        Pos = MAP_APPFONT ( 12 , 179 ) ;
152        Size = MAP_APPFONT ( 94 , 10 ) ;
153		TabStop = TRUE ;
154		Text [ en-US ] = "C~olumn labels" ;
155	};
156    FixedLine FL_CONSBY
157	{
158		Pos = MAP_APPFONT ( 6 , 154 ) ;
159        Size = MAP_APPFONT ( 103 , 8 ) ;
160		Text [ en-US ] = "Consolidate by" ;
161	};
162    FixedLine FL_SEP
163	{
164        Pos = MAP_APPFONT ( 112 , 165 ) ;
165        Size = MAP_APPFONT ( 1 , 24 ) ;
166    };
167    FixedLine FL_OPTIONS
168	{
169		Hide = TRUE ;
170        Pos = MAP_APPFONT ( 115 , 154 ) ;
171        Size = MAP_APPFONT ( 103 , 8 ) ;
172		Text [ en-US ] = "Options" ;
173	};
174	CheckBox BTN_REFS
175	{
176	    HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS";
177        Pos = MAP_APPFONT ( 121 , 165 ) ;
178        Size = MAP_APPFONT ( 94 , 10 ) ;
179		Text [ en-US ] = "~Link to source data" ;
180		TabStop = TRUE ;
181	};
182	OKButton BTN_OK
183	{
184        Pos = MAP_APPFONT ( 224 , 6 ) ;
185		Size = MAP_APPFONT ( 50 , 14 ) ;
186		TabStop = TRUE ;
187		DefButton = TRUE ;
188	};
189	CancelButton BTN_CANCEL
190	{
191        Pos = MAP_APPFONT ( 224 , 23 ) ;
192		Size = MAP_APPFONT ( 50 , 14 ) ;
193		TabStop = TRUE ;
194	};
195	HelpButton BTN_HELP
196	{
197        Pos = MAP_APPFONT ( 224 , 43 ) ;
198		Size = MAP_APPFONT ( 50 , 14 ) ;
199		TabStop = TRUE ;
200	};
201	MoreButton BTN_MORE
202	{
203	    HelpID = "sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE";
204        Pos = MAP_APPFONT ( 224 , 134 ) ;
205        Size = MAP_APPFONT ( 50 , 14 ) ;
206		TabStop = TRUE ;
207		MapUnit = MAP_APPFONT ;
208        Delta = 41 ;
209	};
210	PushButton BTN_REMOVE
211	{
212	    HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_REMOVE";
213        Pos = MAP_APPFONT ( 224 , 114 ) ;
214		Size = MAP_APPFONT ( 50 , 14 ) ;
215		Text [ en-US ] = "~Delete" ;
216		TabStop = TRUE ;
217	};
218	PushButton BTN_ADD
219	{
220	    HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD";
221        Pos = MAP_APPFONT ( 224 , 96 ) ;
222		Size = MAP_APPFONT ( 50 , 14 ) ;
223		Text [ en-US ] = "~Add" ;
224		TabStop = TRUE ;
225	};
226};
227
228