XclImpXFRangeBuffer Class Reference

Contains the XF indexes for every used cell in a single sheet. More...

#include <xistyle.hxx>

Inheritance diagram for XclImpXFRangeBuffer:

Collaboration diagram for XclImpXFRangeBuffer:

Public Member Functions
	XclImpXFRangeBuffer (const XclImpXFRangeBuffer &)=delete
	make noncopyable More...
const XclImpXFRangeBuffer &	operator= (const XclImpXFRangeBuffer &)=delete
	XclImpXFRangeBuffer (const XclImpRoot &rRoot)
virtual	~XclImpXFRangeBuffer () override
void	Initialize ()
	Clears all buffered data, used to set up for a new sheet. More...
void	SetXF (const ScAddress &rScPos, sal_uInt16 nXFIndex)
	Inserts a new XF index. More...
void	SetBlankXF (const ScAddress &rScPos, sal_uInt16 nXFIndex)
	Inserts a new XF index for blank cells. More...
void	SetBoolXF (const ScAddress &rScPos, sal_uInt16 nXFIndex)
	Inserts a new XF index for boolean cells. More...
void	SetRowDefXF (SCROW nScRow, sal_uInt16 nXFIndex)
	Inserts a new XF index for all cells in a row. More...
void	SetColumnDefXF (SCCOL nScCol, sal_uInt16 nXFIndex)
	Inserts a new XF index for all cells in a column. More...
void	SetHyperlink (const XclRange &rXclRange, const OUString &rUrl)
	Inserts a range of hyperlink cells. More...
void	SetMerge (SCCOL nScCol1, SCROW nScRow1, SCCOL nScCol2, SCROW nScRow2)
	Inserts a complete merged cell range. More...
void	Finalize ()
	Applies styles and cell merging to the current sheet in the document. More...

Private Types
enum	XclImpXFInsertMode {   xlXFModeCell ,   xlXFModeBoolCell ,   xlXFModeBlank ,   xlXFModeRow }
	Insertion mode of an XF index. More...

Private Member Functions
void	SetXF (const ScAddress &rScPos, sal_uInt16 nXFIndex, XclImpXFInsertMode eMode)
	Inserts a new XF index for the specified cell type. More...
void	SetBorderLine (const ScRange &rRange, SCTAB nScTab, SvxBoxItemLine nLine)
	Copies border of the last cell of the range to the first cell to keep it visible when the range is merged. More...

Private Attributes
std::vector< std::shared_ptr< XclImpXFRangeColumn > >	maColumns
std::vector< std::pair< XclRange, OUString > >	maHyperlinks
	Array of column XF index buffers. More...
ScRangeList	maMergeList
	Maps URLs to hyperlink cells. More...

Additional Inherited Members
Protected Member Functions inherited from XclImpRoot
	XclImpRoot (XclImpRootData &rImpRootData)
const XclImpRoot &	GetRoot () const
	Returns this root instance - for code readability in derived classes. More...
XclImpRoot &	GetRoot ()
void	SetCodePage (sal_uInt16 nCodePage)
	Sets a code page read from a CODEPAGE record for byte string import. More...
void	InitializeTable (SCTAB nScTab)
	Is called when import filter starts importing a single sheet (all BIFF versions). More...
void	FinalizeTable ()
	Is called when import filter stops importing a single sheet (all BIFF versions). More...
XclImpAddressConverter &	GetAddressConverter () const
	Returns the address converter. More...
XclImpFormulaCompiler &	GetFormulaCompiler () const
	Returns the formula converter. More...
ExcelToSc &	GetOldFmlaConverter () const
	Returns the old formula converter. More...
XclImpSst &	GetSst () const
	Returns the shared string table. More...
XclImpPalette &	GetPalette () const
	Returns the color buffer. More...
XclImpFontBuffer &	GetFontBuffer () const
	Returns the font buffer. More...
XclImpNumFmtBuffer &	GetNumFmtBuffer () const
	Returns the number format buffer. More...
XclImpXFBuffer &	GetXFBuffer () const
	Returns the cell formatting attributes buffer. More...
XclImpXFRangeBuffer &	GetXFRangeBuffer () const
	Returns the buffer of XF index ranges for a sheet. More...
ScRangeListTabs &	GetPrintAreaBuffer () const
	Returns the buffer that contains all print areas in the document. More...
ScRangeListTabs &	GetTitleAreaBuffer () const
	Returns the buffer that contains all print titles in the document. More...
XclImpTabInfo &	GetTabInfo () const
	Returns the buffer that contains the sheet creation order. More...
XclImpNameManager &	GetNameManager () const
	Returns the buffer that contains internal defined names. More...
XclImpLinkManager &	GetLinkManager () const
	Returns the link manager. More...
XclImpObjectManager &	GetObjectManager () const
	Returns the drawing object manager. More...
XclImpSheetDrawing &	GetCurrSheetDrawing () const
	Returns the drawing container of the current sheet. More...
XclImpCondFormatManager &	GetCondFormatManager () const
	Returns the conditional formatting manager. More...
XclImpValidationManager &	GetValidationManager () const
XclImpAutoFilterBuffer &	GetFilterManager () const
	Returns the filter manager. More...
XclImpWebQueryBuffer &	GetWebQueryBuffer () const
	Returns the web query buffer. More...
XclImpPivotTableManager &	GetPivotTableManager () const
	Returns the pivot table manager. More...
XclImpSheetProtectBuffer &	GetSheetProtectBuffer () const
	Returns the sheet protection options of the current sheet. More...
XclImpDocProtectBuffer &	GetDocProtectBuffer () const
	Returns the document protection options. More...
XclImpPageSettings &	GetPageSettings () const
	Returns the page settings of the current sheet. More...
XclImpDocViewSettings &	GetDocViewSettings () const
	Returns the view settings of the entire document. More...
XclImpTabViewSettings &	GetTabViewSettings () const
	Returns the view settings of the current sheet. More...
bool	HasBasic () const
	Returns true, if the document contains a VB project. More...
void	SetHasBasic ()
	Called to indicate that the document contains a VB project. More...
void	ReadCodeName (XclImpStream &rStrm, bool bGlobals)
	Reads the CODENAME record and inserts the codename into the document. More...
ScDocumentImport &	GetDocImport ()
Protected Member Functions inherited from XclRoot
	XclRoot (XclRootData &rRootData)
	XclRoot (const XclRoot &rRoot)
virtual	~XclRoot ()
XclRoot &	operator= (const XclRoot &rRoot)
RootData &	GetOldRoot () const
	Returns old RootData struct. More...
XclBiff	GetBiff () const
	Returns the current BIFF version of the importer/exporter. More...
XclOutput	GetOutput () const
	Returns the current output format of the importer/exporter. More...
bool	IsImport () const
	Returns true, if currently a document is imported. More...
rtl_TextEncoding	GetTextEncoding () const
	Returns the text encoding to import/export byte strings. More...
LanguageType	GetSysLanguage () const
	Returns the system language, i.e. More...
LanguageType	GetDocLanguage () const
	Returns the document language. More...
LanguageType	GetUILanguage () const
	Returns the UI language. More...
sal_Int16	GetDefApiScript () const
	Returns the default script type, e.g. More...
tools::Long	GetCharWidth () const
	Returns the width of the '0' character (default font) for the current printer (twips). More...
tools::Long	GetSpaceWidth () const
bool	IsInGlobals () const
	Returns the current Calc sheet index. More...
SCTAB	GetCurrScTab () const
	Returns the current Calc sheet index. More...
sal_Int32	GetHmmFromPixelX (double fPixelX) const
	Calculates the width of the passed number of pixels in 1/100 mm. More...
sal_Int32	GetHmmFromPixelY (double fPixelY) const
	Calculates the height of the passed number of pixels in 1/100 mm. More...
SfxMedium &	GetMedium () const
	Returns the medium to import from. More...
const OUString &	GetDocUrl () const
	Returns the document URL of the imported/exported file. More...
const OUString &	GetBasePath () const
	Returns the base path of the imported/exported file. More...
const OUString &	GetUserName () const
	Returns the current user name. More...
css::uno::Sequence< css::beans::NamedValue >	RequestEncryptionData (::comphelper::IDocPasswordVerifier &rVerifier) const
	Requests and verifies a password from the medium or the user. More...
const tools::SvRef< SotStorage > &	GetRootStorage () const
	Returns the OLE2 root storage of the imported/exported file. More...
bool	HasVbaStorage () const
	Returns true, if the document contains a VBA storage. More...
tools::SvRef< SotStorage >	OpenStorage (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName) const
	Tries to open a storage as child of the specified storage for reading or writing. More...
tools::SvRef< SotStorage >	OpenStorage (const OUString &rStrgName) const
	Tries to open a storage as child of the root storage for reading or writing. More...
tools::SvRef< SotStorageStream >	OpenStream (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName) const
	Tries to open a new stream in the specified storage for reading or writing. More...
tools::SvRef< SotStorageStream >	OpenStream (const OUString &rStrmName) const
	Tries to open a new stream in the root storage for reading or writing. More...
ScDocument &	GetDoc () const
	Returns reference to the destination document (import) or source document (export). More...
SfxObjectShell *	GetDocShell () const
	Returns the object shell of the Calc document. More...
ScModelObj *	GetDocModelObj () const
	Returns the object model of the Calc document. More...
OutputDevice *	GetPrinter () const
	Returns pointer to the printer of the Calc document. More...
ScStyleSheetPool &	GetStyleSheetPool () const
	Returns the style sheet pool of the Calc document. More...
ScRangeName &	GetNamedRanges () const
	Returns the defined names container of the Calc document. More...
SdrPage *	GetSdrPage (SCTAB nScTab) const
	Returns the drawing layer page of the passed sheet, if present. More...
SvNumberFormatter &	GetFormatter () const
	Returns the number formatter of the Calc document. More...
DateTime	GetNullDate () const
	Returns the null date of the current number formatter. More...
sal_uInt16	GetBaseYear () const
	Returns the base year depending on the current null date (1900 or 1904). More...
double	GetDoubleFromDateTime (const DateTime &rDateTime) const
	Converts a date/time value to a floating-point value. More...
DateTime	GetDateTimeFromDouble (double fValue) const
	Converts a floating-point value to a date/time value. More...
ScEditEngineDefaulter &	GetEditEngine () const
	Returns the edit engine for import/export of rich strings etc. More...
ScHeaderEditEngine &	GetHFEditEngine () const
	Returns the edit engine for import/export of headers/footers. More...
EditEngine &	GetDrawEditEngine () const
	Returns the edit engine for import/export of drawing text boxes. More...
XclFontPropSetHelper &	GetFontPropSetHelper () const
	Returns the property set helper for fonts. More...
XclChPropSetHelper &	GetChartPropSetHelper () const
	Returns the property set helper for the chart filters. More...
ScExtDocOptions &	GetExtDocOptions () const
	Returns the extended document options. More...
XclTracer &	GetTracer () const
	Returns the filter tracer. More...
const ScAddress &	GetScMaxPos () const
	Returns the highest possible cell address in a Calc document. More...
const ScAddress &	GetXclMaxPos () const
	Returns the highest possible cell address in an Excel document (using current BIFF version). More...
const ScAddress &	GetMaxPos () const
	Returns the highest possible cell address valid in Calc and Excel (using current BIFF version). More...
void	SetDocLanguage (LanguageType eLang)
	Sets the document language. More...
void	SetUILanguage (LanguageType eLang)
	Sets the UI language, i.e. More...
void	SetTextEncoding (rtl_TextEncoding eTextEnc)
	Sets the text encoding to import/export byte strings. More...
void	SetCharWidth (const XclFontData &rFontData)
	Sets the width of the '0' - '9' digit character as well as the ' ' space char (using the default font) for the current printer (twips). More...
void	SetCurrScTab (SCTAB nScTab)
	Sets the current Calc sheet index. More...
void	IncCurrScTab ()
	Increases the current Calc sheet index by 1. More...
Static Protected Member Functions inherited from XclImpRoot
static OUString	GetScAddInName (const OUString &rXclName)
	Returns the Calc add-in function name for an Excel function name. More...
Static Protected Member Functions inherited from XclRoot
static OUString	GetDefaultPassword ()
	Returns the default password used for stream encryption. More...

Detailed Description

Contains the XF indexes for every used cell in a single sheet.

Definition at line 607 of file xistyle.hxx.

Member Enumeration Documentation

XclImpXFInsertMode

enum XclImpXFRangeBuffer::XclImpXFInsertMode

private

Insertion mode of an XF index.

Enumerator
xlXFModeCell
xlXFModeBoolCell	Filled cell.
xlXFModeBlank	Cell with a single Boolean value.
xlXFModeRow	Blank cell. Row default XF.

Definition at line 642 of file xistyle.hxx.

Constructor & Destructor Documentation

XclImpXFRangeBuffer() [1/2]

XclImpXFRangeBuffer::XclImpXFRangeBuffer ( const XclImpXFRangeBuffer &  )

delete

make noncopyable

XclImpXFRangeBuffer() [2/2]

XclImpXFRangeBuffer::XclImpXFRangeBuffer ( const XclImpRoot &  rRoot )

explicit

Definition at line 1879 of file xistyle.cxx.

~XclImpXFRangeBuffer()

XclImpXFRangeBuffer::~XclImpXFRangeBuffer ( )

overridevirtual

Definition at line 1884 of file xistyle.cxx.

Member Function Documentation

Finalize()

void XclImpXFRangeBuffer::Finalize

(

)

Applies styles and cell merging to the current sheet in the document.

Definition at line 1985 of file xistyle.cxx.

References ScRange::aEnd, XclImpXF::ApplyPatternToAttrVector(), ScRange::aStart, ATTR_LINEBREAK(), XclImpXFRangeColumn::begin(), CELLTYPE_EDIT, ScAddress::Col(), ScDocument::DoMerge(), XclImpXFRangeColumn::end(), ScDocument::GetAttr(), ScDocument::GetCellType(), XclRoot::GetCurrScTab(), ScDocument::GetDefPattern(), ScDocumentImport::getDoc(), XclImpRoot::GetDocImport(), ScDocument::GetEditText(), XclImpRoot::GetNumFmtBuffer(), XclRoot::GetOldRoot(), XclImpRoot::GetRoot(), XclNumFmtBuffer::GetStdScNumFmt(), XclImpXFBuffer::GetXF(), XclImpRoot::GetXFBuffer(), XclImpXFIndex::GetXFIndex(), i, XclImpHyperlink::InsertUrl(), XclImpXFIndex::IsBoolCell(), maColumns, maHyperlinks, maMergeList, XclImpXFRange::maXFIndex, ScDocument::MaxRow(), ScDocumentImport::Attrs::mbLatinNumFmtOnly, XclImpXFRange::mnScRow1, XclImpXFRange::mnScRow2, ScDocumentImport::Attrs::mvData, ScAttrEntry::nEndRow, NUMBERFORMAT_ENTRY_NOT_FOUND, RootData::pColRowBuff, ScAttrEntry::pPattern, ScAddress::Row(), ScDocumentImport::setAttrEntries(), SetBorderLine(), XclImpColRowSettings::SetManualRowHeight(), and ScRangeList::size().

Referenced by XclImpRoot::FinalizeTable().

Initialize()

void XclImpXFRangeBuffer::Initialize

(

)

Clears all buffered data, used to set up for a new sheet.

Definition at line 1888 of file xistyle.cxx.

References maColumns, maHyperlinks, maMergeList, and ScRangeList::RemoveAll().

Referenced by XclImpRoot::InitializeTable().

operator=()

const XclImpXFRangeBuffer & XclImpXFRangeBuffer::operator= ( const XclImpXFRangeBuffer &  )

delete

SetBlankXF()

void XclImpXFRangeBuffer::SetBlankXF	(	const ScAddress &	rScPos,
		sal_uInt16	nXFIndex
	)

Inserts a new XF index for blank cells.

Definition at line 1931 of file xistyle.cxx.

References SetXF(), and xlXFModeBlank.

Referenced by ImportExcel::Mulblank(), and ImportExcel::ReadBlank().

SetBoolXF()

void XclImpXFRangeBuffer::SetBoolXF	(	const ScAddress &	rScPos,
		sal_uInt16	nXFIndex
	)

Inserts a new XF index for boolean cells.

Definition at line 1936 of file xistyle.cxx.

References SetXF(), and xlXFModeBoolCell.

Referenced by ImportExcel::ReadBoolErr().

SetBorderLine()

void XclImpXFRangeBuffer::SetBorderLine ( const ScRange &  rRange, SCTAB  nScTab, SvxBoxItemLine  nLine  )

private

Copies border of the last cell of the range to the first cell to keep it visible when the range is merged.

Parameters

nLine

SvxBoxItemLine::RIGHT = copy most-right border of top row; SvxBoxItemLine::BOTTOM = copy most-bottom border of first column.

Definition at line 1958 of file xistyle.cxx.

References ScRange::aEnd, ScDocument::ApplyAttr(), ScRange::aStart, ATTR_BORDER(), ScAddress::Col(), ScDocument::GetAttr(), XclRoot::GetDoc(), SvxBoxItem::GetLine(), ScAddress::Row(), and SvxBoxItem::SetLine().

Referenced by Finalize().

SetColumnDefXF()

void XclImpXFRangeBuffer::SetColumnDefXF	(	SCCOL	nScCol,
		sal_uInt16	nXFIndex
	)

Inserts a new XF index for all cells in a column.

Definition at line 1947 of file xistyle.cxx.

References XclImpRoot::GetRoot(), maColumns, and nIndex.

Referenced by XclImpColRowSettings::SetDefaultXF().

SetHyperlink()

void XclImpXFRangeBuffer::SetHyperlink	(	const XclRange &	rXclRange,
		const OUString &	rUrl
	)

Inserts a range of hyperlink cells.

Definition at line 1974 of file xistyle.cxx.

References maHyperlinks.

SetMerge()

void XclImpXFRangeBuffer::SetMerge	(	SCCOL	nScCol1,
		SCROW	nScRow1,
		SCCOL	nScCol2,
		SCROW	nScRow2
	)

Inserts a complete merged cell range.

Definition at line 1979 of file xistyle.cxx.

References maMergeList, and ScRangeList::push_back().

Referenced by ImportExcel::Cellmerging().

SetRowDefXF()

void XclImpXFRangeBuffer::SetRowDefXF	(	SCROW	nScRow,
		sal_uInt16	nXFIndex
	)

Inserts a new XF index for all cells in a row.

Definition at line 1941 of file xistyle.cxx.

References XclRoot::GetDoc(), ScDocument::MaxCol(), SetXF(), and xlXFModeRow.

Referenced by ImportExcel::Row34().

SetXF() [1/2]

void XclImpXFRangeBuffer::SetXF	(	const ScAddress &	rScPos,
		sal_uInt16	nXFIndex
	)

Inserts a new XF index.

Definition at line 1926 of file xistyle.cxx.

References SetXF(), and xlXFModeCell.

Referenced by ImportExcel::Formula(), ImportExcel8::Labelsst(), ImportExcel::Mulrk(), ImportExcel::ReadBoolErr(), ImportExcel::ReadInteger(), ImportExcel::ReadLabel(), ImportExcel::ReadNumber(), ImportExcel::ReadRk(), ImportExcel::Rstring(), SetBlankXF(), SetBoolXF(), SetRowDefXF(), SetXF(), and ImportExcel::Shrfmla().

SetXF() [2/2]

void XclImpXFRangeBuffer::SetXF ( const ScAddress &  rScPos, sal_uInt16  nXFIndex, XclImpXFInsertMode  eMode  )

private

Inserts a new XF index for the specified cell type.

Definition at line 1895 of file xistyle.cxx.

References ScRange::aEnd, ScRangeList::back(), ScAddress::Col(), eMode, ScRangeList::empty(), EXC_XF_HOR_CENTER_AS, EXC_XF_HOR_FILL, XclImpXF::GetHorAlign(), XclImpXFBuffer::GetXF(), XclImpRoot::GetXFBuffer(), ScAddress::IncCol(), maColumns, maMergeList, nIndex, ScRangeList::push_back(), ScAddress::Row(), xlXFModeBlank, xlXFModeBoolCell, and xlXFModeRow.

Member Data Documentation

maColumns

std::vector< std::shared_ptr< XclImpXFRangeColumn > > XclImpXFRangeBuffer::maColumns

private

Definition at line 664 of file xistyle.hxx.

Referenced by Finalize(), Initialize(), SetColumnDefXF(), and SetXF().

maHyperlinks

std::vector< std::pair< XclRange, OUString > > XclImpXFRangeBuffer::maHyperlinks

private

Array of column XF index buffers.

Definition at line 666 of file xistyle.hxx.

Referenced by Finalize(), Initialize(), and SetHyperlink().

maMergeList

ScRangeList XclImpXFRangeBuffer::maMergeList

private

Maps URLs to hyperlink cells.

Definition at line 667 of file xistyle.hxx.

Referenced by Finalize(), Initialize(), SetMerge(), and SetXF().

---

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

• xistyle.hxx
• xistyle.cxx