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