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

#include <xipivot.hxx>

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

Public Member Functions

 XclImpPivotTable (const XclImpRoot &rRoot)
 
virtual ~XclImpPivotTable () override
 
const XclImpPivotCacheRefGetPivotCache () const
 
const ScfStringVecGetVisFieldNames () const
 
sal_uInt16 GetFieldCount () const
 
const XclImpPTFieldGetField (sal_uInt16 nFieldIdx) const
 
XclImpPTFieldGetFieldAcc (sal_uInt16 nFieldIdx)
 
const XclImpPTFieldGetDataField (sal_uInt16 nDataFieldIdx) const
 
OUString GetDataFieldName (sal_uInt16 nDataFieldIdx) const
 
void ReadSxview (XclImpStream &rStrm)
 Reads an SXVIEW record starting a new pivot table. More...
 
void ReadSxvd (XclImpStream &rStrm)
 Reads an SXVD record describing a new field. More...
 
void ReadSxvi (XclImpStream &rStrm)
 Reads an SXVI record describing a new item of the current field. More...
 
void ReadSxvdex (XclImpStream &rStrm)
 Reads an SXVDEX record describing extended options of the current 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 ReadSxex (XclImpStream &rStrm)
 Reads an SXEX record containing additional settings for the 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 Convert ()
 Inserts the pivot table into the Calc document. More...
 
void MaybeRefresh ()
 
void ApplyMergeFlags (const ScRange &rOutRange, const ScDPSaveData &rSaveData)
 
void ApplyFieldInfo ()
 

Private Attributes

XclImpPivotCacheRef mxPCache
 
XclPTInfo maPTInfo
 Pivot cache containing field/item names. More...
 
XclPTExtInfo maPTExtInfo
 General info about the pivot table (SXVIEW record). More...
 
XclPTViewEx9Info maPTViewEx9Info
 Extended info about the pivot table (SXEX record). More...
 
XclPTAddl maPTAddlInfo
 (SXVIEWEX9 record) More...
 
std::vector< XclImpPTFieldRefmaFields
 
XclImpPTFieldRef mxCurrField
 Vector containing all fields. More...
 
ScfStringVec maVisFieldNames
 Current field for importing additional info. More...
 
ScfUInt16Vec maRowFields
 Vector containing all visible field names. More...
 
ScfUInt16Vec maColFields
 Row field indexes. More...
 
ScfUInt16Vec maPageFields
 Column field indexes. More...
 
ScfUInt16Vec maOrigDataFields
 Page field indexes. More...
 
ScfUInt16Vec maFiltDataFields
 Original data field indexes. More...
 
XclImpPTField maDataOrientField
 Filtered data field indexes. More...
 
ScRange maOutScRange
 Special data field orientation field. More...
 
ScDPObjectmpDPObj
 Output range in the Calc document. 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

Definition at line 292 of file xipivot.hxx.

Constructor & Destructor Documentation

◆ XclImpPivotTable()

XclImpPivotTable::XclImpPivotTable ( const XclImpRoot rRoot)
explicit

Definition at line 1241 of file xipivot.cxx.

◆ ~XclImpPivotTable()

XclImpPivotTable::~XclImpPivotTable ( )
overridevirtual

Definition at line 1248 of file xipivot.cxx.

Member Function Documentation

◆ ApplyFieldInfo()

void XclImpPivotTable::ApplyFieldInfo ( )

◆ ApplyMergeFlags()

void XclImpPivotTable::ApplyMergeFlags ( const ScRange rOutRange,
const ScDPSaveData rSaveData 
)

◆ Convert()

void XclImpPivotTable::Convert ( )

◆ GetDataField()

const XclImpPTField * XclImpPivotTable::GetDataField ( sal_uInt16  nDataFieldIdx) const

Definition at line 1271 of file xipivot.cxx.

References GetField(), and maOrigDataFields.

Referenced by GetDataFieldName().

◆ GetDataFieldName()

OUString XclImpPivotTable::GetDataFieldName ( sal_uInt16  nDataFieldIdx) const

Definition at line 1278 of file xipivot.cxx.

References GetDataField().

Referenced by XclImpPTField::ConvertRCPField().

◆ GetField()

const XclImpPTField * XclImpPivotTable::GetField ( sal_uInt16  nFieldIdx) const

◆ GetFieldAcc()

XclImpPTField * XclImpPivotTable::GetFieldAcc ( sal_uInt16  nFieldIdx)

Definition at line 1265 of file xipivot.cxx.

References maFields.

Referenced by ReadSxdi(), and ReadSxpi().

◆ GetFieldCount()

sal_uInt16 XclImpPivotTable::GetFieldCount ( ) const

Definition at line 1254 of file xipivot.cxx.

References maFields.

Referenced by ApplyFieldInfo(), Convert(), and ReadSxvd().

◆ GetPivotCache()

const XclImpPivotCacheRef & XclImpPivotTable::GetPivotCache ( ) const
inline

Definition at line 300 of file xipivot.hxx.

References mxPCache.

Referenced by XclImpPTField::GetCacheField().

◆ GetVisFieldNames()

const ScfStringVec & XclImpPivotTable::GetVisFieldNames ( ) const
inline

Definition at line 301 of file xipivot.hxx.

References maVisFieldNames.

Referenced by XclImpPTField::ConvertRCPField(), and XclImpPTField::GetFieldName().

◆ MaybeRefresh()

void XclImpPivotTable::MaybeRefresh ( )

◆ ReadSxAddl()

void XclImpPivotTable::ReadSxAddl ( XclImpStream rStrm)

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

Definition at line 1404 of file xipivot.cxx.

References maPTAddlInfo, and rStrm.

◆ ReadSxdi()

void XclImpPivotTable::ReadSxdi ( XclImpStream rStrm)

Reads an SXDI record containing data field data.

Definition at line 1378 of file xipivot.cxx.

References GetFieldAcc(), maFiltDataFields, maOrigDataFields, XclPTDataFieldInfo::mnField, mxCurrField, and rStrm.

◆ ReadSxex()

void XclImpPivotTable::ReadSxex ( XclImpStream rStrm)

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

Definition at line 1394 of file xipivot.cxx.

References maPTExtInfo, and rStrm.

◆ ReadSxivd()

void XclImpPivotTable::ReadSxivd ( XclImpStream rStrm)

◆ ReadSxpi()

void XclImpPivotTable::ReadSxpi ( XclImpStream rStrm)

◆ ReadSxvd()

void XclImpPivotTable::ReadSxvd ( XclImpStream rStrm)

Reads an SXVD record describing a new field.

Definition at line 1298 of file xipivot.cxx.

References EXC_PT_MAXFIELDCOUNT, GetFieldCount(), maFields, maVisFieldNames, mxCurrField, and rStrm.

◆ ReadSxvdex()

void XclImpPivotTable::ReadSxvdex ( XclImpStream rStrm)

Reads an SXVDEX record describing extended options of the current field.

Definition at line 1322 of file xipivot.cxx.

References mxCurrField, and rStrm.

◆ ReadSxvi()

void XclImpPivotTable::ReadSxvi ( XclImpStream rStrm)

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

Definition at line 1316 of file xipivot.cxx.

References mxCurrField, and rStrm.

◆ ReadSxview()

void XclImpPivotTable::ReadSxview ( XclImpStream rStrm)

◆ ReadSxViewEx9()

void XclImpPivotTable::ReadSxViewEx9 ( XclImpStream rStrm)

Reads an SXVIEWEX9 record that specifies the pivot tables autoformat.

Definition at line 1399 of file xipivot.cxx.

References maPTViewEx9Info, and rStrm.

Member Data Documentation

◆ maColFields

ScfUInt16Vec XclImpPivotTable::maColFields
private

Row field indexes.

Definition at line 355 of file xipivot.hxx.

Referenced by ApplyFieldInfo(), Convert(), and ReadSxivd().

◆ maDataOrientField

XclImpPTField XclImpPivotTable::maDataOrientField
private

Filtered data field indexes.

Definition at line 359 of file xipivot.hxx.

Referenced by GetField(), and ReadSxivd().

◆ maFields

std::vector< XclImpPTFieldRef > XclImpPivotTable::maFields
private

Definition at line 351 of file xipivot.hxx.

Referenced by GetField(), GetFieldAcc(), GetFieldCount(), and ReadSxvd().

◆ maFiltDataFields

ScfUInt16Vec XclImpPivotTable::maFiltDataFields
private

Original data field indexes.

Definition at line 358 of file xipivot.hxx.

Referenced by Convert(), and ReadSxdi().

◆ maOrigDataFields

ScfUInt16Vec XclImpPivotTable::maOrigDataFields
private

Page field indexes.

Definition at line 357 of file xipivot.hxx.

Referenced by GetDataField(), and ReadSxdi().

◆ maOutScRange

ScRange XclImpPivotTable::maOutScRange
private

Special data field orientation field.

Definition at line 360 of file xipivot.hxx.

Referenced by Convert(), and ReadSxview().

◆ maPageFields

ScfUInt16Vec XclImpPivotTable::maPageFields
private

Column field indexes.

Definition at line 356 of file xipivot.hxx.

Referenced by ApplyFieldInfo(), Convert(), and ReadSxpi().

◆ maPTAddlInfo

XclPTAddl XclImpPivotTable::maPTAddlInfo
private

(SXVIEWEX9 record)

Definition at line 349 of file xipivot.hxx.

Referenced by ApplyMergeFlags(), and ReadSxAddl().

◆ maPTExtInfo

XclPTExtInfo XclImpPivotTable::maPTExtInfo
private

General info about the pivot table (SXVIEW record).

Definition at line 347 of file xipivot.hxx.

Referenced by Convert(), and ReadSxex().

◆ maPTInfo

XclPTInfo XclImpPivotTable::maPTInfo
private

Pivot cache containing field/item names.

Definition at line 346 of file xipivot.hxx.

Referenced by ApplyMergeFlags(), Convert(), ReadSxivd(), and ReadSxview().

◆ maPTViewEx9Info

XclPTViewEx9Info XclImpPivotTable::maPTViewEx9Info
private

Extended info about the pivot table (SXEX record).

Definition at line 348 of file xipivot.hxx.

Referenced by Convert(), and ReadSxViewEx9().

◆ maRowFields

ScfUInt16Vec XclImpPivotTable::maRowFields
private

Vector containing all visible field names.

Definition at line 354 of file xipivot.hxx.

Referenced by ApplyFieldInfo(), Convert(), and ReadSxivd().

◆ maVisFieldNames

ScfStringVec XclImpPivotTable::maVisFieldNames
private

Current field for importing additional info.

Definition at line 353 of file xipivot.hxx.

Referenced by GetVisFieldNames(), and ReadSxvd().

◆ mpDPObj

ScDPObject* XclImpPivotTable::mpDPObj
private

Output range in the Calc document.

Definition at line 361 of file xipivot.hxx.

Referenced by ApplyFieldInfo(), ApplyMergeFlags(), Convert(), and MaybeRefresh().

◆ mxCurrField

XclImpPTFieldRef XclImpPivotTable::mxCurrField
private

Vector containing all fields.

Definition at line 352 of file xipivot.hxx.

Referenced by ReadSxdi(), ReadSxivd(), ReadSxpi(), ReadSxvd(), ReadSxvdex(), ReadSxvi(), and ReadSxview().

◆ mxPCache

XclImpPivotCacheRef XclImpPivotTable::mxPCache
private

Definition at line 344 of file xipivot.hxx.

Referenced by Convert(), GetPivotCache(), MaybeRefresh(), and ReadSxview().


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