LibreOffice Module sc (master) 1
Public Member Functions | Private Attributes | List of all members
XclImpPivotTableManager Class Reference

The main class for pivot table import. More...

#include <xipivot.hxx>

Inheritance diagram for XclImpPivotTableManager:
[legend]
Collaboration diagram for XclImpPivotTableManager:
[legend]

Public Member Functions

 XclImpPivotTableManager (const XclImpRoot &rRoot)
 
virtual ~XclImpPivotTableManager () override
 
XclImpPivotCacheRef GetPivotCache (sal_uInt16 nCacheIdx)
 Returns the pivot cache with the specified 0-based index. More...
 
void ReadSxidstm (XclImpStream &rStrm)
 Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache. More...
 
void ReadSxvs (XclImpStream &rStrm)
 Reads an SXVS record containing the source type of a pivot cache. More...
 
void ReadDconref (XclImpStream &rStrm)
 Reads a DCONREF record containing the source range of a pivot cache. More...
 
void ReadDConName (XclImpStream &rStrm)
 
void ReadSxview (XclImpStream &rStrm)
 Reads an SXVIEW record describing a new pivot table. More...
 
void ReadSxvd (XclImpStream &rStrm)
 Reads an SXVD record describing a new field. More...
 
void ReadSxvdex (XclImpStream &rStrm)
 Reads an SXVDEX record describing extended options of a field. More...
 
void ReadSxivd (XclImpStream &rStrm)
 Reads an SXIVD record containing the row field or column field order. More...
 
void ReadSxpi (XclImpStream &rStrm)
 Reads an SXPI record containing page field data. More...
 
void ReadSxdi (XclImpStream &rStrm)
 Reads an SXDI record containing data field data. More...
 
void ReadSxvi (XclImpStream &rStrm)
 Reads an SXVI record describing a new item of the current field. More...
 
void ReadSxex (XclImpStream &rStrm)
 Reads an SXEX record containing additional settings for a pivot table. More...
 
void ReadSxViewEx9 (XclImpStream &rStrm)
 Reads an SXVIEWEX9 record that specifies the pivot tables autoformat. More...
 
void ReadSxAddl (XclImpStream &rStrm)
 Reads an SXADDL record that specifies additional info for pivot table. More...
 
void ReadPivotCaches (const XclImpStream &rStrm)
 Reads all used pivot caches and creates additional sheets for external data sources. More...
 
void ConvertPivotTables ()
 Inserts all pivot tables into the Calc document. More...
 
void MaybeRefreshPivotTables ()
 

Private Attributes

std::vector< XclImpPivotCacheRefmaPCaches
 
std::vector< XclImpPivotTableRefmaPTables
 List of all pivot caches. More...
 

Additional Inherited Members

- Protected Member Functions inherited from XclImpRoot
 XclImpRoot (XclImpRootData &rImpRootData)
 
const XclImpRootGetRoot () const
 Returns this root instance - for code readability in derived classes. More...
 
XclImpRootGetRoot ()
 
void SetCodePage (sal_uInt16 nCodePage)
 Sets a code page read from a CODEPAGE record for byte string import. More...
 
void InitializeTable (SCTAB nScTab)
 Is called when import filter starts importing a single sheet (all BIFF versions). More...
 
void FinalizeTable ()
 Is called when import filter stops importing a single sheet (all BIFF versions). More...
 
XclImpAddressConverterGetAddressConverter () const
 Returns the address converter. More...
 
XclImpFormulaCompilerGetFormulaCompiler () const
 Returns the formula converter. More...
 
ExcelToScGetOldFmlaConverter () const
 Returns the old formula converter. More...
 
XclImpSstGetSst () const
 Returns the shared string table. More...
 
XclImpPaletteGetPalette () const
 Returns the color buffer. More...
 
XclImpFontBufferGetFontBuffer () const
 Returns the font buffer. More...
 
XclImpNumFmtBufferGetNumFmtBuffer () const
 Returns the number format buffer. More...
 
XclImpXFBufferGetXFBuffer () const
 Returns the cell formatting attributes buffer. More...
 
XclImpXFRangeBufferGetXFRangeBuffer () const
 Returns the buffer of XF index ranges for a sheet. More...
 
ScRangeListTabsGetPrintAreaBuffer () const
 Returns the buffer that contains all print areas in the document. More...
 
ScRangeListTabsGetTitleAreaBuffer () const
 Returns the buffer that contains all print titles in the document. More...
 
XclImpTabInfoGetTabInfo () const
 Returns the buffer that contains the sheet creation order. More...
 
XclImpNameManagerGetNameManager () const
 Returns the buffer that contains internal defined names. More...
 
XclImpLinkManagerGetLinkManager () const
 Returns the link manager. More...
 
XclImpObjectManagerGetObjectManager () const
 Returns the drawing object manager. More...
 
XclImpSheetDrawingGetCurrSheetDrawing () const
 Returns the drawing container of the current sheet. More...
 
XclImpCondFormatManagerGetCondFormatManager () const
 Returns the conditional formatting manager. More...
 
XclImpValidationManagerGetValidationManager () const
 
XclImpAutoFilterBufferGetFilterManager () const
 Returns the filter manager. More...
 
XclImpWebQueryBufferGetWebQueryBuffer () const
 Returns the web query buffer. More...
 
XclImpPivotTableManagerGetPivotTableManager () const
 Returns the pivot table manager. More...
 
XclImpSheetProtectBufferGetSheetProtectBuffer () const
 Returns the sheet protection options of the current sheet. More...
 
XclImpDocProtectBufferGetDocProtectBuffer () const
 Returns the document protection options. More...
 
XclImpPageSettingsGetPageSettings () const
 Returns the page settings of the current sheet. More...
 
XclImpDocViewSettingsGetDocViewSettings () const
 Returns the view settings of the entire document. More...
 
XclImpTabViewSettingsGetTabViewSettings () const
 Returns the view settings of the current sheet. More...
 
bool HasBasic () const
 Returns true, if the document contains a VB project. More...
 
void SetHasBasic ()
 Called to indicate that the document contains a VB project. More...
 
void ReadCodeName (XclImpStream &rStrm, bool bGlobals)
 Reads the CODENAME record and inserts the codename into the document. More...
 
ScDocumentImportGetDocImport ()
 
- Protected Member Functions inherited from XclRoot
 XclRoot (XclRootData &rRootData)
 
 XclRoot (const XclRoot &rRoot)
 
virtual ~XclRoot ()
 
XclRootoperator= (const XclRoot &rRoot)
 
RootDataGetOldRoot () const
 Returns old RootData struct. More...
 
XclBiff GetBiff () const
 Returns the current BIFF version of the importer/exporter. More...
 
XclOutput GetOutput () const
 Returns the current output format of the importer/exporter. More...
 
bool IsImport () const
 Returns true, if currently a document is imported. More...
 
rtl_TextEncoding GetTextEncoding () const
 Returns the text encoding to import/export byte strings. More...
 
LanguageType GetSysLanguage () const
 Returns the system language, i.e. More...
 
LanguageType GetDocLanguage () const
 Returns the document language. More...
 
LanguageType GetUILanguage () const
 Returns the UI language. More...
 
sal_Int16 GetDefApiScript () const
 Returns the default script type, e.g. More...
 
tools::Long GetCharWidth () const
 Returns the width of the '0' character (default font) for the current printer (twips). More...
 
tools::Long GetSpaceWidth () const
 
bool IsInGlobals () const
 Returns the current Calc sheet index. More...
 
SCTAB GetCurrScTab () const
 Returns the current Calc sheet index. More...
 
sal_Int32 GetHmmFromPixelX (double fPixelX) const
 Calculates the width of the passed number of pixels in 1/100 mm. More...
 
sal_Int32 GetHmmFromPixelY (double fPixelY) const
 Calculates the height of the passed number of pixels in 1/100 mm. More...
 
SfxMediumGetMedium () const
 Returns the medium to import from. More...
 
const OUString & GetDocUrl () const
 Returns the document URL of the imported/exported file. More...
 
const OUString & GetBasePath () const
 Returns the base path of the imported/exported file. More...
 
const OUString & GetUserName () const
 Returns the current user name. More...
 
css::uno::Sequence< css::beans::NamedValue > RequestEncryptionData (::comphelper::IDocPasswordVerifier &rVerifier) const
 Requests and verifies a password from the medium or the user. More...
 
const tools::SvRef< SotStorage > & GetRootStorage () const
 Returns the OLE2 root storage of the imported/exported file. More...
 
bool HasVbaStorage () const
 Returns true, if the document contains a VBA storage. More...
 
tools::SvRef< SotStorageOpenStorage (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName) const
 Tries to open a storage as child of the specified storage for reading or writing. More...
 
tools::SvRef< SotStorageOpenStorage (const OUString &rStrgName) const
 Tries to open a storage as child of the root storage for reading or writing. More...
 
tools::SvRef< SotStorageStreamOpenStream (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName) const
 Tries to open a new stream in the specified storage for reading or writing. More...
 
tools::SvRef< SotStorageStreamOpenStream (const OUString &rStrmName) const
 Tries to open a new stream in the root storage for reading or writing. More...
 
ScDocumentGetDoc () const
 Returns reference to the destination document (import) or source document (export). More...
 
SfxObjectShellGetDocShell () const
 Returns the object shell of the Calc document. More...
 
ScModelObjGetDocModelObj () const
 Returns the object model of the Calc document. More...
 
OutputDeviceGetPrinter () const
 Returns pointer to the printer of the Calc document. More...
 
ScStyleSheetPoolGetStyleSheetPool () const
 Returns the style sheet pool of the Calc document. More...
 
ScRangeNameGetNamedRanges () const
 Returns the defined names container of the Calc document. More...
 
SdrPageGetSdrPage (SCTAB nScTab) const
 Returns the drawing layer page of the passed sheet, if present. More...
 
SvNumberFormatterGetFormatter () const
 Returns the number formatter of the Calc document. More...
 
DateTime GetNullDate () const
 Returns the null date of the current number formatter. More...
 
sal_uInt16 GetBaseYear () const
 Returns the base year depending on the current null date (1900 or 1904). More...
 
double GetDoubleFromDateTime (const DateTime &rDateTime) const
 Converts a date/time value to a floating-point value. More...
 
DateTime GetDateTimeFromDouble (double fValue) const
 Converts a floating-point value to a date/time value. More...
 
ScEditEngineDefaulterGetEditEngine () const
 Returns the edit engine for import/export of rich strings etc. More...
 
ScHeaderEditEngineGetHFEditEngine () const
 Returns the edit engine for import/export of headers/footers. More...
 
EditEngineGetDrawEditEngine () const
 Returns the edit engine for import/export of drawing text boxes. More...
 
XclFontPropSetHelperGetFontPropSetHelper () const
 Returns the property set helper for fonts. More...
 
XclChPropSetHelperGetChartPropSetHelper () const
 Returns the property set helper for the chart filters. More...
 
ScExtDocOptionsGetExtDocOptions () const
 Returns the extended document options. More...
 
XclTracerGetTracer () const
 Returns the filter tracer. More...
 
const ScAddressGetScMaxPos () const
 Returns the highest possible cell address in a Calc document. More...
 
const ScAddressGetXclMaxPos () const
 Returns the highest possible cell address in an Excel document (using current BIFF version). More...
 
const ScAddressGetMaxPos () const
 Returns the highest possible cell address valid in Calc and Excel (using current BIFF version). More...
 
void SetDocLanguage (LanguageType eLang)
 Sets the document language. More...
 
void SetUILanguage (LanguageType eLang)
 Sets the UI language, i.e. More...
 
void SetTextEncoding (rtl_TextEncoding eTextEnc)
 Sets the text encoding to import/export byte strings. More...
 
void SetCharWidth (const XclFontData &rFontData)
 Sets the width of the '0' - '9' digit character as well as the ' ' space char (using the default font) for the current printer (twips). More...
 
void SetCurrScTab (SCTAB nScTab)
 Sets the current Calc sheet index. More...
 
void IncCurrScTab ()
 Increases the current Calc sheet index by 1. More...
 
- Static Protected Member Functions inherited from XclImpRoot
static OUString GetScAddInName (const OUString &rXclName)
 Returns the Calc add-in function name for an Excel function name. More...
 
- Static Protected Member Functions inherited from XclRoot
static OUString GetDefaultPassword ()
 Returns the default password used for stream encryption. More...
 

Detailed Description

The main class for pivot table import.

This class contains functions to read all records related to pivot tables and pivot caches.

Definition at line 371 of file xipivot.hxx.

Constructor & Destructor Documentation

◆ XclImpPivotTableManager()

XclImpPivotTableManager::XclImpPivotTableManager ( const XclImpRoot rRoot)
explicit

Definition at line 1611 of file xipivot.cxx.

◆ ~XclImpPivotTableManager()

XclImpPivotTableManager::~XclImpPivotTableManager ( )
overridevirtual

Definition at line 1616 of file xipivot.cxx.

Member Function Documentation

◆ ConvertPivotTables()

void XclImpPivotTableManager::ConvertPivotTables ( )

Inserts all pivot tables into the Calc document.

Definition at line 1724 of file xipivot.cxx.

References maPTables.

Referenced by ImportExcel8::Read().

◆ GetPivotCache()

XclImpPivotCacheRef XclImpPivotTableManager::GetPivotCache ( sal_uInt16  nCacheIdx)

Returns the pivot cache with the specified 0-based index.

Definition at line 1622 of file xipivot.cxx.

References maPCaches.

Referenced by XclImpPivotTable::ReadSxview().

◆ MaybeRefreshPivotTables()

void XclImpPivotTableManager::MaybeRefreshPivotTables ( )

Definition at line 1730 of file xipivot.cxx.

References maPTables.

Referenced by ImportExcel8::Read().

◆ ReadDConName()

void XclImpPivotTableManager::ReadDConName ( XclImpStream rStrm)

Definition at line 1649 of file xipivot.cxx.

References maPCaches, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadDconref()

void XclImpPivotTableManager::ReadDconref ( XclImpStream rStrm)

Reads a DCONREF record containing the source range of a pivot cache.

Definition at line 1643 of file xipivot.cxx.

References maPCaches, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadPivotCaches()

void XclImpPivotTableManager::ReadPivotCaches ( const XclImpStream rStrm)

Reads all used pivot caches and creates additional sheets for external data sources.

Definition at line 1718 of file xipivot.cxx.

References maPCaches, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxAddl()

void XclImpPivotTableManager::ReadSxAddl ( XclImpStream rStrm)

Reads an SXADDL record that specifies additional info for pivot table.

Definition at line 1712 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxdi()

void XclImpPivotTableManager::ReadSxdi ( XclImpStream rStrm)

Reads an SXDI record containing data field data.

Definition at line 1688 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxex()

void XclImpPivotTableManager::ReadSxex ( XclImpStream rStrm)

Reads an SXEX record containing additional settings for a pivot table.

Definition at line 1700 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxidstm()

void XclImpPivotTableManager::ReadSxidstm ( XclImpStream rStrm)

Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache.

Definition at line 1630 of file xipivot.cxx.

References XclImpRoot::GetRoot(), maPCaches, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxivd()

void XclImpPivotTableManager::ReadSxivd ( XclImpStream rStrm)

Reads an SXIVD record containing the row field or column field order.

Definition at line 1676 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxpi()

void XclImpPivotTableManager::ReadSxpi ( XclImpStream rStrm)

Reads an SXPI record containing page field data.

Definition at line 1682 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxvd()

void XclImpPivotTableManager::ReadSxvd ( XclImpStream rStrm)

Reads an SXVD record describing a new field.

Definition at line 1664 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxvdex()

void XclImpPivotTableManager::ReadSxvdex ( XclImpStream rStrm)

Reads an SXVDEX record describing extended options of a field.

Definition at line 1670 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxvi()

void XclImpPivotTableManager::ReadSxvi ( XclImpStream rStrm)

Reads an SXVI record describing a new item of the current field.

Definition at line 1694 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxview()

void XclImpPivotTableManager::ReadSxview ( XclImpStream rStrm)

Reads an SXVIEW record describing a new pivot table.

Definition at line 1657 of file xipivot.cxx.

References XclImpRoot::GetRoot(), maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxViewEx9()

void XclImpPivotTableManager::ReadSxViewEx9 ( XclImpStream rStrm)

Reads an SXVIEWEX9 record that specifies the pivot tables autoformat.

Definition at line 1706 of file xipivot.cxx.

References maPTables, and rStrm.

Referenced by ImportExcel8::Read().

◆ ReadSxvs()

void XclImpPivotTableManager::ReadSxvs ( XclImpStream rStrm)

Reads an SXVS record containing the source type of a pivot cache.

Definition at line 1637 of file xipivot.cxx.

References maPCaches, and rStrm.

Referenced by ImportExcel8::Read().

Member Data Documentation

◆ maPCaches

std::vector< XclImpPivotCacheRef > XclImpPivotTableManager::maPCaches
private

◆ maPTables

std::vector< XclImpPivotTableRef > XclImpPivotTableManager::maPTables
private

The documentation for this class was generated from the following files: