Manages the cell contents and cell formatting of a sheet. More...

#include <sheetdatabuffer.hxx>

Inheritance diagram for oox::xls::SheetDataBuffer:

Collaboration diagram for oox::xls::SheetDataBuffer:

Classes
struct	MergedRange
	Stores information about a merged cell range. More...

struct	RowRangeStyle

struct	StyleRowRangeComp

struct	XfIdRowRange
	Stores information about a range of rows with equal cell formatting. More...

Public Member Functions
	SheetDataBuffer (const WorksheetHelper &rHelper)

void	setBlankCell (const CellModel &rModel)
	Inserts a blank cell (with formatting) into the sheet. More...

void	setValueCell (const CellModel &rModel, double fValue)
	Inserts a value cell into the sheet. More...

void	setStringCell (const CellModel &rModel, const OUString &rText)
	Inserts a simple string cell into the sheet. More...

void	setStringCell (const CellModel &rModel, const RichStringRef &rxString)
	Inserts a rich-string cell into the sheet. More...

void	setStringCell (const CellModel &rModel, sal_Int32 nStringId)
	Inserts a shared string cell into the sheet. More...

void	setDateTimeCell (const CellModel &rModel, const css::util::DateTime &rDateTime)
	Inserts a date/time cell into the sheet and adjusts number format. More...

void	setBooleanCell (const CellModel &rModel, bool bValue)
	Inserts a boolean cell into the sheet and adjusts number format. More...

void	setErrorCell (const CellModel &rModel, const OUString &rErrorCode)
	Inserts an error cell from the passed error code into the sheet. More...

void	setErrorCell (const CellModel &rModel, sal_uInt8 nErrorCode)
	Inserts an error cell from the passed BIFF error code into the sheet. More...

void	setFormulaCell (const CellModel &rModel, const ApiTokenSequence &rTokens)
	Inserts a formula cell into the sheet. More...

void	setDateCell (const CellModel &rModel, const OUString &rDateString)
	Inserts an ISO 8601 date cell into the sheet. More...

void	createSharedFormula (const ScAddress &rRange, const ApiTokenSequence &rTokens)

void	createArrayFormula (const ScRange &rRange, const ApiTokenSequence &rTokens)
	Inserts the passed token array as array formula. More...

void	createTableOperation (const ScRange &rRange, const DataTableModel &rModel)
	Sets a multiple table operation to the passed range. More...

void	setRowFormat (sal_Int32 nRow, sal_Int32 nXfId, bool bCustomFormat)
	Sets default cell formatting for the specified range of rows. More...

void	setMergedRange (const ScRange &rRange)
	Merges the cells in the passed cell range. More...

void	setCellFormat (const CellModel &rModel)
	Processes the cell formatting data of the passed cell. More...

void	finalizeImport ()
	Final processing after the sheet has been imported. More...

void	setCellFormula (const ScAddress &rCellAddr, const ApiTokenSequence &rTokens)
	Sets the passed formula token array into a cell. 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 Types
typedef std::pair< ScRange, ApiTokenSequence >	ArrayFormula
	Stores cell range address and formula token array of an array formula. More...

typedef ::std::vector< ArrayFormula >	ArrayFormulaVector

typedef std::pair< ScRange, DataTableModel >	TableOperation
	Stores cell range address and settings of a table operation. More...

typedef ::std::pair< sal_Int32, sal_Int32 >	XfIdNumFmtKey

typedef ::o3tl::sorted_vector< RowRangeStyle, StyleRowRangeComp >	RowStyles

typedef ::std::map< sal_Int32, RowStyles >	ColStyles

typedef ::std::vector< RowRangeStyle >	TmpRowStyles

typedef ::std::map< sal_Int32, TmpRowStyles >	TmpColStyles

typedef ::std::vector< MergedRange >	MergedRangeVector

Private Member Functions
ApiTokenSequence	resolveSharedFormula (const ScAddress &rMapKey) const
	Creates a formula token array representing the shared formula with the passed identifier. More...

void	finalizeArrayFormula (const ScRange &rRange, const ApiTokenSequence &rTokens) const
	Inserts the passed array formula into the sheet. More...

void	finalizeTableOperation (const ScRange &rRange, const DataTableModel &rModel)
	Inserts the passed table operation into the sheet. More...

void	applyCellMerging (const ScRange &rRange)
	Writes all cell formatting attributes to the passed cell range list. More...

void	addColXfStyles ()

void	addColXfStyleProcessRowRanges ()

Private Attributes
ColStyles	maStylesPerColumn

ArrayFormulaVector	maArrayFormulas
	Stores cell styles by column ( in row ranges ) More...

std::vector< TableOperation >	maTableOperations
	All array formulas in the sheet. More...

::std::map< BinAddress, ApiTokenSequence >	maSharedFormulas
	All table operations in the sheet. More...

ScAddress	maSharedFmlaAddr
	Maps shared formula base address to defined name token index. More...

ScAddress	maSharedBaseAddr
	Address of a cell containing a pending shared formula. More...

XfIdRowRange	maXfIdRowRange
	Base address of the pending shared formula. More...

std::map< XfIdNumFmtKey, ScRangeList >	maXfIdRangeLists
	Cached XF identifier for a range of rows. More...

MergedRangeVector	maMergedRanges
	Collected XF identifiers for cell rangelists. More...

MergedRangeVector	maCenterFillRanges
	Merged cell ranges. More...

bool	mbPendingSharedFmla
	Merged cell ranges from 'center across' or 'fill' alignment. More...

std::map< sal_Int32, std::vector< ValueRange > >	maXfIdRowRangeList
	True = maSharedFmlaAddr and maSharedBaseAddr are valid. 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::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

Manages the cell contents and cell formatting of a sheet.

Definition at line 77 of file sheetdatabuffer.hxx.

Member Typedef Documentation

◆ ArrayFormula

typedef std::pair< ScRange, ApiTokenSequence > oox::xls::SheetDataBuffer::ArrayFormula

private

Stores cell range address and formula token array of an array formula.

Definition at line 153 of file sheetdatabuffer.hxx.

◆ ArrayFormulaVector

typedef ::std::vector< ArrayFormula > oox::xls::SheetDataBuffer::ArrayFormulaVector

private

Definition at line 154 of file sheetdatabuffer.hxx.

◆ ColStyles

typedef ::std::map< sal_Int32, RowStyles > oox::xls::SheetDataBuffer::ColStyles

private

Definition at line 191 of file sheetdatabuffer.hxx.

◆ MergedRangeVector

typedef ::std::vector< MergedRange > oox::xls::SheetDataBuffer::MergedRangeVector

private

Definition at line 204 of file sheetdatabuffer.hxx.

◆ RowStyles

typedef ::o3tl::sorted_vector< RowRangeStyle, StyleRowRangeComp > oox::xls::SheetDataBuffer::RowStyles

private

Definition at line 190 of file sheetdatabuffer.hxx.

◆ TableOperation

typedef std::pair< ScRange, DataTableModel > oox::xls::SheetDataBuffer::TableOperation

private

Stores cell range address and settings of a table operation.

Definition at line 157 of file sheetdatabuffer.hxx.

◆ TmpColStyles

typedef ::std::map< sal_Int32, TmpRowStyles > oox::xls::SheetDataBuffer::TmpColStyles

private

Definition at line 193 of file sheetdatabuffer.hxx.

◆ TmpRowStyles

typedef ::std::vector< RowRangeStyle > oox::xls::SheetDataBuffer::TmpRowStyles

private

Definition at line 192 of file sheetdatabuffer.hxx.

◆ XfIdNumFmtKey

typedef ::std::pair< sal_Int32, sal_Int32 > oox::xls::SheetDataBuffer::XfIdNumFmtKey

private

Definition at line 170 of file sheetdatabuffer.hxx.

Constructor & Destructor Documentation

◆ SheetDataBuffer()

oox::xls::SheetDataBuffer::SheetDataBuffer ( const WorksheetHelper & rHelper )

explicit

Definition at line 95 of file sheetdatabuffer.cxx.

Member Function Documentation

◆ addColXfStyleProcessRowRanges()

void oox::xls::SheetDataBuffer::addColXfStyleProcessRowRanges ( )

private

Definition at line 375 of file sheetdatabuffer.cxx.

References Col, ScAddress::Col(), o3tl::sorted_vector< typename Value, typename Compare, template< typename, typename > class Find, bool >::end(), oox::xls::WorkbookHelper::getAddressConverter(), oox::xls::AddressConverter::getMaxApiAddress(), o3tl::sorted_vector< typename Value, typename Compare, template< typename, typename > class Find, bool >::insert(), o3tl::sorted_vector< typename Value, typename Compare, template< typename, typename > class Find, bool >::lower_bound(), maStylesPerColumn, maXfIdRowRangeList, oox::xls::SheetDataBuffer::RowRangeStyle::mnEndRow, oox::xls::SheetDataBuffer::RowRangeStyle::mnNumFmt, oox::xls::SheetDataBuffer::RowRangeStyle::mnStartRow, o3tl::sorted_vector< typename Value, typename Compare, template< typename, typename > class Find, bool >::reserve(), and o3tl::sorted_vector< typename Value, typename Compare, template< typename, typename > class Find, bool >::size().

Referenced by finalizeImport().

◆ addColXfStyles()

void oox::xls::SheetDataBuffer::addColXfStyles ( )

private

Definition at line 328 of file sheetdatabuffer.cxx.

References oox::xls::addIfNotInMyMap(), oox::xls::WorkbookHelper::getStyles(), maStylesPerColumn, maXfIdRangeLists, oox::xls::SheetDataBuffer::RowRangeStyle::mnEndRow, oox::xls::SheetDataBuffer::RowRangeStyle::mnNumFmt, and oox::xls::SheetDataBuffer::RowRangeStyle::mnStartRow.

Referenced by finalizeImport().

◆ applyCellMerging()

void oox::xls::SheetDataBuffer::applyCellMerging ( const ScRange & rRange )

private

Writes all cell formatting attributes to the passed cell range list.

(depreciates writeXfIdRangeProperties)

Definition at line 792 of file sheetdatabuffer.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), ScDocument::DoMerge(), oox::xls::WorksheetHelper::getScDocument(), oox::xls::WorksheetHelper::getSheetIndex(), oox::xls::lcl_SetBorderLine(), and ScAddress::Row().

Referenced by finalizeImport().

◆ createArrayFormula()

void oox::xls::SheetDataBuffer::createArrayFormula	(	const ScRange &	rRange,
		const ApiTokenSequence &	rTokens
	)

Inserts the passed token array as array formula.

Definition at line 261 of file sheetdatabuffer.cxx.

References maArrayFormulas.

Referenced by oox::xls::SheetDataContext::importArray().

◆ createSharedFormula()

void oox::xls::SheetDataBuffer::createSharedFormula	(	const ScAddress &	rRange,
		const ApiTokenSequence &	rTokens
	)

Definition at line 205 of file sheetdatabuffer.cxx.

References maSharedBaseAddr, maSharedFmlaAddr, maSharedFormulas, mbPendingSharedFmla, resolveSharedFormula(), and setCellFormula().

Referenced by oox::xls::SheetDataContext::importSharedFmla().

◆ createTableOperation()

void oox::xls::SheetDataBuffer::createTableOperation	(	const ScRange &	rRange,
		const DataTableModel &	rModel
	)

Sets a multiple table operation to the passed range.

Definition at line 269 of file sheetdatabuffer.cxx.

References maTableOperations.

Referenced by oox::xls::SheetDataContext::importDataTable(), and oox::xls::SheetDataContext::onEndElement().

◆ finalizeArrayFormula()

void oox::xls::SheetDataBuffer::finalizeArrayFormula	(	const ScRange &	rRange,
		const ApiTokenSequence &	rTokens
	)		const

private

Inserts the passed array formula into the sheet.

Definition at line 629 of file sheetdatabuffer.cxx.

References oox::xls::WorksheetHelper::getCellRange().

Referenced by finalizeImport().

◆ finalizeImport()

void oox::xls::SheetDataBuffer::finalizeImport ( )

Final processing after the sheet has been imported.

Definition at line 452 of file sheetdatabuffer.cxx.

References addColXfStyleProcessRowRanges(), addColXfStyles(), applyCellMerging(), oox::xls::Xf::applyPatternToAttrList(), ATTR_MERGE_FLAG(), finalizeArrayFormula(), finalizeTableOperation(), oox::xls::StylesBuffer::getCellXf(), ScDocument::GetDefPattern(), ScDocumentImport::getDoc(), oox::xls::WorkbookHelper::getDocImport(), SfxItemSet::GetItem(), ScPatternAttr::GetItemSet(), ScDocument::GetPattern(), ScDocument::GetPool(), oox::xls::WorksheetHelper::getSheetIndex(), oox::xls::WorkbookHelper::getStyles(), ScMergeFlagAttr::HasAutoFilter(), ScDocumentImport::invalidateBlockPositionSet(), sc::NumFmtUtil::isLatinScript(), maArrayFormulas, oox::xls::Xf::AttrList::maAttrs, maCenterFillRanges, maMergedRanges, oox::xls::SheetDataBuffer::XfIdRowRange::maRowRange, maStylesPerColumn, maTableOperations, maXfIdRowRange, maXfIdRowRangeList, ScDocument::MaxRow(), ScDocumentImport::Attrs::mbLatinNumFmtOnly, oox::xls::Xf::AttrList::mbLatinNumFmtOnly, oox::xls::SheetDataBuffer::XfIdRowRange::mnXfId, ScDocumentImport::Attrs::mvData, ScAttrEntry::nEndRow, ScAttrEntry::pPattern, SfxItemPool::Put(), SCTAB_MAX, and ScDocumentImport::setAttrEntries().

Referenced by oox::xls::WorksheetGlobals::finalizeWorksheetImport().

◆ finalizeTableOperation()

void oox::xls::SheetDataBuffer::finalizeTableOperation	(	const ScRange &	rRange,
		const DataTableModel &	rModel
	)

private

Inserts the passed table operation into the sheet.

Definition at line 637 of file sheetdatabuffer.cxx.

References ScTabOpParam::aRefColCell, ScTabOpParam::aRefFormulaCell, ScTabOpParam::aRefFormulaEnd, ScTabOpParam::aRefRowCell, ScRange::aStart, ScTabOpParam::Both, ScAddress::Col(), ScTabOpParam::Column, oox::xls::WorkbookHelper::getAddressConverter(), oox::xls::WorkbookHelper::getDocImport(), oox::xls::WorksheetHelper::getSheetIndex(), ScAddress::IncCol(), ScAddress::IncRow(), oox::xls::DataTableModel::maRef1, oox::xls::DataTableModel::maRef2, oox::xls::DataTableModel::mb2dTable, oox::xls::DataTableModel::mbRef1Deleted, oox::xls::DataTableModel::mbRef2Deleted, oox::xls::DataTableModel::mbRowTable, ScTabOpParam::meMode, ScAddress::Row(), ScTabOpParam::Row, ScRefAddress::Set(), ScDocumentImport::setTableOpCells(), and ScAddress::Tab().

Referenced by finalizeImport().

◆ resolveSharedFormula()

ApiTokenSequence oox::xls::SheetDataBuffer::resolveSharedFormula ( const ScAddress & rMapKey ) const

private

Creates a formula token array representing the shared formula with the passed identifier.

Definition at line 622 of file sheetdatabuffer.cxx.

References oox::ContainerHelper::getMapElement(), and maSharedFormulas.

Referenced by createSharedFormula(), and setFormulaCell().

◆ setBlankCell()

void oox::xls::SheetDataBuffer::setBlankCell ( const CellModel & rModel )

Inserts a blank cell (with formatting) into the sheet.

Definition at line 101 of file sheetdatabuffer.cxx.

References setCellFormat().

Referenced by oox::xls::SheetDataContext::importCellBlank(), oox::xls::SheetDataContext::onEndElement(), and setStringCell().

◆ setBooleanCell()

void oox::xls::SheetDataBuffer::setBooleanCell	(	const CellModel &	rModel,
		bool	bValue
	)

Inserts a boolean cell into the sheet and adjusts number format.

Definition at line 169 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getFormulaBuffer(), oox::xls::CellModel::maCellAddr, setCellFormat(), and oox::xls::FormulaBuffer::setCellFormula().

Referenced by oox::xls::SheetDataContext::importCellBool(), oox::xls::SheetDataContext::onEndElement(), and oox::xls::PivotCacheField::writeItemToSourceDataCell().

◆ setCellFormat()

void oox::xls::SheetDataBuffer::setCellFormat ( const CellModel & rModel )

Processes the cell formatting data of the passed cell.

Definition at line 712 of file sheetdatabuffer.cxx.

References ScRange::aEnd, ScRange::aStart, ScRangeList::back(), ScAddress::Col(), ScRangeList::empty(), oox::xls::Xf::getAlignment(), oox::xls::StylesBuffer::getCellXf(), oox::xls::Alignment::getModel(), oox::xls::WorkbookHelper::getStyles(), i, ScAddress::IncCol(), oox::xls::CellModel::maCellAddr, maCenterFillRanges, maXfIdRangeLists, oox::xls::CellModel::mnCellType, oox::xls::AlignmentModel::mnHorAlign, oox::xls::CellModel::mnXfId, ScRangeList::push_back(), ScRangeList::Remove(), ScAddress::Row(), ScAddress::SetRow(), ScRangeList::size(), ScAddress::Tab(), and XML_TOKEN_INVALID.

Referenced by oox::xls::SheetDataContext::onEndElement(), setBlankCell(), setBooleanCell(), setErrorCell(), setFormulaCell(), setStringCell(), and setValueCell().

◆ setCellFormula()

void oox::xls::SheetDataBuffer::setCellFormula	(	const ScAddress &	rCellAddr,
		const ApiTokenSequence &	rTokens
	)

Sets the passed formula token array into a cell.

Definition at line 613 of file sheetdatabuffer.cxx.

References oox::xls::WorksheetHelper::putFormulaTokens().

Referenced by createSharedFormula(), and setFormulaCell().

◆ setDateCell()

void oox::xls::SheetDataBuffer::setDateCell	(	const CellModel &	rModel,
		const OUString &	rDateString
	)

Inserts an ISO 8601 date cell into the sheet.

Definition at line 190 of file sheetdatabuffer.cxx.

References oox::xls::UnitConverter::calcSerialFromDateTime(), oox::xls::WorkbookHelper::getUnitConverter(), sax::Converter::parseDateTime(), SAL_WARN, setStringCell(), and setValueCell().

Referenced by oox::xls::SheetDataContext::onEndElement().

◆ setDateTimeCell()

void oox::xls::SheetDataBuffer::setDateTimeCell	(	const CellModel &	rModel,
		const css::util::DateTime &	rDateTime
	)

Inserts a date/time cell into the sheet and adjusts number format.

Definition at line 147 of file sheetdatabuffer.cxx.

References oox::xls::UnitConverter::calcSerialFromDateTime(), DATETIME, Exception, oox::xls::WorksheetHelper::getCell(), oox::xls::WorkbookHelper::getDocument(), oox::xls::WorkbookHelper::getUnitConverter(), Locale, oox::xls::CellModel::maCellAddr, nIndex, PROP_NumberFormat, oox::PropertySet::setProperty(), setValueCell(), and TIME.

Referenced by oox::xls::PivotCacheField::writeItemToSourceDataCell().

◆ setErrorCell() [1/2]

void oox::xls::SheetDataBuffer::setErrorCell	(	const CellModel &	rModel,
		const OUString &	rErrorCode
	)

Inserts an error cell from the passed error code into the sheet.

Definition at line 178 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getFormulaBuffer(), oox::xls::CellModel::maCellAddr, setCellFormat(), and oox::xls::FormulaBuffer::setCellFormula().

Referenced by oox::xls::SheetDataContext::importCellError(), oox::xls::SheetDataContext::onEndElement(), setErrorCell(), and oox::xls::PivotCacheField::writeItemToSourceDataCell().

◆ setErrorCell() [2/2]

void oox::xls::SheetDataBuffer::setErrorCell	(	const CellModel &	rModel,
		sal_uInt8	nErrorCode
	)

Inserts an error cell from the passed BIFF error code into the sheet.

Definition at line 185 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getUnitConverter(), and setErrorCell().

◆ setFormulaCell()

void oox::xls::SheetDataBuffer::setFormulaCell	(	const CellModel &	rModel,
		const ApiTokenSequence &	rTokens
	)

Inserts a formula cell into the sheet.

Definition at line 213 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getFormulaParser(), oox::xls::CellModel::maCellAddr, maSharedBaseAddr, maSharedFmlaAddr, mbPendingSharedFmla, resolveSharedFormula(), setCellFormat(), and setCellFormula().

Referenced by oox::xls::SheetDataContext::importCellBool(), oox::xls::SheetDataContext::importCellDouble(), oox::xls::SheetDataContext::importCellError(), and oox::xls::SheetDataContext::importCellString().

◆ setMergedRange()

void oox::xls::SheetDataBuffer::setMergedRange ( const ScRange & rRange )

Merges the cells in the passed cell range.

Definition at line 298 of file sheetdatabuffer.cxx.

References maMergedRanges.

Referenced by oox::xls::WorksheetFragment::importMergeCell().

◆ setRowFormat()

void oox::xls::SheetDataBuffer::setRowFormat	(	sal_Int32	nRow,
		sal_Int32	nXfId,
		bool	bCustomFormat
	)

Sets default cell formatting for the specified range of rows.

Definition at line 277 of file sheetdatabuffer.cxx.

References oox::xls::SheetDataBuffer::XfIdRowRange::maRowRange, maXfIdRowRange, maXfIdRowRangeList, oox::ValueRange::mnLast, oox::xls::SheetDataBuffer::XfIdRowRange::mnXfId, oox::xls::SheetDataBuffer::XfIdRowRange::set(), and oox::xls::SheetDataBuffer::XfIdRowRange::tryExpand().

Referenced by oox::xls::WorksheetGlobals::setRowModel().

◆ setStringCell() [1/3]

void oox::xls::SheetDataBuffer::setStringCell	(	const CellModel &	rModel,
		const OUString &	rText
	)

Inserts a simple string cell into the sheet.

Definition at line 112 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getDocImport(), oox::xls::CellModel::maCellAddr, setCellFormat(), and ScDocumentImport::setStringCell().

Referenced by oox::xls::SheetDataContext::importCellRString(), oox::xls::SheetDataContext::importCellSi(), oox::xls::SheetDataContext::importCellString(), oox::xls::SheetDataContext::onEndElement(), setDateCell(), setStringCell(), oox::xls::PivotCacheField::writeItemToSourceDataCell(), and oox::xls::PivotCacheField::writeSourceHeaderCell().

◆ setStringCell() [2/3]

void oox::xls::SheetDataBuffer::setStringCell	(	const CellModel &	rModel,
		const RichStringRef &	rxString
	)

Inserts a rich-string cell into the sheet.

Definition at line 120 of file sheetdatabuffer.cxx.

References oox::xls::Xf::getAlignment(), oox::xls::StylesBuffer::getCellXf(), oox::xls::StylesBuffer::getFontFromCellXf(), oox::xls::Alignment::getModel(), oox::xls::WorkbookHelper::getStyles(), oox::xls::CellModel::maCellAddr, oox::xls::AlignmentModel::mbWrapText, oox::xls::CellModel::mnXfId, oox::xls::WorksheetHelper::putRichString(), setCellFormat(), and setStringCell().

◆ setStringCell() [3/3]

void oox::xls::SheetDataBuffer::setStringCell	(	const CellModel &	rModel,
		sal_Int32	nStringId
	)

Inserts a shared string cell into the sheet.

Definition at line 138 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getSharedStrings(), oox::xls::SharedStringsBuffer::getString(), setBlankCell(), and setStringCell().

◆ setValueCell()

void oox::xls::SheetDataBuffer::setValueCell	(	const CellModel &	rModel,
		double	fValue
	)

Inserts a value cell into the sheet.

Definition at line 106 of file sheetdatabuffer.cxx.

References oox::xls::WorkbookHelper::getDocImport(), oox::xls::CellModel::maCellAddr, setCellFormat(), and ScDocumentImport::setNumericCell().

Referenced by oox::xls::SheetDataContext::importCellDouble(), oox::xls::SheetDataContext::importCellRk(), oox::xls::SheetDataContext::onEndElement(), setDateCell(), setDateTimeCell(), and oox::xls::PivotCacheField::writeItemToSourceDataCell().

Member Data Documentation

◆ maArrayFormulas

ArrayFormulaVector oox::xls::SheetDataBuffer::maArrayFormulas

private

Stores cell styles by column ( in row ranges )

Definition at line 207 of file sheetdatabuffer.hxx.

Referenced by createArrayFormula(), and finalizeImport().

◆ maCenterFillRanges

MergedRangeVector oox::xls::SheetDataBuffer::maCenterFillRanges

private

Merged cell ranges.

Definition at line 218 of file sheetdatabuffer.hxx.

Referenced by finalizeImport(), and setCellFormat().

◆ maMergedRanges

MergedRangeVector oox::xls::SheetDataBuffer::maMergedRanges

private

Collected XF identifiers for cell rangelists.

Definition at line 217 of file sheetdatabuffer.hxx.

Referenced by finalizeImport(), and setMergedRange().

◆ maSharedBaseAddr

ScAddress oox::xls::SheetDataBuffer::maSharedBaseAddr

private

Address of a cell containing a pending shared formula.

Definition at line 213 of file sheetdatabuffer.hxx.

Referenced by createSharedFormula(), and setFormulaCell().

◆ maSharedFmlaAddr

ScAddress oox::xls::SheetDataBuffer::maSharedFmlaAddr

private

Maps shared formula base address to defined name token index.

Definition at line 212 of file sheetdatabuffer.hxx.

Referenced by createSharedFormula(), and setFormulaCell().

◆ maSharedFormulas

::std::map< BinAddress, ApiTokenSequence > oox::xls::SheetDataBuffer::maSharedFormulas

private

All table operations in the sheet.

Definition at line 211 of file sheetdatabuffer.hxx.

Referenced by createSharedFormula(), and resolveSharedFormula().

◆ maStylesPerColumn

ColStyles oox::xls::SheetDataBuffer::maStylesPerColumn

private

Definition at line 206 of file sheetdatabuffer.hxx.

Referenced by addColXfStyleProcessRowRanges(), addColXfStyles(), and finalizeImport().

◆ maTableOperations

std::vector< TableOperation > oox::xls::SheetDataBuffer::maTableOperations

private

All array formulas in the sheet.

Definition at line 209 of file sheetdatabuffer.hxx.

Referenced by createTableOperation(), and finalizeImport().

◆ maXfIdRangeLists

std::map< XfIdNumFmtKey, ScRangeList > oox::xls::SheetDataBuffer::maXfIdRangeLists

private

Cached XF identifier for a range of rows.

Definition at line 216 of file sheetdatabuffer.hxx.

Referenced by addColXfStyles(), and setCellFormat().

◆ maXfIdRowRange

XfIdRowRange oox::xls::SheetDataBuffer::maXfIdRowRange

private

Base address of the pending shared formula.

Definition at line 214 of file sheetdatabuffer.hxx.

Referenced by finalizeImport(), and setRowFormat().

◆ maXfIdRowRangeList

std::map< sal_Int32, std::vector< ValueRange > > oox::xls::SheetDataBuffer::maXfIdRowRangeList

private

True = maSharedFmlaAddr and maSharedBaseAddr are valid.

Definition at line 220 of file sheetdatabuffer.hxx.

Referenced by addColXfStyleProcessRowRanges(), finalizeImport(), and setRowFormat().

◆ mbPendingSharedFmla

bool oox::xls::SheetDataBuffer::mbPendingSharedFmla

private

Merged cell ranges from 'center across' or 'fill' alignment.

Definition at line 219 of file sheetdatabuffer.hxx.

Referenced by createSharedFormula(), and setFormulaCell().

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

Classes

Public Member Functions

Private Types

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Member Typedef Documentation

◆ ArrayFormula

◆ ArrayFormulaVector

◆ ColStyles

◆ MergedRangeVector

◆ RowStyles

◆ TableOperation

◆ TmpColStyles

◆ TmpRowStyles

◆ XfIdNumFmtKey

Constructor & Destructor Documentation

◆ SheetDataBuffer()

Member Function Documentation

◆ addColXfStyleProcessRowRanges()

◆ addColXfStyles()

◆ applyCellMerging()

◆ createArrayFormula()

◆ createSharedFormula()

◆ createTableOperation()

◆ finalizeArrayFormula()

◆ finalizeImport()

◆ finalizeTableOperation()

◆ resolveSharedFormula()

◆ setBlankCell()

◆ setBooleanCell()

◆ setCellFormat()

◆ setCellFormula()

◆ setDateCell()

◆ setDateTimeCell()

◆ setErrorCell() [1/2]

◆ setErrorCell() [2/2]

◆ setFormulaCell()

◆ setMergedRange()

◆ setRowFormat()

◆ setStringCell() [1/3]

◆ setStringCell() [2/3]

◆ setStringCell() [3/3]

◆ setValueCell()

Member Data Documentation

◆ maArrayFormulas

◆ maCenterFillRanges

◆ maMergedRanges

◆ maSharedBaseAddr

◆ maSharedFmlaAddr

◆ maSharedFormulas

◆ maStylesPerColumn

◆ maTableOperations

◆ maXfIdRangeLists

◆ maXfIdRowRange

◆ maXfIdRowRangeList

◆ mbPendingSharedFmla