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