1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
|
/*************************************************************************
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: pvfundlg.hxx,v $
*
* $Revision: 1.6 $
*
* last change: $Author: rt $ $Date: 2005-09-08 21:46:06 $
*
* The Contents of this file are made available subject to
* the terms of GNU Lesser General Public License Version 2.1.
*
*
* GNU Lesser General Public License Version 2.1
* =============================================
* Copyright 2005 by Sun Microsystems, Inc.
* 901 San Antonio Road, Palo Alto, CA 94303, USA
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
************************************************************************/
#ifndef SC_PVFUNDLG_HXX
#define SC_PVFUNDLG_HXX
#ifndef _COM_SUN_STAR_SHEET_DATAPILOTFIELDREFERENCE_HPP_
#include <com/sun/star/sheet/DataPilotFieldReference.hpp>
#endif
#ifndef _COM_SUN_STAR_SHEET_DATAPILOTFIELDSORTINFO_HPP_
#include <com/sun/star/sheet/DataPilotFieldSortInfo.hpp>
#endif
#ifndef _FIXED_HXX
#include <vcl/fixed.hxx>
#endif
#ifndef _LSTBOX_HXX
#include <vcl/lstbox.hxx>
#endif
#ifndef _DIALOG_HXX
#include <vcl/dialog.hxx>
#endif
#ifndef _BUTTON_HXX
#include <vcl/button.hxx>
#endif
#ifndef _MOREBTN_HXX
#include <vcl/morebtn.hxx>
#endif
#ifndef _SV_FIELD_HXX
#include <vcl/field.hxx>
#endif
#ifndef _STDCTRL_HXX
#include <svtools/stdctrl.hxx>
#endif
#ifndef _SVX_CHECKLBX_HXX
#include <svx/checklbx.hxx>
#endif
#ifndef SFX_ITEMCONNECT_HXX
#include <sfx2/itemconnect.hxx>
#endif
#ifndef SC_PIVOT_HXX
#include "pivot.hxx"
#endif
// ============================================================================
typedef sfx::ListBoxWrapper< sal_Int32 > ScDPListBoxWrapper;
class ScDPObject;
// ============================================================================
class ScDPFunctionListBox : public MultiListBox
{
public:
explicit ScDPFunctionListBox( Window* pParent, const ResId& rResId );
explicit ScDPFunctionListBox( Window* pParent, WinBits nStyle = 0 );
void SetSelection( USHORT nFuncMask );
USHORT GetSelection() const;
private:
void FillFunctionNames();
};
// ============================================================================
class ScDPFunctionDlg : public ModalDialog
{
public:
explicit ScDPFunctionDlg( Window* pParent, const ScDPLabelDataVec& rLabelVec,
const ScDPLabelData& rLabelData, const ScDPFuncData& rFuncData );
USHORT GetFuncMask() const;
::com::sun::star::sheet::DataPilotFieldReference GetFieldRef() const;
private:
void Init( const ScDPLabelData& rLabelData, const ScDPFuncData& rFuncData );
DECL_LINK( SelectHdl, ListBox* );
DECL_LINK( DblClickHdl, MultiListBox* );
private:
FixedLine maFlFunc;
ScDPFunctionListBox maLbFunc;
FixedText maFtNameLabel;
FixedInfo maFtName;
FixedLine maFlDisplay;
FixedText maFtType;
ListBox maLbType;
FixedText maFtBaseField;
ListBox maLbBaseField;
FixedText maFtBaseItem;
ListBox maLbBaseItem;
OKButton maBtnOk;
CancelButton maBtnCancel;
HelpButton maBtnHelp;
MoreButton maBtnMore;
ScDPListBoxWrapper maLbTypeWrp; /// Wrapper for direct usage of API constants.
const ScDPLabelDataVec& mrLabelVec; /// Data of all labels.
bool mbEmptyItem; /// true = Empty base item in listbox.
};
// ============================================================================
class ScDPSubtotalDlg : public ModalDialog
{
public:
explicit ScDPSubtotalDlg( Window* pParent, ScDPObject& rDPObj,
const ScDPLabelData& rLabelData, const ScDPFuncData& rFuncData,
const ScDPNameVec& rDataFields, bool bEnableLayout );
USHORT GetFuncMask() const;
void FillLabelData( ScDPLabelData& rLabelData ) const;
private:
void Init( const ScDPLabelData& rLabelData, const ScDPFuncData& rFuncData );
DECL_LINK( DblClickHdl, MultiListBox* );
DECL_LINK( RadioClickHdl, RadioButton* );
DECL_LINK( ClickHdl, PushButton* );
private:
FixedLine maFlSubt;
RadioButton maRbNone;
RadioButton maRbAuto;
RadioButton maRbUser;
ScDPFunctionListBox maLbFunc;
FixedText maFtNameLabel;
FixedInfo maFtName;
CheckBox maCbShowAll;
OKButton maBtnOk;
CancelButton maBtnCancel;
HelpButton maBtnHelp;
PushButton maBtnOptions;
ScDPObject& mrDPObj; /// The DataPilot object (for member names).
const ScDPNameVec& mrDataFields; /// The list of all data field names.
ScDPLabelData maLabelData; /// Cache for sub dialog.
bool mbEnableLayout; /// true = Enable Layout mode controls.
};
// ============================================================================
class ScDPSubtotalOptDlg : public ModalDialog
{
public:
explicit ScDPSubtotalOptDlg( Window* pParent, ScDPObject& rDPObj,
const ScDPLabelData& rLabelData, const ScDPNameVec& rDataFields,
bool bEnableLayout );
void FillLabelData( ScDPLabelData& rLabelData ) const;
private:
void Init( const ScDPNameVec& rDataFields, bool bEnableLayout );
void InitHideListBox();
DECL_LINK( RadioClickHdl, RadioButton* );
DECL_LINK( CheckHdl, CheckBox* );
DECL_LINK( SelectHdl, ListBox* );
private:
FixedLine maFlSortBy;
ListBox maLbSortBy;
RadioButton maRbSortAsc;
RadioButton maRbSortDesc;
RadioButton maRbSortMan;
FixedLine maFlLayout;
FixedText maFtLayout;
ListBox maLbLayout;
CheckBox maCbLayoutEmpty;
FixedLine maFlAutoShow;
CheckBox maCbShow;
NumericField maNfShow;
FixedText maFtShow;
FixedText maFtShowFrom;
ListBox maLbShowFrom;
FixedText maFtShowUsing;
ListBox maLbShowUsing;
FixedLine maFlHide;
SvxCheckListBox maLbHide;
FixedText maFtHierarchy;
ListBox maLbHierarchy;
OKButton maBtnOk;
CancelButton maBtnCancel;
HelpButton maBtnHelp;
ScDPListBoxWrapper maLbLayoutWrp; /// Wrapper for direct usage of API constants.
ScDPListBoxWrapper maLbShowFromWrp; /// Wrapper for direct usage of API constants.
ScDPObject& mrDPObj; /// The DataPilot object (for member names).
ScDPLabelData maLabelData; /// Cache for members data.
};
// ============================================================================
class ScDPShowDetailDlg : public ModalDialog
{
public:
explicit ScDPShowDetailDlg( Window* pParent, ScDPObject& rDPObj, USHORT nOrient );
virtual short Execute();
String GetDimensionName() const;
private:
DECL_LINK( DblClickHdl, ListBox* );
private:
FixedText maFtDims;
ListBox maLbDims;
OKButton maBtnOk;
CancelButton maBtnCancel;
HelpButton maBtnHelp;
};
// ============================================================================
#endif
|
