1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski #ifndef SC_DPOUTPUT_HXX 25*b1cdbd2cSJim Jagielski #define SC_DPOUTPUT_HXX 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XDimensionsSupplier.hpp> 28*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/DataResult.hpp> 29*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/MemberResult.hpp> 30*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/GeneralFunction.hpp> 31*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/DataPilotOutputRangeType.hpp> 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski #include "global.hxx" 34*b1cdbd2cSJim Jagielski #include "address.hxx" 35*b1cdbd2cSJim Jagielski 36*b1cdbd2cSJim Jagielski #include "dpcachetable.hxx" 37*b1cdbd2cSJim Jagielski #include <vector> 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski namespace com { namespace sun { namespace star { namespace sheet { 40*b1cdbd2cSJim Jagielski struct DataPilotFieldFilter; 41*b1cdbd2cSJim Jagielski struct DataPilotTablePositionData; 42*b1cdbd2cSJim Jagielski }}}} 43*b1cdbd2cSJim Jagielski 44*b1cdbd2cSJim Jagielski class Rectangle; 45*b1cdbd2cSJim Jagielski class SvStream; 46*b1cdbd2cSJim Jagielski class ScDocument; 47*b1cdbd2cSJim Jagielski class ScStrCollection; 48*b1cdbd2cSJim Jagielski 49*b1cdbd2cSJim Jagielski struct ScDPOutLevelData; 50*b1cdbd2cSJim Jagielski 51*b1cdbd2cSJim Jagielski 52*b1cdbd2cSJim Jagielski struct ScDPGetPivotDataField 53*b1cdbd2cSJim Jagielski { 54*b1cdbd2cSJim Jagielski String maFieldName; 55*b1cdbd2cSJim Jagielski com::sun::star::sheet::GeneralFunction meFunction; 56*b1cdbd2cSJim Jagielski 57*b1cdbd2cSJim Jagielski bool mbValIsStr; 58*b1cdbd2cSJim Jagielski String maValStr; 59*b1cdbd2cSJim Jagielski double mnValNum; 60*b1cdbd2cSJim Jagielski ScDPGetPivotDataFieldScDPGetPivotDataField61*b1cdbd2cSJim Jagielski ScDPGetPivotDataField() : 62*b1cdbd2cSJim Jagielski meFunction( com::sun::star::sheet::GeneralFunction_NONE ), 63*b1cdbd2cSJim Jagielski mbValIsStr( false ), 64*b1cdbd2cSJim Jagielski mnValNum( 0.0 ) 65*b1cdbd2cSJim Jagielski { 66*b1cdbd2cSJim Jagielski } 67*b1cdbd2cSJim Jagielski }; 68*b1cdbd2cSJim Jagielski 69*b1cdbd2cSJim Jagielski 70*b1cdbd2cSJim Jagielski 71*b1cdbd2cSJim Jagielski class ScDPOutput //! name??? 72*b1cdbd2cSJim Jagielski { 73*b1cdbd2cSJim Jagielski private: 74*b1cdbd2cSJim Jagielski //! use impl-object? 75*b1cdbd2cSJim Jagielski ScDocument* pDoc; 76*b1cdbd2cSJim Jagielski com::sun::star::uno::Reference< 77*b1cdbd2cSJim Jagielski com::sun::star::sheet::XDimensionsSupplier> xSource; 78*b1cdbd2cSJim Jagielski ScAddress aStartPos; 79*b1cdbd2cSJim Jagielski sal_Bool bDoFilter; 80*b1cdbd2cSJim Jagielski ScDPOutLevelData* pColFields; 81*b1cdbd2cSJim Jagielski ScDPOutLevelData* pRowFields; 82*b1cdbd2cSJim Jagielski ScDPOutLevelData* pPageFields; 83*b1cdbd2cSJim Jagielski long nColFieldCount; 84*b1cdbd2cSJim Jagielski long nRowFieldCount; 85*b1cdbd2cSJim Jagielski long nPageFieldCount; 86*b1cdbd2cSJim Jagielski com::sun::star::uno::Sequence< 87*b1cdbd2cSJim Jagielski com::sun::star::uno::Sequence< 88*b1cdbd2cSJim Jagielski com::sun::star::sheet::DataResult> > aData; 89*b1cdbd2cSJim Jagielski sal_Bool bResultsError; 90*b1cdbd2cSJim Jagielski bool mbHasDataLayout; 91*b1cdbd2cSJim Jagielski String aDataDescription; 92*b1cdbd2cSJim Jagielski 93*b1cdbd2cSJim Jagielski // Number format related parameters 94*b1cdbd2cSJim Jagielski sal_uInt32* pColNumFmt; 95*b1cdbd2cSJim Jagielski sal_uInt32* pRowNumFmt; 96*b1cdbd2cSJim Jagielski long nColFmtCount; 97*b1cdbd2cSJim Jagielski long nRowFmtCount; 98*b1cdbd2cSJim Jagielski sal_uInt32 nSingleNumFmt; 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski // Output geometry related parameters 101*b1cdbd2cSJim Jagielski sal_Bool bSizesValid; 102*b1cdbd2cSJim Jagielski sal_Bool bSizeOverflow; 103*b1cdbd2cSJim Jagielski long nColCount; 104*b1cdbd2cSJim Jagielski long nRowCount; 105*b1cdbd2cSJim Jagielski long nHeaderSize; 106*b1cdbd2cSJim Jagielski bool mbHeaderLayout; // sal_True : grid, sal_False : standard 107*b1cdbd2cSJim Jagielski SCCOL nTabStartCol; 108*b1cdbd2cSJim Jagielski SCROW nTabStartRow; 109*b1cdbd2cSJim Jagielski SCCOL nMemberStartCol; 110*b1cdbd2cSJim Jagielski SCROW nMemberStartRow; 111*b1cdbd2cSJim Jagielski SCCOL nDataStartCol; 112*b1cdbd2cSJim Jagielski SCROW nDataStartRow; 113*b1cdbd2cSJim Jagielski SCCOL nTabEndCol; 114*b1cdbd2cSJim Jagielski SCROW nTabEndRow; 115*b1cdbd2cSJim Jagielski 116*b1cdbd2cSJim Jagielski void DataCell( SCCOL nCol, SCROW nRow, SCTAB nTab, 117*b1cdbd2cSJim Jagielski const com::sun::star::sheet::DataResult& rData ); 118*b1cdbd2cSJim Jagielski void HeaderCell( SCCOL nCol, SCROW nRow, SCTAB nTab, 119*b1cdbd2cSJim Jagielski const com::sun::star::sheet::MemberResult& rData, 120*b1cdbd2cSJim Jagielski sal_Bool bColHeader, long nLevel ); 121*b1cdbd2cSJim Jagielski void FieldCell( SCCOL nCol, SCROW nRow, SCTAB nTab, const String& rCaption, 122*b1cdbd2cSJim Jagielski bool bInTable, bool bPopup, bool bHasHiddenMember ); 123*b1cdbd2cSJim Jagielski void CalcSizes(); 124*b1cdbd2cSJim Jagielski 125*b1cdbd2cSJim Jagielski /** Query which sub-area of the table the cell is in. See 126*b1cdbd2cSJim Jagielski css.sheet.DataPilotTablePositionType for the interpretation of the 127*b1cdbd2cSJim Jagielski return value. */ 128*b1cdbd2cSJim Jagielski sal_Int32 GetPositionType(const ScAddress& rPos); 129*b1cdbd2cSJim Jagielski 130*b1cdbd2cSJim Jagielski public: 131*b1cdbd2cSJim Jagielski ScDPOutput( ScDocument* pD, 132*b1cdbd2cSJim Jagielski const com::sun::star::uno::Reference< 133*b1cdbd2cSJim Jagielski com::sun::star::sheet::XDimensionsSupplier>& xSrc, 134*b1cdbd2cSJim Jagielski const ScAddress& rPos, sal_Bool bFilter ); 135*b1cdbd2cSJim Jagielski ~ScDPOutput(); 136*b1cdbd2cSJim Jagielski 137*b1cdbd2cSJim Jagielski void SetPosition( const ScAddress& rPos ); 138*b1cdbd2cSJim Jagielski 139*b1cdbd2cSJim Jagielski void Output(); //! Refresh? 140*b1cdbd2cSJim Jagielski ScRange GetOutputRange( sal_Int32 nRegionType = ::com::sun::star::sheet::DataPilotOutputRangeType::WHOLE ); 141*b1cdbd2cSJim Jagielski long GetHeaderRows(); 142*b1cdbd2cSJim Jagielski sal_Bool HasError(); // range overflow or exception from source 143*b1cdbd2cSJim Jagielski 144*b1cdbd2cSJim Jagielski void GetPositionData(const ScAddress& rPos, ::com::sun::star::sheet::DataPilotTablePositionData& rPosData); 145*b1cdbd2cSJim Jagielski 146*b1cdbd2cSJim Jagielski /** Get filtering criteria based on the position of the cell within data 147*b1cdbd2cSJim Jagielski field region. */ 148*b1cdbd2cSJim Jagielski bool GetDataResultPositionData(::std::vector< ::com::sun::star::sheet::DataPilotFieldFilter >& rFilters, const ScAddress& rPos); 149*b1cdbd2cSJim Jagielski 150*b1cdbd2cSJim Jagielski sal_Bool GetPivotData( ScDPGetPivotDataField& rTarget, /* returns result */ 151*b1cdbd2cSJim Jagielski const std::vector< ScDPGetPivotDataField >& rFilters ); 152*b1cdbd2cSJim Jagielski long GetHeaderDim( const ScAddress& rPos, sal_uInt16& rOrient ); 153*b1cdbd2cSJim Jagielski sal_Bool GetHeaderDrag( const ScAddress& rPos, sal_Bool bMouseLeft, sal_Bool bMouseTop, 154*b1cdbd2cSJim Jagielski long nDragDim, 155*b1cdbd2cSJim Jagielski Rectangle& rPosRect, sal_uInt16& rOrient, long& rDimPos ); 156*b1cdbd2cSJim Jagielski sal_Bool IsFilterButton( const ScAddress& rPos ); 157*b1cdbd2cSJim Jagielski 158*b1cdbd2cSJim Jagielski void GetMemberResultNames( ScStrCollection& rNames, long nDimension ); 159*b1cdbd2cSJim Jagielski 160*b1cdbd2cSJim Jagielski void SetHeaderLayout(bool bUseGrid); 161*b1cdbd2cSJim Jagielski bool GetHeaderLayout() const; 162*b1cdbd2cSJim Jagielski 163*b1cdbd2cSJim Jagielski static void GetDataDimensionNames( String& rSourceName, String& rGivenName, 164*b1cdbd2cSJim Jagielski const com::sun::star::uno::Reference< 165*b1cdbd2cSJim Jagielski com::sun::star::uno::XInterface>& xDim ); 166*b1cdbd2cSJim Jagielski }; 167*b1cdbd2cSJim Jagielski 168*b1cdbd2cSJim Jagielski 169*b1cdbd2cSJim Jagielski #endif 170*b1cdbd2cSJim Jagielski 171