xref: /AOO41X/main/sc/inc/pivot.hxx (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir /*
28*cdf0e10cSrcweir 	WICHTIG:
29*cdf0e10cSrcweir 	Folgende Reihenfolge beim Aufbau der Pivot-Tabelle unbedingt einzuhalten:
30*cdf0e10cSrcweir 
31*cdf0e10cSrcweir 	pPivot->SetColFields(aColArr, aColCount)
32*cdf0e10cSrcweir 	pPivot->SetRowFields(aRowArr, aRowCount)
33*cdf0e10cSrcweir 	pPivot->SetDataFields(aDataArr, aDataCount)
34*cdf0e10cSrcweir 	if (pPivot->CreateData())
35*cdf0e10cSrcweir 	{
36*cdf0e10cSrcweir 		pPivotDrawData();
37*cdf0e10cSrcweir 		pPivotReleaseData();
38*cdf0e10cSrcweir 	}
39*cdf0e10cSrcweir 
40*cdf0e10cSrcweir 	ausserdem ist sicherzustellen, dass entweder das ColArr oder das RowArr
41*cdf0e10cSrcweir 	einen PivotDataField Eintrag enthalten
42*cdf0e10cSrcweir 
43*cdf0e10cSrcweir */
44*cdf0e10cSrcweir 
45*cdf0e10cSrcweir 
46*cdf0e10cSrcweir #ifndef SC_PIVOT_HXX
47*cdf0e10cSrcweir #define SC_PIVOT_HXX
48*cdf0e10cSrcweir 
49*cdf0e10cSrcweir #include "global.hxx"
50*cdf0e10cSrcweir #include "address.hxx"
51*cdf0e10cSrcweir #include "dpglobal.hxx"
52*cdf0e10cSrcweir 
53*cdf0e10cSrcweir #include <vector>
54*cdf0e10cSrcweir #include <boost/shared_ptr.hpp>
55*cdf0e10cSrcweir 
56*cdf0e10cSrcweir class SubTotal;
57*cdf0e10cSrcweir #include "collect.hxx"
58*cdf0e10cSrcweir 
59*cdf0e10cSrcweir #define PIVOT_DATA_FIELD		(MAXCOLCOUNT)
60*cdf0e10cSrcweir #define PIVOT_FUNC_REF			(MAXCOLCOUNT)
61*cdf0e10cSrcweir #include <com/sun/star/uno/Sequence.hxx>
62*cdf0e10cSrcweir #include <com/sun/star/sheet/DataPilotFieldReference.hpp>
63*cdf0e10cSrcweir #include <com/sun/star/sheet/DataPilotFieldSortInfo.hpp>
64*cdf0e10cSrcweir #include <com/sun/star/sheet/DataPilotFieldLayoutInfo.hpp>
65*cdf0e10cSrcweir #include <com/sun/star/sheet/DataPilotFieldAutoShowInfo.hpp>
66*cdf0e10cSrcweir 
67*cdf0e10cSrcweir class SvStream;
68*cdf0e10cSrcweir class ScDocument;
69*cdf0e10cSrcweir class ScUserListData;
70*cdf0e10cSrcweir class ScProgress;
71*cdf0e10cSrcweir 
72*cdf0e10cSrcweir // ============================================================================
73*cdf0e10cSrcweir 
74*cdf0e10cSrcweir struct ScDPLabelData
75*cdf0e10cSrcweir {
76*cdf0e10cSrcweir     ::rtl::OUString     maName;         /// Original name of the dimension.
77*cdf0e10cSrcweir     ::rtl::OUString     maLayoutName;   /// Layout name (display name)
78*cdf0e10cSrcweir     SCCOL               mnCol;
79*cdf0e10cSrcweir     sal_uInt16          mnFuncMask;     /// Page/Column/Row subtotal function.
80*cdf0e10cSrcweir     sal_Int32           mnUsedHier;     /// Used hierarchy.
81*cdf0e10cSrcweir     sal_Int32           mnFlags;        /// Flags from the DataPilotSource dimension
82*cdf0e10cSrcweir     bool                mbShowAll;      /// true = Show all (also empty) results.
83*cdf0e10cSrcweir     bool                mbIsValue;      /// true = Sum or count in data field.
84*cdf0e10cSrcweir 
85*cdf0e10cSrcweir     struct Member
86*cdf0e10cSrcweir     {
87*cdf0e10cSrcweir         ::rtl::OUString maName;
88*cdf0e10cSrcweir         ::rtl::OUString maLayoutName;
89*cdf0e10cSrcweir         bool mbVisible;
90*cdf0e10cSrcweir         bool mbShowDetails;
91*cdf0e10cSrcweir 
92*cdf0e10cSrcweir         Member();
93*cdf0e10cSrcweir 
94*cdf0e10cSrcweir         /**
95*cdf0e10cSrcweir          * return the name that should be displayed in the dp dialogs i.e.
96*cdf0e10cSrcweir          * when the layout name is present, use it, or else use the original
97*cdf0e10cSrcweir          * name.
98*cdf0e10cSrcweir          */
99*cdf0e10cSrcweir         ::rtl::OUString SC_DLLPUBLIC getDisplayName() const;
100*cdf0e10cSrcweir     };
101*cdf0e10cSrcweir     ::std::vector<Member>                               maMembers;
102*cdf0e10cSrcweir     ::com::sun::star::uno::Sequence< ::rtl::OUString >  maHiers;        /// Hierarchies.
103*cdf0e10cSrcweir     ::com::sun::star::sheet::DataPilotFieldSortInfo     maSortInfo;     /// Sorting info.
104*cdf0e10cSrcweir     ::com::sun::star::sheet::DataPilotFieldLayoutInfo   maLayoutInfo;   /// Layout info.
105*cdf0e10cSrcweir     ::com::sun::star::sheet::DataPilotFieldAutoShowInfo maShowInfo;     /// AutoShow info.
106*cdf0e10cSrcweir 
107*cdf0e10cSrcweir     explicit            ScDPLabelData( const String& rName, SCCOL nCol, bool bIsValue );
108*cdf0e10cSrcweir 
109*cdf0e10cSrcweir     /**
110*cdf0e10cSrcweir      * return the name that should be displayed in the dp dialogs i.e. when
111*cdf0e10cSrcweir      * the layout name is present, use it, or else use the original name.
112*cdf0e10cSrcweir      */
113*cdf0e10cSrcweir     ::rtl::OUString SC_DLLPUBLIC getDisplayName() const;
114*cdf0e10cSrcweir };
115*cdf0e10cSrcweir 
116*cdf0e10cSrcweir typedef std::vector< ScDPLabelData > ScDPLabelDataVector;
117*cdf0e10cSrcweir 
118*cdf0e10cSrcweir // ============================================================================
119*cdf0e10cSrcweir 
120*cdf0e10cSrcweir struct ScPivotField
121*cdf0e10cSrcweir {
122*cdf0e10cSrcweir     SCCOL               nCol;
123*cdf0e10cSrcweir     sal_uInt16          nFuncMask;
124*cdf0e10cSrcweir     sal_uInt16          nFuncCount;
125*cdf0e10cSrcweir     ::com::sun::star::sheet::DataPilotFieldReference maFieldRef;
126*cdf0e10cSrcweir 
127*cdf0e10cSrcweir     explicit            ScPivotField( SCCOL nNewCol = 0, sal_uInt16 nNewFuncMask = PIVOT_FUNC_NONE );
128*cdf0e10cSrcweir 
129*cdf0e10cSrcweir     bool                operator==( const ScPivotField& r ) const;
130*cdf0e10cSrcweir };
131*cdf0e10cSrcweir 
132*cdf0e10cSrcweir typedef ::std::vector< ScPivotField > ScPivotFieldVector;
133*cdf0e10cSrcweir 
134*cdf0e10cSrcweir // ============================================================================
135*cdf0e10cSrcweir 
136*cdf0e10cSrcweir struct ScPivotParam
137*cdf0e10cSrcweir {
138*cdf0e10cSrcweir     SCCOL           nCol;           // Cursor Position /
139*cdf0e10cSrcweir     SCROW           nRow;           // bzw. Anfang des Zielbereiches
140*cdf0e10cSrcweir     SCTAB           nTab;
141*cdf0e10cSrcweir     ScDPLabelDataVector maLabelArray;
142*cdf0e10cSrcweir     ScPivotFieldVector maPageArr;
143*cdf0e10cSrcweir     ScPivotFieldVector maColArr;
144*cdf0e10cSrcweir     ScPivotFieldVector maRowArr;
145*cdf0e10cSrcweir     ScPivotFieldVector maDataArr;
146*cdf0e10cSrcweir     bool            bIgnoreEmptyRows;
147*cdf0e10cSrcweir     bool            bDetectCategories;
148*cdf0e10cSrcweir     bool            bMakeTotalCol;
149*cdf0e10cSrcweir     bool            bMakeTotalRow;
150*cdf0e10cSrcweir 
151*cdf0e10cSrcweir     ScPivotParam();
152*cdf0e10cSrcweir 
153*cdf0e10cSrcweir     bool            operator==( const ScPivotParam& r ) const;
154*cdf0e10cSrcweir };
155*cdf0e10cSrcweir 
156*cdf0e10cSrcweir // ============================================================================
157*cdf0e10cSrcweir 
158*cdf0e10cSrcweir struct ScPivotFuncData
159*cdf0e10cSrcweir {
160*cdf0e10cSrcweir     SCCOL               mnCol;
161*cdf0e10cSrcweir     sal_uInt16          mnFuncMask;
162*cdf0e10cSrcweir     ::com::sun::star::sheet::DataPilotFieldReference maFieldRef;
163*cdf0e10cSrcweir 
164*cdf0e10cSrcweir     explicit            ScPivotFuncData( SCCOL nCol, sal_uInt16 nFuncMask );
165*cdf0e10cSrcweir     explicit            ScPivotFuncData( SCCOL nCol, sal_uInt16 nFuncMask,
166*cdf0e10cSrcweir                             const ::com::sun::star::sheet::DataPilotFieldReference& rFieldRef );
167*cdf0e10cSrcweir };
168*cdf0e10cSrcweir 
169*cdf0e10cSrcweir typedef ::std::vector< ScPivotFuncData > ScPivotFuncDataVector;
170*cdf0e10cSrcweir 
171*cdf0e10cSrcweir // ============================================================================
172*cdf0e10cSrcweir 
173*cdf0e10cSrcweir typedef std::vector< String > ScDPNameVec;
174*cdf0e10cSrcweir 
175*cdf0e10cSrcweir // ============================================================================
176*cdf0e10cSrcweir 
177*cdf0e10cSrcweir #endif
178