xref: /aoo42x/main/sc/source/ui/dbgui/consdlg.src (revision 2f154c07)
182177cdbSAndrew Rist/**************************************************************
2*2f154c07Smseidel *
382177cdbSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
482177cdbSAndrew Rist * or more contributor license agreements.  See the NOTICE file
582177cdbSAndrew Rist * distributed with this work for additional information
682177cdbSAndrew Rist * regarding copyright ownership.  The ASF licenses this file
782177cdbSAndrew Rist * to you under the Apache License, Version 2.0 (the
882177cdbSAndrew Rist * "License"); you may not use this file except in compliance
982177cdbSAndrew Rist * with the License.  You may obtain a copy of the License at
10*2f154c07Smseidel *
1182177cdbSAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
12*2f154c07Smseidel *
1382177cdbSAndrew Rist * Unless required by applicable law or agreed to in writing,
1482177cdbSAndrew Rist * software distributed under the License is distributed on an
1582177cdbSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
1682177cdbSAndrew Rist * KIND, either express or implied.  See the License for the
1782177cdbSAndrew Rist * specific language governing permissions and limitations
1882177cdbSAndrew Rist * under the License.
19*2f154c07Smseidel *
2082177cdbSAndrew Rist *************************************************************/
2182177cdbSAndrew Rist
2282177cdbSAndrew Rist
23*2f154c07Smseidel
24cdf0e10cSrcweir#include "consdlg.hrc"
25cdf0e10cSrcweirModelessDialog RID_SCDLG_CONSOLIDATE
26cdf0e10cSrcweir{
27cdf0e10cSrcweir	OutputSize = TRUE ;
28cdf0e10cSrcweir	HelpId = CMD_SID_OPENDLG_CONSOLIDATE ;
29cdf0e10cSrcweir	Hide = TRUE ;
30cdf0e10cSrcweir	SVLook = TRUE ;
31*2f154c07Smseidel	Size = MAP_APPFONT ( 280, 154 ) ;
32cdf0e10cSrcweir	Text [ en-US ] = "Consolidate" ;
33cdf0e10cSrcweir	Moveable = TRUE ;
34cdf0e10cSrcweir	Closeable = FALSE ;
35cdf0e10cSrcweir	ListBox LB_FUNC
36cdf0e10cSrcweir	{
37*2f154c07Smseidel		HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_FUNC" ;
38cdf0e10cSrcweir		Border = TRUE ;
39*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 17 ) ;
40*2f154c07Smseidel		Size = MAP_APPFONT ( 212, 90 ) ;
41cdf0e10cSrcweir		TabStop = TRUE ;
42cdf0e10cSrcweir		DropDown = TRUE ;
43cdf0e10cSrcweir		StringList [ en-US ] =
44cdf0e10cSrcweir		{
45*2f154c07Smseidel			< "Sum" ; Default ;						> ;
46*2f154c07Smseidel			< "Count" ; Default ;					> ;
47*2f154c07Smseidel			< "Average" ; Default ;					> ;
48*2f154c07Smseidel			< "Max" ; Default ;						> ;
49*2f154c07Smseidel			< "Min" ; Default ;						> ;
50*2f154c07Smseidel			< "Product" ; Default ;					> ;
51*2f154c07Smseidel			< "Count (numbers only)" ; Default ;	> ;
52*2f154c07Smseidel			< "StDev (sample)" ; Default ;			> ;
53*2f154c07Smseidel			< "StDevP (population)" ; Default ;		> ;
54*2f154c07Smseidel			< "Var (sample)" ; Default ;			> ;
55*2f154c07Smseidel			< "VarP (population)" ; Default ;		> ;
56cdf0e10cSrcweir		};
57cdf0e10cSrcweir	};
58cdf0e10cSrcweir	Edit ED_DATA_AREA
59cdf0e10cSrcweir	{
60*2f154c07Smseidel		HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA" ;
61cdf0e10cSrcweir		Border = TRUE ;
62*2f154c07Smseidel		Pos = MAP_APPFONT ( 100, 106 ) ;
63*2f154c07Smseidel		Size = MAP_APPFONT ( 104, 12 ) ;
64cdf0e10cSrcweir		TabStop = TRUE ;
65cdf0e10cSrcweir	};
66cdf0e10cSrcweir	Edit ED_DEST_AREA
67cdf0e10cSrcweir	{
68*2f154c07Smseidel		HelpID = "sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA" ;
69cdf0e10cSrcweir		Border = TRUE ;
70*2f154c07Smseidel		Pos = MAP_APPFONT ( 100, 135 ) ;
71*2f154c07Smseidel		Size = MAP_APPFONT ( 104, 12 ) ;
72cdf0e10cSrcweir		TabStop = TRUE ;
73cdf0e10cSrcweir	};
74cdf0e10cSrcweir	ImageButton RB_DATA_AREA
75cdf0e10cSrcweir	{
76*2f154c07Smseidel		HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA" ;
77*2f154c07Smseidel		Pos = MAP_APPFONT ( 206, 105 ) ;
78*2f154c07Smseidel		Size = MAP_APPFONT ( 13, 15 ) ;
79cdf0e10cSrcweir		TabStop = TRUE ;
80cdf0e10cSrcweir		QuickHelpText [ en-US ] = "Shrink" ;
81cdf0e10cSrcweir	};
82cdf0e10cSrcweir	ImageButton RB_DEST_AREA
83cdf0e10cSrcweir	{
84*2f154c07Smseidel		HelpID = "sc:ImageButton:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA" ;
85*2f154c07Smseidel		Pos = MAP_APPFONT ( 206, 134 ) ;
86*2f154c07Smseidel		Size = MAP_APPFONT ( 13, 15 ) ;
87cdf0e10cSrcweir		TabStop = TRUE ;
88cdf0e10cSrcweir		QuickHelpText [ en-US ] = "Shrink" ;
89cdf0e10cSrcweir	};
90cdf0e10cSrcweir	ListBox LB_DATA_AREA
91cdf0e10cSrcweir	{
92*2f154c07Smseidel		HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA" ;
93cdf0e10cSrcweir		Border = TRUE ;
94*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 106 ) ;
95*2f154c07Smseidel		Size = MAP_APPFONT ( 90, 90 ) ;
96cdf0e10cSrcweir		TabStop = TRUE ;
97cdf0e10cSrcweir		DropDown = TRUE ;
98cdf0e10cSrcweir	};
99cdf0e10cSrcweir	ListBox LB_DEST_AREA
100cdf0e10cSrcweir	{
101*2f154c07Smseidel		HelpID = "sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA" ;
102cdf0e10cSrcweir		Border = TRUE ;
103*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 135 ) ;
104*2f154c07Smseidel		Size = MAP_APPFONT ( 90, 90 ) ;
105cdf0e10cSrcweir		TabStop = TRUE ;
106cdf0e10cSrcweir		DropDown = TRUE ;
107cdf0e10cSrcweir	};
108cdf0e10cSrcweir	MultiListBox LB_CONSAREAS
109cdf0e10cSrcweir	{
110*2f154c07Smseidel		HelpID = "sc:MultiListBox:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS" ;
111cdf0e10cSrcweir		SimpleMode = TRUE ;
112cdf0e10cSrcweir		Border = TRUE ;
113*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 46 ) ;
114*2f154c07Smseidel		Size = MAP_APPFONT ( 212, 43 ) ;
115cdf0e10cSrcweir		TabStop = TRUE ;
116cdf0e10cSrcweir	};
117cdf0e10cSrcweir	FixedText FT_FUNC
118cdf0e10cSrcweir	{
119*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 6 ) ;
120*2f154c07Smseidel		Size = MAP_APPFONT ( 212, 8 ) ;
121cdf0e10cSrcweir		Text [ en-US ] = "~Function" ;
122cdf0e10cSrcweir	};
123cdf0e10cSrcweir	FixedText FT_CONSAREAS
124cdf0e10cSrcweir	{
125*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 35 ) ;
126*2f154c07Smseidel		Size = MAP_APPFONT ( 212, 8 ) ;
127cdf0e10cSrcweir		Text [ en-US ] = "~Consolidation ranges" ;
128cdf0e10cSrcweir	};
129cdf0e10cSrcweir	FixedText FT_DATA_AREA
130cdf0e10cSrcweir	{
131*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 95 ) ;
132*2f154c07Smseidel		Size = MAP_APPFONT ( 212, 8 ) ;
133cdf0e10cSrcweir		Text [ en-US ] = "~Source data range" ;
134cdf0e10cSrcweir	};
135cdf0e10cSrcweir	FixedText FT_DEST_AREA
136cdf0e10cSrcweir	{
137*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 124 ) ;
138*2f154c07Smseidel		Size = MAP_APPFONT ( 212, 8 ) ;
139cdf0e10cSrcweir		Text [ en-US ] = "Copy results ~to" ;
140cdf0e10cSrcweir	};
141cdf0e10cSrcweir	CheckBox BTN_BYROW
142cdf0e10cSrcweir	{
143*2f154c07Smseidel		HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYROW" ;
144*2f154c07Smseidel		Pos = MAP_APPFONT ( 12, 165 ) ;
145*2f154c07Smseidel		Size = MAP_APPFONT ( 94, 10 ) ;
146cdf0e10cSrcweir		Text [ en-US ] = "~Row labels" ;
147cdf0e10cSrcweir		TabStop = TRUE ;
148cdf0e10cSrcweir	};
149cdf0e10cSrcweir	CheckBox BTN_BYCOL
150cdf0e10cSrcweir	{
151*2f154c07Smseidel		HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_BYCOL" ;
152*2f154c07Smseidel		Pos = MAP_APPFONT ( 12, 179 ) ;
153*2f154c07Smseidel		Size = MAP_APPFONT ( 94, 10 ) ;
154cdf0e10cSrcweir		TabStop = TRUE ;
155cdf0e10cSrcweir		Text [ en-US ] = "C~olumn labels" ;
156cdf0e10cSrcweir	};
157*2f154c07Smseidel	FixedLine FL_CONSBY
158cdf0e10cSrcweir	{
159*2f154c07Smseidel		Pos = MAP_APPFONT ( 6, 154 ) ;
160*2f154c07Smseidel		Size = MAP_APPFONT ( 103, 8 ) ;
161cdf0e10cSrcweir		Text [ en-US ] = "Consolidate by" ;
162cdf0e10cSrcweir	};
163*2f154c07Smseidel	FixedLine FL_SEP
164cdf0e10cSrcweir	{
165*2f154c07Smseidel		Pos = MAP_APPFONT ( 112, 165 ) ;
166*2f154c07Smseidel		Size = MAP_APPFONT ( 1, 24 ) ;
167*2f154c07Smseidel	};
168*2f154c07Smseidel	FixedLine FL_OPTIONS
169cdf0e10cSrcweir	{
170cdf0e10cSrcweir		Hide = TRUE ;
171*2f154c07Smseidel		Pos = MAP_APPFONT ( 115, 154 ) ;
172*2f154c07Smseidel		Size = MAP_APPFONT ( 103, 8 ) ;
173cdf0e10cSrcweir		Text [ en-US ] = "Options" ;
174cdf0e10cSrcweir	};
175cdf0e10cSrcweir	CheckBox BTN_REFS
176cdf0e10cSrcweir	{
177*2f154c07Smseidel		HelpID = "sc:CheckBox:RID_SCDLG_CONSOLIDATE:BTN_REFS" ;
178*2f154c07Smseidel		Pos = MAP_APPFONT ( 121, 165 ) ;
179*2f154c07Smseidel		Size = MAP_APPFONT ( 94, 10 ) ;
180cdf0e10cSrcweir		Text [ en-US ] = "~Link to source data" ;
181cdf0e10cSrcweir		TabStop = TRUE ;
182cdf0e10cSrcweir	};
183cdf0e10cSrcweir	OKButton BTN_OK
184cdf0e10cSrcweir	{
185*2f154c07Smseidel		Pos = MAP_APPFONT ( 224, 6 ) ;
186*2f154c07Smseidel		Size = MAP_APPFONT ( 50, 14 ) ;
187cdf0e10cSrcweir		TabStop = TRUE ;
188cdf0e10cSrcweir		DefButton = TRUE ;
189cdf0e10cSrcweir	};
190cdf0e10cSrcweir	CancelButton BTN_CANCEL
191cdf0e10cSrcweir	{
192*2f154c07Smseidel		Pos = MAP_APPFONT ( 224, 23 ) ;
193*2f154c07Smseidel		Size = MAP_APPFONT ( 50, 14 ) ;
194cdf0e10cSrcweir		TabStop = TRUE ;
195cdf0e10cSrcweir	};
196cdf0e10cSrcweir	HelpButton BTN_HELP
197cdf0e10cSrcweir	{
198*2f154c07Smseidel		Pos = MAP_APPFONT ( 224, 43 ) ;
199*2f154c07Smseidel		Size = MAP_APPFONT ( 50, 14 ) ;
200cdf0e10cSrcweir		TabStop = TRUE ;
201cdf0e10cSrcweir	};
202cdf0e10cSrcweir	MoreButton BTN_MORE
203cdf0e10cSrcweir	{
204*2f154c07Smseidel		HelpID = "sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE" ;
205*2f154c07Smseidel		Pos = MAP_APPFONT ( 224, 134 ) ;
206*2f154c07Smseidel		Size = MAP_APPFONT ( 50, 14 ) ;
207cdf0e10cSrcweir		TabStop = TRUE ;
208cdf0e10cSrcweir		MapUnit = MAP_APPFONT ;
209*2f154c07Smseidel		Delta = 41 ;
210cdf0e10cSrcweir	};
211cdf0e10cSrcweir	PushButton BTN_REMOVE
212cdf0e10cSrcweir	{
213*2f154c07Smseidel		HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_REMOVE" ;
214*2f154c07Smseidel		Pos = MAP_APPFONT ( 224, 114 ) ;
215*2f154c07Smseidel		Size = MAP_APPFONT ( 50, 14 ) ;
216cdf0e10cSrcweir		Text [ en-US ] = "~Delete" ;
217cdf0e10cSrcweir		TabStop = TRUE ;
218cdf0e10cSrcweir	};
219cdf0e10cSrcweir	PushButton BTN_ADD
220cdf0e10cSrcweir	{
221*2f154c07Smseidel		HelpID = "sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD" ;
222*2f154c07Smseidel		Pos = MAP_APPFONT ( 224, 96 ) ;
223*2f154c07Smseidel		Size = MAP_APPFONT ( 50, 14 ) ;
224cdf0e10cSrcweir		Text [ en-US ] = "~Add" ;
225cdf0e10cSrcweir		TabStop = TRUE ;
226cdf0e10cSrcweir	};
227cdf0e10cSrcweir};
228cdf0e10cSrcweir
229*2f154c07Smseidel// ********************************************************************** EOF
230