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