LibreOffice Module sc (master)  1
Public Member Functions | Private Types | Private Member Functions | Private Attributes | List of all members
oox::xls::WorksheetGlobals Class Reference
Inheritance diagram for oox::xls::WorksheetGlobals:
[legend]
Collaboration diagram for oox::xls::WorksheetGlobals:
[legend]

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...
 
SheetDataBuffergetSheetData ()
 Returns the buffer for cell contents and cell formatting. More...
 
CondFormatBuffergetCondFormats ()
 Returns the conditional formatting in this sheet. More...
 
CommentsBuffergetComments ()
 Returns the buffer for all cell comments in this sheet. More...
 
AutoFilterBuffergetAutoFilters ()
 Returns the auto filters for the sheet. More...
 
QueryTableBuffergetQueryTables ()
 Returns the buffer for all web query tables in this sheet. More...
 
WorksheetSettingsgetWorksheetSettings ()
 Returns the worksheet settings object. More...
 
PageSettingsgetPageSettings ()
 Returns the page/print settings for this sheet. More...
 
SheetViewSettingsgetSheetViewSettings ()
 Returns the view settings for this sheet. More...
 
VmlDrawinggetVmlDrawing ()
 Returns the VML drawing page for this sheet (OOXML/BIFF12 only). More...
 
ExtLstgetExtLst ()
 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
 
WorkbookHelperoperator= (WorkbookHelper const &)=delete
 
WorkbookHelperoperator= (WorkbookHelper &&)=delete
 
::oox::core::FilterBasegetBaseFilter () const
 Returns the base filter object (base class of all filters). More...
 
SegmentProgressBargetProgressBar () 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)
 
ScDocumentgetScDocument ()
 
const ScDocumentgetScDocument () const
 
ScDocumentImportgetDocImport ()
 
const ScDocumentImportgetDocImport () const
 
ScEditEngineDefaultergetEditEngine () 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...
 
ScRangeDatacreateNamedRangeObject (OUString &orName, const css::uno::Sequence< css::sheet::FormulaToken > &rTokens, sal_Int32 nIndex, sal_Int32 nNameFlags) const
 Creates and returns a defined name on-the-fly in the Calc document. More...
 
ScRangeDatacreateLocalNamedRangeObject (OUString &orName, const css::uno::Sequence< css::sheet::FormulaToken > &rTokens, sal_Int32 nIndex, sal_Int32 nNameFlags, sal_Int32 nTab) 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...
 
ScDBDatafindDatabaseRangeByIndex (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...
 
FormulaBuffergetFormulaBuffer () const
 
WorkbookSettingsgetWorkbookSettings () const
 Returns the global workbook settings object. More...
 
ViewSettingsgetViewSettings () const
 Returns the workbook and sheet view settings object. More...
 
WorksheetBuffergetWorksheets () const
 Returns the worksheet buffer containing sheet names and properties. More...
 
ThemeBuffergetTheme () const
 Returns the office theme object read from the theme substorage. More...
 
StylesBuffergetStyles () const
 Returns all cell formatting objects read from the styles substream. More...
 
SharedStringsBuffergetSharedStrings () const
 Returns the shared strings read from the shared strings substream. More...
 
ExternalLinkBuffergetExternalLinks () const
 Returns the external links read from the external links substream. More...
 
DefinedNamesBuffergetDefinedNames () const
 Returns the defined names read from the workbook globals. More...
 
TableBuffergetTables () const
 Returns the tables collection (equivalent to Calc's database ranges). More...
 
ScenarioBuffergetScenarios () const
 Returns the scenarios collection. More...
 
ConnectionsBuffergetConnections () const
 Returns the collection of external data connections. More...
 
PivotCacheBuffergetPivotCaches () const
 Returns the collection of pivot caches. More...
 
PivotTableBuffergetPivotTables () const
 Returns the collection of pivot tables. More...
 
FormulaParsergetFormulaParser () const
 Returns a shared import formula parser (import filter only!). More...
 
FormulaParsercreateFormulaParser () const
 Returns an unshared import formula parser (import filter only!). More...
 
UnitConvertergetUnitConverter () const
 Returns the measurement unit converter. More...
 
AddressConvertergetAddressConverter () const
 Returns the converter for string to cell address/range conversion. More...
 
oox::drawingml::chart::ChartConvertergetChartConverter () const
 Returns the chart object converter. More...
 
PageSettingsConvertergetPageSettingsConverter () const
 Returns the page and print settings converter. More...
 
::oox::core::XmlFilterBasegetOoxFilter () 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 ()
 

Private Types

typedef ::std::vector< sal_Int32 > OutlineLevelVec
 
typedef ::std::pair< ColumnModel, sal_Int32 > ColumnModelRange
 
typedef ::std::map< sal_Int32, ColumnModelRangeColumnModelRangeMap
 
typedef ::std::pair< RowModel, sal_Int32 > RowModelRange
 
typedef ::std::map< sal_Int32, RowModelRangeRowModelRangeMap
 
typedef ::std::unique_ptr< VmlDrawingVmlDrawingPtr
 

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 ()
 Converts row properties for all rows in the sheet. More...
 
void convertRows (OutlineLevelVec &orRowLevels, const ValueRange &rRowRange, const RowModel &rModel, 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 ScAddressmrMaxApiPos
 
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< HyperlinkModelmaHyperlinks
 Ranges of rows sorted by first row index. More...
 
std::vector< ValidationModelmaValidations
 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

- Static Public Member Functions inherited from oox::xls::WorkbookHelper
static WorkbookGlobalsRef constructGlobals (ExcelFilter &rFilter)
 

Detailed Description

Definition at line 198 of file worksheethelper.cxx.

Member Typedef Documentation

typedef ::std::pair< ColumnModel, sal_Int32 > oox::xls::WorksheetGlobals::ColumnModelRange
private

Definition at line 322 of file worksheethelper.cxx.

Definition at line 323 of file worksheethelper.cxx.

typedef ::std::vector< sal_Int32 > oox::xls::WorksheetGlobals::OutlineLevelVec
private

Definition at line 321 of file worksheethelper.cxx.

typedef ::std::pair< RowModel, sal_Int32 > oox::xls::WorksheetGlobals::RowModelRange
private

Definition at line 324 of file worksheethelper.cxx.

Definition at line 325 of file worksheethelper.cxx.

typedef ::std::unique_ptr< VmlDrawing > oox::xls::WorksheetGlobals::VmlDrawingPtr
private

Definition at line 359 of file worksheethelper.cxx.

Constructor & Destructor Documentation

oox::xls::WorksheetGlobals::WorksheetGlobals ( const WorkbookHelper rHelper,
const ISegmentProgressBarRef rxProgressBar,
WorksheetType  eSheetType,
SCTAB  nSheet 
)
explicit

Member Function Documentation

void oox::xls::WorksheetGlobals::convertColumnFormat ( sal_Int32  nFirstCol,
sal_Int32  nLastCol,
sal_Int32  nXfId 
)
void oox::xls::WorksheetGlobals::convertColumns ( )
private

Converts column properties for all columns in the sheet.

Definition at line 1144 of file worksheethelper.cxx.

References ScAddress::Col(), convertOutlines(), maColModels, maDefColModel, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, and mrMaxApiPos.

Referenced by finalizeWorksheetImport().

void oox::xls::WorksheetGlobals::convertColumns ( OutlineLevelVec orColLevels,
const ValueRange rColRange,
const ColumnModel rModel 
)
private
void oox::xls::WorksheetGlobals::convertOutlines ( OutlineLevelVec orLevels,
sal_Int32  nColRow,
sal_Int32  nLevel,
bool  bCollapsed,
bool  bRows 
)
private

Converts outline grouping for the passed column or row.

Definition at line 1258 of file worksheethelper.cxx.

References groupColumnsOrRows(), and nIndex.

Referenced by convertColumns(), and convertRows().

void oox::xls::WorksheetGlobals::convertRows ( )
private

Converts row properties for all rows in the sheet.

Definition at line 1203 of file worksheethelper.cxx.

References convertOutlines(), maDefRowModel, maRowModels, oox::xls::RowModel::mfHeight, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, mrMaxApiPos, and ScAddress::Row().

Referenced by finalizeWorksheetImport().

void oox::xls::WorksheetGlobals::convertRows ( OutlineLevelVec orRowLevels,
const ValueRange rRowRange,
const RowModel rModel,
double  fDefHeight = -1.0 
)
private
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 716 of file worksheethelper.cxx.

References maShapeBoundingBox.

Referenced by oox::xls::WorksheetHelper::extendShapeBoundingBox().

void oox::xls::WorksheetGlobals::extendUsedArea ( const ScAddress rAddress)

Extends the used area of this sheet by the passed cell position.

Definition at line 696 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().

void oox::xls::WorksheetGlobals::extendUsedArea ( const ScRange rRange)

Extends the used area of this sheet by the passed cell range.

Definition at line 704 of file worksheethelper.cxx.

References ScRange::aEnd, ScRange::aStart, and extendUsedArea().

void oox::xls::WorksheetGlobals::finalizeDrawingImport ( )
void oox::xls::WorksheetGlobals::finalizeDrawings ( )
private
void oox::xls::WorksheetGlobals::finalizeHyperlinkRanges ( )
private

Inserts all imported hyperlinks into their cell ranges.

Definition at line 963 of file worksheethelper.cxx.

References getHyperlinkUrl(), getSheetIndex(), insertHyperlink(), maHyperlinks, and ScAddress::Row().

Referenced by finalizeWorksheetImport().

void oox::xls::WorksheetGlobals::finalizeValidationRanges ( ) const
private
void oox::xls::WorksheetGlobals::finalizeWorksheetImport ( )
AutoFilterBuffer& oox::xls::WorksheetGlobals::getAutoFilters ( )
inline

Returns the auto filters for the sheet.

Definition at line 249 of file worksheethelper.cxx.

References maAutoFilters.

Referenced by oox::xls::WorksheetHelper::getAutoFilters().

Reference< XCell > oox::xls::WorksheetGlobals::getCell ( const ScAddress rAddress) const

Returns the XCell interface for the passed cell address.

Definition at line 443 of file worksheethelper.cxx.

References ScAddress::Col(), Exception, mxSheet, and ScAddress::Row().

Referenced by oox::xls::WorksheetHelper::getCell(), and getCellPosition().

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 610 of file worksheethelper.cxx.

References ScAddress::Col(), getCellPosition(), getSheetIndex(), maDrawPageSize, mrMaxApiPos, oox::xls::Point, and ScAddress::Row().

Referenced by getCellRangeFromRectangle().

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 533 of file worksheethelper.cxx.

References getCell(), oox::PropertySet::getProperty(), getSheetIndex(), and oox::xls::Point.

Referenced by getCellAddressFromPosition(), oox::xls::WorksheetHelper::getCellPosition(), and getCellRangeFromRectangle().

Reference< XCellRange > oox::xls::WorksheetGlobals::getCellRange ( const ScRange rRange) const

Returns the XCellRange interface for the passed cell range address.

Definition at line 456 of file worksheethelper.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), Exception, mxSheet, and ScAddress::Row().

Referenced by finalizeDrawings(), and oox::xls::WorksheetHelper::getCellRange().

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 646 of file worksheethelper.cxx.

References ScAddress::Col(), getCellAddressFromPosition(), getCellPosition(), getSheetIndex(), ScAddress::IncCol(), ScAddress::IncRow(), oox::xls::Point, and ScAddress::Row().

Referenced by finalizeDrawings().

Reference< XSheetCellRanges > oox::xls::WorksheetGlobals::getCellRangeList ( const ScRangeList rRanges) const

Returns the XSheetCellRanges interface for the passed cell range addresses.

Definition at line 469 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().

Reference< XCellRange > oox::xls::WorksheetGlobals::getColumn ( sal_Int32  nCol) const

Returns the XCellRange interface for a column.

Definition at line 484 of file worksheethelper.cxx.

References Exception, mxSheet, and xColumn.

Referenced by setPageBreak().

CommentsBuffer& oox::xls::WorksheetGlobals::getComments ( )
inline

Returns the buffer for all cell comments in this sheet.

Definition at line 247 of file worksheethelper.cxx.

References maComments.

Referenced by oox::xls::WorksheetHelper::getComments().

CondFormatBuffer& oox::xls::WorksheetGlobals::getCondFormats ( )
inline

Returns the conditional formatting in this sheet.

Definition at line 245 of file worksheethelper.cxx.

References maCondFormats.

Referenced by finalizeWorksheetImport(), and oox::xls::WorksheetHelper::getCondFormats().

Reference< XDrawPage > oox::xls::WorksheetGlobals::getDrawPage ( ) const

Returns the XDrawPage interface of the draw page of the current sheet.

Definition at line 514 of file worksheethelper.cxx.

References Exception, and mxSheet.

Referenced by oox::xls::WorksheetHelper::getDrawPage().

const awt::Size & oox::xls::WorksheetGlobals::getDrawPageSize ( ) const

Returns the size of the entire drawing page in 1/100 mm.

Definition at line 527 of file worksheethelper.cxx.

References maDrawPageSize.

Referenced by oox::xls::WorksheetHelper::getDrawPageSize().

ExtLst& oox::xls::WorksheetGlobals::getExtLst ( )
inline

returns the ExtLst entries that need to be filled

Definition at line 261 of file worksheethelper.cxx.

References maExtLst.

Referenced by oox::xls::WorksheetHelper::getExtLst().

OUString oox::xls::WorksheetGlobals::getHyperlinkUrl ( const HyperlinkModel rHyperlink) const
private
PageSettings& oox::xls::WorksheetGlobals::getPageSettings ( )
inline

Returns the page/print settings for this sheet.

Definition at line 255 of file worksheethelper.cxx.

References maPageSett.

Referenced by oox::xls::WorksheetHelper::getPageSettings().

QueryTableBuffer& oox::xls::WorksheetGlobals::getQueryTables ( )
inline

Returns the buffer for all web query tables in this sheet.

Definition at line 251 of file worksheethelper.cxx.

References maQueryTables.

Referenced by oox::xls::WorksheetHelper::getQueryTables().

Reference< XCellRange > oox::xls::WorksheetGlobals::getRow ( sal_Int32  nRow) const

Returns the XCellRange interface for a row.

Definition at line 499 of file worksheethelper.cxx.

References Exception, mxSheet, and xRow.

Referenced by setPageBreak().

virtual ISegmentProgressBarRef oox::xls::WorksheetGlobals::getRowProgress ( )
inlineoverridevirtual

Allow the threaded importer to override our progress bar impl.

Implements oox::xls::IWorksheetProgress.

Definition at line 310 of file worksheethelper.cxx.

References mxRowProgress.

const Reference< XSpreadsheet >& oox::xls::WorksheetGlobals::getSheet ( ) const
inline

Returns the XSpreadsheet interface of the current sheet.

Definition at line 215 of file worksheethelper.cxx.

References mxSheet.

Referenced by oox::xls::WorksheetHelper::getSheet().

SheetDataBuffer& oox::xls::WorksheetGlobals::getSheetData ( )
inline

Returns the buffer for cell contents and cell formatting.

Definition at line 243 of file worksheethelper.cxx.

References maSheetData.

Referenced by oox::xls::WorksheetHelper::getSheetData().

SCTAB oox::xls::WorksheetGlobals::getSheetIndex ( ) const
inline
WorksheetType oox::xls::WorksheetGlobals::getSheetType ( ) const
inline

Returns the type of this sheet.

Definition at line 211 of file worksheethelper.cxx.

References meSheetType.

Referenced by oox::xls::WorksheetHelper::getSheetType().

SheetViewSettings& oox::xls::WorksheetGlobals::getSheetViewSettings ( )
inline

Returns the view settings for this sheet.

Definition at line 257 of file worksheethelper.cxx.

References maSheetViewSett.

Referenced by oox::xls::WorksheetHelper::getSheetViewSettings().

VmlDrawing& oox::xls::WorksheetGlobals::getVmlDrawing ( )
inline

Returns the VML drawing page for this sheet (OOXML/BIFF12 only).

Definition at line 259 of file worksheethelper.cxx.

References mxVmlDrawing.

Referenced by oox::xls::WorksheetHelper::getVmlDrawing().

WorksheetSettings& oox::xls::WorksheetGlobals::getWorksheetSettings ( )
inline

Returns the worksheet settings object.

Definition at line 253 of file worksheethelper.cxx.

References maSheetSett.

Referenced by oox::xls::WorksheetHelper::getWorksheetSettings().

void oox::xls::WorksheetGlobals::groupColumnsOrRows ( sal_Int32  nFirstColRow,
sal_Int32  nLastColRow,
bool  bCollapsed,
bool  bRows 
)
private

Groups columns or rows for the given range.

Definition at line 1286 of file worksheethelper.cxx.

References Exception, getSheetIndex(), and mxSheet.

Referenced by convertOutlines().

void oox::xls::WorksheetGlobals::initializeWorksheetImport ( )
void oox::xls::WorksheetGlobals::insertHyperlink ( const ScAddress rAddress,
const OUString &  rUrl 
)
private
bool oox::xls::WorksheetGlobals::isValidSheet ( ) const
inline

Returns true, if this helper refers to an existing Calc sheet.

Definition at line 208 of file worksheethelper.cxx.

References mxSheet.

void oox::xls::WorksheetGlobals::setBaseColumnWidth ( sal_Int32  nWidth)
void oox::xls::WorksheetGlobals::setColumnModel ( const ColumnModel rModel)

Sets column settings for a specific column range.

Column default formatting is converted directly, other settings are cached and converted in the finalizeImport() call.

Definition at line 756 of file worksheethelper.cxx.

References ScAddress::Col(), convertColumnFormat(), first, oox::xls::WorkbookHelper::getAddressConverter(), oox::xls::AddressConverter::getMaxXlsAddress(), maColModels, oox::xls::ColumnModel::maRange, oox::ValueRange::mnFirst, oox::ValueRange::mnLast, oox::xls::ColumnModel::mnXfId, and mrMaxApiPos.

Referenced by oox::xls::WorksheetHelper::setColumnModel().

virtual void oox::xls::WorksheetGlobals::setCustomRowProgress ( const ISegmentProgressBarRef rxRowProgress)
inlineoverridevirtual

Implements oox::xls::IWorksheetProgress.

Definition at line 314 of file worksheethelper.cxx.

References mbFastRowProgress, and mxRowProgress.

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 746 of file worksheethelper.cxx.

References maDefColModel, mbHasDefWidth, and oox::xls::ColumnModel::mfWidth.

Referenced by oox::xls::WorksheetHelper::setDefaultColumnWidth().

void oox::xls::WorksheetGlobals::setDefaultRowSettings ( double  fHeight,
bool  bCustomHeight,
bool  bHidden,
bool  bThickTop,
bool  bThickBottom 
)
void oox::xls::WorksheetGlobals::setDrawingPath ( const OUString &  rDrawingPath)

Sets the path to the DrawingML fragment of this sheet.

Definition at line 686 of file worksheethelper.cxx.

References maDrawingPath.

Referenced by oox::xls::WorksheetHelper::setDrawingPath().

void oox::xls::WorksheetGlobals::setHyperlink ( const HyperlinkModel rModel)

Inserts the hyperlink URL into the spreadsheet.

Definition at line 676 of file worksheethelper.cxx.

References maHyperlinks.

Referenced by oox::xls::WorksheetHelper::setHyperlink().

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 667 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().

void oox::xls::WorksheetGlobals::setRowModel ( const RowModel rModel)

Sets row settings for a specific row.

Row default formatting is converted directly, other settings are cached and converted in the finalizeImport() call.

Definition at line 848 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().

void oox::xls::WorksheetGlobals::setValidation ( const ValidationModel rModel)

Inserts the data validation settings into the spreadsheet.

Definition at line 681 of file worksheethelper.cxx.

References maValidations.

Referenced by oox::xls::WorksheetHelper::setValidation().

void oox::xls::WorksheetGlobals::setVmlDrawingPath ( const OUString &  rVmlDrawingPath)

Sets the path to the legacy VML drawing fragment of this sheet.

Definition at line 691 of file worksheethelper.cxx.

References maVmlDrawingPath.

Referenced by oox::xls::WorksheetHelper::setVmlDrawingPath().

void oox::xls::WorksheetGlobals::UpdateRowProgress ( const ScRange rUsedArea,
SCROW  nRow 
)
private

Update the row import progress bar.

Definition at line 894 of file worksheethelper.cxx.

References ScRange::aEnd, ScRange::aStart, mbFastRowProgress, mxRowProgress, and ScAddress::Row().

Referenced by setRowModel().

Member Data Documentation

AutoFilterBuffer oox::xls::WorksheetGlobals::maAutoFilters
private

Buffer for all cell comments in this sheet.

Definition at line 372 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), and getAutoFilters().

ColumnModelRangeMap oox::xls::WorksheetGlobals::maColModels
private

Default column formatting.

Definition at line 364 of file worksheethelper.cxx.

Referenced by convertColumns(), and setColumnModel().

CommentsBuffer oox::xls::WorksheetGlobals::maComments
private

Buffer for conditional formatting.

Definition at line 371 of file worksheethelper.cxx.

Referenced by finalizeDrawings(), and getComments().

CondFormatBuffer oox::xls::WorksheetGlobals::maCondFormats
private

Buffer for cell contents and cell formatting.

Definition at line 370 of file worksheethelper.cxx.

Referenced by getCondFormats().

ColumnModel oox::xls::WorksheetGlobals::maDefColModel
private

Used area of the sheet, and sheet index of the sheet.

Definition at line 363 of file worksheethelper.cxx.

Referenced by convertColumns(), setBaseColumnWidth(), setDefaultColumnWidth(), and WorksheetGlobals().

RowModel oox::xls::WorksheetGlobals::maDefRowModel
private

Ranges of columns sorted by first column index.

Definition at line 365 of file worksheethelper.cxx.

Referenced by convertRows(), setDefaultRowSettings(), and WorksheetGlobals().

OUString oox::xls::WorksheetGlobals::maDrawingPath
private

List of extended elements.

Definition at line 379 of file worksheethelper.cxx.

Referenced by finalizeDrawings(), and setDrawingPath().

awt::Size oox::xls::WorksheetGlobals::maDrawPageSize
private

Path to legacy VML drawing fragment.

Definition at line 381 of file worksheethelper.cxx.

Referenced by finalizeDrawings(), getCellAddressFromPosition(), and getDrawPageSize().

ExtLst oox::xls::WorksheetGlobals::maExtLst
private

Collection of all VML shapes.

Definition at line 378 of file worksheethelper.cxx.

Referenced by getExtLst().

std::vector< HyperlinkModel > oox::xls::WorksheetGlobals::maHyperlinks
private

Ranges of rows sorted by first row index.

Definition at line 367 of file worksheethelper.cxx.

Referenced by finalizeHyperlinkRanges(), and setHyperlink().

PageSettings oox::xls::WorksheetGlobals::maPageSett
private

Global settings for this sheet.

Definition at line 375 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), and getPageSettings().

QueryTableBuffer oox::xls::WorksheetGlobals::maQueryTables
private

Sheet auto filters (not associated to a table).

Definition at line 373 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), and getQueryTables().

RowModelRangeMap oox::xls::WorksheetGlobals::maRowModels
private

Default row formatting.

Definition at line 366 of file worksheethelper.cxx.

Referenced by convertRows(), and setRowModel().

awt::Rectangle oox::xls::WorksheetGlobals::maShapeBoundingBox
private

Current size of the drawing page in 1/100 mm.

Definition at line 382 of file worksheethelper.cxx.

Referenced by extendShapeBoundingBox(), and finalizeDrawings().

SheetDataBuffer oox::xls::WorksheetGlobals::maSheetData
private

Cell ranges containing data validation settings.

Definition at line 369 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), getSheetData(), and setRowModel().

WorksheetSettings oox::xls::WorksheetGlobals::maSheetSett
private

Buffer for all web query tables in this sheet.

Definition at line 374 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), and getWorksheetSettings().

SheetViewSettings oox::xls::WorksheetGlobals::maSheetViewSett
private

Page/print settings for this sheet.

Definition at line 376 of file worksheethelper.cxx.

Referenced by finalizeDrawings(), finalizeWorksheetImport(), and getSheetViewSettings().

ScRange oox::xls::WorksheetGlobals::maUsedArea
private

Reference to maximum Calc cell address from address converter.

Definition at line 362 of file worksheethelper.cxx.

Referenced by extendUsedArea(), finalizeDrawings(), getSheetIndex(), setRowModel(), and WorksheetGlobals().

std::vector< ValidationModel > oox::xls::WorksheetGlobals::maValidations
private

Cell ranges containing hyperlinks.

Definition at line 368 of file worksheethelper.cxx.

Referenced by finalizeValidationRanges(), and setValidation().

OUString oox::xls::WorksheetGlobals::maVmlDrawingPath
private

Path to DrawingML fragment.

Definition at line 380 of file worksheethelper.cxx.

Referenced by finalizeDrawings(), and setVmlDrawingPath().

bool oox::xls::WorksheetGlobals::mbFastRowProgress
private

Sheet progress bar.

Definition at line 384 of file worksheethelper.cxx.

Referenced by setCustomRowProgress(), and UpdateRowProgress().

bool oox::xls::WorksheetGlobals::mbHasDefWidth
private

Reference to the current sheet.

Definition at line 389 of file worksheethelper.cxx.

Referenced by setBaseColumnWidth(), and setDefaultColumnWidth().

WorksheetType oox::xls::WorksheetGlobals::meSheetType
private

Progress bar for finalization.

Definition at line 387 of file worksheethelper.cxx.

Referenced by convertColumns(), and getSheetType().

const ScAddress& oox::xls::WorksheetGlobals::mrMaxApiPos
private
ISegmentProgressBarRef oox::xls::WorksheetGlobals::mxFinalProgress
private

Progress bar for row/cell processing.

Definition at line 386 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), and WorksheetGlobals().

ISegmentProgressBarRef oox::xls::WorksheetGlobals::mxProgressBar
private

Bounding box for all shapes from all drawings.

Definition at line 383 of file worksheethelper.cxx.

Referenced by WorksheetGlobals().

ISegmentProgressBarRef oox::xls::WorksheetGlobals::mxRowProgress
private

Do we have a progress bar thread ?

Definition at line 385 of file worksheethelper.cxx.

Referenced by finalizeWorksheetImport(), getRowProgress(), setCustomRowProgress(), UpdateRowProgress(), and WorksheetGlobals().

Reference< XSpreadsheet > oox::xls::WorksheetGlobals::mxSheet
private
VmlDrawingPtr oox::xls::WorksheetGlobals::mxVmlDrawing
private

View settings for this sheet.

Definition at line 377 of file worksheethelper.cxx.

Referenced by getVmlDrawing(), and WorksheetGlobals().


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