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 -----------------------------------------------------------------------


inline constexpr OUStringLiteral EXC_STORAGE_PTCACHE = u"_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: */

DateTime

ScDPObject
Definition: dpobject.hxx:84

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

XclPCItem::XclPCItem
XclPCItem(XclPCItem &&)=default

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

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

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

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

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

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

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

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

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

dpobject.hxx

u
float u

ftools.hxx

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

ScGeneralFunction
ScGeneralFunction
the css::sheet::GeneralFunction enum is extended by constants in GeneralFunction2,...
Definition: generalfunction.hxx:29

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

sal_uInt8
unsigned char sal_uInt8

xladdress.hxx

EXC_SXVDEX_SHOWALL
const sal_uInt32 EXC_SXVDEX_SHOWALL
Definition: xlpivot.hxx:332

EXC_SXVI_TYPE_COUNTNUM
const sal_uInt16 EXC_SXVI_TYPE_COUNTNUM
Definition: xlpivot.hxx:147

EXC_SXDB_DEFAULTFLAGS
const sal_uInt16 EXC_SXDB_DEFAULTFLAGS
Definition: xlpivot.hxx:211

EXC_SXFIELD_POSTPONE
const sal_uInt16 EXC_SXFIELD_POSTPONE
Definition: xlpivot.hxx:224

EXC_SXDI_FUNC_AVERAGE
const sal_uInt16 EXC_SXDI_FUNC_AVERAGE
Definition: xlpivot.hxx:179

EXC_SXDI_REF_INDEX
const sal_uInt16 EXC_SXDI_REF_INDEX
Definition: xlpivot.hxx:197

EXC_ID_SXNUMGROUP
const sal_uInt16 EXC_ID_SXNUMGROUP
Definition: xlpivot.hxx:275

EXC_SXDI_PREVITEM
const sal_uInt16 EXC_SXDI_PREVITEM
Definition: xlpivot.hxx:199

EXC_SXVS_EXTERN
const sal_uInt16 EXC_SXVS_EXTERN
Definition: xlpivot.hxx:300

EXC_SXDI_FUNC_VAR
const sal_uInt16 EXC_SXDI_FUNC_VAR
Definition: xlpivot.hxx:186

EXC_SXVIEW_AUTOFMT
const sal_uInt16 EXC_SXVIEW_AUTOFMT
Definition: xlpivot.hxx:105

EXC_SXFIELD_CALCED
const sal_uInt16 EXC_SXFIELD_CALCED
Definition: xlpivot.hxx:225

EXC_SXVD_AXIS_ROWCOL
const sal_uInt16 EXC_SXVD_AXIS_ROWCOL
Definition: xlpivot.hxx:115

EXC_SXVD_SUBT_COUNT
const sal_uInt16 EXC_SXVD_SUBT_COUNT
Definition: xlpivot.hxx:121

EXC_SXVDEX_AUTOSHOW_ASC
const sal_uInt32 EXC_SXVDEX_AUTOSHOW_ASC
Definition: xlpivot.hxx:336

EXC_SXDI_REF_PERC_TOTAL
const sal_uInt16 EXC_SXDI_REF_PERC_TOTAL
Definition: xlpivot.hxx:196

EXC_SXVI_TYPE_COUNT
const sal_uInt16 EXC_SXVI_TYPE_COUNT
Definition: xlpivot.hxx:142

EXC_ID_DCONNAME
const sal_uInt16 EXC_ID_DCONNAME
Definition: xlpivot.hxx:94

EXC_SXVI_TYPE_PAGE
const sal_uInt16 EXC_SXVI_TYPE_PAGE
Definition: xlpivot.hxx:137

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

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

EXC_SXVI_FORMULA
const sal_uInt16 EXC_SXVI_FORMULA
Definition: xlpivot.hxx:157

EXC_SXNUMGROUP_TYPE_NUM
const sal_uInt16 EXC_SXNUMGROUP_TYPE_NUM
Definition: xlpivot.hxx:287

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

EXC_SXDB_REFRESH_LOAD
const sal_uInt16 EXC_SXDB_REFRESH_LOAD
Definition: xlpivot.hxx:207

EXC_PT_NOSTRING
const sal_uInt16 EXC_PT_NOSTRING
Definition: xlpivot.hxx:41

EXC_ID_SXRULE
const sal_uInt16 EXC_ID_SXRULE
Definition: xlpivot.hxx:306

EXC_SXDI_FUNC_COUNT
const sal_uInt16 EXC_SXDI_FUNC_COUNT
Definition: xlpivot.hxx:178

EXC_ID_SXPI
const sal_uInt16 EXC_ID_SXPI
Definition: xlpivot.hxx:171

EXC_SXVD_SUBT_COUNTNUM
const sal_uInt16 EXC_SXVD_SUBT_COUNTNUM
Definition: xlpivot.hxx:126

EXC_SXVDEX_SORT_ASC
const sal_uInt32 EXC_SXVDEX_SORT_ASC
Definition: xlpivot.hxx:334

EXC_ID_SXDATETIME
const sal_uInt16 EXC_ID_SXDATETIME
Definition: xlpivot.hxx:266

EXC_SXDI_FUNC_MIN
const sal_uInt16 EXC_SXDI_FUNC_MIN
Definition: xlpivot.hxx:181

EXC_SXVI_TYPE_NULL
const sal_uInt16 EXC_SXVI_TYPE_NULL
Definition: xlpivot.hxx:138

EXC_SXDI_FUNC_SUM
const sal_uInt16 EXC_SXDI_FUNC_SUM
Definition: xlpivot.hxx:177

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

EXC_ID_00F5
const sal_uInt16 EXC_ID_00F5
Definition: xlpivot.hxx:318

EXC_ID_SXIVD
const sal_uInt16 EXC_ID_SXIVD
Definition: xlpivot.hxx:163

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

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

EXC_PCFIELD_STANDARD
@ EXC_PCFIELD_STANDARD
Definition: xlpivot.hxx:82

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

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

EXC_PCFIELD_UNKNOWN
@ EXC_PCFIELD_UNKNOWN
Calculated field.
Definition: xlpivot.hxx:88

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

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

EXC_SXVI_TYPE_AVERAGE
const sal_uInt16 EXC_SXVI_TYPE_AVERAGE
Definition: xlpivot.hxx:143

EXC_SXDI_NEXTITEM
const sal_uInt16 EXC_SXDI_NEXTITEM
Definition: xlpivot.hxx:200

EXC_SXVD_AXIS_DATA
const sal_uInt16 EXC_SXVD_AXIS_DATA
Definition: xlpivot.hxx:114

EXC_PT_MAXDATACOUNT
const sal_uInt16 EXC_PT_MAXDATACOUNT
Definition: xlpivot.hxx:57

EXC_SXVDEX_SHOW_NONE
const sal_uInt16 EXC_SXVDEX_SHOW_NONE
Definition: xlpivot.hxx:343

EXC_SXDB_BG_QUERY
const sal_uInt16 EXC_SXDB_BG_QUERY
Definition: xlpivot.hxx:209

EXC_SXVI_MISSING
const sal_uInt16 EXC_SXVI_MISSING
Definition: xlpivot.hxx:158

EXC_SXDB_OPT_CACHE
const sal_uInt16 EXC_SXDB_OPT_CACHE
Definition: xlpivot.hxx:208

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

EXC_SXVD_SUBT_MAX
const sal_uInt16 EXC_SXVD_SUBT_MAX
Definition: xlpivot.hxx:123

EXC_SXVI_TYPE_MIN
const sal_uInt16 EXC_SXVI_TYPE_MIN
Definition: xlpivot.hxx:145

EXC_SXVD_SUBT_DEFAULT
const sal_uInt16 EXC_SXVD_SUBT_DEFAULT
Definition: xlpivot.hxx:119

EXC_SXVDEX_FORMAT_NONE
const sal_uInt16 EXC_SXVDEX_FORMAT_NONE
Definition: xlpivot.hxx:344

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

EXC_ID_SXEXT
const sal_uInt16 EXC_ID_SXEXT
Definition: xlpivot.hxx:293

EXC_SXNUMGROUP_TYPE_DAY
const sal_uInt16 EXC_SXNUMGROUP_TYPE_DAY
Definition: xlpivot.hxx:283

EXC_SXVD_SUBT_STDDEVP
const sal_uInt16 EXC_SXVD_SUBT_STDDEVP
Definition: xlpivot.hxx:128

EXC_SXDBEX_CREATION_DATE
const double EXC_SXDBEX_CREATION_DATE
Definition: xlpivot.hxx:351

EXC_SXVDEX_DEFAULTFLAGS
const sal_uInt32 EXC_SXVDEX_DEFAULTFLAGS
Definition: xlpivot.hxx:340

EXC_SXNUMGROUP_TYPE_MIN
const sal_uInt16 EXC_SXNUMGROUP_TYPE_MIN
Definition: xlpivot.hxx:281

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

EXC_SXVD_SUBT_VAR
const sal_uInt16 EXC_SXVD_SUBT_VAR
Definition: xlpivot.hxx:129

EXC_SXVI_DEFAULT_CACHE
const sal_uInt16 EXC_SXVI_DEFAULT_CACHE
Definition: xlpivot.hxx:160

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

EXC_ID_SXEMPTY
const sal_uInt16 EXC_ID_SXEMPTY
Definition: xlpivot.hxx:269

EXC_SXVD_AXIS_COL
const sal_uInt16 EXC_SXVD_AXIS_COL
Definition: xlpivot.hxx:112

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

EXC_ID_SXVS
const sal_uInt16 EXC_ID_SXVS
Definition: xlpivot.hxx:296

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

EXC_PCITEM_TEXT
@ EXC_PCITEM_TEXT
Empty cell.
Definition: xlpivot.hxx:71

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

EXC_PCITEM_DOUBLE
@ EXC_PCITEM_DOUBLE
String data.
Definition: xlpivot.hxx:72

EXC_PCITEM_ERROR
@ EXC_PCITEM_ERROR
Boolean value.
Definition: xlpivot.hxx:76

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

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

EXC_PCITEM_INVALID
@ EXC_PCITEM_INVALID
Definition: xlpivot.hxx:69

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

EXC_ID_SXEX
const sal_uInt16 EXC_ID_SXEX
Definition: xlpivot.hxx:309

EXC_SXDB_SRC_EXTERN
const sal_uInt16 EXC_SXDB_SRC_EXTERN
Definition: xlpivot.hxx:216

EXC_PT_AUTOFMT_FLAGS
const sal_uInt32 EXC_PT_AUTOFMT_FLAGS
Definition: xlpivot.hxx:64

EXC_SXVIEW_DEFAULTFLAGS
const sal_uInt16 EXC_SXVIEW_DEFAULTFLAGS
Definition: xlpivot.hxx:102

EXC_STORAGE_PTCACHE
constexpr OUStringLiteral EXC_STORAGE_PTCACHE
Definition: xlpivot.hxx:38

EXC_SXVS_SCENARIO
const sal_uInt16 EXC_SXVS_SCENARIO
Definition: xlpivot.hxx:303

EXC_SXFIELD_NUMGROUP
const sal_uInt16 EXC_SXFIELD_NUMGROUP
Definition: xlpivot.hxx:227

EXC_SXFIELD_HASITEMS
const sal_uInt16 EXC_SXFIELD_HASITEMS
Definition: xlpivot.hxx:223

EXC_PT_MAXROWCOLCOUNT
const sal_uInt16 EXC_PT_MAXROWCOLCOUNT
Definition: xlpivot.hxx:55

EXC_ID_SXPAIR
const sal_uInt16 EXC_ID_SXPAIR
Definition: xlpivot.hxx:324

EXC_SXLI_DEFAULTFLAGS
const sal_uInt16 EXC_SXLI_DEFAULTFLAGS
Definition: xlpivot.hxx:168

EXC_PT_MAXFIELDCOUNT
const sal_uInt16 EXC_PT_MAXFIELDCOUNT
Definition: xlpivot.hxx:54

EXC_SXVD_AXIS_NONE
const sal_uInt16 EXC_SXVD_AXIS_NONE
Definition: xlpivot.hxx:110

EXC_PC_NOITEM
const sal_uInt16 EXC_PC_NOITEM
Definition: xlpivot.hxx:51

EXC_SXFIELD_16BIT
const sal_uInt16 EXC_SXFIELD_16BIT
Definition: xlpivot.hxx:228

EXC_SXNUMGROUP_AUTOMIN
const sal_uInt16 EXC_SXNUMGROUP_AUTOMIN
Definition: xlpivot.hxx:277

EXC_SXVIEW_COLGRAND
const sal_uInt16 EXC_SXVIEW_COLGRAND
Definition: xlpivot.hxx:101

EXC_SXDI_REF_PERC_COL
const sal_uInt16 EXC_SXDI_REF_PERC_COL
Definition: xlpivot.hxx:195

EXC_SXVI_TYPE_PROD
const sal_uInt16 EXC_SXVI_TYPE_PROD
Definition: xlpivot.hxx:146

EXC_SXDI_REF_PERC_DIFF
const sal_uInt16 EXC_SXDI_REF_PERC_DIFF
Definition: xlpivot.hxx:192

EXC_SXVDEX_LAYOUT_TOP
const sal_uInt32 EXC_SXVDEX_LAYOUT_TOP
Definition: xlpivot.hxx:339

EXC_ID_SXFILT
const sal_uInt16 EXC_ID_SXFILT
Definition: xlpivot.hxx:315

EXC_ID_SXVDEX
const sal_uInt16 EXC_ID_SXVDEX
Definition: xlpivot.hxx:330

EXC_SXDI_REF_RUN_TOTAL
const sal_uInt16 EXC_SXDI_REF_RUN_TOTAL
Definition: xlpivot.hxx:193

EXC_ID_SXADDL
const sal_uInt16 EXC_ID_SXADDL
Definition: xlpivot.hxx:361

EXC_SXFDBTYPE_DEFAULT
const sal_uInt16 EXC_SXFDBTYPE_DEFAULT
Definition: xlpivot.hxx:355

EXC_SXIVD_DATA
const sal_uInt16 EXC_SXIVD_DATA
Definition: xlpivot.hxx:164

EXC_PT_AUTOFMT_ZERO
const sal_uInt16 EXC_PT_AUTOFMT_ZERO
Definition: xlpivot.hxx:63

EXC_SXVD_AXIS_ROW
const sal_uInt16 EXC_SXVD_AXIS_ROW
Definition: xlpivot.hxx:111

EXC_ID_SXDOUBLE
const sal_uInt16 EXC_ID_SXDOUBLE
Definition: xlpivot.hxx:251

EXC_ID_SXINTEGER
const sal_uInt16 EXC_ID_SXINTEGER
Definition: xlpivot.hxx:260

EXC_SXDI_FUNC_VARP
const sal_uInt16 EXC_SXDI_FUNC_VARP
Definition: xlpivot.hxx:187

EXC_ID_SXGROUPINFO
const sal_uInt16 EXC_ID_SXGROUPINFO
Definition: xlpivot.hxx:290

EXC_ID_SXSTRING
const sal_uInt16 EXC_ID_SXSTRING
Definition: xlpivot.hxx:263

EXC_ID_SXIDSTM
const sal_uInt16 EXC_ID_SXIDSTM
Definition: xlpivot.hxx:272

EXC_SXNUMGROUP_TYPE_HOUR
const sal_uInt16 EXC_SXNUMGROUP_TYPE_HOUR
Definition: xlpivot.hxx:282

EXC_SXDB_SRC_CONSOLID
const sal_uInt16 EXC_SXDB_SRC_CONSOLID
Definition: xlpivot.hxx:217

EXC_ID_SXVD
const sal_uInt16 EXC_ID_SXVD
Definition: xlpivot.hxx:108

EXC_ID_SXBOOLEAN
const sal_uInt16 EXC_ID_SXBOOLEAN
Definition: xlpivot.hxx:254

EXC_SXDB_BLOCKRECS
const sal_uInt16 EXC_SXDB_BLOCKRECS
Definition: xlpivot.hxx:213

EXC_SXVI_TYPE_GRAND
const sal_uInt16 EXC_SXVI_TYPE_GRAND
Definition: xlpivot.hxx:152

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

EXC_SXVD_DEFAULT_CACHE
const sal_uInt16 EXC_SXVD_DEFAULT_CACHE
Definition: xlpivot.hxx:132

EXC_SXVD_AXIS_PAGE
const sal_uInt16 EXC_SXVD_AXIS_PAGE
Definition: xlpivot.hxx:113

EXC_PT_AUTOFMT_HEADER
const sal_uInt16 EXC_PT_AUTOFMT_HEADER
Definition: xlpivot.hxx:62

EXC_SXVD_SUBT_AVERAGE
const sal_uInt16 EXC_SXVD_SUBT_AVERAGE
Definition: xlpivot.hxx:122

EXC_SXVD_SUBT_SUM
const sal_uInt16 EXC_SXVD_SUBT_SUM
Definition: xlpivot.hxx:120

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

EXC_SXDI_FUNC_PRODUCT
const sal_uInt16 EXC_SXDI_FUNC_PRODUCT
Definition: xlpivot.hxx:182

EXC_SXNUMGROUP_TYPE_QUART
const sal_uInt16 EXC_SXNUMGROUP_TYPE_QUART
Definition: xlpivot.hxx:285

EXC_SXVI_HIDDEN
const sal_uInt16 EXC_SXVI_HIDDEN
Definition: xlpivot.hxx:155

EXC_SXVS_PIVOTTAB
const sal_uInt16 EXC_SXVS_PIVOTTAB
Definition: xlpivot.hxx:302

EXC_SXNUMGROUP_TYPE_MONTH
const sal_uInt16 EXC_SXNUMGROUP_TYPE_MONTH
Definition: xlpivot.hxx:284

EXC_ID_SXVI
const sal_uInt16 EXC_ID_SXVI
Definition: xlpivot.hxx:135

EXC_ID_SXFORMULA
const sal_uInt16 EXC_ID_SXFORMULA
Definition: xlpivot.hxx:347

EXC_SXDI_FUNC_MAX
const sal_uInt16 EXC_SXDI_FUNC_MAX
Definition: xlpivot.hxx:180

EXC_SXVD_SUBT_MIN
const sal_uInt16 EXC_SXVD_SUBT_MIN
Definition: xlpivot.hxx:124

EXC_SXDI_FUNC_STDDEVP
const sal_uInt16 EXC_SXDI_FUNC_STDDEVP
Definition: xlpivot.hxx:185

EXC_SXVI_TYPE_VAR
const sal_uInt16 EXC_SXVI_TYPE_VAR
Definition: xlpivot.hxx:150

EXC_SXPI_ALLITEMS
const sal_uInt16 EXC_SXPI_ALLITEMS
Definition: xlpivot.hxx:172

EXC_SXVD_SUBT_STDDEV
const sal_uInt16 EXC_SXVD_SUBT_STDDEV
Definition: xlpivot.hxx:127

EXC_SXNUMGROUP_TYPE_SEC
const sal_uInt16 EXC_SXNUMGROUP_TYPE_SEC
Definition: xlpivot.hxx:280

EXC_SXEX_DEFAULTFLAGS
const sal_uInt32 EXC_SXEX_DEFAULTFLAGS
Definition: xlpivot.hxx:312

EXC_PC_MAXITEMCOUNT
const size_t EXC_PC_MAXITEMCOUNT
Definition: xlpivot.hxx:50

EXC_SXVDEX_LAYOUT_BLANK
const sal_uInt32 EXC_SXVDEX_LAYOUT_BLANK
Definition: xlpivot.hxx:338

EXC_SXDI_REF_PERC_ROW
const sal_uInt16 EXC_SXDI_REF_PERC_ROW
Definition: xlpivot.hxx:194

EXC_SXVD_SUBT_NONE
const sal_uInt16 EXC_SXVD_SUBT_NONE
Definition: xlpivot.hxx:118

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

EXC_SXFIELD_DATA_NONE
const sal_uInt16 EXC_SXFIELD_DATA_NONE
Definition: xlpivot.hxx:232

EXC_SXVI_TYPE_SUM
const sal_uInt16 EXC_SXVI_TYPE_SUM
Definition: xlpivot.hxx:141

EXC_SXVI_TYPE_MAX
const sal_uInt16 EXC_SXVI_TYPE_MAX
Definition: xlpivot.hxx:144

EXC_ID_DCONREF
const sal_uInt16 EXC_ID_DCONREF
Definition: xlpivot.hxx:93

EXC_SXDI_REF_NORMAL
const sal_uInt16 EXC_SXDI_REF_NORMAL
Definition: xlpivot.hxx:189

EXC_SXVD_SUBT_PROD
const sal_uInt16 EXC_SXVD_SUBT_PROD
Definition: xlpivot.hxx:125

EXC_ID_SXVIEWEX9
const sal_uInt16 EXC_ID_SXVIEWEX9
Definition: xlpivot.hxx:358

EXC_ID_SXLI
const sal_uInt16 EXC_ID_SXLI
Definition: xlpivot.hxx:167

EXC_PC_MAXFIELDCOUNT
const size_t EXC_PC_MAXFIELDCOUNT
Definition: xlpivot.hxx:45

EXC_SXDI_REF_PERC
const sal_uInt16 EXC_SXDI_REF_PERC
Definition: xlpivot.hxx:191

EXC_SXVDEX_SORT_OWN
const sal_uInt16 EXC_SXVDEX_SORT_OWN
Definition: xlpivot.hxx:342

EXC_SXDB_ENABLE_REFRESH
const sal_uInt16 EXC_SXDB_ENABLE_REFRESH
Definition: xlpivot.hxx:210

EXC_SXDB_SAVEDATA
const sal_uInt16 EXC_SXDB_SAVEDATA
Definition: xlpivot.hxx:205

EXC_SXDB_SRC_SHEET
const sal_uInt16 EXC_SXDB_SRC_SHEET
Definition: xlpivot.hxx:215

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_SXVI_DEFAULTFLAGS
const sal_uInt16 EXC_SXVI_DEFAULTFLAGS
Definition: xlpivot.hxx:154

EXC_SXDI_REF_DIFF
const sal_uInt16 EXC_SXDI_REF_DIFF
Definition: xlpivot.hxx:190

EXC_SXDB_INVALID
const sal_uInt16 EXC_SXDB_INVALID
Definition: xlpivot.hxx:206

EXC_ID_SXDI
const sal_uInt16 EXC_ID_SXDI
Definition: xlpivot.hxx:175

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

EXC_SXVI_HIDEDETAIL
const sal_uInt16 EXC_SXVI_HIDEDETAIL
Definition: xlpivot.hxx:156

EXC_PT_MAXSTRLEN
const sal_uInt16 EXC_PT_MAXSTRLEN
Definition: xlpivot.hxx:42

EXC_SXVD_AXIS_ROWCOLPAGE
const sal_uInt16 EXC_SXVD_AXIS_ROWCOLPAGE
Definition: xlpivot.hxx:116

EXC_PT_MAXITEMCOUNT
const sal_uInt16 EXC_PT_MAXITEMCOUNT
Definition: xlpivot.hxx:60

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

EXC_SXVIEW_DATALAST
const sal_uInt16 EXC_SXVIEW_DATALAST
Definition: xlpivot.hxx:104

EXC_SXVI_TYPE_DATA
const sal_uInt16 EXC_SXVI_TYPE_DATA
Definition: xlpivot.hxx:139

EXC_SXEX_DRILLDOWN
const sal_uInt32 EXC_SXEX_DRILLDOWN
Definition: xlpivot.hxx:311

EXC_SXVI_TYPE_STDDEV
const sal_uInt16 EXC_SXVI_TYPE_STDDEV
Definition: xlpivot.hxx:148

EXC_SXVS_CONSOLID
const sal_uInt16 EXC_SXVS_CONSOLID
Definition: xlpivot.hxx:301

EXC_SXVDEX_SORT
const sal_uInt32 EXC_SXVDEX_SORT
Definition: xlpivot.hxx:333

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

EXC_SXVDEX_AUTOSHOW
const sal_uInt32 EXC_SXVDEX_AUTOSHOW
Definition: xlpivot.hxx:335

EXC_ID_SXFIELD
const sal_uInt16 EXC_ID_SXFIELD
Definition: xlpivot.hxx:221

EXC_SXFIELD_HASCHILD
const sal_uInt16 EXC_SXFIELD_HASCHILD
Definition: xlpivot.hxx:226

EXC_PC_NOFIELD
const sal_uInt16 EXC_PC_NOFIELD
Definition: xlpivot.hxx:46

EXC_ID_SXERROR
const sal_uInt16 EXC_ID_SXERROR
Definition: xlpivot.hxx:257

EXC_PC_MAXSTRLEN
const sal_Int32 EXC_PC_MAXSTRLEN
Definition: xlpivot.hxx:47

EXC_PT_MAXPAGECOUNT
const sal_uInt16 EXC_PT_MAXPAGECOUNT
Definition: xlpivot.hxx:56

EXC_SXVS_UNKNOWN
const sal_uInt16 EXC_SXVS_UNKNOWN
Definition: xlpivot.hxx:298

EXC_SXVS_SHEET
const sal_uInt16 EXC_SXVS_SHEET
Definition: xlpivot.hxx:299

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

EXC_SXNUMGROUP_AUTOMAX
const sal_uInt16 EXC_SXNUMGROUP_AUTOMAX
Definition: xlpivot.hxx:278

EXC_SXVDEX_LAYOUT_REPORT
const sal_uInt32 EXC_SXVDEX_LAYOUT_REPORT
Definition: xlpivot.hxx:337

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

EXC_ID_SXDB
const sal_uInt16 EXC_ID_SXDB
Definition: xlpivot.hxx:203

EXC_SXVI_TYPE_DEFAULT
const sal_uInt16 EXC_SXVI_TYPE_DEFAULT
Definition: xlpivot.hxx:140

EXC_SXVI_TYPE_STDDEVP
const sal_uInt16 EXC_SXVI_TYPE_STDDEVP
Definition: xlpivot.hxx:149

EXC_ID_SXFDBTYPE
const sal_uInt16 EXC_ID_SXFDBTYPE
Definition: xlpivot.hxx:354

EXC_SXNUMGROUP_TYPE_YEAR
const sal_uInt16 EXC_SXNUMGROUP_TYPE_YEAR
Definition: xlpivot.hxx:286

EXC_ID_SXDBEX
const sal_uInt16 EXC_ID_SXDBEX
Definition: xlpivot.hxx:350

EXC_SXDI_FUNC_STDDEV
const sal_uInt16 EXC_SXDI_FUNC_STDDEV
Definition: xlpivot.hxx:184

EXC_ID_SXVIEW
const sal_uInt16 EXC_ID_SXVIEW
Definition: xlpivot.hxx:98

EXC_SXVI_TYPE_VARP
const sal_uInt16 EXC_SXVI_TYPE_VARP
Definition: xlpivot.hxx:151

EXC_SXFIELD_DATA_MASK
const sal_uInt16 EXC_SXFIELD_DATA_MASK
Definition: xlpivot.hxx:230

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_SXVD_SUBT_VARP
const sal_uInt16 EXC_SXVD_SUBT_VARP
Definition: xlpivot.hxx:130

EXC_SXVIEW_ROWGRAND
const sal_uInt16 EXC_SXVIEW_ROWGRAND
Definition: xlpivot.hxx:100

EXC_ID_SXFMLA
const sal_uInt16 EXC_ID_SXFMLA
Definition: xlpivot.hxx:327

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