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