237 const OUString*
GetItemName( sal_uInt16 nItemIdx )
const;
350 std::vector< XclImpPTFieldRef >
Represents a field in a pivot cache (a column of data items in the source area).
ScDPNumGroupInfo GetScDateGroupInfo() const
Returns a Calc struct with date grouping data.
const XclImpPCItem * GetLimitItem(sal_uInt16 nItemIdx) const
Returns the item representing a limit value in numeric/date/time grouping fields.
XclImpPivotCache & mrPCache
XclImpPCField(const XclImpRoot &rRoot, XclImpPivotCache &rPCache, sal_uInt16 nFieldIdx)
Creates a pivot cache field by reading an SXFIELD record.
::std::vector< XclImpPCItemRef > XclImpPCItemVec
XclImpPCItemVec maNumGroupItems
List of all source data items.
XclImpPCItemVec maOrigItems
List of all displayed data items.
void ConvertDateGroupField(ScDPSaveData &rSaveData, const ScfStringVec &rVisNames) const
Inserts date grouping information of this field into the passed ScDPSaveData.
const double * GetNumGroupLimit(sal_uInt16 nLimitIdx) const
Returns a limit value for numeric grouping fields.
bool mbNumGroupInfoRead
Column index of source data for this field.
ScDPNumGroupInfo GetScNumGroupInfo() const
Returns a Calc struct with numeric grouping data.
void ConvertGroupField(ScDPSaveData &rSaveData, const ScfStringVec &rVisNames) const
Inserts grouping information of this field into the passed ScDPSaveData.
SCCOL mnSourceScCol
List of items containing numeric grouping limits.
void ConvertStdGroupField(ScDPSaveData &rSaveData, const ScfStringVec &rVisNames) const
Inserts standard grouping information of this field into the passed ScDPSaveData.
const OUString & GetFieldName(const ScfStringVec &rVisNames) const
Returns the name of the field, uses the passed visible name if supported.
virtual ~XclImpPCField() override
void WriteFieldNameToSource(SCCOL nScCol, SCTAB nScTab)
Inserts the field name into the document.
XclImpPCItemVec maItems
Parent pivot cache containing this field.
const DateTime * GetDateGroupLimit(sal_uInt16 nLimitIdx) const
Returns a limit value for date grouping fields (minimum/maximum only).
const sal_Int16 * GetDateGroupStep() const
Returns the step value for date grouping fields.
void WriteLastOrigItemToSource(SCROW nScRow, SCTAB nScTab)
Inserts the data of the last inserted item into the document.
void ReadSxnumgroup(XclImpStream &rStrm)
Reads the SXNUMGROUP record describing numeric grouping fields.
void ReadSxfield(XclImpStream &rStrm)
Reads the SXFIELD record describing the field.
void ConvertNumGroupField(ScDPSaveData &rSaveData, const ScfStringVec &rVisNames) const
Inserts numeric grouping information of this field into the passed ScDPSaveData.
const XclImpPCItem * GetItem(sal_uInt16 nItemIdx) const
Returns the item at the specified position or 0 on error.
void WriteOrigItemToSource(SCROW nScRow, SCTAB nScTab, sal_uInt16 nItemIdx)
Inserts the specified item data into the document.
void ReadItem(XclImpStream &rStrm)
Reads an item data record describing a new item.
void ReadSxgroupinfo(XclImpStream &rStrm)
Reads the SXGROUPINFO record describing the item order in grouping fields.
const XclImpPCField * GetGroupBaseField() const
Returns the base field if this is a grouping field.
Represents a data item in a pivot cache.
void ReadSxinteger(XclImpStream &rStrm)
Reads an SXINTEGER record describing an integer item.
void ReadSxdouble(XclImpStream &rStrm)
Reads an SXDOUBLE record describing a floating-point item.
void ReadSxempty(XclImpStream &rStrm)
Reads an SXEMPTY record describing an empty item.
void WriteToSource(XclImpRoot &rRoot, const ScAddress &rScPos) const
Inserts the item data into the passed document.
XclImpPCItem(XclImpStream &rStrm)
void ReadSxboolean(XclImpStream &rStrm)
Reads an SXBOOLEAN record describing a boolean item.
void ReadSxstring(XclImpStream &rStrm)
Reads an SXSTRING record describing a text item.
void ReadSxerror(XclImpStream &rStrm)
Reads an SXERROR record describing an error code item.
void ReadSxdatetime(XclImpStream &rStrm)
Reads an SXDATETIME record describing a date/time item.
void ConvertHiddenField(ScDPSaveData &rSaveData) const
void ConvertPageField(ScDPSaveData &rSaveData) const
const XclImpPivotTable & mrPTable
XclPTFieldExtInfo maFieldExtInfo
General field info (SXVD record).
void AddDataFieldInfo(const XclPTDataFieldInfo &rDataInfo)
XclImpPTField(const XclImpPivotTable &rPTable, sal_uInt16 nCacheIdx)
XclPTPageFieldInfo maPageInfo
Extended field info (SXVDEX record).
void ReadSxvi(XclImpStream &rStrm)
Reads an SXVI record describing a new item of this field.
std::vector< XclImpPTItemRef > maItems
Vector of extended data field info (SXDI records).
sal_uInt16 GetAxes() const
Returns the flags of the axes this field is part of.
void SetAxes(sal_uInt16 nAxes)
Sets the flags of the axes this field is part of.
void ReadSxvd(XclImpStream &rStrm)
Reads an SXVD record describing the field.
bool HasDataFieldInfo() const
void ConvertFieldInfo(const ScDPSaveData &rSaveData, ScDPObject *pObj, const XclImpRoot &rRoot, bool bPageField=false) const
void ConvertRowColField(ScDPSaveData &rSaveData) const
void ConvertRCPField(ScDPSaveData &rSaveData) const
XclPTFieldInfo maFieldInfo
Parent pivot table containing this field.
const OUString * GetItemName(sal_uInt16 nItemIdx) const
Returns the internal name of the specified item.
void ConvertDataFieldInfo(ScDPSaveDimension &rSaveDim, const XclPTDataFieldInfo &rDataInfo) const
const XclImpPCField * GetCacheField() const
Returns the corresponding pivot cache field of this field.
void SetPageFieldInfo(const XclPTPageFieldInfo &rPageInfo)
const XclImpPTItem * GetItem(sal_uInt16 nItemIdx) const
Returns the specified item.
void ConvertDataField(ScDPSaveData &rSaveData) const
OUString GetVisFieldName() const
Returns the internally set visible name of this field.
std::vector< XclPTDataFieldInfo > maDataInfoVector
Page field info (entry from SXPI record).
OUString GetFieldName() const
Returns the name of this field that is used to create the Calc dimensions.
void ReadSxvdex(XclImpStream &rStrm)
Reads an SXVDEX record describing extended options of the field.
void ConvertItem(ScDPSaveDimension &rSaveDim, ScDPObject *pObj, const XclImpRoot &rRoot) const
Inserts this item into the passed ScDPSaveDimension.
const XclImpPCField * mpCacheField
General data for this item.
const OUString * GetItemName() const
Returns the internal name of the item or 0, if no name could be found.
XclImpPTItem(const XclImpPCField *pCacheField)
void ReadSxvi(XclImpStream &rStrm)
Reads an SXVI record containing data of this item.
bool mbSelfRef
Source data type.
sal_uInt16 mnSrcType
Pivot cache stream identifier.
XclImpPCFieldVec maFields
Pivot cache settings (SXDB record).
XclImpPivotCache(const XclImpRoot &rRoot)
bool IsRefreshOnLoad() const
OUString maTabName
URL of the source data.
void ReadDconref(XclImpStream &rStrm)
Reads a DCONREF record containing the source range of the pivot cache.
OUString maUrl
Source range in the spreadsheet.
::std::vector< XclImpPCFieldRef > XclImpPCFieldVec
virtual ~XclImpPivotCache() override
const OUString & GetSourceRangeName() const
const ScRange & GetSourceRange() const
Returns the data source range read from the DCONREF record.
sal_uInt16 mnStrmId
Name of the source data range.
ScRange maSrcRange
List of pivot cache fields.
void ReadDConName(XclImpStream &rStrm)
Read DECONNAME record which contains the defined name of the source range.
void ReadSxidstm(XclImpStream &rStrm)
Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache.
const XclImpPCField * GetField(sal_uInt16 nFieldIdx) const
Returns read-only access to a pivot cache field.
void ReadSxvs(XclImpStream &rStrm)
Reads an SXVS record containing the source type of the pivot cache.
OUString maSrcRangeName
Sheet name of the source data.
void ReadPivotCacheStream(const XclImpStream &rStrm)
Reads the entire pivot cache stream.
The main class for pivot table import.
void ReadSxvdex(XclImpStream &rStrm)
Reads an SXVDEX record describing extended options of a field.
void ReadSxvi(XclImpStream &rStrm)
Reads an SXVI record describing a new item of the current field.
std::vector< XclImpPivotCacheRef > maPCaches
void ReadSxpi(XclImpStream &rStrm)
Reads an SXPI record containing page field data.
XclImpPivotTableManager(const XclImpRoot &rRoot)
void ReadSxViewEx9(XclImpStream &rStrm)
Reads an SXVIEWEX9 record that specifies the pivot tables autoformat.
void ReadPivotCaches(const XclImpStream &rStrm)
Reads all used pivot caches and creates additional sheets for external data sources.
void ReadSxview(XclImpStream &rStrm)
Reads an SXVIEW record describing a new pivot table.
void ReadDconref(XclImpStream &rStrm)
Reads a DCONREF record containing the source range of a pivot cache.
std::vector< XclImpPivotTableRef > maPTables
List of all pivot caches.
void ReadSxivd(XclImpStream &rStrm)
Reads an SXIVD record containing the row field or column field order.
void ReadSxdi(XclImpStream &rStrm)
Reads an SXDI record containing data field data.
void MaybeRefreshPivotTables()
void ReadSxidstm(XclImpStream &rStrm)
Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache.
virtual ~XclImpPivotTableManager() override
void ReadSxAddl(XclImpStream &rStrm)
Reads an SXADDL record that specifies additional info for pivot table.
XclImpPivotCacheRef GetPivotCache(sal_uInt16 nCacheIdx)
Returns the pivot cache with the specified 0-based index.
void ReadSxvd(XclImpStream &rStrm)
Reads an SXVD record describing a new field.
void ReadDConName(XclImpStream &rStrm)
void ConvertPivotTables()
Inserts all pivot tables into the Calc document.
void ReadSxex(XclImpStream &rStrm)
Reads an SXEX record containing additional settings for a pivot table.
void ReadSxvs(XclImpStream &rStrm)
Reads an SXVS record containing the source type of a pivot cache.
const XclImpPTField * GetField(sal_uInt16 nFieldIdx) const
XclPTInfo maPTInfo
Pivot cache containing field/item names.
ScfUInt16Vec maColFields
Row field indexes.
XclPTViewEx9Info maPTViewEx9Info
Extended info about the pivot table (SXEX record).
void ReadSxview(XclImpStream &rStrm)
Reads an SXVIEW record starting a new pivot table.
XclImpPivotCacheRef mxPCache
void ReadSxex(XclImpStream &rStrm)
Reads an SXEX record containing additional settings for the pivot table.
const ScfStringVec & GetVisFieldNames() const
const XclImpPivotCacheRef & GetPivotCache() const
ScRange maOutScRange
Special data field orientation field.
ScfUInt16Vec maFiltDataFields
Original data field indexes.
virtual ~XclImpPivotTable() override
ScfStringVec maVisFieldNames
Current field for importing additional info.
ScfUInt16Vec maOrigDataFields
Page field indexes.
sal_uInt16 GetFieldCount() const
void ReadSxvi(XclImpStream &rStrm)
Reads an SXVI record describing a new item of the current field.
XclImpPTField maDataOrientField
Filtered data field indexes.
ScfUInt16Vec maPageFields
Column field indexes.
XclImpPTField * GetFieldAcc(sal_uInt16 nFieldIdx)
void ReadSxvdex(XclImpStream &rStrm)
Reads an SXVDEX record describing extended options of the current field.
XclImpPivotTable(const XclImpRoot &rRoot)
void ReadSxViewEx9(XclImpStream &rStrm)
Reads an SXVIEWEX9 record that specifies the pivot tables autoformat.
ScDPObject * mpDPObj
Output range in the Calc document.
XclImpPTFieldRef mxCurrField
Vector containing all fields.
OUString GetDataFieldName(sal_uInt16 nDataFieldIdx) const
ScfUInt16Vec maRowFields
Vector containing all visible field names.
void ReadSxivd(XclImpStream &rStrm)
Reads an SXIVD record containing the row field or column field order.
void ReadSxAddl(XclImpStream &rStrm)
Reads an SXADDL record that specifies additional info for pivot table.
XclPTExtInfo maPTExtInfo
General info about the pivot table (SXVIEW record).
void Convert()
Inserts the pivot table into the Calc document.
void ReadSxdi(XclImpStream &rStrm)
Reads an SXDI record containing data field data.
XclPTAddl maPTAddlInfo
(SXVIEWEX9 record)
const XclImpPTField * GetDataField(sal_uInt16 nDataFieldIdx) const
void ReadSxvd(XclImpStream &rStrm)
Reads an SXVD record describing a new field.
void ReadSxpi(XclImpStream &rStrm)
Reads an SXPI record containing page field data.
void ApplyMergeFlags(const ScRange &rOutRange, const ScDPSaveData &rSaveData)
std::vector< XclImpPTFieldRef > maFields
Access to global data from other classes.
This class is used to import record oriented streams.
Represents a field in a pivot cache.
Represents a data item of any type in a pivot cache.
Contains data for a pivot cache (SXDB record).
Additional pivot table settings (SXADDL record).
Contains data for a pivot table data field (SXDI record).
Extended information about a pivot table (SXEX record).
Contains extended data for a pivot table field (SXVDEX record).
Contains data for a pivot table field (SXVD record).
Contains data for a pivot table (SXVIEW record).
Contains data for a pivot table data item (SXVI record).
Contains data for a pivot table page field (part of SXPI record).
Pivot table autoformat settings (SXVIEWEX9 record).
std::shared_ptr< XclImpPTField > XclImpPTFieldRef
std::shared_ptr< XclImpPivotCache > XclImpPivotCacheRef
std::shared_ptr< XclImpPCField > XclImpPCFieldRef
std::shared_ptr< XclImpPTItem > XclImpPTItemRef
std::shared_ptr< XclImpPCItem > XclImpPCItemRef
std::shared_ptr< XclImpPivotTable > XclImpPivotTableRef