#include <xipivot.hxx>
Public Member Functions | |
| XclImpPivotCache (const XclImpRoot &rRoot) | |
| virtual | ~XclImpPivotCache () override |
| const ScRange & | GetSourceRange () const |
| Returns the data source range read from the DCONREF record. More... | |
| const OUString & | GetSourceRangeName () const |
| const XclImpPCField * | GetField (sal_uInt16 nFieldIdx) const |
| Returns read-only access to a pivot cache field. 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 the pivot cache. More... | |
| void | ReadDconref (XclImpStream &rStrm) |
| Reads a DCONREF record containing the source range of the pivot cache. More... | |
| void | ReadDConName (XclImpStream &rStrm) |
| Read DECONNAME record which contains the defined name of the source range. More... | |
| void | ReadPivotCacheStream (const XclImpStream &rStrm) |
| Reads the entire pivot cache stream. More... | |
| bool | IsRefreshOnLoad () const |
| bool | IsValid () const |
Private Types | |
| typedef ::std::vector< XclImpPCFieldRef > | XclImpPCFieldVec |
Private Attributes | |
| XclPCInfo | maPCInfo |
| XclImpPCFieldVec | maFields |
| Pivot cache settings (SXDB record). More... | |
| ScRange | maSrcRange |
| List of pivot cache fields. More... | |
| OUString | maUrl |
| Source range in the spreadsheet. More... | |
| OUString | maTabName |
| URL of the source data. More... | |
| OUString | maSrcRangeName |
| Sheet name of the source data. More... | |
| sal_uInt16 | mnStrmId |
| Name of the source data range. More... | |
| sal_uInt16 | mnSrcType |
| Pivot cache stream identifier. More... | |
| bool | mbSelfRef |
| Source data type. More... | |
Additional Inherited Members | |
 Protected Member Functions inherited from XclImpRoot | |
| XclImpRoot (XclImpRootData &rImpRootData) | |
| const XclImpRoot & | GetRoot () const |
| Returns this root instance - for code readability in derived classes. More... | |
| XclImpRoot & | GetRoot () |
| 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... | |
| XclImpAddressConverter & | GetAddressConverter () const |
| Returns the address converter. More... | |
| XclImpFormulaCompiler & | GetFormulaCompiler () const |
| Returns the formula converter. More... | |
| ExcelToSc & | GetOldFmlaConverter () const |
| Returns the old formula converter. More... | |
| XclImpSst & | GetSst () const |
| Returns the shared string table. More... | |
| XclImpPalette & | GetPalette () const |
| Returns the color buffer. More... | |
| XclImpFontBuffer & | GetFontBuffer () const |
| Returns the font buffer. More... | |
| XclImpNumFmtBuffer & | GetNumFmtBuffer () const |
| Returns the number format buffer. More... | |
| XclImpXFBuffer & | GetXFBuffer () const |
| Returns the cell formatting attributes buffer. More... | |
| XclImpXFRangeBuffer & | GetXFRangeBuffer () const |
| Returns the buffer of XF index ranges for a sheet. More... | |
| ScRangeListTabs & | GetPrintAreaBuffer () const |
| Returns the buffer that contains all print areas in the document. More... | |
| ScRangeListTabs & | GetTitleAreaBuffer () const |
| Returns the buffer that contains all print titles in the document. More... | |
| XclImpTabInfo & | GetTabInfo () const |
| Returns the buffer that contains the sheet creation order. More... | |
| XclImpNameManager & | GetNameManager () const |
| Returns the buffer that contains internal defined names. More... | |
| XclImpLinkManager & | GetLinkManager () const |
| Returns the link manager. More... | |
| XclImpObjectManager & | GetObjectManager () const |
| Returns the drawing object manager. More... | |
| XclImpSheetDrawing & | GetCurrSheetDrawing () const |
| Returns the drawing container of the current sheet. More... | |
| XclImpCondFormatManager & | GetCondFormatManager () const |
| Returns the conditional formatting manager. More... | |
| XclImpValidationManager & | GetValidationManager () const |
| XclImpAutoFilterBuffer & | GetFilterManager () const |
| Returns the filter manager. More... | |
| XclImpWebQueryBuffer & | GetWebQueryBuffer () const |
| Returns the web query buffer. More... | |
| XclImpPivotTableManager & | GetPivotTableManager () const |
| Returns the pivot table manager. More... | |
| XclImpSheetProtectBuffer & | GetSheetProtectBuffer () const |
| Returns the sheet protection options of the current sheet. More... | |
| XclImpDocProtectBuffer & | GetDocProtectBuffer () const |
| Returns the document protection options. More... | |
| XclImpPageSettings & | GetPageSettings () const |
| Returns the page settings of the current sheet. More... | |
| XclImpDocViewSettings & | GetDocViewSettings () const |
| Returns the view settings of the entire document. More... | |
| XclImpTabViewSettings & | GetTabViewSettings () 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... | |
| ScDocumentImport & | GetDocImport () |
| Protected Member Functions inherited from XclRoot | |
| XclRoot (XclRootData &rRootData) | |
| XclRoot (const XclRoot &rRoot) | |
| virtual | ~XclRoot () |
| XclRoot & | operator= (const XclRoot &rRoot) |
| RootData & | GetOldRoot () 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... | |
| SfxMedium & | GetMedium () 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< SotStorage > | OpenStorage (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< SotStorage > | OpenStorage (const OUString &rStrgName) const |
| Tries to open a storage as child of the root storage for reading or writing. More... | |
| tools::SvRef< SotStorageStream > | OpenStream (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< SotStorageStream > | OpenStream (const OUString &rStrmName) const |
| Tries to open a new stream in the root storage for reading or writing. More... | |
| ScDocument & | GetDoc () const |
| Returns reference to the destination document (import) or source document (export). More... | |
| SfxObjectShell * | GetDocShell () const |
| Returns the object shell of the Calc document. More... | |
| ScModelObj * | GetDocModelObj () const |
| Returns the object model of the Calc document. More... | |
| OutputDevice * | GetPrinter () const |
| Returns pointer to the printer of the Calc document. More... | |
| ScStyleSheetPool & | GetStyleSheetPool () const |
| Returns the style sheet pool of the Calc document. More... | |
| ScRangeName & | GetNamedRanges () const |
| Returns the defined names container of the Calc document. More... | |
| SdrPage * | GetSdrPage (SCTAB nScTab) const |
| Returns the drawing layer page of the passed sheet, if present. More... | |
| SvNumberFormatter & | GetFormatter () 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... | |
| ScEditEngineDefaulter & | GetEditEngine () const |
| Returns the edit engine for import/export of rich strings etc. More... | |
| ScHeaderEditEngine & | GetHFEditEngine () const |
| Returns the edit engine for import/export of headers/footers. More... | |
| EditEngine & | GetDrawEditEngine () const |
| Returns the edit engine for import/export of drawing text boxes. More... | |
| XclFontPropSetHelper & | GetFontPropSetHelper () const |
| Returns the property set helper for fonts. More... | |
| XclChPropSetHelper & | GetChartPropSetHelper () const |
| Returns the property set helper for the chart filters. More... | |
| ScExtDocOptions & | GetExtDocOptions () const |
| Returns the extended document options. More... | |
| XclTracer & | GetTracer () const |
| Returns the filter tracer. More... | |
| const ScAddress & | GetScMaxPos () const |
| Returns the highest possible cell address in a Calc document. More... | |
| const ScAddress & | GetXclMaxPos () const |
| Returns the highest possible cell address in an Excel document (using current BIFF version). More... | |
| const ScAddress & | GetMaxPos () 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 142 of file xipivot.hxx.
Member Typedef Documentation
◆ XclImpPCFieldVec
|
private |
Definition at line 178 of file xipivot.hxx.
Constructor & Destructor Documentation
◆ XclImpPivotCache()
|
explicit |
Definition at line 589 of file xipivot.cxx.
◆ ~XclImpPivotCache()
|
overridevirtual |
Definition at line 598 of file xipivot.cxx.
Member Function Documentation
◆ GetField()
| const XclImpPCField * XclImpPivotCache::GetField | ( | sal_uInt16 | nFieldIdx | ) | const |
Returns read-only access to a pivot cache field.
Definition at line 604 of file xipivot.cxx.
References maFields.
Referenced by XclImpPCField::GetGroupBaseField().
◆ GetSourceRange()
|
inline |
Returns the data source range read from the DCONREF record.
Definition at line 151 of file xipivot.hxx.
References maSrcRange.
◆ GetSourceRangeName()
|
inline |
Definition at line 153 of file xipivot.hxx.
References maSrcRangeName.
◆ IsRefreshOnLoad()
| bool XclImpPivotCache::IsRefreshOnLoad | ( | ) | const |
Definition at line 862 of file xipivot.cxx.
References EXC_SXDB_REFRESH_LOAD, maPCInfo, and XclPCInfo::mnFlags.
◆ IsValid()
| bool XclImpPivotCache::IsValid | ( | ) | const |
Definition at line 867 of file xipivot.cxx.
References ScRange::IsValid(), maSrcRange, and maSrcRangeName.
◆ ReadDConName()
| void XclImpPivotCache::ReadDConName | ( | XclImpStream & | rStrm | ) |
Read DECONNAME record which contains the defined name of the source range.
Definition at line 644 of file xipivot.cxx.
References maSrcRangeName, mbSelfRef, and rStrm.
◆ ReadDconref()
| void XclImpPivotCache::ReadDconref | ( | XclImpStream & | rStrm | ) |
Reads a DCONREF record containing the source range of the pivot cache.
Definition at line 622 of file xipivot.cxx.
References XclImpAddressConverter::ConvertRange(), XclImpUrlHelper::DecodeUrl(), EXC_SXVS_SHEET, XclImpRoot::GetAddressConverter(), XclImpRoot::GetRoot(), maSrcRange, maTabName, maUrl, mbSelfRef, mnSrcType, XclRange::Read(), rStrm, and ScAddress::UNINITIALIZED.
◆ ReadPivotCacheStream()
| void XclImpPivotCache::ReadPivotCacheStream | ( | const XclImpStream & | rStrm | ) |
Reads the entire pivot cache stream.
Uses decrypter from passed stream.
Definition at line 660 of file xipivot.cxx.
References ScRange::aEnd, aName, ScRange::aStart, XclImpStream::CopyDecrypterFrom(), ScDocument::CreateValidTabName(), EXC_ID_00F5, EXC_ID_EOF, EXC_ID_SXBOOLEAN, EXC_ID_SXDATETIME, EXC_ID_SXDB, EXC_ID_SXDBEX, EXC_ID_SXDOUBLE, EXC_ID_SXEMPTY, EXC_ID_SXERROR, EXC_ID_SXFDBTYPE, EXC_ID_SXFIELD, EXC_ID_SXFILT, EXC_ID_SXFMLA, EXC_ID_SXFORMULA, EXC_ID_SXGROUPINFO, EXC_ID_SXINDEXLIST, EXC_ID_SXINTEGER, EXC_ID_SXNAME, EXC_ID_SXNUMGROUP, EXC_ID_SXPAIR, EXC_ID_SXRULE, EXC_ID_SXSTRING, EXC_PC_MAXFIELDCOUNT, EXC_STORAGE_PTCACHE, EXC_SXDB_SAVEDATA, EXC_SXVS_EXTERN, EXC_SXVS_SHEET, XclRoot::GetDoc(), ScfTools::GetHexStr(), XclImpStream::GetRecId(), XclImpRoot::GetRoot(), XclImpTabInfo::GetScTabFromXclName(), XclImpRoot::GetTabInfo(), ScDocument::GetTableCount(), ScDocument::HasTable(), tools::SvRef< typename T >::is(), maFields, ScDocument::MakeTable(), maPCInfo, maSrcRange, maSrcRangeName, maTabName, ScDocument::MaxCol(), ScDocument::MaxRow(), MAXTABCOUNT, mbSelfRef, XclPCInfo::mnFlags, XclPCInfo::mnSrcRecs, mnSrcType, mnStrmId, XclPCInfo::mnTotalFields, XclRoot::OpenStorage(), XclRoot::OpenStream(), XclImpStream::ReaduInt16(), XclImpStream::ReaduInt8(), ScDocument::RenameTab(), ScAddress::Row(), rStrm, SAL_WARN, ScAddress::SetCol(), ScAddress::SetRow(), ScAddress::SetTab(), and XclImpStream::StartNextRecord().
◆ ReadSxidstm()
| void XclImpPivotCache::ReadSxidstm | ( | XclImpStream & | rStrm | ) |
Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache.
Definition at line 611 of file xipivot.cxx.
◆ ReadSxvs()
| void XclImpPivotCache::ReadSxvs | ( | XclImpStream & | rStrm | ) |
Reads an SXVS record containing the source type of the pivot cache.
Definition at line 616 of file xipivot.cxx.
References EXC_SXVS_SHEET, XclRoot::GetTracer(), mnSrcType, rStrm, and XclTracer::TracePivotDataSource().
Member Data Documentation
◆ maFields
|
private |
Pivot cache settings (SXDB record).
Definition at line 181 of file xipivot.hxx.
Referenced by GetField(), and ReadPivotCacheStream().
◆ maPCInfo
|
private |
Definition at line 180 of file xipivot.hxx.
Referenced by IsRefreshOnLoad(), and ReadPivotCacheStream().
◆ maSrcRange
|
private |
List of pivot cache fields.
Definition at line 182 of file xipivot.hxx.
Referenced by GetSourceRange(), IsValid(), ReadDconref(), and ReadPivotCacheStream().
◆ maSrcRangeName
|
private |
Sheet name of the source data.
Definition at line 185 of file xipivot.hxx.
Referenced by GetSourceRangeName(), IsValid(), ReadDConName(), and ReadPivotCacheStream().
◆ maTabName
|
private |
URL of the source data.
Definition at line 184 of file xipivot.hxx.
Referenced by ReadDconref(), and ReadPivotCacheStream().
◆ maUrl
|
private |
Source range in the spreadsheet.
Definition at line 183 of file xipivot.hxx.
Referenced by ReadDconref().
◆ mbSelfRef
|
private |
Source data type.
Definition at line 188 of file xipivot.hxx.
Referenced by ReadDConName(), ReadDconref(), and ReadPivotCacheStream().
◆ mnSrcType
|
private |
Pivot cache stream identifier.
Definition at line 187 of file xipivot.hxx.
Referenced by ReadDconref(), ReadPivotCacheStream(), and ReadSxvs().
◆ mnStrmId
|
private |
Name of the source data range.
Definition at line 186 of file xipivot.hxx.
Referenced by ReadPivotCacheStream(), and ReadSxidstm().
The documentation for this class was generated from the following files:
