xref: /AOO41X/main/sc/source/ui/dbgui/consdlg.src (revision 82177cdbfc5fbca7e9a45fdfffbbaeb8a0d1d1a3)
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
10cdf0e10cSrcweir *
11*82177cdbSAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
12cdf0e10cSrcweir *
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.
19cdf0e10cSrcweir *
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