sc/html/xlpivot_8hxx_source.html

 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */

 /*

  * This file is part of the LibreOffice project.

  *

  * This Source Code Form is subject to the terms of the Mozilla Public

  * License, v. 2.0. If a copy of the MPL was not distributed with this

  * file, You can obtain one at http://mozilla.org/MPL/2.0/.

  *

  * This file incorporates work covered by the following license notice:

  *

  *   Licensed to the Apache Software Foundation (ASF) under one or more

  *   contributor license agreements. See the NOTICE file distributed

  *   with this work for additional information regarding copyright

  *   ownership. The ASF licenses this file to you under the Apache

  *   License, Version 2.0 (the "License"); you may not use this file

  *   except in compliance with the License. You may obtain a copy of

  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .

  */


 #pragma once


 #include <com/sun/star/sheet/DataPilotFieldOrientation.hpp>

 #include <tools/datetime.hxx>

 #include "ftools.hxx"

 #include "xladdress.hxx"

 #include <dpobject.hxx>


 #include <optional>


 class XclImpStream;

 class XclExpStream;

 enum class ScGeneralFunction;


 // Constants and Enumerations =================================================


 // misc -----------------------------------------------------------------------


 #define EXC_STORAGE_PTCACHE         "_SX_DB_CUR"


 // strings

 const sal_uInt16 EXC_PT_NOSTRING            = 0xFFFF;

 const sal_uInt16 EXC_PT_MAXSTRLEN           = 0xFFFE;


 // pivot cache fields

 const size_t EXC_PC_MAXFIELDCOUNT           = 0xFFFE;

 const sal_uInt16 EXC_PC_NOFIELD             = 0xFFFF;

 const sal_Int32 EXC_PC_MAXSTRLEN           = 255;


 // pivot cache items

 const size_t EXC_PC_MAXITEMCOUNT            = 32500;

 const sal_uInt16 EXC_PC_NOITEM              = 0xFFFF;


 // pivot table fields

 const sal_uInt16 EXC_PT_MAXFIELDCOUNT       = 0xFFFE;

 const sal_uInt16 EXC_PT_MAXROWCOLCOUNT      = EXC_PT_MAXFIELDCOUNT;

 const sal_uInt16 EXC_PT_MAXPAGECOUNT        = 256;

 const sal_uInt16 EXC_PT_MAXDATACOUNT        = 256;


 // pivot table items

 const sal_uInt16 EXC_PT_MAXITEMCOUNT        = 32500;


 const sal_uInt16 EXC_PT_AUTOFMT_HEADER      = 0x810;

 const sal_uInt16 EXC_PT_AUTOFMT_ZERO        = 0;

 const sal_uInt32 EXC_PT_AUTOFMT_FLAGS       = 0x20;


 enum XclPCItemType

 {

     EXC_PCITEM_INVALID,

     EXC_PCITEM_EMPTY,

     EXC_PCITEM_TEXT,

     EXC_PCITEM_DOUBLE,

     EXC_PCITEM_DATETIME,

     EXC_PCITEM_INTEGER,

     EXC_PCITEM_BOOL,

     EXC_PCITEM_ERROR

 };


 enum XclPCFieldType

 {

     EXC_PCFIELD_STANDARD,

     EXC_PCFIELD_STDGROUP,

     EXC_PCFIELD_NUMGROUP,

     EXC_PCFIELD_DATEGROUP,

     EXC_PCFIELD_DATECHILD,

     EXC_PCFIELD_CALCED,

     EXC_PCFIELD_UNKNOWN

 };


 // (0x0051,0x0052) DCONREF, DCONNAME ------------------------------------------


 const sal_uInt16 EXC_ID_DCONREF             = 0x0051;

 const sal_uInt16 EXC_ID_DCONNAME            = 0x0052;


 // (0x00B0) SXVIEW ------------------------------------------------------------


 const sal_uInt16 EXC_ID_SXVIEW              = 0x00B0;


 const sal_uInt16 EXC_SXVIEW_ROWGRAND        = 0x0001;

 const sal_uInt16 EXC_SXVIEW_COLGRAND        = 0x0002;

 const sal_uInt16 EXC_SXVIEW_DEFAULTFLAGS    = 0x0208;


 const sal_uInt16 EXC_SXVIEW_DATALAST        = 0xFFFF;

 const sal_uInt16 EXC_SXVIEW_AUTOFMT         = 0x0001;


 // (0x00B1) SXVD --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXVD                = 0x00B1;


 const sal_uInt16 EXC_SXVD_AXIS_NONE         = 0x0000;

 const sal_uInt16 EXC_SXVD_AXIS_ROW          = 0x0001;

 const sal_uInt16 EXC_SXVD_AXIS_COL          = 0x0002;

 const sal_uInt16 EXC_SXVD_AXIS_PAGE         = 0x0004;

 const sal_uInt16 EXC_SXVD_AXIS_DATA         = 0x0008;

 const sal_uInt16 EXC_SXVD_AXIS_ROWCOL       = EXC_SXVD_AXIS_ROW | EXC_SXVD_AXIS_COL;

 const sal_uInt16 EXC_SXVD_AXIS_ROWCOLPAGE   = EXC_SXVD_AXIS_ROWCOL | EXC_SXVD_AXIS_PAGE;


 const sal_uInt16 EXC_SXVD_SUBT_NONE         = 0x0000;

 const sal_uInt16 EXC_SXVD_SUBT_DEFAULT      = 0x0001;

 const sal_uInt16 EXC_SXVD_SUBT_SUM          = 0x0002;

 const sal_uInt16 EXC_SXVD_SUBT_COUNT        = 0x0004;

 const sal_uInt16 EXC_SXVD_SUBT_AVERAGE      = 0x0008;

 const sal_uInt16 EXC_SXVD_SUBT_MAX          = 0x0010;

 const sal_uInt16 EXC_SXVD_SUBT_MIN          = 0x0020;

 const sal_uInt16 EXC_SXVD_SUBT_PROD         = 0x0040;

 const sal_uInt16 EXC_SXVD_SUBT_COUNTNUM     = 0x0080;

 const sal_uInt16 EXC_SXVD_SUBT_STDDEV       = 0x0100;

 const sal_uInt16 EXC_SXVD_SUBT_STDDEVP      = 0x0200;

 const sal_uInt16 EXC_SXVD_SUBT_VAR          = 0x0400;

 const sal_uInt16 EXC_SXVD_SUBT_VARP         = 0x0800;


 const sal_uInt16 EXC_SXVD_DEFAULT_CACHE     = EXC_PC_NOFIELD;


 // (0x00B2) SXVI --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXVI                = 0x00B2;


 const sal_uInt16 EXC_SXVI_TYPE_PAGE         = 0x00FE;

 const sal_uInt16 EXC_SXVI_TYPE_NULL         = 0x00FF;

 const sal_uInt16 EXC_SXVI_TYPE_DATA         = 0x0000;

 const sal_uInt16 EXC_SXVI_TYPE_DEFAULT      = 0x0001;

 const sal_uInt16 EXC_SXVI_TYPE_SUM          = 0x0002;

 const sal_uInt16 EXC_SXVI_TYPE_COUNT        = 0x0003;

 const sal_uInt16 EXC_SXVI_TYPE_AVERAGE      = 0x0004;

 const sal_uInt16 EXC_SXVI_TYPE_MAX          = 0x0005;

 const sal_uInt16 EXC_SXVI_TYPE_MIN          = 0x0006;

 const sal_uInt16 EXC_SXVI_TYPE_PROD         = 0x0007;

 const sal_uInt16 EXC_SXVI_TYPE_COUNTNUM     = 0x0008;

 const sal_uInt16 EXC_SXVI_TYPE_STDDEV       = 0x0009;

 const sal_uInt16 EXC_SXVI_TYPE_STDDEVP      = 0x000A;

 const sal_uInt16 EXC_SXVI_TYPE_VAR          = 0x000B;

 const sal_uInt16 EXC_SXVI_TYPE_VARP         = 0x000C;

 const sal_uInt16 EXC_SXVI_TYPE_GRAND        = 0x000D;


 const sal_uInt16 EXC_SXVI_DEFAULTFLAGS      = 0x0000;

 const sal_uInt16 EXC_SXVI_HIDDEN            = 0x0001;

 const sal_uInt16 EXC_SXVI_HIDEDETAIL        = 0x0002;

 const sal_uInt16 EXC_SXVI_FORMULA           = 0x0004;

 const sal_uInt16 EXC_SXVI_MISSING           = 0x0008;


 const sal_uInt16 EXC_SXVI_DEFAULT_CACHE     = EXC_PC_NOFIELD;


 // (0x00B4) SXIVD -------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXIVD               = 0x00B4;

 const sal_uInt16 EXC_SXIVD_DATA             = 0xFFFE;


 // (0x00B5) SXLI --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXLI                = 0x00B5;

 const sal_uInt16 EXC_SXLI_DEFAULTFLAGS      = 0x0000;


 // (0x00B6) SXPI --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXPI                = 0x00B6;

 const sal_uInt16 EXC_SXPI_ALLITEMS          = 0x7FFD;


 // (0x00C5) SXDI --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXDI                = 0x00C5;


 const sal_uInt16 EXC_SXDI_FUNC_SUM          = 0x0000;

 const sal_uInt16 EXC_SXDI_FUNC_COUNT        = 0x0001;

 const sal_uInt16 EXC_SXDI_FUNC_AVERAGE      = 0x0002;

 const sal_uInt16 EXC_SXDI_FUNC_MAX          = 0x0003;

 const sal_uInt16 EXC_SXDI_FUNC_MIN          = 0x0004;

 const sal_uInt16 EXC_SXDI_FUNC_PRODUCT      = 0x0005;

 const sal_uInt16 EXC_SXDI_FUNC_COUNTNUM     = 0x0006;

 const sal_uInt16 EXC_SXDI_FUNC_STDDEV       = 0x0007;

 const sal_uInt16 EXC_SXDI_FUNC_STDDEVP      = 0x0008;

 const sal_uInt16 EXC_SXDI_FUNC_VAR          = 0x0009;

 const sal_uInt16 EXC_SXDI_FUNC_VARP         = 0x000A;


 const sal_uInt16 EXC_SXDI_REF_NORMAL        = 0x0000;

 const sal_uInt16 EXC_SXDI_REF_DIFF          = 0x0001;

 const sal_uInt16 EXC_SXDI_REF_PERC          = 0x0002;

 const sal_uInt16 EXC_SXDI_REF_PERC_DIFF     = 0x0003;

 const sal_uInt16 EXC_SXDI_REF_RUN_TOTAL     = 0x0004;

 const sal_uInt16 EXC_SXDI_REF_PERC_ROW      = 0x0005;

 const sal_uInt16 EXC_SXDI_REF_PERC_COL      = 0x0006;

 const sal_uInt16 EXC_SXDI_REF_PERC_TOTAL    = 0x0007;

 const sal_uInt16 EXC_SXDI_REF_INDEX         = 0x0008;


 const sal_uInt16 EXC_SXDI_PREVITEM          = 0x7FFB;

 const sal_uInt16 EXC_SXDI_NEXTITEM          = 0x7FFC;


 // (0x00C6) SXDB --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXDB                = 0x00C6;


 const sal_uInt16 EXC_SXDB_SAVEDATA          = 0x0001;

 const sal_uInt16 EXC_SXDB_INVALID           = 0x0002;

 const sal_uInt16 EXC_SXDB_REFRESH_LOAD      = 0x0004;

 const sal_uInt16 EXC_SXDB_OPT_CACHE         = 0x0008;

 const sal_uInt16 EXC_SXDB_BG_QUERY          = 0x0010;

 const sal_uInt16 EXC_SXDB_ENABLE_REFRESH    = 0x0020;

 const sal_uInt16 EXC_SXDB_DEFAULTFLAGS      = EXC_SXDB_SAVEDATA | EXC_SXDB_ENABLE_REFRESH;


 const sal_uInt16 EXC_SXDB_BLOCKRECS         = 0x1FFF;


 const sal_uInt16 EXC_SXDB_SRC_SHEET         = 0x0001;

 const sal_uInt16 EXC_SXDB_SRC_EXTERN        = 0x0002;

 const sal_uInt16 EXC_SXDB_SRC_CONSOLID      = 0x0004;

 const sal_uInt16 EXC_SXDB_SRC_SCENARIO      = 0x0008;


 // (0x00C7) SXFIELD -----------------------------------------------------------

 const sal_uInt16 EXC_ID_SXFIELD             = 0x00C7;


 const sal_uInt16 EXC_SXFIELD_HASITEMS       = 0x0001;

 const sal_uInt16 EXC_SXFIELD_POSTPONE       = 0x0002;

 const sal_uInt16 EXC_SXFIELD_CALCED         = 0x0004;

 const sal_uInt16 EXC_SXFIELD_HASCHILD       = 0x0008;

 const sal_uInt16 EXC_SXFIELD_NUMGROUP       = 0x0010;

 const sal_uInt16 EXC_SXFIELD_16BIT          = 0x0200;


 const sal_uInt16 EXC_SXFIELD_DATA_MASK      = 0x0DE0;

 // known data types

 const sal_uInt16 EXC_SXFIELD_DATA_NONE      = 0x0000;

 const sal_uInt16 EXC_SXFIELD_DATA_STR       = 0x0480;

 const sal_uInt16 EXC_SXFIELD_DATA_INT       = 0x0520;

 const sal_uInt16 EXC_SXFIELD_DATA_DBL       = 0x0560;

 const sal_uInt16 EXC_SXFIELD_DATA_STR_INT   = 0x05A0;

 const sal_uInt16 EXC_SXFIELD_DATA_STR_DBL   = 0x05E0;

 const sal_uInt16 EXC_SXFIELD_DATA_DATE      = 0x0900;

 const sal_uInt16 EXC_SXFIELD_DATA_DATE_EMP  = 0x0980;

 const sal_uInt16 EXC_SXFIELD_DATA_DATE_NUM  = 0x0D00;

 const sal_uInt16 EXC_SXFIELD_DATA_DATE_STR  = 0x0D80;


 const sal_uInt16 EXC_SXFIELD_INDEX_MIN      = 0;

 const sal_uInt16 EXC_SXFIELD_INDEX_MAX      = 1;

 const sal_uInt16 EXC_SXFIELD_INDEX_STEP     = 2;


 // (0x00C8) SXINDEXLIST -------------------------------------------------------

 const sal_uInt16 EXC_ID_SXINDEXLIST         = 0x00C8;


 // (0x00C9) SXDOUBLE ----------------------------------------------------------

 const sal_uInt16 EXC_ID_SXDOUBLE            = 0x00C9;


 // (0x00CA) SXBOOLEAN ---------------------------------------------------------

 const sal_uInt16 EXC_ID_SXBOOLEAN           = 0x00CA;


 // (0x00CB) SXERROR -----------------------------------------------------------

 const sal_uInt16 EXC_ID_SXERROR             = 0x00CB;


 // (0x00CC) SXINTEGER ---------------------------------------------------------

 const sal_uInt16 EXC_ID_SXINTEGER           = 0x00CC;


 // (0x00CD) SXSTRING ----------------------------------------------------------

 const sal_uInt16 EXC_ID_SXSTRING            = 0x00CD;


 // (0x00CE) SXDATETIME --------------------------------------------------------

 const sal_uInt16 EXC_ID_SXDATETIME          = 0x00CE;


 // (0x00CF) SXEMPTY -----------------------------------------------------------

 const sal_uInt16 EXC_ID_SXEMPTY             = 0x00CF;


 // (0x00D5) SXIDSTM -----------------------------------------------------------

 const sal_uInt16 EXC_ID_SXIDSTM             = 0x00D5;


 // (0x00D8) SXNUMGROUP --------------------------------------------------------

 const sal_uInt16 EXC_ID_SXNUMGROUP          = 0x00D8;


 const sal_uInt16 EXC_SXNUMGROUP_AUTOMIN     = 0x0001;

 const sal_uInt16 EXC_SXNUMGROUP_AUTOMAX     = 0x0002;


 const sal_uInt16 EXC_SXNUMGROUP_TYPE_SEC    = 1;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_MIN    = 2;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_HOUR   = 3;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_DAY    = 4;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_MONTH  = 5;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_QUART  = 6;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_YEAR   = 7;

 const sal_uInt16 EXC_SXNUMGROUP_TYPE_NUM    = 8;


 // (0x00D9) SXGROUPINFO -------------------------------------------------------

 const sal_uInt16 EXC_ID_SXGROUPINFO         = 0x00D9;


 // (0x00DC) SXEXT -------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXEXT               = 0x00DC;


 // (0x00E3) SXVS --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXVS                = 0x00E3;


 const sal_uInt16 EXC_SXVS_UNKNOWN           = 0x0000;

 const sal_uInt16 EXC_SXVS_SHEET             = 0x0001;

 const sal_uInt16 EXC_SXVS_EXTERN            = 0x0002;

 const sal_uInt16 EXC_SXVS_CONSOLID          = 0x0004;

 const sal_uInt16 EXC_SXVS_PIVOTTAB          = 0x0008;

 const sal_uInt16 EXC_SXVS_SCENARIO          = 0x0010;


 // (0x00F0) SXRULE ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXRULE              = 0x00F0;


 // (0x00F1) SXEX --------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXEX                = 0x00F1;


 const sal_uInt32 EXC_SXEX_DRILLDOWN         = 0x00020000;

 const sal_uInt32 EXC_SXEX_DEFAULTFLAGS      = 0x004F0200;


 // (0x00F2) SXFILT ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXFILT              = 0x00F2;


 // (0x00F5) -------------------------------------------------------------------

 const sal_uInt16 EXC_ID_00F5                = 0x00F5;


 // (0x00F6) SXNAME ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXNAME              = 0x00F6;


 // (0x00F8) SXPAIR ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXPAIR              = 0x00F8;


 // (0x00F9) SXFMLA ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXFMLA              = 0x00F9;


 // (0x0100) SXVDEX ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXVDEX              = 0x0100;


 const sal_uInt32 EXC_SXVDEX_SHOWALL         = 0x00000001;

 const sal_uInt32 EXC_SXVDEX_SORT            = 0x00000200;

 const sal_uInt32 EXC_SXVDEX_SORT_ASC        = 0x00000400;

 const sal_uInt32 EXC_SXVDEX_AUTOSHOW        = 0x00000800;

 const sal_uInt32 EXC_SXVDEX_AUTOSHOW_ASC    = 0x00001000;

 const sal_uInt32 EXC_SXVDEX_LAYOUT_REPORT   = 0x00200000;

 const sal_uInt32 EXC_SXVDEX_LAYOUT_BLANK    = 0x00400000;

 const sal_uInt32 EXC_SXVDEX_LAYOUT_TOP      = 0x00800000;

 const sal_uInt32 EXC_SXVDEX_DEFAULTFLAGS    = 0x0A00001E | EXC_SXVDEX_SORT_ASC | EXC_SXVDEX_AUTOSHOW_ASC;


 const sal_uInt16 EXC_SXVDEX_SORT_OWN        = 0xFFFF;

 const sal_uInt16 EXC_SXVDEX_SHOW_NONE       = 0xFFFF;

 const sal_uInt16 EXC_SXVDEX_FORMAT_NONE     = 0x0000;


 // (0x0103) SXFORMULA ---------------------------------------------------------

 const sal_uInt16 EXC_ID_SXFORMULA           = 0x0103;


 // (0x0122) SXDBEX ------------------------------------------------------------

 const sal_uInt16 EXC_ID_SXDBEX              = 0x0122;

 const double EXC_SXDBEX_CREATION_DATE       = 51901.029652778;


 // (0x01BB) SXFDBTYPE ---------------------------------------------------------

 const sal_uInt16 EXC_ID_SXFDBTYPE           = 0x01BB;

 const sal_uInt16 EXC_SXFDBTYPE_DEFAULT      = 0x0000;


 // (0x0810) SXVIEWEX9 ---------------------------------------------------------

 const sal_uInt16 EXC_ID_SXVIEWEX9       = 0x0810;


 // (0x0864) SXADDL ("Pivot Table Additional Info") ----------------------------

 const sal_uInt16 EXC_ID_SXADDL       = 0x0864;


 // Pivot cache


 class XclPCItem

 {

 public:

     explicit            XclPCItem();

     virtual             ~XclPCItem();


     XclPCItem(XclPCItem const &) = default;

     XclPCItem(XclPCItem &&) = default;

     XclPCItem & operator =(XclPCItem const &) = default;

     XclPCItem & operator =(XclPCItem &&) = default;


     void                SetEmpty();

     void                SetText( const OUString& rText );

     void                SetDouble( double fValue, const OUString& rText = OUString() );

     void                SetDateTime( const DateTime& rDateTime, const OUString& rText = OUString() );

     void                SetInteger( sal_Int16 nValue );

     void                SetError( sal_uInt16 nError );

     void                SetBool( bool bValue, const OUString& rText = OUString() );


     const OUString& ConvertToText() const { return maText; }


     bool                IsEqual( const XclPCItem& rItem ) const;


     bool                IsEmpty() const;

     const OUString* GetText() const;

     const double*       GetDouble() const;

     const DateTime*     GetDateTime() const;

     const sal_Int16*    GetInteger() const;

     const sal_uInt16*   GetError() const;

     const bool*         GetBool() const;


     XclPCItemType GetType() const;


 private:

     XclPCItemType       meType;

     OUString       maText;

     DateTime            maDateTime;

     union

     {

         double              mfValue;

         sal_Int16           mnValue;

         sal_uInt16          mnError;

         bool                mbValue;

     };

 };


 inline bool operator==( const XclPCItem& rLeft, const XclPCItem& rRight ) { return rLeft.IsEqual( rRight ); }

 inline bool operator!=( const XclPCItem& rLeft, const XclPCItem& rRight ) { return !(rLeft == rRight); }


 // Field settings =============================================================


 struct XclPCFieldInfo

 {

     OUString       maName;

     sal_uInt16          mnFlags;

     sal_uInt16          mnGroupChild;

     sal_uInt16          mnGroupBase;

     sal_uInt16          mnVisItems;

     sal_uInt16          mnGroupItems;

     sal_uInt16          mnBaseItems;

     sal_uInt16          mnOrigItems;


     explicit            XclPCFieldInfo();

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPCFieldInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPCFieldInfo& rInfo );


 // Numeric grouping field settings ============================================


 struct XclPCNumGroupInfo

 {

     sal_uInt16          mnFlags;


     explicit            XclPCNumGroupInfo();


     void                SetNumType();


     sal_Int32           GetScDateType() const;

     void                SetScDateType( sal_Int32 nScType );


     sal_uInt16          GetXclDataType() const;

     void                SetXclDataType( sal_uInt16 nXclType );

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPCNumGroupInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPCNumGroupInfo& rInfo );


 // Base class for pivot cache fields ==========================================


 class XclPCField

 {

 public:

     explicit            XclPCField( XclPCFieldType eFieldType, sal_uInt16 nFieldIdx );

     virtual             ~XclPCField();


     sal_uInt16   GetFieldIndex() const { return mnFieldIdx; }


     bool                IsSupportedField() const;


     bool                IsStandardField() const;


     bool                IsStdGroupField() const;

     bool                IsNumGroupField() const;

     bool                IsDateGroupField() const;

     bool                IsGroupField() const;


     bool                IsGroupBaseField() const;

     bool                IsGroupChildField() const;


     bool                HasOrigItems() const;

     bool                HasInlineItems() const;

     bool                HasPostponedItems() const;

     bool                Has16BitIndexes() const;


 protected:

     XclPCFieldInfo      maFieldInfo;

     XclPCFieldType      meFieldType;

     sal_uInt16          mnFieldIdx;

     ScfUInt16Vec        maGroupOrder;

     XclPCNumGroupInfo   maNumGroupInfo;

 };


 // Pivot cache settings =======================================================


 struct XclPCInfo

 {

     sal_uInt32          mnSrcRecs;

     sal_uInt16          mnStrmId;

     sal_uInt16          mnFlags;

     sal_uInt16          mnBlockRecs;

     sal_uInt16          mnStdFields;

     sal_uInt16          mnTotalFields;

     sal_uInt16          mnSrcType;

     OUString       maUserName;


     explicit            XclPCInfo();

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPCInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPCInfo& rInfo );


 // Pivot table


 // cached name ================================================================


 struct XclPTCachedName

 {

     OUString       maName;

     bool                mbUseCache;


     explicit     XclPTCachedName() : mbUseCache( true ) {}

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTCachedName& rCachedName );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTCachedName& rCachedName );


 struct XclPTVisNameInfo

 {

     XclPTCachedName     maVisName;


     bool         HasVisName() const { return !maVisName.mbUseCache; }

     const OUString* GetVisName() const;

     void                SetVisName( const OUString& rName );

 };


 // Field item settings ========================================================


 struct XclPTItemInfo : public XclPTVisNameInfo

 {

     sal_uInt16          mnType;

     sal_uInt16          mnFlags;

     sal_uInt16          mnCacheIdx;


     explicit            XclPTItemInfo();

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTItemInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTItemInfo& rInfo );


 // General field settings =====================================================


 typedef ::std::vector< ScGeneralFunction > XclPTSubtotalVec;


 struct XclPTFieldInfo : public XclPTVisNameInfo

 {

     sal_uInt16          mnAxes;

     sal_uInt16          mnSubtCount;

     sal_uInt16          mnSubtotals;

     sal_uInt16          mnItemCount;

     sal_uInt16          mnCacheIdx;


     explicit            XclPTFieldInfo();


     css::sheet::DataPilotFieldOrientation GetApiOrient( sal_uInt16 nMask ) const;

     void                AddApiOrient( css::sheet::DataPilotFieldOrientation eOrient );


     void                GetSubtotals( XclPTSubtotalVec& rSubtotals ) const;

     void                SetSubtotals( const XclPTSubtotalVec& rSubtotals );

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTFieldInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTFieldInfo& rInfo );


 // Extended field settings ====================================================


 struct XclPTFieldExtInfo

 {

     sal_uInt32          mnFlags;

     sal_uInt16          mnSortField;

     sal_uInt16          mnShowField;

     sal_uInt16          mnNumFmt;

     std::optional<OUString> mpFieldTotalName;


     explicit            XclPTFieldExtInfo();


     sal_Int32           GetApiSortMode() const;

     void                SetApiSortMode( sal_Int32 nSortMode );


     sal_Int32           GetApiAutoShowMode() const;

     void                SetApiAutoShowMode( sal_Int32 nShowMode );


     sal_Int32           GetApiAutoShowCount() const;

     void                SetApiAutoShowCount( sal_Int32 nShowCount );


     sal_Int32           GetApiLayoutMode() const;

     void                SetApiLayoutMode( sal_Int32 nLayoutMode );

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTFieldExtInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTFieldExtInfo& rInfo );


 // Page field settings ========================================================


 struct XclPTPageFieldInfo

 {

     sal_uInt16          mnField;

     sal_uInt16          mnSelItem;

     sal_uInt16          mnObjId;


     explicit            XclPTPageFieldInfo();

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTPageFieldInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTPageFieldInfo& rInfo );


 // Data field settings ========================================================


 struct XclPTDataFieldInfo : public XclPTVisNameInfo

 {

     sal_uInt16          mnField;

     sal_uInt16          mnAggFunc;

     sal_uInt16          mnRefType;

     sal_uInt16          mnRefField;

     sal_uInt16          mnRefItem;

     sal_uInt16          mnNumFmt;


     explicit            XclPTDataFieldInfo();


     ScGeneralFunction GetApiAggFunc() const;

     void                SetApiAggFunc( ScGeneralFunction eAggFunc );


     sal_Int32           GetApiRefType() const;

     void                SetApiRefType( sal_Int32 nRefType );


     sal_Int32           GetApiRefItemType() const;

     void                SetApiRefItemType( sal_Int32 nRefItemType );

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTDataFieldInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTDataFieldInfo& rInfo );


 // Pivot table settings =======================================================


 struct XclPTInfo

 {

     OUString       maTableName;

     OUString       maDataName;

     XclRange            maOutXclRange;

     XclAddress          maDataXclPos;

     sal_uInt16          mnFirstHeadRow;

     sal_uInt16          mnCacheIdx;

     sal_uInt16          mnDataAxis;

     sal_uInt16          mnDataPos;

     sal_uInt16          mnFields;

     sal_uInt16          mnRowFields;

     sal_uInt16          mnColFields;

     sal_uInt16          mnPageFields;

     sal_uInt16          mnDataFields;

     sal_uInt16          mnDataRows;

     sal_uInt16          mnDataCols;

     sal_uInt16          mnFlags;

     sal_uInt16          mnAutoFmtIdx;


     explicit            XclPTInfo();

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTInfo& rInfo );


 // Extended pivot table settings ==============================================


 struct XclPTExtInfo

 {

     sal_uInt16          mnSxformulaRecs;

     sal_uInt16          mnSxselectRecs;

     sal_uInt16          mnPagePerRow;

     sal_uInt16          mnPagePerCol;

     sal_uInt32          mnFlags;


     explicit            XclPTExtInfo();

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTExtInfo& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTExtInfo& rInfo );


 // Pivot table autoformat settings ==============================================


 struct XclPTViewEx9Info

 {

     sal_uInt32          mbReport;

     sal_uInt8           mnAutoFormat;

     sal_uInt8           mnGridLayout;

     OUString       maGrandTotalName;


     explicit            XclPTViewEx9Info();

     void                Init( const ScDPObject& rDPObj );

 };


 XclImpStream& operator>>( XclImpStream& rStrm, XclPTViewEx9Info& rInfo );

 XclExpStream& operator<<( XclExpStream& rStrm, const XclPTViewEx9Info& rInfo );


 struct XclPTAddl

 {

     bool          mbCompactMode;

     explicit      XclPTAddl();

 };


 XclImpStream& operator>>(XclImpStream& rStrm, XclPTAddl& rInfo);


 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

EXC_PC_NOFIELD
const sal_uInt16 EXC_PC_NOFIELD
Definition: xlpivot.hxx:46

XclPTFieldExtInfo::mnFlags
sal_uInt32 mnFlags
Definition: xlpivot.hxx:622

EXC_SXDI_REF_RUN_TOTAL
const sal_uInt16 EXC_SXDI_REF_RUN_TOTAL
Definition: xlpivot.hxx:193

XclPCItem::meType
XclPCItemType meType
Definition: xlpivot.hxx:417

XclPTDataFieldInfo::mnRefItem
sal_uInt16 mnRefItem
Index to SXVD of referred field used for the results.
Definition: xlpivot.hxx:678

XclPTFieldExtInfo::SetApiLayoutMode
void SetApiLayoutMode(sal_Int32 nLayoutMode)
Sets the layout mode represented by the passed API constant.
Definition: xlpivot.cxx:625

EXC_SXVDEX_SORT
const sal_uInt32 EXC_SXVDEX_SORT
Definition: xlpivot.hxx:333

XclPCField::IsStdGroupField
bool IsStdGroupField() const
Returns true, if this field is a grouping field.
Definition: xlpivot.cxx:303

XclPTInfo::XclPTInfo
XclPTInfo()
Index to pivot table autoformat.
Definition: xlpivot.cxx:834

EXC_SXVDEX_FORMAT_NONE
const sal_uInt16 EXC_SXVDEX_FORMAT_NONE
Definition: xlpivot.hxx:344

EXC_ID_SXPI
const sal_uInt16 EXC_ID_SXPI
Definition: xlpivot.hxx:171

EXC_SXFIELD_16BIT
const sal_uInt16 EXC_SXFIELD_16BIT
Definition: xlpivot.hxx:228

XclPTDataFieldInfo::mnRefType
sal_uInt16 mnRefType
Data aggregation function.
Definition: xlpivot.hxx:676

XclPTItemInfo::mnFlags
sal_uInt16 mnFlags
Type of the item (e.g. data, function, grand total).
Definition: xlpivot.hxx:577

EXC_SXVDEX_LAYOUT_BLANK
const sal_uInt32 EXC_SXVDEX_LAYOUT_BLANK
Definition: xlpivot.hxx:338

XclPTCachedName
A name for various pivot table info structs.
Definition: xlpivot.hxx:547

XclPCNumGroupInfo::SetNumType
void SetNumType()
Definition: xlpivot.cxx:220

EXC_SXDI_FUNC_STDDEVP
const sal_uInt16 EXC_SXDI_FUNC_STDDEVP
Definition: xlpivot.hxx:185

EXC_PC_MAXFIELDCOUNT
const size_t EXC_PC_MAXFIELDCOUNT
Definition: xlpivot.hxx:45

XclPTFieldInfo::XclPTFieldInfo
XclPTFieldInfo()
Index into cache for field name (not part of record).
Definition: xlpivot.cxx:460

XclPCField::IsGroupField
bool IsGroupField() const
Returns true, if this field is a grouping field of any type.
Definition: xlpivot.cxx:318

DateTime

EXC_SXFIELD_DATA_DBL
const sal_uInt16 EXC_SXFIELD_DATA_DBL
Only integers, opt. with doubles.
Definition: xlpivot.hxx:235

EXC_ID_00F5
const sal_uInt16 EXC_ID_00F5
Definition: xlpivot.hxx:318

XclPCInfo::XclPCInfo
XclPCInfo()
Name of user who last modified the cache.
Definition: xlpivot.cxx:356

XclPTDataFieldInfo::SetApiAggFunc
void SetApiAggFunc(ScGeneralFunction eAggFunc)
Sets the aggregation function represented by the passed API enum.
Definition: xlpivot.cxx:731

XclPCItem::GetDouble
const double * GetDouble() const
Returns pointer to value, if the item type is 'double', otherwise 0.
Definition: xlpivot.cxx:140

EXC_SXFIELD_DATA_NONE
const sal_uInt16 EXC_SXFIELD_DATA_NONE
Definition: xlpivot.hxx:232

XclPTVisNameInfo::GetVisName
const OUString * GetVisName() const
Returns the name, if set explicitly (maVisName.mbUseCache is false).
Definition: xlpivot.cxx:420

XclPTViewEx9Info
Pivot table autoformat settings (SXVIEWEX9 record).
Definition: xlpivot.hxx:751

EXC_ID_SXIVD
const sal_uInt16 EXC_ID_SXIVD
Definition: xlpivot.hxx:163

EXC_PT_AUTOFMT_ZERO
const sal_uInt16 EXC_PT_AUTOFMT_ZERO
Definition: xlpivot.hxx:63

XclPCNumGroupInfo::SetScDateType
void SetScDateType(sal_Int32 nScType)
Definition: xlpivot.cxx:242

EXC_SXVS_EXTERN
const sal_uInt16 EXC_SXVS_EXTERN
Definition: xlpivot.hxx:300

EXC_SXNUMGROUP_TYPE_QUART
const sal_uInt16 EXC_SXNUMGROUP_TYPE_QUART
Definition: xlpivot.hxx:285

EXC_SXDI_FUNC_STDDEV
const sal_uInt16 EXC_SXDI_FUNC_STDDEV
Definition: xlpivot.hxx:184

EXC_SXVIEW_DEFAULTFLAGS
const sal_uInt16 EXC_SXVIEW_DEFAULTFLAGS
Definition: xlpivot.hxx:102

XclPTFieldExtInfo::mpFieldTotalName
std::optional< OUString > mpFieldTotalName
Definition: xlpivot.hxx:626

EXC_SXDB_SRC_EXTERN
const sal_uInt16 EXC_SXDB_SRC_EXTERN
Definition: xlpivot.hxx:216

EXC_SXNUMGROUP_TYPE_MIN
const sal_uInt16 EXC_SXNUMGROUP_TYPE_MIN
Definition: xlpivot.hxx:281

XclExpStream
This class is used to export Excel record streams.
Definition: xestream.hxx:72

XclPCInfo::mnSrcType
sal_uInt16 mnSrcType
Number of all fields (standard, grouped, calculated).
Definition: xlpivot.hxx:533

EXC_SXVDEX_AUTOSHOW
const sal_uInt32 EXC_SXVDEX_AUTOSHOW
Definition: xlpivot.hxx:335

XclPTViewEx9Info::XclPTViewEx9Info
XclPTViewEx9Info()
classic : 10 08 00 00 00 00 00 00 20 00 00 00 01 00 00 00 00 default : 10 08 00 00 00 00 00 00 20 00 ...
Definition: xlpivot.cxx:969

XclPCFieldType
XclPCFieldType
Specifies the type of a pivot cache field.
Definition: xlpivot.hxx:80

XclPCItem::SetError
void SetError(sal_uInt16 nError)
Sets the item to 'error' type and adds the passed Excel error code.
Definition: xlpivot.cxx:88

XclPTCachedName::mbUseCache
bool mbUseCache
The visible name, if used.
Definition: xlpivot.hxx:550

EXC_ID_SXVS
const sal_uInt16 EXC_ID_SXVS
Definition: xlpivot.hxx:296

EXC_SXDB_BG_QUERY
const sal_uInt16 EXC_SXDB_BG_QUERY
Definition: xlpivot.hxx:209

XclPTDataFieldInfo::mnAggFunc
sal_uInt16 mnAggFunc
Base field for this data info.
Definition: xlpivot.hxx:675

XclPTFieldInfo::mnCacheIdx
sal_uInt16 mnCacheIdx
Number of items of this field.
Definition: xlpivot.hxx:597

XclPTDataFieldInfo::mnRefField
sal_uInt16 mnRefField
Result reference type.
Definition: xlpivot.hxx:677

EXC_SXPI_ALLITEMS
const sal_uInt16 EXC_SXPI_ALLITEMS
Definition: xlpivot.hxx:172

XclPTExtInfo
Extended information about a pivot table (SXEX record).
Definition: xlpivot.hxx:734

EXC_SXDI_PREVITEM
const sal_uInt16 EXC_SXDI_PREVITEM
Definition: xlpivot.hxx:199

EXC_SXVI_HIDDEN
const sal_uInt16 EXC_SXVI_HIDDEN
Definition: xlpivot.hxx:155

EXC_SXVI_TYPE_STDDEVP
const sal_uInt16 EXC_SXVI_TYPE_STDDEVP
Definition: xlpivot.hxx:149

XclPTFieldExtInfo::GetApiLayoutMode
sal_Int32 GetApiLayoutMode() const
Returns the API constant representing the layout mode.
Definition: xlpivot.cxx:616

EXC_SXNUMGROUP_TYPE_YEAR
const sal_uInt16 EXC_SXNUMGROUP_TYPE_YEAR
Definition: xlpivot.hxx:286

XclPCItem::SetDateTime
void SetDateTime(const DateTime &rDateTime, const OUString &rText=OUString())
Sets the item to 'date/time' type and adds the passed date.
Definition: xlpivot.cxx:74

XclPCFieldInfo
Contains data for a pivot cache field (SXFIELD record).
Definition: xlpivot.hxx:435

XclPTViewEx9Info::mnAutoFormat
sal_uInt8 mnAutoFormat
2 for report* fmts ?
Definition: xlpivot.hxx:754

EXC_SXVDEX_LAYOUT_TOP
const sal_uInt32 EXC_SXVDEX_LAYOUT_TOP
Definition: xlpivot.hxx:339

XclPTAddl::XclPTAddl
XclPTAddl()
Definition: xlpivot.cxx:1025

XclPCItem::GetBool
const bool * GetBool() const
Returns pointer to Boolean value, if the item type is 'boolean', otherwise 0.
Definition: xlpivot.cxx:160

operator==
bool operator==(const XclPCItem &rLeft, const XclPCItem &rRight)
Definition: xlpivot.hxx:429

XclPCItem::mnValue
sal_Int16 mnValue
Value of a floating-point item.
Definition: xlpivot.hxx:423

EXC_SXVI_DEFAULTFLAGS
const sal_uInt16 EXC_SXVI_DEFAULTFLAGS
Definition: xlpivot.hxx:154

XclPTInfo::mnColFields
sal_uInt16 mnColFields
Number of row fields.
Definition: xlpivot.hxx:717

XclPCItem::XclPCItem
XclPCItem()
Definition: xlpivot.cxx:45

XclPTDataFieldInfo::SetApiRefItemType
void SetApiRefItemType(sal_Int32 nRefItemType)
Sets the result reference item type represented by the passed API constant.
Definition: xlpivot.cxx:798

XclPCItem::operator=
XclPCItem & operator=(XclPCItem const &)=default

EXC_SXVD_AXIS_ROWCOLPAGE
const sal_uInt16 EXC_SXVD_AXIS_ROWCOLPAGE
Definition: xlpivot.hxx:116

EXC_SXFIELD_DATA_DATE
const sal_uInt16 EXC_SXFIELD_DATA_DATE
Only strings and doubles, nothing else.
Definition: xlpivot.hxx:238

XclPCField::mnFieldIdx
sal_uInt16 mnFieldIdx
Type of this pivot cache field.
Definition: xlpivot.hxx:517

EXC_ID_SXRULE
const sal_uInt16 EXC_ID_SXRULE
Definition: xlpivot.hxx:306

operator>>
XclImpStream & operator>>(XclImpStream &rStrm, XclPCFieldInfo &rInfo)
Definition: xlpivot.cxx:183

XclPTItemInfo::mnCacheIdx
sal_uInt16 mnCacheIdx
Several flags.
Definition: xlpivot.hxx:578

EXC_SXFIELD_DATA_DATE_EMP
const sal_uInt16 EXC_SXFIELD_DATA_DATE_EMP
Only dates, nothing else.
Definition: xlpivot.hxx:239

XclPCItem::~XclPCItem
virtual ~XclPCItem()
Definition: xlpivot.cxx:51

XclPCFieldInfo::mnGroupItems
sal_uInt16 mnGroupItems
Number of visible items for this field.
Definition: xlpivot.hxx:442

EXC_PCFIELD_DATEGROUP
Numeric grouping field.
Definition: xlpivot.hxx:85

XclPCItem::SetText
void SetText(const OUString &rText)
Sets the item to 'text' type and adds the passed text.
Definition: xlpivot.cxx:61

XclPTFieldInfo::GetSubtotals
void GetSubtotals(XclPTSubtotalVec &rSubtotals) const
Returns a vector of all set subtotal functions.
Definition: xlpivot.cxx:499

EXC_SXVD_AXIS_COL
const sal_uInt16 EXC_SXVD_AXIS_COL
Definition: xlpivot.hxx:112

XclPCItem::maDateTime
DateTime maDateTime
Text representation of the item.
Definition: xlpivot.hxx:419

XclPTInfo::maDataXclPos
XclAddress maDataXclPos
Output range.
Definition: xlpivot.hxx:710

EXC_PT_NOSTRING
const sal_uInt16 EXC_PT_NOSTRING
Definition: xlpivot.hxx:41

EXC_PCFIELD_STDGROUP
Standard field without grouping.
Definition: xlpivot.hxx:83

XclPTFieldInfo::SetSubtotals
void SetSubtotals(const XclPTSubtotalVec &rSubtotals)
Sets the subtotal functions contained in the passed sequence.
Definition: xlpivot.cxx:518

EXC_SXVDEX_SHOW_NONE
const sal_uInt16 EXC_SXVDEX_SHOW_NONE
Definition: xlpivot.hxx:343

EXC_ID_SXINDEXLIST
const sal_uInt16 EXC_ID_SXINDEXLIST
List index for step item in groupings.
Definition: xlpivot.hxx:248

XclPCFieldInfo::mnGroupChild
sal_uInt16 mnGroupChild
Various flags.
Definition: xlpivot.hxx:439

EXC_SXDI_REF_PERC_TOTAL
const sal_uInt16 EXC_SXDI_REF_PERC_TOTAL
Definition: xlpivot.hxx:196

EXC_SXDI_REF_PERC_DIFF
const sal_uInt16 EXC_SXDI_REF_PERC_DIFF
Definition: xlpivot.hxx:192

XclPCField
Represents a field in a pivot cache.
Definition: xlpivot.hxx:476

EXC_ID_DCONNAME
const sal_uInt16 EXC_ID_DCONNAME
Definition: xlpivot.hxx:94

XclPCItem::SetBool
void SetBool(bool bValue, const OUString &rText=OUString())
Sets the item to 'boolean' type and adds the passed Boolean value.
Definition: xlpivot.cxx:106

EXC_PCITEM_INVALID
Definition: xlpivot.hxx:69

XclPTViewEx9Info::Init
void Init(const ScDPObject &rDPObj)
Definition: xlpivot.cxx:976

XclPTFieldExtInfo::SetApiSortMode
void SetApiSortMode(sal_Int32 nSortMode)
Sets the sorting mode represented by the passed API constant.
Definition: xlpivot.cxx:587

XclPTInfo::mnFlags
sal_uInt16 mnFlags
Number of columns containing data.
Definition: xlpivot.hxx:722

XclPCFieldInfo::mnVisItems
sal_uInt16 mnVisItems
Base field if this field contains grouping info.
Definition: xlpivot.hxx:441

EXC_SXVI_TYPE_DATA
const sal_uInt16 EXC_SXVI_TYPE_DATA
Definition: xlpivot.hxx:139

XclPTFieldExtInfo::GetApiSortMode
sal_Int32 GetApiSortMode() const
Returns the API constant representing the sorting mode.
Definition: xlpivot.cxx:579

EXC_SXVD_SUBT_COUNTNUM
const sal_uInt16 EXC_SXVD_SUBT_COUNTNUM
Definition: xlpivot.hxx:126

EXC_ID_SXLI
const sal_uInt16 EXC_ID_SXLI
Definition: xlpivot.hxx:167

EXC_SXVD_SUBT_STDDEV
const sal_uInt16 EXC_SXVD_SUBT_STDDEV
Definition: xlpivot.hxx:127

EXC_SXVD_SUBT_DEFAULT
const sal_uInt16 EXC_SXVD_SUBT_DEFAULT
Definition: xlpivot.hxx:119

XclPTViewEx9Info::mbReport
sal_uInt32 mbReport
Definition: xlpivot.hxx:753

EXC_SXVI_HIDEDETAIL
const sal_uInt16 EXC_SXVI_HIDEDETAIL
Definition: xlpivot.hxx:156

XclPTDataFieldInfo::XclPTDataFieldInfo
XclPTDataFieldInfo()
Number format of the results.
Definition: xlpivot.cxx:700

XclPTDataFieldInfo::GetApiAggFunc
ScGeneralFunction GetApiAggFunc() const
Returns the API enum representing the aggregation function.
Definition: xlpivot.cxx:710

XclPTVisNameInfo
Base struct for named info structs.
Definition: xlpivot.hxx:559

XclPTInfo::mnFields
sal_uInt16 mnFields
Position of data fields.
Definition: xlpivot.hxx:715

EXC_ID_SXGROUPINFO
const sal_uInt16 EXC_ID_SXGROUPINFO
Definition: xlpivot.hxx:290

EXC_PCITEM_EMPTY
Special state, not used in Excel files.
Definition: xlpivot.hxx:70

XclPCField::maGroupOrder
ScfUInt16Vec maGroupOrder
Own field index in pivot cache.
Definition: xlpivot.hxx:518

EXC_SXFIELD_INDEX_STEP
const sal_uInt16 EXC_SXFIELD_INDEX_STEP
List index for maximum item in groupings.
Definition: xlpivot.hxx:245

EXC_SXDI_FUNC_MIN
const sal_uInt16 EXC_SXDI_FUNC_MIN
Definition: xlpivot.hxx:181

EXC_SXDI_FUNC_VAR
const sal_uInt16 EXC_SXDI_FUNC_VAR
Definition: xlpivot.hxx:186

EXC_PT_MAXDATACOUNT
const sal_uInt16 EXC_PT_MAXDATACOUNT
Definition: xlpivot.hxx:57

XclPCNumGroupInfo
Contains data for a numeric grouping field (SXNUMGROUP record).
Definition: xlpivot.hxx:455

EXC_SXVI_TYPE_VARP
const sal_uInt16 EXC_SXVI_TYPE_VARP
Definition: xlpivot.hxx:151

EXC_SXVS_SHEET
const sal_uInt16 EXC_SXVS_SHEET
Definition: xlpivot.hxx:299

XclPTFieldInfo::mnSubtCount
sal_uInt16 mnSubtCount
Flags for axes this field is part of.
Definition: xlpivot.hxx:594

EXC_PT_AUTOFMT_FLAGS
const sal_uInt32 EXC_PT_AUTOFMT_FLAGS
Definition: xlpivot.hxx:64

EXC_PT_MAXITEMCOUNT
const sal_uInt16 EXC_PT_MAXITEMCOUNT
Definition: xlpivot.hxx:60

EXC_SXDB_DEFAULTFLAGS
const sal_uInt16 EXC_SXDB_DEFAULTFLAGS
Definition: xlpivot.hxx:211

XclPCInfo::mnStdFields
sal_uInt16 mnStdFields
Records in a source database block.
Definition: xlpivot.hxx:531

EXC_SXVI_TYPE_DEFAULT
const sal_uInt16 EXC_SXVI_TYPE_DEFAULT
Definition: xlpivot.hxx:140

EXC_PCFIELD_STANDARD
Definition: xlpivot.hxx:82

XclPTFieldExtInfo
Contains extended data for a pivot table field (SXVDEX record).
Definition: xlpivot.hxx:620

XclPTInfo::mnDataRows
sal_uInt16 mnDataRows
Number of data fields.
Definition: xlpivot.hxx:720

EXC_SXVS_CONSOLID
const sal_uInt16 EXC_SXVS_CONSOLID
Definition: xlpivot.hxx:301

EXC_SXVI_TYPE_PAGE
const sal_uInt16 EXC_SXVI_TYPE_PAGE
Definition: xlpivot.hxx:137

EXC_SXVD_AXIS_DATA
const sal_uInt16 EXC_SXVD_AXIS_DATA
Definition: xlpivot.hxx:114

EXC_SXFIELD_INDEX_MAX
const sal_uInt16 EXC_SXFIELD_INDEX_MAX
List index for minimum item in groupings.
Definition: xlpivot.hxx:244

XclPTFieldInfo::AddApiOrient
void AddApiOrient(css::sheet::DataPilotFieldOrientation eOrient)
Adds the axis orientation represented by the passed API enum.
Definition: xlpivot.cxx:485

XclPTInfo::mnDataFields
sal_uInt16 mnDataFields
Number of page fields.
Definition: xlpivot.hxx:719

EXC_PC_NOITEM
const sal_uInt16 EXC_PC_NOITEM
Definition: xlpivot.hxx:51

EXC_SXNUMGROUP_TYPE_HOUR
const sal_uInt16 EXC_SXNUMGROUP_TYPE_HOUR
Definition: xlpivot.hxx:282

EXC_SXNUMGROUP_TYPE_DAY
const sal_uInt16 EXC_SXNUMGROUP_TYPE_DAY
Definition: xlpivot.hxx:283

EXC_PCITEM_DOUBLE
String data.
Definition: xlpivot.hxx:72

EXC_ID_SXNAME
const sal_uInt16 EXC_ID_SXNAME
Unknown record.
Definition: xlpivot.hxx:321

EXC_PCITEM_BOOL
16-bit integer value.
Definition: xlpivot.hxx:75

EXC_SXVDEX_LAYOUT_REPORT
const sal_uInt32 EXC_SXVDEX_LAYOUT_REPORT
Definition: xlpivot.hxx:337

EXC_SXNUMGROUP_AUTOMAX
const sal_uInt16 EXC_SXNUMGROUP_AUTOMAX
Definition: xlpivot.hxx:278

XclPTInfo::mnCacheIdx
sal_uInt16 mnCacheIdx
First heading row.
Definition: xlpivot.hxx:712

XclPTFieldExtInfo::mnShowField
sal_uInt16 mnShowField
Index to data field sorting bases on.
Definition: xlpivot.hxx:624

XclPCNumGroupInfo::GetScDateType
sal_Int32 GetScDateType() const
Definition: xlpivot.cxx:225

EXC_ID_SXEXT
const sal_uInt16 EXC_ID_SXEXT
Definition: xlpivot.hxx:293

XclPCFieldInfo::mnGroupBase
sal_uInt16 mnGroupBase
Field containing grouping info for this field.
Definition: xlpivot.hxx:440

EXC_SXEX_DRILLDOWN
const sal_uInt32 EXC_SXEX_DRILLDOWN
Definition: xlpivot.hxx:311

XclPTViewEx9Info::maGrandTotalName
OUString maGrandTotalName
0 == gridlayout, 0x10 == modern
Definition: xlpivot.hxx:756

EXC_SXVD_SUBT_NONE
const sal_uInt16 EXC_SXVD_SUBT_NONE
Definition: xlpivot.hxx:118

XclPTPageFieldInfo
Contains data for a pivot table page field (part of SXPI record).
Definition: xlpivot.hxx:657

EXC_PCFIELD_NUMGROUP
Standard grouping field.
Definition: xlpivot.hxx:84

XclPCItem::SetInteger
void SetInteger(sal_Int16 nValue)
Sets the item to 'integer' type and adds the passed value.
Definition: xlpivot.cxx:81

XclPTDataFieldInfo::mnNumFmt
sal_uInt16 mnNumFmt
Index to SXVI of referred item of the used field.
Definition: xlpivot.hxx:679

EXC_PCFIELD_DATECHILD
First date grouping field (opt. with child grouping field).
Definition: xlpivot.hxx:86

EXC_SXDI_NEXTITEM
const sal_uInt16 EXC_SXDI_NEXTITEM
Definition: xlpivot.hxx:200

XclPTPageFieldInfo::mnField
sal_uInt16 mnField
Definition: xlpivot.hxx:659

XclPTVisNameInfo::maVisName
XclPTCachedName maVisName
Definition: xlpivot.hxx:561

XclPTSubtotalVec
::std::vector< ScGeneralFunction > XclPTSubtotalVec
Definition: xlpivot.hxx:588

EXC_SXNUMGROUP_TYPE_NUM
const sal_uInt16 EXC_SXNUMGROUP_TYPE_NUM
Definition: xlpivot.hxx:287

EXC_SXVD_SUBT_MIN
const sal_uInt16 EXC_SXVD_SUBT_MIN
Definition: xlpivot.hxx:124

XclPCItem::GetDateTime
const DateTime * GetDateTime() const
Returns pointer to date, if the item type is 'date/time', otherwise 0.
Definition: xlpivot.cxx:145

XclPCInfo::mnStrmId
sal_uInt16 mnStrmId
Records in source database.
Definition: xlpivot.hxx:528

EXC_SXDI_REF_INDEX
const sal_uInt16 EXC_SXDI_REF_INDEX
Definition: xlpivot.hxx:197

XclPCItem::GetText
const OUString * GetText() const
Returns pointer to text, if the item type is 'text', otherwise 0.
Definition: xlpivot.cxx:135

XclPTExtInfo::mnPagePerRow
sal_uInt16 mnPagePerRow
Number of SXSELECT records.
Definition: xlpivot.hxx:738

EXC_ID_SXSTRING
const sal_uInt16 EXC_ID_SXSTRING
Definition: xlpivot.hxx:263

EXC_ID_SXDATETIME
const sal_uInt16 EXC_ID_SXDATETIME
Definition: xlpivot.hxx:266

EXC_PCITEM_DATETIME
Floating-point value.
Definition: xlpivot.hxx:73

XclPTFieldInfo
Contains data for a pivot table field (SXVD record).
Definition: xlpivot.hxx:591

EXC_SXVD_SUBT_SUM
const sal_uInt16 EXC_SXVD_SUBT_SUM
Definition: xlpivot.hxx:120

EXC_PC_MAXITEMCOUNT
const size_t EXC_PC_MAXITEMCOUNT
Definition: xlpivot.hxx:50

XclPCNumGroupInfo::mnFlags
sal_uInt16 mnFlags
Definition: xlpivot.hxx:457

XclPCNumGroupInfo::SetXclDataType
void SetXclDataType(sal_uInt16 nXclType)
Definition: xlpivot.cxx:265

EXC_SXFIELD_NUMGROUP
const sal_uInt16 EXC_SXFIELD_NUMGROUP
Definition: xlpivot.hxx:227

EXC_SXVIEW_DATALAST
const sal_uInt16 EXC_SXVIEW_DATALAST
Definition: xlpivot.hxx:104

EXC_SXFDBTYPE_DEFAULT
const sal_uInt16 EXC_SXFDBTYPE_DEFAULT
Definition: xlpivot.hxx:355

dpobject.hxx

EXC_SXDI_FUNC_COUNTNUM
const sal_uInt16 EXC_SXDI_FUNC_COUNTNUM
Definition: xlpivot.hxx:183

EXC_SXDB_SRC_SCENARIO
const sal_uInt16 EXC_SXDB_SRC_SCENARIO
Definition: xlpivot.hxx:218

EXC_SXEX_DEFAULTFLAGS
const sal_uInt32 EXC_SXEX_DEFAULTFLAGS
Definition: xlpivot.hxx:312

EXC_SXDI_REF_NORMAL
const sal_uInt16 EXC_SXDI_REF_NORMAL
Definition: xlpivot.hxx:189

XclPCFieldInfo::mnOrigItems
sal_uInt16 mnOrigItems
Number of items in the base field.
Definition: xlpivot.hxx:444

EXC_SXDB_REFRESH_LOAD
const sal_uInt16 EXC_SXDB_REFRESH_LOAD
Definition: xlpivot.hxx:207

EXC_SXFIELD_HASCHILD
const sal_uInt16 EXC_SXFIELD_HASCHILD
Definition: xlpivot.hxx:226

XclPCInfo::mnFlags
sal_uInt16 mnFlags
Stream identifier.
Definition: xlpivot.hxx:529

XclPTFieldExtInfo::SetApiAutoShowCount
void SetApiAutoShowCount(sal_Int32 nShowCount)
Sets the number of items to be shown in AutoShow mode.
Definition: xlpivot.cxx:611

EXC_SXVDEX_SORT_OWN
const sal_uInt16 EXC_SXVDEX_SORT_OWN
Definition: xlpivot.hxx:342

XclPTVisNameInfo::HasVisName
bool HasVisName() const
The displayed name of the item.
Definition: xlpivot.hxx:564

EXC_SXFIELD_HASITEMS
const sal_uInt16 EXC_SXFIELD_HASITEMS
Definition: xlpivot.hxx:223

EXC_SXDI_FUNC_COUNT
const sal_uInt16 EXC_SXDI_FUNC_COUNT
Definition: xlpivot.hxx:178

XclPCInfo::mnSrcRecs
sal_uInt32 mnSrcRecs
Definition: xlpivot.hxx:527

EXC_PCFIELD_CALCED
Additional date grouping field.
Definition: xlpivot.hxx:87

EXC_ID_SXFMLA
const sal_uInt16 EXC_ID_SXFMLA
Definition: xlpivot.hxx:327

EXC_SXFIELD_CALCED
const sal_uInt16 EXC_SXFIELD_CALCED
Definition: xlpivot.hxx:225

XclPCInfo::mnBlockRecs
sal_uInt16 mnBlockRecs
Flags for the cache.
Definition: xlpivot.hxx:530

EXC_SXDB_SAVEDATA
const sal_uInt16 EXC_SXDB_SAVEDATA
Definition: xlpivot.hxx:205

EXC_ID_SXVI
const sal_uInt16 EXC_ID_SXVI
Definition: xlpivot.hxx:135

XclPCItem::IsEmpty
bool IsEmpty() const
Returns true, if the item type is 'empty'.
Definition: xlpivot.cxx:130

EXC_SXDBEX_CREATION_DATE
const double EXC_SXDBEX_CREATION_DATE
Definition: xlpivot.hxx:351

EXC_SXVI_TYPE_GRAND
const sal_uInt16 EXC_SXVI_TYPE_GRAND
Definition: xlpivot.hxx:152

EXC_SXNUMGROUP_AUTOMIN
const sal_uInt16 EXC_SXNUMGROUP_AUTOMIN
Definition: xlpivot.hxx:277

XclPCNumGroupInfo::GetXclDataType
sal_uInt16 GetXclDataType() const
Definition: xlpivot.cxx:260

EXC_SXDI_FUNC_MAX
const sal_uInt16 EXC_SXDI_FUNC_MAX
Definition: xlpivot.hxx:180

EXC_SXVIEW_COLGRAND
const sal_uInt16 EXC_SXVIEW_COLGRAND
Definition: xlpivot.hxx:101

xladdress.hxx

EXC_ID_SXDOUBLE
const sal_uInt16 EXC_ID_SXDOUBLE
Definition: xlpivot.hxx:251

XclPTFieldInfo::mnSubtotals
sal_uInt16 mnSubtotals
Number of subtotal functions.
Definition: xlpivot.hxx:595

EXC_ID_SXINTEGER
const sal_uInt16 EXC_ID_SXINTEGER
Definition: xlpivot.hxx:260

XclPTInfo::mnDataCols
sal_uInt16 mnDataCols
Number of rows containing data.
Definition: xlpivot.hxx:721

EXC_SXNUMGROUP_TYPE_MONTH
const sal_uInt16 EXC_SXNUMGROUP_TYPE_MONTH
Definition: xlpivot.hxx:284

XclPCField::XclPCField
XclPCField(XclPCFieldType eFieldType, sal_uInt16 nFieldIdx)
Definition: xlpivot.cxx:283

EXC_SXVD_SUBT_VAR
const sal_uInt16 EXC_SXVD_SUBT_VAR
Definition: xlpivot.hxx:129

XclPTPageFieldInfo::mnSelItem
sal_uInt16 mnSelItem
Base field for this page info.
Definition: xlpivot.hxx:660

EXC_ID_SXEMPTY
const sal_uInt16 EXC_ID_SXEMPTY
Definition: xlpivot.hxx:269

XclPTInfo::mnRowFields
sal_uInt16 mnRowFields
Number of all fields.
Definition: xlpivot.hxx:716

XclPTInfo::mnPageFields
sal_uInt16 mnPageFields
Number of column fields.
Definition: xlpivot.hxx:718

XclPTItemInfo
Contains data for a pivot table data item (SXVI record).
Definition: xlpivot.hxx:574

EXC_PCFIELD_UNKNOWN
Calculated field.
Definition: xlpivot.hxx:88

XclPTFieldExtInfo::mnSortField
sal_uInt16 mnSortField
Several flags and number of items for AutoShow.
Definition: xlpivot.hxx:623

EXC_SXFIELD_DATA_DATE_STR
const sal_uInt16 EXC_SXFIELD_DATA_DATE_STR
Dates with integers or doubles without strings.
Definition: xlpivot.hxx:241

EXC_ID_SXDB
const sal_uInt16 EXC_ID_SXDB
Definition: xlpivot.hxx:203

XclPTItemInfo::mnType
sal_uInt16 mnType
Definition: xlpivot.hxx:576

EXC_ID_SXDBEX
const sal_uInt16 EXC_ID_SXDBEX
Definition: xlpivot.hxx:350

XclPCItem::SetEmpty
void SetEmpty()
Sets the item to 'empty' type.
Definition: xlpivot.cxx:55

EXC_SXVD_SUBT_AVERAGE
const sal_uInt16 EXC_SXVD_SUBT_AVERAGE
Definition: xlpivot.hxx:122

XclPCItem::GetInteger
const sal_Int16 * GetInteger() const
Returns pointer to integer, if the item type is 'integer', otherwise 0.
Definition: xlpivot.cxx:150

XclPTFieldExtInfo::XclPTFieldExtInfo
XclPTFieldExtInfo()
Definition: xlpivot.cxx:571

XclPTInfo::mnDataPos
sal_uInt16 mnDataPos
Orientation of data fields.
Definition: xlpivot.hxx:714

EXC_SXDI_REF_PERC_ROW
const sal_uInt16 EXC_SXDI_REF_PERC_ROW
Definition: xlpivot.hxx:194

EXC_SXDI_FUNC_PRODUCT
const sal_uInt16 EXC_SXDI_FUNC_PRODUCT
Definition: xlpivot.hxx:182

EXC_ID_SXIDSTM
const sal_uInt16 EXC_ID_SXIDSTM
Definition: xlpivot.hxx:272

XclPTDataFieldInfo::GetApiRefItemType
sal_Int32 GetApiRefItemType() const
Returns the API constant representing the result reference item type.
Definition: xlpivot.cxx:786

EXC_SXVD_AXIS_ROWCOL
const sal_uInt16 EXC_SXVD_AXIS_ROWCOL
Definition: xlpivot.hxx:115

XclPTDataFieldInfo
Contains data for a pivot table data field (SXDI record).
Definition: xlpivot.hxx:672

XclPCItemType
XclPCItemType
Data type of a pivot cache item.
Definition: xlpivot.hxx:67

XclAddress
A 2D cell address struct with Excel column and row indexes.
Definition: xladdress.hxx:29

XclPTPageFieldInfo::XclPTPageFieldInfo
XclPTPageFieldInfo()
Escher object ID of dropdown listbox.
Definition: xlpivot.cxx:675

XclPTAddl::mbCompactMode
bool mbCompactMode
Definition: xlpivot.hxx:768

EXC_SXVDEX_AUTOSHOW_ASC
const sal_uInt32 EXC_SXVDEX_AUTOSHOW_ASC
Definition: xlpivot.hxx:336

XclPCItem::GetType
XclPCItemType GetType() const
Returns the type of the item.
Definition: xlpivot.cxx:165

EXC_SXFIELD_DATA_INT
const sal_uInt16 EXC_SXFIELD_DATA_INT
Only strings, nothing else.
Definition: xlpivot.hxx:234

EXC_ID_SXFORMULA
const sal_uInt16 EXC_ID_SXFORMULA
Definition: xlpivot.hxx:347

XclPCField::IsGroupChildField
bool IsGroupChildField() const
Returns true, if this field is a child field in a grouping (it has a base field). ...
Definition: xlpivot.cxx:328

EXC_PCITEM_TEXT
Empty cell.
Definition: xlpivot.hxx:71

ftools.hxx

EXC_SXDI_FUNC_AVERAGE
const sal_uInt16 EXC_SXDI_FUNC_AVERAGE
Definition: xlpivot.hxx:179

EXC_SXVDEX_SORT_ASC
const sal_uInt32 EXC_SXVDEX_SORT_ASC
Definition: xlpivot.hxx:334

EXC_SXVI_TYPE_STDDEV
const sal_uInt16 EXC_SXVI_TYPE_STDDEV
Definition: xlpivot.hxx:148

XclPCNumGroupInfo::XclPCNumGroupInfo
XclPCNumGroupInfo()
Various flags.
Definition: xlpivot.cxx:214

XclPCField::GetFieldIndex
sal_uInt16 GetFieldIndex() const
Returns the index of this field in the containing pivot cache.
Definition: xlpivot.hxx:483

EXC_SXVD_AXIS_PAGE
const sal_uInt16 EXC_SXVD_AXIS_PAGE
Definition: xlpivot.hxx:113

XclPTExtInfo::XclPTExtInfo
XclPTExtInfo()
Flags for the entire pivot table.
Definition: xlpivot.cxx:905

XclPTInfo::maOutXclRange
XclRange maOutXclRange
The visible name of the data field.
Definition: xlpivot.hxx:709

XclPTCachedName::maName
OUString maName
Definition: xlpivot.hxx:549

EXC_ID_DCONREF
const sal_uInt16 EXC_ID_DCONREF
Definition: xlpivot.hxx:93

XclPCField::IsStandardField
bool IsStandardField() const
Returns true, if this is a standard field build directly from source data.
Definition: xlpivot.cxx:298

EXC_SXVS_PIVOTTAB
const sal_uInt16 EXC_SXVS_PIVOTTAB
Definition: xlpivot.hxx:302

EXC_SXVD_DEFAULT_CACHE
const sal_uInt16 EXC_SXVD_DEFAULT_CACHE
Definition: xlpivot.hxx:132

EXC_SXVI_TYPE_SUM
const sal_uInt16 EXC_SXVI_TYPE_SUM
Definition: xlpivot.hxx:141

EXC_PCITEM_ERROR
Boolean value.
Definition: xlpivot.hxx:76

XclPCField::Has16BitIndexes
bool Has16BitIndexes() const
Returns true, if the item indexes in the SXINDEXLIST record are stored as 16-bit values.
Definition: xlpivot.cxx:348

XclPCInfo::mnTotalFields
sal_uInt16 mnTotalFields
Number of standard pivot cache fields.
Definition: xlpivot.hxx:532

EXC_SXDB_SRC_CONSOLID
const sal_uInt16 EXC_SXDB_SRC_CONSOLID
Definition: xlpivot.hxx:217

XclPTCachedName::XclPTCachedName
XclPTCachedName()
true = Use name in cache instead of maName.
Definition: xlpivot.hxx:552

XclPCField::IsGroupBaseField
bool IsGroupBaseField() const
Returns true, if this field has a child field in a grouping.
Definition: xlpivot.cxx:323

XclPCField::maFieldInfo
XclPCFieldInfo maFieldInfo
Definition: xlpivot.hxx:515

EXC_ID_SXDI
const sal_uInt16 EXC_ID_SXDI
Definition: xlpivot.hxx:175

EXC_ID_SXVD
const sal_uInt16 EXC_ID_SXVD
Definition: xlpivot.hxx:108

EXC_SXVI_TYPE_PROD
const sal_uInt16 EXC_SXVI_TYPE_PROD
Definition: xlpivot.hxx:146

XclPTExtInfo::mnPagePerCol
sal_uInt16 mnPagePerCol
Number of page fields per row.
Definition: xlpivot.hxx:739

EXC_SXFIELD_DATA_STR_INT
const sal_uInt16 EXC_SXFIELD_DATA_STR_INT
Only doubles, nothing else.
Definition: xlpivot.hxx:236

EXC_ID_SXVIEW
const sal_uInt16 EXC_ID_SXVIEW
Definition: xlpivot.hxx:98

XclPCField::~XclPCField
virtual ~XclPCField()
Definition: xlpivot.cxx:289

EXC_SXVD_SUBT_STDDEVP
const sal_uInt16 EXC_SXVD_SUBT_STDDEVP
Definition: xlpivot.hxx:128

XclPTInfo::maDataName
OUString maDataName
The name of the pivot table.
Definition: xlpivot.hxx:708

EXC_SXDI_FUNC_SUM
const sal_uInt16 EXC_SXDI_FUNC_SUM
Definition: xlpivot.hxx:177

EXC_SXVDEX_DEFAULTFLAGS
const sal_uInt32 EXC_SXVDEX_DEFAULTFLAGS
Definition: xlpivot.hxx:340

EXC_SXDI_REF_DIFF
const sal_uInt16 EXC_SXDI_REF_DIFF
Definition: xlpivot.hxx:190

ScfUInt16Vec
::std::vector< sal_uInt16 > ScfUInt16Vec
Definition: ftools.hxx:255

EXC_ID_SXBOOLEAN
const sal_uInt16 EXC_ID_SXBOOLEAN
Definition: xlpivot.hxx:254

EXC_SXVI_TYPE_NULL
const sal_uInt16 EXC_SXVI_TYPE_NULL
Definition: xlpivot.hxx:138

XclPTExtInfo::mnSxformulaRecs
sal_uInt16 mnSxformulaRecs
Definition: xlpivot.hxx:736

XclPCInfo
Contains data for a pivot cache (SXDB record).
Definition: xlpivot.hxx:525

XclPCItem::GetError
const sal_uInt16 * GetError() const
Returns pointer to error code, if the item type is 'error', otherwise 0.
Definition: xlpivot.cxx:155

EXC_PT_MAXFIELDCOUNT
const sal_uInt16 EXC_PT_MAXFIELDCOUNT
Definition: xlpivot.hxx:54

sal_uInt8
unsigned char sal_uInt8

EXC_SXFIELD_DATA_STR_DBL
const sal_uInt16 EXC_SXFIELD_DATA_STR_DBL
Only strings and integers, opt. with doubles.
Definition: xlpivot.hxx:237

operator<<
XclExpStream & operator<<(XclExpStream &rStrm, const XclPCFieldInfo &rInfo)
Definition: xlpivot.cxx:199

EXC_SXIVD_DATA
const sal_uInt16 EXC_SXIVD_DATA
Definition: xlpivot.hxx:164

ScGeneralFunction
ScGeneralFunction
the css::sheet::GeneralFunction enum is extended by constants in GeneralFunction2, which causes some type-safety issues.
Definition: generalfunction.hxx:28

EXC_SXVD_SUBT_MAX
const sal_uInt16 EXC_SXVD_SUBT_MAX
Definition: xlpivot.hxx:123

EXC_SXFIELD_POSTPONE
const sal_uInt16 EXC_SXFIELD_POSTPONE
Definition: xlpivot.hxx:224

EXC_SXVI_TYPE_COUNT
const sal_uInt16 EXC_SXVI_TYPE_COUNT
Definition: xlpivot.hxx:142

XclPTDataFieldInfo::GetApiRefType
sal_Int32 GetApiRefType() const
Returns the API constant representing the result reference type.
Definition: xlpivot.cxx:750

EXC_ID_SXFILT
const sal_uInt16 EXC_ID_SXFILT
Definition: xlpivot.hxx:315

XclPTInfo
Contains data for a pivot table (SXVIEW record).
Definition: xlpivot.hxx:705

EXC_ID_SXPAIR
const sal_uInt16 EXC_ID_SXPAIR
Definition: xlpivot.hxx:324

XclPCItem::ConvertToText
const OUString & ConvertToText() const
Returns the text representation of the item.
Definition: xlpivot.hxx:393

EXC_PT_MAXROWCOLCOUNT
const sal_uInt16 EXC_PT_MAXROWCOLCOUNT
Definition: xlpivot.hxx:55

XclPCFieldInfo::mnFlags
sal_uInt16 mnFlags
Name of the pivot cache field.
Definition: xlpivot.hxx:438

EXC_PT_MAXSTRLEN
const sal_uInt16 EXC_PT_MAXSTRLEN
Definition: xlpivot.hxx:42

operator!=
bool operator!=(const XclPCItem &rLeft, const XclPCItem &rRight)
Definition: xlpivot.hxx:430

XclPTAddl
Additional pivot table settings (SXADDL record).
Definition: xlpivot.hxx:766

EXC_SXVS_UNKNOWN
const sal_uInt16 EXC_SXVS_UNKNOWN
Definition: xlpivot.hxx:298

XclPCItem::maText
OUString maText
Type of the item.
Definition: xlpivot.hxx:418

EXC_SXVI_TYPE_VAR
const sal_uInt16 EXC_SXVI_TYPE_VAR
Definition: xlpivot.hxx:150

EXC_ID_SXEX
const sal_uInt16 EXC_ID_SXEX
Definition: xlpivot.hxx:309

EXC_SXVI_DEFAULT_CACHE
const sal_uInt16 EXC_SXVI_DEFAULT_CACHE
Definition: xlpivot.hxx:160

XclPTPageFieldInfo::mnObjId
sal_uInt16 mnObjId
Index to selected item.
Definition: xlpivot.hxx:661

EXC_ID_SXNUMGROUP
const sal_uInt16 EXC_ID_SXNUMGROUP
Definition: xlpivot.hxx:275

EXC_PCITEM_INTEGER
Date/time.
Definition: xlpivot.hxx:74

XclPTFieldInfo::GetApiOrient
css::sheet::DataPilotFieldOrientation GetApiOrient(sal_uInt16 nMask) const
Returns the API enum representing the orientation (first of row/col/page/data).
Definition: xlpivot.cxx:469

XclPCItem::mnError
sal_uInt16 mnError
Value of an integer item.
Definition: xlpivot.hxx:424

XclPTExtInfo::mnSxselectRecs
sal_uInt16 mnSxselectRecs
Number of SXFORMULA records.
Definition: xlpivot.hxx:737

EXC_SXVDEX_SHOWALL
const sal_uInt32 EXC_SXVDEX_SHOWALL
Definition: xlpivot.hxx:332

EXC_SXVI_TYPE_MIN
const sal_uInt16 EXC_SXVI_TYPE_MIN
Definition: xlpivot.hxx:145

XclPTDataFieldInfo::SetApiRefType
void SetApiRefType(sal_Int32 nRefType)
Sets the result reference type represented by the passed API constant.
Definition: xlpivot.cxx:769

EXC_ID_SXADDL
const sal_uInt16 EXC_ID_SXADDL
Definition: xlpivot.hxx:361

EXC_ID_SXFDBTYPE
const sal_uInt16 EXC_ID_SXFDBTYPE
Definition: xlpivot.hxx:354

ScDPObject
Definition: dpobject.hxx:83

XclPTVisNameInfo::SetVisName
void SetVisName(const OUString &rName)
Sets the visible name and enables usage of cache if name is empty.
Definition: xlpivot.cxx:425

XclPCField::HasPostponedItems
bool HasPostponedItems() const
Returns true, if the items are stored separately after the last field.
Definition: xlpivot.cxx:343

XclPCField::IsDateGroupField
bool IsDateGroupField() const
Returns true, if this field is a date/time grouping field.
Definition: xlpivot.cxx:313

EXC_SXFIELD_INDEX_MIN
const sal_uInt16 EXC_SXFIELD_INDEX_MIN
Dates and strings, opt. with integers or doubles.
Definition: xlpivot.hxx:243

EXC_SXVD_AXIS_NONE
const sal_uInt16 EXC_SXVD_AXIS_NONE
Definition: xlpivot.hxx:110

XclPTFieldExtInfo::SetApiAutoShowMode
void SetApiAutoShowMode(sal_Int32 nShowMode)
Sets the AutoShow mode represented by the passed API constant.
Definition: xlpivot.cxx:601

XclPCField::HasOrigItems
bool HasOrigItems() const
Returns true, if the field is based on a column in the source data area.
Definition: xlpivot.cxx:333

EXC_ID_SXFIELD
const sal_uInt16 EXC_ID_SXFIELD
Definition: xlpivot.hxx:221

XclPTFieldExtInfo::GetApiAutoShowCount
sal_Int32 GetApiAutoShowCount() const
Returns the number of items to be shown in AutoShow mode.
Definition: xlpivot.cxx:606

XclPCField::HasInlineItems
bool HasInlineItems() const
Returns true, if any items are stored after the SXFIELD record.
Definition: xlpivot.cxx:338

EXC_SXVI_TYPE_MAX
const sal_uInt16 EXC_SXVI_TYPE_MAX
Definition: xlpivot.hxx:144

EXC_SXDB_ENABLE_REFRESH
const sal_uInt16 EXC_SXDB_ENABLE_REFRESH
Definition: xlpivot.hxx:210

EXC_SXDB_OPT_CACHE
const sal_uInt16 EXC_SXDB_OPT_CACHE
Definition: xlpivot.hxx:208

XclPCField::maNumGroupInfo
XclPCNumGroupInfo maNumGroupInfo
Order of items in a grouping field (SXGROUPINFO record).
Definition: xlpivot.hxx:519

XclPCFieldInfo::XclPCFieldInfo
XclPCFieldInfo()
Number of original source data items.
Definition: xlpivot.cxx:172

XclPCItem::mbValue
bool mbValue
Error code of an error item.
Definition: xlpivot.hxx:425

EXC_SXVD_AXIS_ROW
const sal_uInt16 EXC_SXVD_AXIS_ROW
Definition: xlpivot.hxx:111

EXC_SXDB_SRC_SHEET
const sal_uInt16 EXC_SXDB_SRC_SHEET
Definition: xlpivot.hxx:215

EXC_SXDB_INVALID
const sal_uInt16 EXC_SXDB_INVALID
Definition: xlpivot.hxx:206

XclPCField::IsNumGroupField
bool IsNumGroupField() const
Returns true, if this field is a numeric grouping field.
Definition: xlpivot.cxx:308

XclPTDataFieldInfo::mnField
sal_uInt16 mnField
Definition: xlpivot.hxx:674

XclPTInfo::maTableName
OUString maTableName
Definition: xlpivot.hxx:707

EXC_PT_MAXPAGECOUNT
const sal_uInt16 EXC_PT_MAXPAGECOUNT
Definition: xlpivot.hxx:56

EXC_SXVIEW_AUTOFMT
const sal_uInt16 EXC_SXVIEW_AUTOFMT
Definition: xlpivot.hxx:105

EXC_SXVD_SUBT_VARP
const sal_uInt16 EXC_SXVD_SUBT_VARP
Definition: xlpivot.hxx:130

EXC_SXDI_REF_PERC_COL
const sal_uInt16 EXC_SXDI_REF_PERC_COL
Definition: xlpivot.hxx:195

XclPCItem::IsEqual
bool IsEqual(const XclPCItem &rItem) const
Returns true, if the passed term equals this item.
Definition: xlpivot.cxx:113

EXC_SXNUMGROUP_TYPE_SEC
const sal_uInt16 EXC_SXNUMGROUP_TYPE_SEC
Definition: xlpivot.hxx:280

XclImpStream
This class is used to import record oriented streams.
Definition: xistream.hxx:277

EXC_ID_SXVDEX
const sal_uInt16 EXC_ID_SXVDEX
Definition: xlpivot.hxx:330

EXC_SXVIEW_ROWGRAND
const sal_uInt16 EXC_SXVIEW_ROWGRAND
Definition: xlpivot.hxx:100

XclPCItem::SetDouble
void SetDouble(double fValue, const OUString &rText=OUString())
Sets the item to 'double' type and adds the passed value.
Definition: xlpivot.cxx:67

XclPCFieldInfo::mnBaseItems
sal_uInt16 mnBaseItems
Number of special items in a grouping field.
Definition: xlpivot.hxx:443

EXC_ID_SXERROR
const sal_uInt16 EXC_ID_SXERROR
Definition: xlpivot.hxx:257

EXC_SXFIELD_DATA_STR
const sal_uInt16 EXC_SXFIELD_DATA_STR
Special state for groupings.
Definition: xlpivot.hxx:233

XclPTItemInfo::XclPTItemInfo
XclPTItemInfo()
Index into cache for item name.
Definition: xlpivot.cxx:433

XclPCField::meFieldType
XclPCFieldType meFieldType
Pivot cache field info (SXFIELD record).
Definition: xlpivot.hxx:516

XclPCField::IsSupportedField
bool IsSupportedField() const
Returns true, if the type of the field is supported by Calc.
Definition: xlpivot.cxx:293

EXC_SXFIELD_DATA_DATE_NUM
const sal_uInt16 EXC_SXFIELD_DATA_DATE_NUM
Dates and empty strings, nothing else (?).
Definition: xlpivot.hxx:240

XclPCFieldInfo::maName
OUString maName
Definition: xlpivot.hxx:437

EXC_SXVI_TYPE_AVERAGE
const sal_uInt16 EXC_SXVI_TYPE_AVERAGE
Definition: xlpivot.hxx:143

EXC_SXVD_SUBT_PROD
const sal_uInt16 EXC_SXVD_SUBT_PROD
Definition: xlpivot.hxx:125

EXC_SXVI_FORMULA
const sal_uInt16 EXC_SXVI_FORMULA
Definition: xlpivot.hxx:157

EXC_SXVS_SCENARIO
const sal_uInt16 EXC_SXVS_SCENARIO
Definition: xlpivot.hxx:303

EXC_ID_SXVIEWEX9
const sal_uInt16 EXC_ID_SXVIEWEX9
Definition: xlpivot.hxx:358

XclPTExtInfo::mnFlags
sal_uInt32 mnFlags
Number of page fields per column.
Definition: xlpivot.hxx:740

EXC_SXVI_MISSING
const sal_uInt16 EXC_SXVI_MISSING
Definition: xlpivot.hxx:158

EXC_SXDI_REF_PERC
const sal_uInt16 EXC_SXDI_REF_PERC
Definition: xlpivot.hxx:191

EXC_PT_AUTOFMT_HEADER
const sal_uInt16 EXC_PT_AUTOFMT_HEADER
Definition: xlpivot.hxx:62

EXC_SXVI_TYPE_COUNTNUM
const sal_uInt16 EXC_SXVI_TYPE_COUNTNUM
Definition: xlpivot.hxx:147

EXC_SXDB_BLOCKRECS
const sal_uInt16 EXC_SXDB_BLOCKRECS
Definition: xlpivot.hxx:213

XclRange
A 2D cell range address struct with Excel column and row indexes.
Definition: xladdress.hxx:58

EXC_SXDI_FUNC_VARP
const sal_uInt16 EXC_SXDI_FUNC_VARP
Definition: xlpivot.hxx:187

XclPCInfo::maUserName
OUString maUserName
Database type.
Definition: xlpivot.hxx:534

EXC_PC_MAXSTRLEN
const sal_Int32 EXC_PC_MAXSTRLEN
Definition: xlpivot.hxx:47

XclPTFieldInfo::mnItemCount
sal_uInt16 mnItemCount
Bitfield for subtotal functions.
Definition: xlpivot.hxx:596

XclPTFieldInfo::mnAxes
sal_uInt16 mnAxes
Definition: xlpivot.hxx:593

XclPTInfo::mnFirstHeadRow
sal_uInt16 mnFirstHeadRow
First cell containing data.
Definition: xlpivot.hxx:711

nValue
sal_Int16 nValue

EXC_SXFIELD_DATA_MASK
const sal_uInt16 EXC_SXFIELD_DATA_MASK
Definition: xlpivot.hxx:230

EXC_SXVD_SUBT_COUNT
const sal_uInt16 EXC_SXVD_SUBT_COUNT
Definition: xlpivot.hxx:121

XclPCItem::mfValue
double mfValue
Definition: xlpivot.hxx:422

EXC_SXLI_DEFAULTFLAGS
const sal_uInt16 EXC_SXLI_DEFAULTFLAGS
Definition: xlpivot.hxx:168

XclPTFieldExtInfo::GetApiAutoShowMode
sal_Int32 GetApiAutoShowMode() const
Returns the API constant representing the AutoShow mode.
Definition: xlpivot.cxx:595

XclPTInfo::mnAutoFmtIdx
sal_uInt16 mnAutoFmtIdx
Flags for the entire pivot table.
Definition: xlpivot.hxx:723

XclPTViewEx9Info::mnGridLayout
sal_uInt8 mnGridLayout
AutoFormat ID.
Definition: xlpivot.hxx:755

XclPCItem
Represents a data item of any type in a pivot cache.
Definition: xlpivot.hxx:366

XclPTInfo::mnDataAxis
sal_uInt16 mnDataAxis
0-based index of the pivot cache.
Definition: xlpivot.hxx:713

XclPTFieldExtInfo::mnNumFmt
sal_uInt16 mnNumFmt
Index to data field AutoShow bases on.
Definition: xlpivot.hxx:625