#include <querytablebuffer.hxx>
Public Member Functions | |
| QueryTable (const WorksheetHelper &rHelper) | |
| void | importQueryTable (const AttributeList &rAttribs) |
| Imports query table settings from the queryTable element. More... | |
| void | importQueryTable (SequenceInputStream &rStrm) |
| Imports query table settings from the QUERYTABLE record. More... | |
| void | finalizeImport () |
| Inserts a web query into the sheet. More... | |
 Public Member Functions inherited from oox::xls::WorksheetHelper | |
| WorksheetHelper (WorksheetGlobals &rSheetGlob) | |
| WorksheetType | getSheetType () const |
| Returns the type of this sheet. More... | |
| SCTAB | getSheetIndex () const |
| Returns the index of the current sheet. More... | |
| const css::uno::Reference< css::sheet::XSpreadsheet > & | getSheet () const |
| Returns the XSpreadsheet interface of the current sheet. More... | |
| css::uno::Reference< css::table::XCell > | getCell (const ScAddress &rAddress) const |
| Returns the XCell interface for the passed cell address. More... | |
| css::uno::Reference< css::table::XCellRange > | getCellRange (const ScRange &rRange) const |
| Returns the XCellRange interface for the passed cell range address. More... | |
| css::uno::Reference< css::drawing::XDrawPage > | getDrawPage () const |
| Returns the XDrawPage interface of the draw page of the current sheet. More... | |
| css::awt::Point | getCellPosition (sal_Int32 nCol, sal_Int32 nRow) const |
| Returns the absolute cell position in 1/100 mm. More... | |
| const css::awt::Size & | getDrawPageSize () const |
| Returns the size of the entire drawing page in 1/100 mm. More... | |
| SheetDataBuffer & | getSheetData () const |
| Returns the buffer for cell contents and cell formatting. More... | |
| CondFormatBuffer & | getCondFormats () const |
| Returns the conditional formatting in this sheet. More... | |
| CommentsBuffer & | getComments () const |
| Returns the buffer for all cell comments in this sheet. More... | |
| AutoFilterBuffer & | getAutoFilters () const |
| Returns the auto filters for the sheet. More... | |
| QueryTableBuffer & | getQueryTables () const |
| Returns the buffer for all web query tables in this sheet. More... | |
| WorksheetSettings & | getWorksheetSettings () const |
| Returns the worksheet settings object. More... | |
| PageSettings & | getPageSettings () const |
| Returns the page/print settings for this sheet. More... | |
| SheetViewSettings & | getSheetViewSettings () const |
| Returns the view settings for this sheet. More... | |
| VmlDrawing & | getVmlDrawing () const |
| Returns the VML drawing page for this sheet (OOXML/BIFF12 only). More... | |
| ExtLst & | getExtLst () const |
| void | setPageBreak (const PageBreakModel &rModel, bool bRowBreak) |
| Sets a column or row page break described in the passed struct. More... | |
| void | setHyperlink (const HyperlinkModel &rModel) |
| Inserts the hyperlink URL into the spreadsheet. More... | |
| void | setValidation (const ValidationModel &rModel) |
| Inserts the data validation settings into the spreadsheet. More... | |
| void | setDrawingPath (const OUString &rDrawingPath) |
| Sets the path to the DrawingML fragment of this sheet. More... | |
| void | setVmlDrawingPath (const OUString &rVmlDrawingPath) |
| Sets the path to the legacy VML drawing fragment of this sheet. More... | |
| void | extendUsedArea (const ScAddress &rAddress) |
| Extends the used area of this sheet by the passed cell position. More... | |
| void | extendUsedArea (const ScRange &rRange) |
| Extends the used area of this sheet by the passed cell range. More... | |
| void | extendShapeBoundingBox (const css::awt::Rectangle &rShapeRect) |
| Extends the shape bounding box by the position and size of the passed rectangle (in 1/100 mm). More... | |
| void | setBaseColumnWidth (sal_Int32 nWidth) |
| Sets base width for all columns (without padding pixels). More... | |
| void | setDefaultColumnWidth (double fWidth) |
| Sets default width for all columns. More... | |
| void | setColumnModel (const ColumnModel &rModel) |
| Sets column settings for a specific range of columns. More... | |
| void | setDefaultRowSettings (double fHeight, bool bCustomHeight, bool bHidden, bool bThickTop, bool bThickBottom) |
| Sets default height and hidden state for all unused rows in the sheet. More... | |
| void | setRowModel (const RowModel &rModel) |
| Sets row settings for a specific range of rows. More... | |
| void | putRichString (const ScAddress &rAddress, RichString &rString, const oox::xls::Font *pFirstPortionFont, bool bSingleLine=false) |
| Inserts a rich-string cell directly into the Calc sheet. More... | |
| void | putFormulaTokens (const ScAddress &rAddress, const ApiTokenSequence &rTokens) |
| Inserts a formula cell directly into the Calc sheet. More... | |
| void | initializeWorksheetImport () |
| Initial conversion before importing the worksheet. More... | |
| void | finalizeWorksheetImport () |
| Final conversion after importing the worksheet. More... | |
| void | finalizeDrawingImport () |
| Final import of drawing objects. More... | |
| void | setCellFormula (const ScAddress &rTokenAddress, const OUString &) |
| void | setCellFormula (const ScAddress &rAddr, sal_Int32 nSharedId, const OUString &rCellValue, sal_Int32 nValueType) |
| void | setCellArrayFormula (const ScRange &rRangeAddress, const ScAddress &rTokenAddress, const OUString &rTokenStr) |
| void | createSharedFormulaMapEntry (const ScAddress &rAddress, sal_Int32 nSharedId, const OUString &rTokens) |
| void | setCellFormulaValue (const ScAddress &rAddress, const OUString &rValueStr, sal_Int32 nCellType) |
| ScDocument & | getScDocument () |
| Public Member Functions inherited from oox::xls::WorkbookHelper | |
| WorkbookHelper (WorkbookGlobals &rBookGlob) | |
| virtual | ~WorkbookHelper () |
| WorkbookHelper (WorkbookHelper const &)=default | |
| WorkbookHelper (WorkbookHelper &&)=default | |
| WorkbookHelper & | operator= (WorkbookHelper const &)=delete |
| WorkbookHelper & | operator= (WorkbookHelper &&)=delete |
| ::oox::core::FilterBase & | getBaseFilter () const |
| Returns the base filter object (base class of all filters). More... | |
| SegmentProgressBar & | getProgressBar () const |
| Returns the filter progress bar. More... | |
| sal_Int16 | getCurrentSheetIndex () const |
| Returns the index of the current Calc sheet, if filter currently processes a sheet. More... | |
| bool | isGeneratorKnownGood () const |
| Returns true when reading a file generated by a known good generator. More... | |
| bool | hasCalculatedFormulaCells () const |
| Returns true if any formula cell is calculated. More... | |
| void | setCalculatedFormulaCells () |
| Set if any formula cell is calculated. More... | |
| void | setVbaProjectStorage (const StorageRef &rxVbaPrjStrg) |
| Sets the VBA project storage used to import VBA source code and forms. More... | |
| void | setCurrentSheetIndex (SCTAB nSheet) |
| Sets the index of the current Calc sheet, if filter currently processes a sheet. More... | |
| void | finalizeWorkbookImport () |
| Final conversion after importing the workbook. More... | |
| void | useInternalChartDataTable (bool bInternal) |
| ScDocument & | getScDocument () |
| const ScDocument & | getScDocument () const |
| ScDocumentImport & | getDocImport () |
| const ScDocumentImport & | getDocImport () const |
| ScEditEngineDefaulter & | getEditEngine () const |
| const css::uno::Reference< css::sheet::XSpreadsheetDocument > & | getDocument () const |
| Returns a reference to the source/target spreadsheet document model. More... | |
| css::uno::Reference< css::sheet::XSpreadsheet > | getSheetFromDoc (sal_Int32 nSheet) const |
| Returns a reference to the specified spreadsheet in the document model. More... | |
| css::uno::Reference< css::sheet::XSpreadsheet > | getSheetFromDoc (const OUString &rSheet) const |
| Returns a reference to the specified spreadsheet in the document model. More... | |
| css::uno::Reference< css::table::XCellRange > | getCellRangeFromDoc (const ScRange &rRange) const |
| Returns the XCellRange interface for the passed cell range address. More... | |
| css::uno::Reference< css::container::XNameContainer > | getCellStyleFamily () const |
| Returns the cell styles container from the Calc document. More... | |
| css::uno::Reference< css::style::XStyle > | getStyleObject (const OUString &rStyleName, bool bPageStyle) const |
| Returns the specified cell or page style from the Calc document. More... | |
| RangeDataRet | createNamedRangeObject (OUString &orName, sal_Int32 nIndex, sal_Int32 nNameFlags, bool bHidden) const |
| Creates and returns a defined name on-the-fly in the Calc document. More... | |
| RangeDataRet | createLocalNamedRangeObject (OUString &orName, sal_Int32 nIndex, sal_Int32 nNameFlags, sal_Int32 nTab, bool bHidden) const |
| Creates and returns a defined name on-the-fly in the sheet. More... | |
| css::uno::Reference< css::sheet::XDatabaseRange > | createDatabaseRangeObject (OUString &orName, const ScRange &rRangeAddr) const |
| Creates and returns a database range on-the-fly in the Calc document. More... | |
| css::uno::Reference< css::sheet::XDatabaseRange > | createUnnamedDatabaseRangeObject (const ScRange &rRangeAddr) const |
| Creates and returns an unnamed database range on-the-fly in the Calc document. More... | |
| ScDBData * | findDatabaseRangeByIndex (sal_uInt16 nIndex) const |
| Finds the (already existing) database range of the given formula token index. More... | |
| css::uno::Reference< css::style::XStyle > | createStyleObject (OUString &orStyleName, bool bPageStyle) const |
| Creates and returns a com.sun.star.style.Style object for cells or pages. More... | |
| FormulaBuffer & | getFormulaBuffer () const |
| WorkbookSettings & | getWorkbookSettings () const |
| Returns the global workbook settings object. More... | |
| ViewSettings & | getViewSettings () const |
| Returns the workbook and sheet view settings object. More... | |
| WorksheetBuffer & | getWorksheets () const |
| Returns the worksheet buffer containing sheet names and properties. More... | |
| ThemeBuffer & | getTheme () const |
| Returns the office theme object read from the theme substorage. More... | |
| StylesBuffer & | getStyles () const |
| Returns all cell formatting objects read from the styles substream. More... | |
| SharedStringsBuffer & | getSharedStrings () const |
| Returns the shared strings read from the shared strings substream. More... | |
| ExternalLinkBuffer & | getExternalLinks () const |
| Returns the external links read from the external links substream. More... | |
| DefinedNamesBuffer & | getDefinedNames () const |
| Returns the defined names read from the workbook globals. More... | |
| TableBuffer & | getTables () const |
| Returns the tables collection (equivalent to Calc's database ranges). More... | |
| ScenarioBuffer & | getScenarios () const |
| Returns the scenarios collection. More... | |
| ConnectionsBuffer & | getConnections () const |
| Returns the collection of external data connections. More... | |
| PivotCacheBuffer & | getPivotCaches () const |
| Returns the collection of pivot caches. More... | |
| PivotTableBuffer & | getPivotTables () const |
| Returns the collection of pivot tables. More... | |
| FormulaParser & | getFormulaParser () const |
| Returns a shared import formula parser (import filter only!). More... | |
| FormulaParser * | createFormulaParser () const |
| Returns an unshared import formula parser (import filter only!). More... | |
| UnitConverter & | getUnitConverter () const |
| Returns the measurement unit converter. More... | |
| AddressConverter & | getAddressConverter () const |
| Returns the converter for string to cell address/range conversion. More... | |
| oox::drawingml::chart::ChartConverter * | getChartConverter () const |
| Returns the chart object converter. More... | |
| PageSettingsConverter & | getPageSettingsConverter () const |
| Returns the page and print settings converter. More... | |
| ::oox::core::XmlFilterBase & | getOoxFilter () const |
| Returns the base OOXML/BIFF12 filter object. More... | |
| bool | importOoxFragment (const rtl::Reference< oox::core::FragmentHandler > &rxHandler) |
| Imports a fragment using the passed fragment handler, which contains the full path to the fragment stream. More... | |
| bool | importOoxFragment (const rtl::Reference< oox::core::FragmentHandler > &rxHandler, oox::core::FastParser &rParser) |
| rtl_TextEncoding | getTextEncoding () const |
| Returns the text encoding used to import/export byte strings. More... | |
Private Attributes | |
| QueryTableModel | maModel |
Additional Inherited Members | |
| Public Types inherited from oox::xls::WorkbookHelper | |
| typedef std::pair< ScRangeData *, bool > | RangeDataRet |
| Static Public Member Functions inherited from oox::xls::WorksheetHelper | |
| static WorksheetGlobalsRef | constructGlobals (const WorkbookHelper &rHelper, const ISegmentProgressBarRef &rxProgressBar, WorksheetType eSheetType, SCTAB nSheet) |
| static IWorksheetProgress * | getWorksheetInterface (const WorksheetGlobalsRef &xRef) |
| Static Public Member Functions inherited from oox::xls::WorkbookHelper | |
| static WorkbookGlobalsRef | constructGlobals (ExcelFilter &rFilter) |
Detailed Description
Definition at line 48 of file querytablebuffer.hxx.
Constructor & Destructor Documentation
◆ QueryTable()
|
explicit |
Definition at line 150 of file querytablebuffer.cxx.
Member Function Documentation
◆ finalizeImport()
| void oox::xls::QueryTable::finalizeImport | ( | ) |
Inserts a web query into the sheet.
Definition at line 213 of file querytablebuffer.cxx.
References ScRange::aStart, oox::xls::BIFF12_CONNECTION_HTML, ScAddress::Col(), Exception, oox::core::FilterBase::getAbsoluteUrl(), oox::xls::WorkbookHelper::getAddressConverter(), oox::PropertySet::getAnyProperty(), oox::xls::WorkbookHelper::getBaseFilter(), oox::xls::DefinedNamesBuffer::getByModelName(), oox::xls::ConnectionsBuffer::getConnection(), oox::xls::WorkbookHelper::getConnections(), oox::xls::WorkbookHelper::getDefinedNames(), oox::xls::WorkbookHelper::getDocument(), oox::xls::WorksheetHelper::getSheetIndex(), oox::xls::QueryTableModel::maDefName, maModel, oox::xls::WebPrModel::maTables, oox::xls::WebPrModel::maUrl, oox::xls::WebPrModel::mbHtmlTables, oox::xls::WebPrModel::mbXml, oox::xls::QueryTableModel::mnConnId, ScAddress::Row(), oox::PropertySet::setProperty(), ScAddress::Tab(), and u.
Referenced by oox::xls::QueryTableBuffer::finalizeImport().
◆ importQueryTable() [1/2]
| void oox::xls::QueryTable::importQueryTable | ( | const AttributeList & | rAttribs | ) |
Imports query table settings from the queryTable element.
Definition at line 155 of file querytablebuffer.cxx.
References oox::AttributeList::getBool(), oox::AttributeList::getInteger(), oox::AttributeList::getToken(), oox::AttributeList::getXString(), oox::xls::QueryTableModel::maDefName, maModel, oox::xls::QueryTableModel::mbAdjustColWidth, oox::xls::AutoFormatModel::mbApplyAlignment, oox::xls::AutoFormatModel::mbApplyBorder, oox::xls::AutoFormatModel::mbApplyFill, oox::xls::AutoFormatModel::mbApplyFont, oox::xls::AutoFormatModel::mbApplyNumFmt, oox::xls::AutoFormatModel::mbApplyProtection, oox::xls::QueryTableModel::mbBackground, oox::xls::QueryTableModel::mbDisableEdit, oox::xls::QueryTableModel::mbDisableRefresh, oox::xls::QueryTableModel::mbFillFormulas, oox::xls::QueryTableModel::mbFirstBackground, oox::xls::QueryTableModel::mbHeaders, oox::xls::QueryTableModel::mbIntermediate, oox::xls::QueryTableModel::mbPreserveFormat, oox::xls::QueryTableModel::mbRefreshOnLoad, oox::xls::QueryTableModel::mbRemoveDataOnSave, oox::xls::QueryTableModel::mbRowNumbers, oox::xls::AutoFormatModel::mnAutoFormatId, oox::xls::QueryTableModel::mnConnId, and oox::xls::QueryTableModel::mnGrowShrinkType.
Referenced by oox::xls::QueryTableFragment::onCreateContext(), and oox::xls::QueryTableFragment::onCreateRecordContext().
◆ importQueryTable() [2/2]
| void oox::xls::QueryTable::importQueryTable | ( | SequenceInputStream & | rStrm | ) |
Imports query table settings from the QUERYTABLE record.
Definition at line 182 of file querytablebuffer.cxx.
References oox::getFlag(), oox::xls::QueryTableModel::maDefName, maModel, oox::xls::QueryTableModel::mbAdjustColWidth, oox::xls::AutoFormatModel::mbApplyAlignment, oox::xls::AutoFormatModel::mbApplyBorder, oox::xls::AutoFormatModel::mbApplyFill, oox::xls::AutoFormatModel::mbApplyFont, oox::xls::AutoFormatModel::mbApplyNumFmt, oox::xls::AutoFormatModel::mbApplyProtection, oox::xls::QueryTableModel::mbBackground, oox::xls::QueryTableModel::mbDisableEdit, oox::xls::QueryTableModel::mbDisableRefresh, oox::xls::QueryTableModel::mbFillFormulas, oox::xls::QueryTableModel::mbFirstBackground, oox::xls::QueryTableModel::mbHeaders, oox::xls::QueryTableModel::mbIntermediate, oox::xls::QueryTableModel::mbPreserveFormat, oox::xls::QueryTableModel::mbRefreshOnLoad, oox::xls::QueryTableModel::mbRemoveDataOnSave, oox::xls::QueryTableModel::mbRowNumbers, oox::xls::AutoFormatModel::mnAutoFormatId, oox::xls::QueryTableModel::mnConnId, oox::xls::QueryTableModel::mnGrowShrinkType, rStrm, and STATIC_ARRAY_SELECT.
Member Data Documentation
◆ maModel
|
private |
Definition at line 62 of file querytablebuffer.hxx.
Referenced by finalizeImport(), and importQueryTable().
The documentation for this class was generated from the following files:
