Public Member Functions | |
| WorksheetGlobals (const WorkbookHelper &rHelper, const ISegmentProgressBarRef &rxProgressBar, WorksheetType eSheetType, SCTAB nSheet) | |
| Service name for a SheetCellRanges object. More... | |
| bool | isValidSheet () const |
| Returns true, if this helper refers to an existing Calc sheet. More... | |
| WorksheetType | getSheetType () const |
| Returns the type of this sheet. More... | |
| SCTAB | getSheetIndex () const |
| Returns the index of the current sheet. More... | |
| const Reference< XSpreadsheet > & | getSheet () const |
| Returns the XSpreadsheet interface of the current sheet. More... | |
| Reference< XCell > | getCell (const ScAddress &rAddress) const |
| Returns the XCell interface for the passed cell address. More... | |
| Reference< XCellRange > | getCellRange (const ScRange &rRange) const |
| Returns the XCellRange interface for the passed cell range address. More... | |
| Reference< XSheetCellRanges > | getCellRangeList (const ScRangeList &rRanges) const |
| Returns the XSheetCellRanges interface for the passed cell range addresses. More... | |
| Reference< XCellRange > | getColumn (sal_Int32 nCol) const |
| Returns the XCellRange interface for a column. More... | |
| Reference< XCellRange > | getRow (sal_Int32 nRow) const |
| Returns the XCellRange interface for a row. More... | |
| Reference< XDrawPage > | getDrawPage () const |
| Returns the XDrawPage interface of the draw page of the current sheet. More... | |
| const awt::Size & | getDrawPageSize () const |
| Returns the size of the entire drawing page in 1/100 mm. More... | |
| awt::Point | getCellPosition (sal_Int32 nCol, sal_Int32 nRow) const |
| Returns the absolute position of the top-left corner of the cell in 1/100 mm. More... | |
| ScAddress | getCellAddressFromPosition (const awt::Point &rPosition) const |
| Returns the address of the cell that contains the passed point in 1/100 mm. More... | |
| ScRange | getCellRangeFromRectangle (const awt::Rectangle &rRect) const |
| Returns the cell range address that contains the passed rectangle in 1/100 mm. More... | |
| SheetDataBuffer & | getSheetData () |
| Returns the buffer for cell contents and cell formatting. More... | |
| CondFormatBuffer & | getCondFormats () |
| Returns the conditional formatting in this sheet. More... | |
| CommentsBuffer & | getComments () |
| Returns the buffer for all cell comments in this sheet. More... | |
| AutoFilterBuffer & | getAutoFilters () |
| Returns the auto filters for the sheet. More... | |
| QueryTableBuffer & | getQueryTables () |
| Returns the buffer for all web query tables in this sheet. More... | |
| WorksheetSettings & | getWorksheetSettings () |
| Returns the worksheet settings object. More... | |
| PageSettings & | getPageSettings () |
| Returns the page/print settings for this sheet. More... | |
| SheetViewSettings & | getSheetViewSettings () |
| Returns the view settings for this sheet. More... | |
| VmlDrawing & | getVmlDrawing () |
| Returns the VML drawing page for this sheet (OOXML/BIFF12 only). More... | |
| ExtLst & | getExtLst () |
| returns the ExtLst entries that need to be filled More... | |
| 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 awt::Rectangle &rShapeRect) |
| Extends the shape bounding box by the position and size of the passed rectangle. 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 column range. More... | |
| void | convertColumnFormat (sal_Int32 nFirstCol, sal_Int32 nLastCol, sal_Int32 nXfId) |
| Converts column default cell formatting. 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 row. More... | |
| void | initializeWorksheetImport () |
| Initial conversion before importing the worksheet. More... | |
| void | finalizeWorksheetImport () |
| Final conversion after importing the worksheet. More... | |
| void | finalizeDrawingImport () |
| virtual ISegmentProgressBarRef | getRowProgress () override |
| Allow the threaded importer to override our progress bar impl. More... | |
| virtual void | setCustomRowProgress (const ISegmentProgressBarRef &rxRowProgress) override |
 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... | |
| 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, const css::uno::Sequence< css::sheet::FormulaToken > &rTokens, 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, const css::uno::Sequence< css::sheet::FormulaToken > &rTokens, 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... | |
| Public Member Functions inherited from oox::xls::IWorksheetProgress | |
| virtual | ~IWorksheetProgress () |
| virtual ISegmentProgressBarRef | getRowProgress ()=0 |
| virtual void | setCustomRowProgress (const ISegmentProgressBarRef &rxRowProgress)=0 |
Private Types | |
| typedef ::std::vector< sal_Int32 > | OutlineLevelVec |
| typedef ::std::pair< ColumnModel, sal_Int32 > | ColumnModelRange |
| typedef ::std::map< sal_Int32, ColumnModelRange > | ColumnModelRangeMap |
| typedef ::std::pair< RowModel, sal_Int32 > | RowModelRange |
| typedef ::std::map< sal_Int32, RowModelRange > | RowModelRangeMap |
| typedef ::std::unique_ptr< VmlDrawing > | VmlDrawingPtr |
Private Member Functions | |
| void | finalizeHyperlinkRanges () |
| Inserts all imported hyperlinks into their cell ranges. More... | |
| OUString | getHyperlinkUrl (const HyperlinkModel &rHyperlink) const |
| Generates the final URL for the passed hyperlink. More... | |
| void | insertHyperlink (const ScAddress &rAddress, const OUString &rUrl) |
| Inserts a hyperlinks into the specified cell. More... | |
| void | finalizeValidationRanges () const |
| Inserts all imported data validations into their cell ranges. More... | |
| void | convertColumns () |
| Converts column properties for all columns in the sheet. More... | |
| void | convertColumns (OutlineLevelVec &orColLevels, const ValueRange &rColRange, const ColumnModel &rModel) |
| Converts column properties. More... | |
| void | convertRows (const std::vector< sc::ColRowSpan > &rSpans) |
| Converts row properties for all rows in the sheet. More... | |
| void | convertRows (OutlineLevelVec &orRowLevels, const ValueRange &rRowRange, const RowModel &rModel, const std::vector< sc::ColRowSpan > &rSpans, double fDefHeight=-1.0) |
| Converts row properties. More... | |
| void | convertOutlines (OutlineLevelVec &orLevels, sal_Int32 nColRow, sal_Int32 nLevel, bool bCollapsed, bool bRows) |
| Converts outline grouping for the passed column or row. More... | |
| void | groupColumnsOrRows (sal_Int32 nFirstColRow, sal_Int32 nLastColRow, bool bCollapsed, bool bRows) |
| Groups columns or rows for the given range. More... | |
| void | finalizeDrawings () |
| Imports the drawings of the sheet (DML, VML, DFF) and updates the used area. More... | |
| void | UpdateRowProgress (const ScRange &rUsedArea, SCROW nRow) |
| Update the row import progress bar. More... | |
Private Attributes | |
| const ScAddress & | mrMaxApiPos |
| ScRange | maUsedArea |
| Reference to maximum Calc cell address from address converter. More... | |
| ColumnModel | maDefColModel |
| Used area of the sheet, and sheet index of the sheet. More... | |
| ColumnModelRangeMap | maColModels |
| Default column formatting. More... | |
| RowModel | maDefRowModel |
| Ranges of columns sorted by first column index. More... | |
| RowModelRangeMap | maRowModels |
| Default row formatting. More... | |
| std::vector< HyperlinkModel > | maHyperlinks |
| Ranges of rows sorted by first row index. More... | |
| std::vector< ValidationModel > | maValidations |
| Cell ranges containing hyperlinks. More... | |
| SheetDataBuffer | maSheetData |
| Cell ranges containing data validation settings. More... | |
| CondFormatBuffer | maCondFormats |
| Buffer for cell contents and cell formatting. More... | |
| CommentsBuffer | maComments |
| Buffer for conditional formatting. More... | |
| AutoFilterBuffer | maAutoFilters |
| Buffer for all cell comments in this sheet. More... | |
| QueryTableBuffer | maQueryTables |
| Sheet auto filters (not associated to a table). More... | |
| WorksheetSettings | maSheetSett |
| Buffer for all web query tables in this sheet. More... | |
| PageSettings | maPageSett |
| Global settings for this sheet. More... | |
| SheetViewSettings | maSheetViewSett |
| Page/print settings for this sheet. More... | |
| VmlDrawingPtr | mxVmlDrawing |
| View settings for this sheet. More... | |
| ExtLst | maExtLst |
| Collection of all VML shapes. More... | |
| OUString | maDrawingPath |
| List of extended elements. More... | |
| OUString | maVmlDrawingPath |
| Path to DrawingML fragment. More... | |
| awt::Size | maDrawPageSize |
| Path to legacy VML drawing fragment. More... | |
| awt::Rectangle | maShapeBoundingBox |
| Current size of the drawing page in 1/100 mm. More... | |
| ISegmentProgressBarRef | mxProgressBar |
| Bounding box for all shapes from all drawings. More... | |
| bool | mbFastRowProgress |
| Sheet progress bar. More... | |
| ISegmentProgressBarRef | mxRowProgress |
| Do we have a progress bar thread ? More... | |
| ISegmentProgressBarRef | mxFinalProgress |
| Progress bar for row/cell processing. More... | |
| WorksheetType | meSheetType |
| Progress bar for finalization. More... | |
| Reference< XSpreadsheet > | mxSheet |
| Type of this sheet. More... | |
| bool | mbHasDefWidth |
| Reference to the current sheet. More... | |
Additional Inherited Members | |
| Public Types inherited from oox::xls::WorkbookHelper | |
| typedef std::pair< ScRangeData *, bool > | RangeDataRet |
| Static Public Member Functions inherited from oox::xls::WorkbookHelper | |
| static WorkbookGlobalsRef | constructGlobals (ExcelFilter &rFilter) |
Detailed Description
Definition at line 213 of file worksheethelper.cxx.
Member Typedef Documentation
◆ ColumnModelRange
|
private |
Definition at line 337 of file worksheethelper.cxx.
◆ ColumnModelRangeMap
|
private |
Definition at line 338 of file worksheethelper.cxx.
◆ OutlineLevelVec
|
private |
Definition at line 336 of file worksheethelper.cxx.
◆ RowModelRange
|
private |
Definition at line 339 of file worksheethelper.cxx.
◆ RowModelRangeMap
|
private |
Definition at line 340 of file worksheethelper.cxx.
◆ VmlDrawingPtr
|
private |
Definition at line 377 of file worksheethelper.cxx.
Constructor & Destructor Documentation
◆ WorksheetGlobals()
|
explicit |
Service name for a SheetCellRanges object.
Definition at line 412 of file worksheethelper.cxx.
References ScRange::aStart, maDefColModel, maDefRowModel, maUsedArea, oox::xls::ColumnModel::mbCollapsed, oox::xls::RowModel::mbCollapsed, oox::xls::RowModel::mbCustomFormat, oox::xls::RowModel::mbCustomHeight, oox::xls::ColumnModel::mbHidden, oox::xls::RowModel::mbHidden, oox::xls::RowModel::mbShowPhonetic, oox::xls::RowModel::mfHeight, oox::xls::ColumnModel::mfWidth, oox::xls::ColumnModel::mnLevel, oox::xls::RowModel::mnLevel, oox::xls::ColumnModel::mnXfId, oox::xls::RowModel::mnXfId, mxFinalProgress, mxProgressBar, mxRowProgress, mxSheet, mxVmlDrawing, and ScAddress::SetTab().
Member Function Documentation
◆ convertColumnFormat()
| void oox::xls::WorksheetGlobals::convertColumnFormat | ( | sal_Int32 | nFirstCol, |
| sal_Int32 | nLastCol, | ||
| sal_Int32 | nXfId | ||
| ) |
Converts column default cell formatting.
Definition at line 842 of file worksheethelper.cxx.
References oox::xls::WorkbookHelper::getAddressConverter(), oox::xls::WorkbookHelper::getDocImport(), getSheetIndex(), oox::xls::WorkbookHelper::getStyles(), mrMaxApiPos, ScAddress::Row(), and oox::xls::StylesBuffer::writeCellXfToDoc().
Referenced by setColumnModel().
◆ convertColumns() [1/2]
|
private |
Converts column properties for all columns in the sheet.
Definition at line 1190 of file worksheethelper.cxx.
References ScAddress::Col(), convertColumns(), convertOutlines(), maColModels, maDefColModel, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, and mrMaxApiPos.
Referenced by convertColumns(), and finalizeWorksheetImport().
◆ convertColumns() [2/2]
|
private |
Converts column properties.
Definition at line 1216 of file worksheethelper.cxx.
References convertOutlines(), oox::xls::Digit, oox::xls::WorkbookHelper::getScDocument(), getSheetIndex(), oox::xls::WorkbookHelper::getUnitConverter(), oox::xls::Macro, oox::xls::ColumnModel::mbCollapsed, oox::xls::ColumnModel::mbHidden, meSheetType, oox::xls::ColumnModel::mfWidth, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, oox::xls::ColumnModel::mnLevel, ScDocument::SetColHidden(), ScDocument::SetColWidthOnly(), and oox::xls::Twip.
◆ convertOutlines()
|
private |
Converts outline grouping for the passed column or row.
Definition at line 1316 of file worksheethelper.cxx.
References groupColumnsOrRows(), and nIndex.
Referenced by convertColumns(), and convertRows().
◆ convertRows() [1/2]
|
private |
Converts row properties for all rows in the sheet.
Definition at line 1249 of file worksheethelper.cxx.
References convertOutlines(), convertRows(), maDefRowModel, maRowModels, oox::xls::RowModel::mfHeight, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, mrMaxApiPos, and ScAddress::Row().
Referenced by convertRows(), and finalizeWorksheetImport().
◆ convertRows() [2/2]
|
private |
Converts row properties.
Definition at line 1276 of file worksheethelper.cxx.
References convertOutlines(), oox::xls::WorkbookHelper::getScDocument(), getSheetIndex(), oox::xls::RowModel::mbCollapsed, oox::xls::RowModel::mbCustomHeight, oox::xls::RowModel::mbHidden, oox::xls::RowModel::mfHeight, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, oox::xls::RowModel::mnLevel, o3tl::pt, ScDocument::SetManualHeight(), ScDocument::SetRowFiltered(), ScDocument::SetRowHeightOnly(), ScDocument::SetRowHidden(), and o3tl::toTwips().
◆ extendShapeBoundingBox()
| void oox::xls::WorksheetGlobals::extendShapeBoundingBox | ( | const awt::Rectangle & | rShapeRect | ) |
Extends the shape bounding box by the position and size of the passed rectangle.
Definition at line 734 of file worksheethelper.cxx.
References maShapeBoundingBox.
Referenced by oox::xls::WorksheetHelper::extendShapeBoundingBox().
◆ extendUsedArea() [1/2]
| void oox::xls::WorksheetGlobals::extendUsedArea | ( | const ScAddress & | rAddress | ) |
Extends the used area of this sheet by the passed cell position.
Definition at line 714 of file worksheethelper.cxx.
References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), maUsedArea, ScAddress::Row(), ScAddress::SetCol(), and ScAddress::SetRow().
Referenced by oox::xls::WorksheetHelper::extendUsedArea(), extendUsedArea(), and finalizeDrawings().
◆ extendUsedArea() [2/2]
| void oox::xls::WorksheetGlobals::extendUsedArea | ( | const ScRange & | rRange | ) |
Extends the used area of this sheet by the passed cell range.
Definition at line 722 of file worksheethelper.cxx.
References ScRange::aEnd, ScRange::aStart, and extendUsedArea().
◆ finalizeDrawingImport()
| void oox::xls::WorksheetGlobals::finalizeDrawingImport | ( | ) |
Definition at line 999 of file worksheethelper.cxx.
References finalizeDrawings(), and oox::xls::WorkbookHelper::setCurrentSheetIndex().
Referenced by oox::xls::WorksheetHelper::finalizeDrawingImport().
◆ finalizeDrawings()
|
private |
Imports the drawings of the sheet (DML, VML, DFF) and updates the used area.
Definition at line 1369 of file worksheethelper.cxx.
References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), extendUsedArea(), oox::xls::CommentsBuffer::finalizeImport(), getCellRangeFromRectangle(), oox::xls::WorkbookHelper::getScDocument(), getSheetIndex(), oox::xls::WorkbookHelper::getViewSettings(), Size::Height(), oox::xls::WorkbookHelper::importOoxFragment(), oox::xls::SheetViewSettings::isSheetRightToLeft(), maComments, maDrawingPath, maDrawPageSize, maShapeBoundingBox, maSheetViewSett, maUsedArea, maVmlDrawingPath, mrMaxApiPos, mxSheet, ScAddress::Row(), ScAddress::SetCol(), oox::PropertySet::setProperty(), ScAddress::SetRow(), oox::xls::ViewSettings::setSheetUsedArea(), and Size::Width().
Referenced by finalizeDrawingImport().
◆ finalizeHyperlinkRanges()
|
private |
Inserts all imported hyperlinks into their cell ranges.
Definition at line 1009 of file worksheethelper.cxx.
References getHyperlinkUrl(), getSheetIndex(), insertHyperlink(), maHyperlinks, and ScAddress::Row().
Referenced by finalizeWorksheetImport().
◆ finalizeValidationRanges()
|
private |
Inserts all imported data validations into their cell ranges.
Definition at line 1094 of file worksheethelper.cxx.
References oox::xls::CondFormatBuffer::convertToApiOperator(), eType, Exception, condformat::entry::FORMULA, oox::PropertySet::getAnyProperty(), getCellRangeList(), oox::xls::WorkbookHelper::getCurrentSheetIndex(), oox::xls::WorkbookHelper::getSheetFromDoc(), maValidations, oox::PropertySet::setProperty(), and XML_none.
Referenced by finalizeWorksheetImport().
◆ finalizeWorksheetImport()
| void oox::xls::WorksheetGlobals::finalizeWorksheetImport | ( | ) |
Final conversion after importing the worksheet.
Definition at line 945 of file worksheethelper.cxx.
References ScRange::aEnd, oox::xls::TableBuffer::applyAutoFilters(), ScRange::aStart, convertColumns(), convertRows(), ScDBCollection::empty(), finalizeHyperlinkRanges(), oox::xls::CondFormatBuffer::finalizeImport(), oox::xls::PageSettings::finalizeImport(), oox::xls::QueryTableBuffer::finalizeImport(), oox::xls::SheetDataBuffer::finalizeImport(), oox::xls::SheetViewSettings::finalizeImport(), oox::xls::WorksheetSettings::finalizeImport(), oox::xls::AutoFilterBuffer::finalizeImport(), finalizeValidationRanges(), ScDocument::GetAnonymousDBData(), ScDBData::GetArea(), getCondFormats(), ScDocument::GetDBCollection(), ScDBCollection::getNamedDBs(), oox::xls::WorkbookHelper::getScDocument(), getSheetIndex(), oox::xls::WorkbookHelper::getTables(), ScDBData::HasAutoFilter(), maAutoFilters, maPageSett, maQueryTables, maSheetData, maSheetSett, maSheetViewSett, mxFinalProgress, mxRowProgress, and ScAddress::Row().
Referenced by oox::xls::WorksheetHelper::finalizeWorksheetImport().
◆ getAutoFilters()
|
inline |
Returns the auto filters for the sheet.
Definition at line 264 of file worksheethelper.cxx.
References maAutoFilters.
Referenced by oox::xls::WorksheetHelper::getAutoFilters().
◆ getCell()
| Reference< XCell > oox::xls::WorksheetGlobals::getCell | ( | const ScAddress & | rAddress | ) | const |
Returns the XCell interface for the passed cell address.
Definition at line 461 of file worksheethelper.cxx.
References ScAddress::Col(), Exception, mxSheet, and ScAddress::Row().
Referenced by oox::xls::WorksheetHelper::getCell().
◆ getCellAddressFromPosition()
| ScAddress oox::xls::WorksheetGlobals::getCellAddressFromPosition | ( | const awt::Point & | rPosition | ) | const |
Returns the address of the cell that contains the passed point in 1/100 mm.
Definition at line 628 of file worksheethelper.cxx.
References ScAddress::Col(), getCellPosition(), getSheetIndex(), maDrawPageSize, mrMaxApiPos, and ScAddress::Row().
Referenced by getCellRangeFromRectangle().
◆ getCellPosition()
| awt::Point oox::xls::WorksheetGlobals::getCellPosition | ( | sal_Int32 | nCol, |
| sal_Int32 | nRow | ||
| ) | const |
Returns the absolute position of the top-left corner of the cell in 1/100 mm.
Definition at line 551 of file worksheethelper.cxx.
References oox::xls::WorkbookHelper::getScDocument(), getSheetIndex(), tools::Rectangle::Left(), and tools::Rectangle::Top().
Referenced by getCellAddressFromPosition(), oox::xls::WorksheetHelper::getCellPosition(), and getCellRangeFromRectangle().
◆ getCellRange()
| Reference< XCellRange > oox::xls::WorksheetGlobals::getCellRange | ( | const ScRange & | rRange | ) | const |
Returns the XCellRange interface for the passed cell range address.
Definition at line 474 of file worksheethelper.cxx.
References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), Exception, mxSheet, and ScAddress::Row().
Referenced by oox::xls::WorksheetHelper::getCellRange().
◆ getCellRangeFromRectangle()
| ScRange oox::xls::WorksheetGlobals::getCellRangeFromRectangle | ( | const awt::Rectangle & | rRect | ) | const |
Returns the cell range address that contains the passed rectangle in 1/100 mm.
Definition at line 664 of file worksheethelper.cxx.
References ScAddress::Col(), getCellAddressFromPosition(), getCellPosition(), getSheetIndex(), ScAddress::IncCol(), ScAddress::IncRow(), and ScAddress::Row().
Referenced by finalizeDrawings().
◆ getCellRangeList()
| Reference< XSheetCellRanges > oox::xls::WorksheetGlobals::getCellRangeList | ( | const ScRangeList & | rRanges | ) | const |
Returns the XSheetCellRanges interface for the passed cell range addresses.
Definition at line 487 of file worksheethelper.cxx.
References createInstance(), ScRangeList::empty(), Exception, oox::xls::gaSheetCellRanges(), oox::xls::WorkbookHelper::getBaseFilter(), mxSheet, and oox::xls::AddressConverter::toApiSequence().
Referenced by finalizeValidationRanges().
◆ getColumn()
| Reference< XCellRange > oox::xls::WorksheetGlobals::getColumn | ( | sal_Int32 | nCol | ) | const |
Returns the XCellRange interface for a column.
Definition at line 502 of file worksheethelper.cxx.
References Exception, mxSheet, and xColumn.
Referenced by setPageBreak().
◆ getComments()
|
inline |
Returns the buffer for all cell comments in this sheet.
Definition at line 262 of file worksheethelper.cxx.
References maComments.
Referenced by oox::xls::WorksheetHelper::getComments().
◆ getCondFormats()
|
inline |
Returns the conditional formatting in this sheet.
Definition at line 260 of file worksheethelper.cxx.
References maCondFormats.
Referenced by finalizeWorksheetImport(), and oox::xls::WorksheetHelper::getCondFormats().
◆ getDrawPage()
| Reference< XDrawPage > oox::xls::WorksheetGlobals::getDrawPage | ( | ) | const |
Returns the XDrawPage interface of the draw page of the current sheet.
Definition at line 532 of file worksheethelper.cxx.
References Exception, and mxSheet.
Referenced by oox::xls::WorksheetHelper::getDrawPage().
◆ getDrawPageSize()
| const awt::Size & oox::xls::WorksheetGlobals::getDrawPageSize | ( | ) | const |
Returns the size of the entire drawing page in 1/100 mm.
Definition at line 545 of file worksheethelper.cxx.
References maDrawPageSize.
Referenced by oox::xls::WorksheetHelper::getDrawPageSize().
◆ getExtLst()
|
inline |
returns the ExtLst entries that need to be filled
Definition at line 276 of file worksheethelper.cxx.
References maExtLst.
Referenced by oox::xls::WorksheetHelper::getExtLst().
◆ getHyperlinkUrl()
|
private |
Generates the final URL for the passed hyperlink.
Definition at line 1022 of file worksheethelper.cxx.
References formula::FormulaGrammar::CONV_XL_R1C1, oox::xls::WorkbookHelper::getBaseFilter(), oox::xls::WorksheetBuffer::getCalcSheetName(), ScDocumentImport::getDoc(), oox::xls::WorkbookHelper::getDocImport(), oox::xls::WorkbookHelper::getWorksheets(), oox::ole::StdHlinkInfo::maLocation, oox::ole::StdHlinkInfo::maTarget, ScRange::ParseAny(), VALID, and ZERO.
Referenced by finalizeHyperlinkRanges().
◆ getPageSettings()
|
inline |
Returns the page/print settings for this sheet.
Definition at line 270 of file worksheethelper.cxx.
References maPageSett.
Referenced by oox::xls::WorksheetHelper::getPageSettings().
◆ getQueryTables()
|
inline |
Returns the buffer for all web query tables in this sheet.
Definition at line 266 of file worksheethelper.cxx.
References maQueryTables.
Referenced by oox::xls::WorksheetHelper::getQueryTables().
◆ getRow()
| Reference< XCellRange > oox::xls::WorksheetGlobals::getRow | ( | sal_Int32 | nRow | ) | const |
Returns the XCellRange interface for a row.
Definition at line 517 of file worksheethelper.cxx.
References Exception, mxSheet, and xRow.
Referenced by setPageBreak().
◆ getRowProgress()
|
inlineoverridevirtual |
Allow the threaded importer to override our progress bar impl.
Implements oox::xls::IWorksheetProgress.
Definition at line 325 of file worksheethelper.cxx.
References mxRowProgress.
◆ getSheet()
|
inline |
Returns the XSpreadsheet interface of the current sheet.
Definition at line 230 of file worksheethelper.cxx.
References mxSheet.
Referenced by oox::xls::WorksheetHelper::getSheet().
◆ getSheetData()
|
inline |
Returns the buffer for cell contents and cell formatting.
Definition at line 258 of file worksheethelper.cxx.
References maSheetData.
Referenced by oox::xls::WorksheetHelper::getSheetData().
◆ getSheetIndex()
|
inline |
Returns the index of the current sheet.
Definition at line 228 of file worksheethelper.cxx.
References ScRange::aStart, maUsedArea, and ScAddress::Tab().
Referenced by convertColumnFormat(), convertColumns(), convertRows(), finalizeDrawings(), finalizeHyperlinkRanges(), finalizeWorksheetImport(), getCellAddressFromPosition(), getCellPosition(), getCellRangeFromRectangle(), oox::xls::WorksheetHelper::getSheetIndex(), groupColumnsOrRows(), and initializeWorksheetImport().
◆ getSheetType()
|
inline |
Returns the type of this sheet.
Definition at line 226 of file worksheethelper.cxx.
References meSheetType.
Referenced by oox::xls::WorksheetHelper::getSheetType().
◆ getSheetViewSettings()
|
inline |
Returns the view settings for this sheet.
Definition at line 272 of file worksheethelper.cxx.
References maSheetViewSett.
Referenced by oox::xls::WorksheetHelper::getSheetViewSettings().
◆ getVmlDrawing()
|
inline |
Returns the VML drawing page for this sheet (OOXML/BIFF12 only).
Definition at line 274 of file worksheethelper.cxx.
References mxVmlDrawing.
Referenced by oox::xls::WorksheetHelper::getVmlDrawing().
◆ getWorksheetSettings()
|
inline |
Returns the worksheet settings object.
Definition at line 268 of file worksheethelper.cxx.
References maSheetSett.
Referenced by oox::xls::WorksheetHelper::getWorksheetSettings().
◆ groupColumnsOrRows()
|
private |
Groups columns or rows for the given range.
Definition at line 1344 of file worksheethelper.cxx.
References Exception, getSheetIndex(), and mxSheet.
Referenced by convertOutlines().
◆ initializeWorksheetImport()
| void oox::xls::WorksheetGlobals::initializeWorksheetImport | ( | ) |
Initial conversion before importing the worksheet.
Definition at line 928 of file worksheethelper.cxx.
References SfxStyleSheetBasePool::Find(), ScDocumentImport::getDoc(), oox::xls::WorkbookHelper::getDocImport(), getSheetIndex(), oox::xls::WorkbookHelper::getStyles(), ScDocument::GetStyleSheetPool(), ScDocumentImport::setCellStyleToSheet(), and oox::xls::WorkbookHelper::setCurrentSheetIndex().
Referenced by oox::xls::WorksheetHelper::initializeWorksheetImport().
◆ insertHyperlink()
|
private |
Inserts a hyperlinks into the specified cell.
Definition at line 1060 of file worksheethelper.cxx.
References ScDocument::ApplyAttr(), aStr, ATTR_HYPERLINK(), CELLTYPE_EDIT, CELLTYPE_STRING, EditEngine::Clear(), ScAddress::Col(), EditEngine::CreateTextObject(), EE_FEATURE_FIELD(), ScDocumentImport::getDoc(), oox::xls::WorkbookHelper::getDocImport(), ScDocument::GetEditEngine(), ScRefCellValue::getString(), ScRefCellValue::getType(), EditEngine::QuickInsertField(), ScAddress::Row(), ScDocumentImport::setEditCell(), and ScAddress::Tab().
Referenced by finalizeHyperlinkRanges().
◆ isValidSheet()
|
inline |
Returns true, if this helper refers to an existing Calc sheet.
Definition at line 223 of file worksheethelper.cxx.
References mxSheet.
◆ setBaseColumnWidth()
| void oox::xls::WorksheetGlobals::setBaseColumnWidth | ( | sal_Int32 | nWidth | ) |
Sets base width for all columns (without padding pixels).
This value is only used, if base width has not been set with setDefaultColumnWidth().
Definition at line 752 of file worksheethelper.cxx.
References oox::xls::Digit, oox::xls::WorkbookHelper::getUnitConverter(), maDefColModel, mbHasDefWidth, oox::xls::ColumnModel::mfWidth, oox::xls::UnitConverter::scaleValue(), and oox::xls::ScreenX.
Referenced by oox::xls::WorksheetHelper::setBaseColumnWidth().
◆ setColumnModel()
| void oox::xls::WorksheetGlobals::setColumnModel | ( | const ColumnModel & | rModel | ) |
Sets column settings for a specific column range.
@descr Column default formatting is converted directly, other settings are cached and converted in the finalizeImport() call.
Definition at line 772 of file worksheethelper.cxx.
References Col, ScAddress::Col(), convertColumnFormat(), first, oox::xls::WorkbookHelper::getAddressConverter(), maColModels, oox::xls::ColumnModel::maRange, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, oox::xls::ColumnModel::mnXfId, and mrMaxApiPos.
Referenced by oox::xls::WorksheetHelper::setColumnModel().
◆ setCustomRowProgress()
|
inlineoverridevirtual |
Implements oox::xls::IWorksheetProgress.
Definition at line 329 of file worksheethelper.cxx.
References mbFastRowProgress, and mxRowProgress.
◆ setDefaultColumnWidth()
| void oox::xls::WorksheetGlobals::setDefaultColumnWidth | ( | double | fWidth | ) |
Sets default width for all columns.
This function overrides the base width set with the setBaseColumnWidth() function.
Definition at line 762 of file worksheethelper.cxx.
References maDefColModel, mbHasDefWidth, and oox::xls::ColumnModel::mfWidth.
Referenced by oox::xls::WorksheetHelper::setDefaultColumnWidth().
◆ setDefaultRowSettings()
| void oox::xls::WorksheetGlobals::setDefaultRowSettings | ( | double | fHeight, |
| bool | bCustomHeight, | ||
| bool | bHidden, | ||
| bool | bThickTop, | ||
| bool | bThickBottom | ||
| ) |
Sets default height and hidden state for all unused rows in the sheet.
Definition at line 855 of file worksheethelper.cxx.
References maDefRowModel, oox::xls::RowModel::mbCustomHeight, oox::xls::RowModel::mbHidden, oox::xls::RowModel::mbThickBottom, oox::xls::RowModel::mbThickTop, and oox::xls::RowModel::mfHeight.
Referenced by oox::xls::WorksheetHelper::setDefaultRowSettings().
◆ setDrawingPath()
| void oox::xls::WorksheetGlobals::setDrawingPath | ( | const OUString & | rDrawingPath | ) |
Sets the path to the DrawingML fragment of this sheet.
Definition at line 704 of file worksheethelper.cxx.
References maDrawingPath.
Referenced by oox::xls::WorksheetHelper::setDrawingPath().
◆ setHyperlink()
| void oox::xls::WorksheetGlobals::setHyperlink | ( | const HyperlinkModel & | rModel | ) |
Inserts the hyperlink URL into the spreadsheet.
Definition at line 694 of file worksheethelper.cxx.
References maHyperlinks.
Referenced by oox::xls::WorksheetHelper::setHyperlink().
◆ setPageBreak()
| void oox::xls::WorksheetGlobals::setPageBreak | ( | const PageBreakModel & | rModel, |
| bool | bRowBreak | ||
| ) |
Sets a column or row page break described in the passed struct.
Definition at line 685 of file worksheethelper.cxx.
References getColumn(), getRow(), oox::xls::PageBreakModel::mbManual, oox::xls::PageBreakModel::mnColRow, and oox::PropertySet::setProperty().
Referenced by oox::xls::WorksheetHelper::setPageBreak().
◆ setRowModel()
| void oox::xls::WorksheetGlobals::setRowModel | ( | const RowModel & | rModel | ) |
Sets row settings for a specific row.
@descr Row default formatting is converted directly, other settings are cached and converted in the finalizeImport() call.
Definition at line 864 of file worksheethelper.cxx.
References oox::xls::WorkbookHelper::getAddressConverter(), oox::xls::RowModel::maColSpans, maRowModels, maSheetData, maUsedArea, oox::xls::RowModel::mbCustomFormat, oox::xls::RowModel::mnRow, oox::xls::RowModel::mnXfId, oox::xls::SheetDataBuffer::setColSpans(), oox::xls::SheetDataBuffer::setRowFormat(), and UpdateRowProgress().
Referenced by oox::xls::WorksheetHelper::setRowModel().
◆ setValidation()
| void oox::xls::WorksheetGlobals::setValidation | ( | const ValidationModel & | rModel | ) |
Inserts the data validation settings into the spreadsheet.
Definition at line 699 of file worksheethelper.cxx.
References maValidations.
Referenced by oox::xls::WorksheetHelper::setValidation().
◆ setVmlDrawingPath()
| void oox::xls::WorksheetGlobals::setVmlDrawingPath | ( | const OUString & | rVmlDrawingPath | ) |
Sets the path to the legacy VML drawing fragment of this sheet.
Definition at line 709 of file worksheethelper.cxx.
References maVmlDrawingPath.
Referenced by oox::xls::WorksheetHelper::setVmlDrawingPath().
◆ UpdateRowProgress()
|
private |
Update the row import progress bar.
Definition at line 910 of file worksheethelper.cxx.
References ScRange::aEnd, ScRange::aStart, mbFastRowProgress, mxRowProgress, and ScAddress::Row().
Referenced by setRowModel().
Member Data Documentation
◆ maAutoFilters
|
private |
Buffer for all cell comments in this sheet.
Definition at line 390 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), and getAutoFilters().
◆ maColModels
|
private |
Default column formatting.
Definition at line 382 of file worksheethelper.cxx.
Referenced by convertColumns(), and setColumnModel().
◆ maComments
|
private |
Buffer for conditional formatting.
Definition at line 389 of file worksheethelper.cxx.
Referenced by finalizeDrawings(), and getComments().
◆ maCondFormats
|
private |
Buffer for cell contents and cell formatting.
Definition at line 388 of file worksheethelper.cxx.
Referenced by getCondFormats().
◆ maDefColModel
|
private |
Used area of the sheet, and sheet index of the sheet.
Definition at line 381 of file worksheethelper.cxx.
Referenced by convertColumns(), setBaseColumnWidth(), setDefaultColumnWidth(), and WorksheetGlobals().
◆ maDefRowModel
|
private |
Ranges of columns sorted by first column index.
Definition at line 383 of file worksheethelper.cxx.
Referenced by convertRows(), setDefaultRowSettings(), and WorksheetGlobals().
◆ maDrawingPath
|
private |
List of extended elements.
Definition at line 397 of file worksheethelper.cxx.
Referenced by finalizeDrawings(), and setDrawingPath().
◆ maDrawPageSize
|
private |
Path to legacy VML drawing fragment.
Definition at line 399 of file worksheethelper.cxx.
Referenced by finalizeDrawings(), getCellAddressFromPosition(), and getDrawPageSize().
◆ maExtLst
|
private |
Collection of all VML shapes.
Definition at line 396 of file worksheethelper.cxx.
Referenced by getExtLst().
◆ maHyperlinks
|
private |
Ranges of rows sorted by first row index.
Definition at line 385 of file worksheethelper.cxx.
Referenced by finalizeHyperlinkRanges(), and setHyperlink().
◆ maPageSett
|
private |
Global settings for this sheet.
Definition at line 393 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), and getPageSettings().
◆ maQueryTables
|
private |
Sheet auto filters (not associated to a table).
Definition at line 391 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), and getQueryTables().
◆ maRowModels
|
private |
Default row formatting.
Definition at line 384 of file worksheethelper.cxx.
Referenced by convertRows(), and setRowModel().
◆ maShapeBoundingBox
|
private |
Current size of the drawing page in 1/100 mm.
Definition at line 400 of file worksheethelper.cxx.
Referenced by extendShapeBoundingBox(), and finalizeDrawings().
◆ maSheetData
|
private |
Cell ranges containing data validation settings.
Definition at line 387 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), getSheetData(), and setRowModel().
◆ maSheetSett
|
private |
Buffer for all web query tables in this sheet.
Definition at line 392 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), and getWorksheetSettings().
◆ maSheetViewSett
|
private |
Page/print settings for this sheet.
Definition at line 394 of file worksheethelper.cxx.
Referenced by finalizeDrawings(), finalizeWorksheetImport(), and getSheetViewSettings().
◆ maUsedArea
|
private |
Reference to maximum Calc cell address from address converter.
Definition at line 380 of file worksheethelper.cxx.
Referenced by extendUsedArea(), finalizeDrawings(), getSheetIndex(), setRowModel(), and WorksheetGlobals().
◆ maValidations
|
private |
Cell ranges containing hyperlinks.
Definition at line 386 of file worksheethelper.cxx.
Referenced by finalizeValidationRanges(), and setValidation().
◆ maVmlDrawingPath
|
private |
Path to DrawingML fragment.
Definition at line 398 of file worksheethelper.cxx.
Referenced by finalizeDrawings(), and setVmlDrawingPath().
◆ mbFastRowProgress
|
private |
Sheet progress bar.
Definition at line 402 of file worksheethelper.cxx.
Referenced by setCustomRowProgress(), and UpdateRowProgress().
◆ mbHasDefWidth
|
private |
Reference to the current sheet.
Definition at line 407 of file worksheethelper.cxx.
Referenced by setBaseColumnWidth(), and setDefaultColumnWidth().
◆ meSheetType
|
private |
Progress bar for finalization.
Definition at line 405 of file worksheethelper.cxx.
Referenced by convertColumns(), and getSheetType().
◆ mrMaxApiPos
|
private |
Definition at line 379 of file worksheethelper.cxx.
Referenced by convertColumnFormat(), convertColumns(), convertRows(), finalizeDrawings(), getCellAddressFromPosition(), and setColumnModel().
◆ mxFinalProgress
|
private |
Progress bar for row/cell processing.
Definition at line 404 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), and WorksheetGlobals().
◆ mxProgressBar
|
private |
Bounding box for all shapes from all drawings.
Definition at line 401 of file worksheethelper.cxx.
Referenced by WorksheetGlobals().
◆ mxRowProgress
|
private |
Do we have a progress bar thread ?
Definition at line 403 of file worksheethelper.cxx.
Referenced by finalizeWorksheetImport(), getRowProgress(), setCustomRowProgress(), UpdateRowProgress(), and WorksheetGlobals().
◆ mxSheet
|
private |
Type of this sheet.
Definition at line 406 of file worksheethelper.cxx.
Referenced by finalizeDrawings(), getCell(), getCellRange(), getCellRangeList(), getColumn(), getDrawPage(), getRow(), getSheet(), groupColumnsOrRows(), isValidSheet(), and WorksheetGlobals().
◆ mxVmlDrawing
|
private |
View settings for this sheet.
Definition at line 395 of file worksheethelper.cxx.
Referenced by getVmlDrawing(), and WorksheetGlobals().
The documentation for this class was generated from the following file:
