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