Contains static methods used anywhere in the filters. More...

#include <ftools.hxx>

Public Member Functions
	ScfTools ()=delete
	We don't want anybody to instantiate this class, since it is just a collection of static items. More...

	ScfTools (const ScfTools &)=delete

const ScfTools &	operator= (const ScfTools &)=delete

Static Public Member Functions
static double	ReadLongDouble (SvStream &rStrm)
	Reads a 10-byte-long-double and converts it to double. More...

static rtl_TextEncoding	GetSystemTextEncoding ()
	Returns system text encoding for byte string conversion. More...

static OUString	GetHexStr (sal_uInt16 nValue)
	Returns a string representing the hexadecimal value of nValue. More...

static sal_uInt8	GetMixedColorComp (sal_uInt8 nFore, sal_uInt8 nBack, sal_uInt8 nTrans)
	Mixes RGB components with given transparence. More...

static Color	GetMixedColor (const Color &rFore, const Color &rBack, sal_uInt8 nTrans)
	Mixes colors with given transparence. More...

static OUString	ConvertToScDefinedName (const OUString &rName)
	Converts a string to a valid Calc defined name or database range name. More...

static tools::SvRef< SotStorage >	OpenStorageRead (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName)
	Tries to open an existing storage with the specified name in the passed storage (read-only). More...

static tools::SvRef< SotStorage >	OpenStorageWrite (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName)
	Creates and opens a storage with the specified name in the passed storage (read/write). More...

static tools::SvRef< SotStorageStream >	OpenStorageStreamRead (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName)
	Tries to open an existing stream with the specified name in the passed storage (read-only). More...

static tools::SvRef< SotStorageStream >	OpenStorageStreamWrite (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName)
	Creates and opens a stream with the specified name in the passed storage (read/write). More...

static bool	CheckItem (const SfxItemSet &rItemSet, sal_uInt16 nWhichId, bool bDeep)
	Returns true, if the passed item set contains the item. More...

static bool	CheckItems (const SfxItemSet &rItemSet, const sal_uInt16 *pnWhichIds, bool bDeep)
	Returns true, if the passed item set contains at least one of the items. More...

static void	PutItem (SfxItemSet &rItemSet, const SfxPoolItem &rItem, sal_uInt16 nWhichId, bool bSkipPoolDef)
	Puts the item into the passed item set. More...

static void	PutItem (SfxItemSet &rItemSet, const SfxPoolItem &rItem, bool bSkipPoolDef)
	Puts the item into the passed item set. More...

static ScStyleSheet &	MakeCellStyleSheet (ScStyleSheetPool &rPool, const OUString &rStyleName, bool bForceName)
	Creates and returns a cell style sheet and inserts it into the pool. More...

static ScStyleSheet &	MakePageStyleSheet (ScStyleSheetPool &rPool, const OUString &rStyleName, bool bForceName)
	Creates and returns a page style sheet and inserts it into the pool. More...

static OString	read_zeroTerminated_uInt8s_ToOString (SvStream &rStrm, sal_Int32 &rnBytesLeft)
	Reads and returns a zero terminated byte string and decreases a stream counter. More...

static OUString	read_zeroTerminated_uInt8s_ToOUString (SvStream &rStrm, sal_Int32 &rnBytesLeft, rtl_TextEncoding eTextEnc)
	Reads and returns a zero terminated byte string and decreases a stream counter. More...

static void	AppendCString (SvStream &rStrm, OUString &rString, rtl_TextEncoding eTextEnc)
	Appends a zero terminated byte string. More...

static const OUString &	GetHTMLDocName ()
	Returns the built-in range name for an HTML document. More...

static const OUString &	GetHTMLTablesName ()
	Returns the built-in range name for all HTML tables. More...

static OUString	GetNameFromHTMLIndex (sal_uInt32 nIndex)
	Returns the built-in range name for an HTML table, specified by table index. More...

static OUString	GetNameFromHTMLName (const OUString &rTabName)
	Returns the built-in range name for an HTML table, specified by table name. More...

static bool	IsHTMLDocName (const OUString &rSource)
	Returns true, if rSource is the built-in range name for an HTML document. More...

static bool	IsHTMLTablesName (const OUString &rSource)
	Returns true, if rSource is the built-in range name for all HTML tables. More...

static bool	GetHTMLNameFromName (const OUString &rSource, OUString &rName)
	Converts a built-in range name to an HTML table name. More...

Static Private Member Functions
static const OUString &	GetHTMLIndexPrefix ()
	Returns the prefix for table index names. More...

static const OUString &	GetHTMLNamePrefix ()
	Returns the prefix for table names. More...

Detailed Description

Contains static methods used anywhere in the filters.

Definition at line 117 of file ftools.hxx.

Constructor & Destructor Documentation

ScfTools::ScfTools ( )

delete

We don't want anybody to instantiate this class, since it is just a collection of static items.

ScfTools::ScfTools ( const ScfTools & )

delete

Member Function Documentation

void ScfTools::AppendCString	(	SvStream &	rStrm,
		OUString &	rString,
		rtl_TextEncoding	eTextEnc
	)

static

Appends a zero terminated byte string.

Definition at line 274 of file ftools.cxx.

References read_zeroTerminated_uInt8s_ToOUString().

Referenced by ImportLotus::Read().

bool ScfTools::CheckItem	(	const SfxItemSet &	rItemSet,
		sal_uInt16	nWhichId,
		bool	bDeep
	)

static

Returns true, if the passed item set contains the item.

Parameters

bDeep true = Searches in parent item sets too.

Definition at line 196 of file ftools.cxx.

References SfxItemSet::GetItemState().

Referenced by CheckItems(), XclExpCellProt::FillFromItemSet(), XclExpCellAlign::FillFromItemSet(), XclExpCellBorder::FillFromItemSet(), XclExpCellArea::FillFromItemSet(), XclExpColor::FillFromItemSet(), XclExpXF::Init(), XclExpCellTable::XclExpCellTable(), XclExpCFImpl::XclExpCFImpl(), and XclExpPageSettings::XclExpPageSettings().

bool ScfTools::CheckItems	(	const SfxItemSet &	rItemSet,
		const sal_uInt16 *	pnWhichIds,
		bool	bDeep
	)

static

Returns true, if the passed item set contains at least one of the items.

Parameters

pnWhichIds	Zero-terminated array of Which-IDs.
bDeep	true = Searches in parent item sets too.

Definition at line 201 of file ftools.cxx.

References CheckItem().

Referenced by XclExpFontHelper::CheckItems().

OUString ScfTools::ConvertToScDefinedName ( const OUString & rName )

static

Converts a string to a valid Calc defined name or database range name.

Defined names in Calc may contain letters, digits (*), underscores, periods (*), colons (*), question marks, and dollar signs. (*) = not allowed at first position.

Definition at line 145 of file ftools.cxx.

References CharName, ScCompiler::IsCharFlagAllConventions(), Name, nPos, sName, and u.

Referenced by OP_NamedRange(), OP_SymphNamedRange(), XclImpExtName::XclImpExtName(), and XclImpName::XclImpName().

OUString ScfTools::GetHexStr ( sal_uInt16 nValue )

static

Returns a string representing the hexadecimal value of nValue.

Definition at line 117 of file ftools.cxx.

References aStr.

Referenced by XclImpPivotCache::ReadPivotCacheStream(), and XclExpPivotCache::WriteCacheStream().

const OUString & ScfTools::GetHTMLDocName ( )

static

Returns the built-in range name for an HTML document.

Definition at line 281 of file ftools.cxx.

Referenced by IsHTMLDocName(), XclImpWebQuery::ReadParamqry(), and ScHTMLImport::WriteToDocument().

const OUString & ScfTools::GetHTMLIndexPrefix ( )

staticprivate

Returns the prefix for table index names.

Definition at line 293 of file ftools.cxx.

Referenced by GetHTMLNameFromName(), and GetNameFromHTMLIndex().

bool ScfTools::GetHTMLNameFromName	(	const OUString &	rSource,
		OUString &	rName
	)

static

Converts a built-in range name to an HTML table name.

Parameters

rSource	The string to be determined.
rName	The HTML table name.

Returns: true, if conversion was successful.

Definition at line 328 of file ftools.cxx.

References ScGlobal::AddQuotes(), aIndex, GetHTMLIndexPrefix(), GetHTMLNamePrefix(), getLength(), and CharClass::isAsciiNumeric().

Referenced by XclExpWebQuery::XclExpWebQuery().

const OUString & ScfTools::GetHTMLNamePrefix ( )

staticprivate

Returns the prefix for table names.

Definition at line 300 of file ftools.cxx.

Referenced by GetHTMLNameFromName(), and GetNameFromHTMLName().

const OUString & ScfTools::GetHTMLTablesName ( )

static

Returns the built-in range name for all HTML tables.

Definition at line 287 of file ftools.cxx.

Referenced by IsHTMLTablesName(), XclImpWebQuery::ReadParamqry(), and ScHTMLImport::WriteToDocument().

Color ScfTools::GetMixedColor	(	const Color &	rFore,
		const Color &	rBack,
		sal_uInt8	nTrans
	)

static

Mixes colors with given transparence.

Parameters

nTrans Foreground transparence (0x00 == full rFore ... 0x80 = full rBack).

Definition at line 133 of file ftools.cxx.

References Color::GetBlue(), Color::GetGreen(), GetMixedColorComp(), and Color::GetRed().

Referenced by XclTools::GetPatternColor(), and XclImpChRoot::GetSeriesFillAutoColor().

sal_uInt8 ScfTools::GetMixedColorComp	(	sal_uInt8	nFore,
		sal_uInt8	nBack,
		sal_uInt8	nTrans
	)

static

Mixes RGB components with given transparence.

Parameters

nTrans Foreground transparence (0x00 == full nFore ... 0x80 = full nBack).

Definition at line 127 of file ftools.cxx.

Referenced by GetMixedColor().

OUString ScfTools::GetNameFromHTMLIndex ( sal_uInt32 nIndex )

static

Returns the built-in range name for an HTML table, specified by table index.

Definition at line 306 of file ftools.cxx.

References aName, and GetHTMLIndexPrefix().

Referenced by ScHTMLImport::GetHTMLRangeNameList(), XclImpWebQuery::ReadWqtables(), and ScHTMLImport::WriteToDocument().

OUString ScfTools::GetNameFromHTMLName ( const OUString & rTabName )

static

Returns the built-in range name for an HTML table, specified by table name.

Definition at line 313 of file ftools.cxx.

References GetHTMLNamePrefix().

Referenced by XclImpWebQuery::ReadWqtables(), and ScHTMLImport::WriteToDocument().

rtl_TextEncoding ScfTools::GetSystemTextEncoding ( )

static

Returns system text encoding for byte string conversion.

Definition at line 112 of file ftools.cxx.

Referenced by XclImpFont::FillToItemSet(), oox::xls::Font::fillToItemSet(), and XclExpFontBuffer::InitDefaultFonts().

bool ScfTools::IsHTMLDocName ( const OUString & rSource )

static

Returns true, if rSource is the built-in range name for an HTML document.

Definition at line 318 of file ftools.cxx.

References GetHTMLDocName().

Referenced by XclExpWebQuery::XclExpWebQuery().

bool ScfTools::IsHTMLTablesName ( const OUString & rSource )

static

Returns true, if rSource is the built-in range name for all HTML tables.

Definition at line 323 of file ftools.cxx.

References GetHTMLTablesName().

Referenced by ScHTMLImport::GetHTMLRangeNameList(), and XclExpWebQuery::XclExpWebQuery().

ScStyleSheet & ScfTools::MakeCellStyleSheet	(	ScStyleSheetPool &	rPool,
		const OUString &	rStyleName,
		bool	bForceName
	)

static

Creates and returns a cell style sheet and inserts it into the pool.

If the style sheet is already in the pool, another unused style name is used.

Parameters

bForceName Controls behaviour, if the style already exists: true = Old existing style will be renamed; false = New style gets another name.

Definition at line 253 of file ftools.cxx.

Referenced by oox::xls::StylesBuffer::createDxfStyle(), oox::xls::StylesBuffer::createExtDxfStyle(), and XclImpCondFormat::ReadCF().

ScStyleSheet & ScfTools::MakePageStyleSheet	(	ScStyleSheetPool &	rPool,
		const OUString &	rStyleName,
		bool	bForceName
	)

static

Creates and returns a page style sheet and inserts it into the pool.

If the style sheet is already in the pool, another unused style name is used.

Parameters

bForceName Controls behaviour, if the style already exists: true = Old existing style will be renamed; false = New style gets another name.

Definition at line 258 of file ftools.cxx.

Referenced by XclImpPageSettings::Finalize().

tools::SvRef< SotStorage > ScfTools::OpenStorageRead	(	tools::SvRef< SotStorage > const &	xStrg,
		const OUString &	rStrgName
	)

static

Tries to open an existing storage with the specified name in the passed storage (read-only).

Definition at line 161 of file ftools.cxx.

References tools::SvRef< T >::is(), SotStorage::IsContained(), and SotStorage::OpenSotStorage().

Referenced by XclRoot::OpenStorage().

tools::SvRef< SotStorageStream > ScfTools::OpenStorageStreamRead	(	tools::SvRef< SotStorage > const &	xStrg,
		const OUString &	rStrmName
	)

static

Tries to open an existing stream with the specified name in the passed storage (read-only).

Definition at line 177 of file ftools.cxx.

References tools::SvRef< T >::is(), SotStorage::IsContained(), SotStorage::IsStream(), and SotStorage::OpenSotStream().

Referenced by XclRoot::OpenStream(), and ScFormatFilterPluginImpl::ScImportExcel().

tools::SvRef< SotStorageStream > ScfTools::OpenStorageStreamWrite	(	tools::SvRef< SotStorage > const &	xStrg,
		const OUString &	rStrmName
	)

static

Creates and opens a stream with the specified name in the passed storage (read/write).

Definition at line 185 of file ftools.cxx.

References tools::SvRef< T >::is(), SotStorage::IsContained(), and SotStorage::OpenSotStream().

Referenced by lcl_ExportExcelBiff(), and XclRoot::OpenStream().

tools::SvRef< SotStorage > ScfTools::OpenStorageWrite	(	tools::SvRef< SotStorage > const &	xStrg,
		const OUString &	rStrgName
	)

static

Creates and opens a storage with the specified name in the passed storage (read/write).

Definition at line 169 of file ftools.cxx.

References tools::SvRef< T >::is(), and SotStorage::OpenSotStorage().

Referenced by XclRoot::OpenStorage().

const ScfTools& ScfTools::operator= ( const ScfTools & )

delete

void ScfTools::PutItem	(	SfxItemSet &	rItemSet,
		const SfxPoolItem &	rItem,
		sal_uInt16	nWhichId,
		bool	bSkipPoolDef
	)

static

Puts the item into the passed item set.

The item will be put into the item set, if bSkipPoolDef is false, or if the item differs from the default pool item.

Parameters

rItemSet	The destination item set.
rItem	The item to put into the item set.
nWhichId	The Which-ID to set with the item.
bSkipPoolDef	true = Do not put item if it is equal to pool default; false = Always put the item.

Definition at line 210 of file ftools.cxx.

References SfxPoolItem::CloneSetWhich(), SfxItemPool::GetDefaultItem(), SfxItemSet::GetPool(), and SfxItemSet::Put().

Referenced by XclImpXF::CreatePattern(), oox::xls::Xf::createPattern(), XclImpNumFmtBuffer::FillScFmtToItemSet(), oox::xls::NumberFormat::fillToItemSet(), oox::xls::Font::fillToItemSet(), XclImpCellProt::FillToItemSet(), XclImpCellAlign::FillToItemSet(), XclImpCellBorder::FillToItemSet(), oox::xls::Alignment::fillToItemSet(), XclImpCellArea::FillToItemSet(), oox::xls::Protection::fillToItemSet(), oox::xls::Border::fillToItemSet(), oox::xls::Fill::fillToItemSet(), XclImpPageSettings::Finalize(), and PutItem().

void ScfTools::PutItem	(	SfxItemSet &	rItemSet,
		const SfxPoolItem &	rItem,
		bool	bSkipPoolDef
	)

static

Puts the item into the passed item set.

The item will be put into the item set, if bSkipPoolDef is false, or if the item differs from the default pool item.

Parameters

rItemSet	The destination item set.
rItem	The item to put into the item set.
bSkipPoolDef	true = Do not put item if it is equal to pool default; false = Always put the item.

Definition at line 218 of file ftools.cxx.

References PutItem(), and SfxPoolItem::Which().