#include <rangeutl.hxx>

Static Public Member Functions
static void	AssignString (OUString &rString, const OUString &rNewStr, bool bAppendStr, sal_Unicode cSeparator=' ')
	helper methods More...

static sal_Int32	IndexOf (std::u16string_view rString, sal_Unicode cSearchChar, sal_Int32 nOffset, sal_Unicode cQuote='\'')

static sal_Int32	IndexOfDifferent (std::u16string_view rString, sal_Unicode cSearchChar, sal_Int32 nOffset)

static sal_Int32	GetTokenCount (std::u16string_view rString, sal_Unicode cSeparator=' ')

static void	GetTokenByOffset (OUString &rToken, std::u16string_view rString, sal_Int32 &nOffset, sal_Unicode cSeparator=' ', sal_Unicode cQuote='\'')

static void	AppendTableName (OUStringBuffer &rBuf, const OUString &rTabName)

static bool	GetAddressFromString (ScAddress &rAddress, std::u16string_view rAddressStr, const ScDocument &rDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Int32 &nOffset, sal_Unicode cSeparator=' ', sal_Unicode cQuote='\'')
	String to Range core. More...

static bool	GetRangeFromString (ScRange &rRange, std::u16string_view rRangeStr, const ScDocument &rDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Int32 &nOffset, sal_Unicode cSeparator=' ', sal_Unicode cQuote='\'')

static bool	GetRangeListFromString (ScRangeList &rRangeList, std::u16string_view rRangeListStr, const ScDocument &rDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ', sal_Unicode cQuote='\'')

static bool	GetAreaFromString (ScArea &rArea, std::u16string_view rRangeStr, const ScDocument &rDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Int32 &nOffset, sal_Unicode cSeparator=' ')

static bool	GetRangeFromString (css::table::CellRangeAddress &rRange, std::u16string_view rRangeStr, const ScDocument &rDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Int32 &nOffset, sal_Unicode cSeparator=' ')
	String to Range API. More...

static void	GetStringFromAddress (OUString &rString, const ScAddress &rAddress, const ScDocument *pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ', bool bAppendStr=false, ScRefFlags nFormatFlags=ScRefFlags::VALID\|ScRefFlags::TAB_3D)
	Range to String core. More...

static void	GetStringFromRange (OUString &rString, const ScRange &rRange, const ScDocument *pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ', bool bAppendStr=false, ScRefFlags nFormatFlags=ScRefFlags::VALID\|ScRefFlags::TAB_3D)

static void	GetStringFromRangeList (OUString &rString, const ScRangeList pRangeList, const ScDocument pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ')

static void	GetStringFromArea (OUString &rString, const ScArea &rArea, const ScDocument *pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator, bool bAppendStr=false, ScRefFlags nFormatFlags=ScRefFlags::VALID\|ScRefFlags::TAB_3D)

static void	GetStringFromAddress (OUString &rString, const css::table::CellAddress &rAddress, const ScDocument *pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ', bool bAppendStr=false)
	Range to String API. More...

static void	GetStringFromRange (OUString &rString, const css::table::CellRangeAddress &rRange, const ScDocument *pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ', bool bAppendStr=false, ScRefFlags nFormatFlags=ScRefFlags::VALID\|ScRefFlags::TAB_3D)

static void	GetStringFromRangeList (OUString &rString, const css::uno::Sequence< css::table::CellRangeAddress > &rRangeSeq, const ScDocument *pDocument, formula::FormulaGrammar::AddressConvention eConv, sal_Unicode cSeparator=' ')

static void	GetStringFromXMLRangeString (OUString &rString, std::u16string_view rXMLRange, const ScDocument &rDoc)
	XML Range to Calc Range. More...

static ScRangeData *	GetRangeDataFromString (const OUString &rString, const SCTAB nTab, const ScDocument &rDoc, formula::FormulaGrammar::AddressConvention eConv)
	String to RangeData core. More...

Detailed Description

Definition at line 89 of file rangeutl.hxx.

Member Function Documentation

◆ AppendTableName()

void ScRangeStringConverter::AppendTableName	(	OUStringBuffer &	rBuf,
		const OUString &	rTabName
	)

static

Definition at line 439 of file rangeutl.cxx.

References ScCompiler::CheckTabQuotes().

Referenced by lcl_appendCellAddress(), and lcl_appendCellRangeAddress().

◆ AssignString()

void ScRangeStringConverter::AssignString	(	OUString &	rString,
		const OUString &	rNewStr,
		bool	bAppendStr,
		sal_Unicode	cSeparator = `' '`
	)

static

helper methods

Definition at line 355 of file rangeutl.cxx.

Referenced by ScXMLConverter::GetStringFromDetObjType(), ScXMLConverter::GetStringFromDetOpType(), ScXMLConverter::GetStringFromFunction(), and ScXMLConverter::GetStringFromOrientation().

◆ GetAddressFromString()

bool ScRangeStringConverter::GetAddressFromString	(	ScAddress &	rAddress,
		std::u16string_view	rAddressStr,
		const ScDocument &	rDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Int32 &	nOffset,
		sal_Unicode	cSeparator = `' '`,
		sal_Unicode	cQuote = `'\''`
	)

static

String to Range core.

Definition at line 461 of file rangeutl.cxx.

References ScDocument::GetAddressConvention(), GetTokenByOffset(), ScAddress::Parse(), and VALID.

Referenced by ScMyCellInfo::CreateCell(), sc::SparklineGroupsImportContext::fillSparklineAttributes(), XMLTableShapeImportHelper::finishShape(), ScXMLConsolidationContext::ScXMLConsolidationContext(), and ScXMLDataPilotTableContext::SetButtons().

◆ GetAreaFromString()

bool ScRangeStringConverter::GetAreaFromString	(	ScArea &	rArea,
		std::u16string_view	rRangeStr,
		const ScDocument &	rDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Int32 &	nOffset,
		sal_Unicode	cSeparator = `' '`
	)

static

Definition at line 579 of file rangeutl.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), GetRangeFromString(), ScArea::nColEnd, ScArea::nColStart, ScArea::nRowEnd, ScArea::nRowStart, ScArea::nTab, ScAddress::Row(), and ScAddress::Tab().

Referenced by ScXMLConsolidationContext::endFastElement().

◆ GetRangeDataFromString()

ScRangeData * ScRangeStringConverter::GetRangeDataFromString	(	const OUString &	rString,
		const SCTAB	nTab,
		const ScDocument &	rDoc,
		formula::FormulaGrammar::AddressConvention	eConv
	)

static

String to RangeData core.

Definition at line 922 of file rangeutl.cxx.

References aName, ScGlobal::EraseQuotes(), ScRangeName::findByUpperName(), ScGlobal::FindUnquoted(), ScGlobal::getCharClass(), ScDocument::GetRangeName(), ScDocument::GetTable(), nIndex, pData, and CharClass::uppercase().

Referenced by ScInterpreter::ScIndirect().

◆ GetRangeFromString() [1/2]

static bool ScRangeStringConverter::GetRangeFromString	(	css::table::CellRangeAddress &	rRange,
		std::u16string_view	rRangeStr,
		const ScDocument &	rDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Int32 &	nOffset,
		sal_Unicode	cSeparator = `' '`
	)

static

String to Range API.

◆ GetRangeFromString() [2/2]

static bool ScRangeStringConverter::GetRangeFromString	(	ScRange &	rRange,
		std::u16string_view	rRangeStr,
		const ScDocument &	rDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Int32 &	nOffset,
		sal_Unicode	cSeparator = `' '`,
		sal_Unicode	cQuote = `'\''`
	)

static

Referenced by GetAreaFromString(), GetRangeListFromString(), ScXMLDatabaseRangeContext::ScXMLDatabaseRangeContext(), ScXMLDataPilotTableContext::ScXMLDataPilotTableContext(), ScXMLDataStreamContext::ScXMLDataStreamContext(), ScXMLDetectiveHighlightedContext::ScXMLDetectiveHighlightedContext(), ScXMLFilterContext::ScXMLFilterContext(), ScXMLSortContext::ScXMLSortContext(), ScXMLSourceCellRangeContext::ScXMLSourceCellRangeContext(), and ScXMLImport::SetLabelRanges().

◆ GetRangeListFromString()

bool ScRangeStringConverter::GetRangeListFromString	(	ScRangeList &	rRangeList,
		std::u16string_view	rRangeListStr,
		const ScDocument &	rDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`,
		sal_Unicode	cQuote = `'\''`
	)

static

Definition at line 552 of file rangeutl.cxx.

References GetRangeFromString(), and ScRangeList::push_back().

Referenced by ScTabView::DoChartSelection(), ScXMLTableContext::endFastElement(), sc::SparklineGroupsImportContext::fillSparklineAttributes(), ScTableSheetsObj::getCellRangesByName(), oox::xls::SparklineGroupsContext::onCharacters(), oox::xls::ExtConditionalFormattingContext::onEndElement(), ScXMLConditionalFormatContext::ScXMLConditionalFormatContext(), ScXMLTableScenarioContext::ScXMLTableScenarioContext(), and ScXMLImport::SetChangeTrackingViewSettings().

◆ GetStringFromAddress() [1/2]

static void ScRangeStringConverter::GetStringFromAddress	(	OUString &	rString,
		const css::table::CellAddress &	rAddress,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`,
		bool	bAppendStr = `false`
	)

static

Range to String API.

◆ GetStringFromAddress() [2/2]

static void ScRangeStringConverter::GetStringFromAddress	(	OUString &	rString,
		const ScAddress &	rAddress,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`,
		bool	bAppendStr = `false`,
		ScRefFlags	nFormatFlags = `ScRefFlags::VALID\|ScRefFlags::TAB_3D`
	)

static

Range to String core.

Referenced by sc::SparklineGroupsExport::addSparklineAttributes(), ScXMLExport::ExportConditionalFormat(), ScXMLAutoStylePoolP::exportStyleContent(), ScMyValidationsContainer::GetBaseCellAddress(), ScXMLExport::WriteConsolidation(), ScXMLExportDataPilot::WriteDataPilots(), ScChangeTrackingExportHelper::WriteFormulaCell(), ScXMLExport::WriteNamedRange(), ScXMLExport::WriteShapes(), and writeSort().

◆ GetStringFromArea()

void ScRangeStringConverter::GetStringFromArea	(	OUString &	rString,
		const ScArea &	rArea,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator,
		bool	bAppendStr = `false`,
		ScRefFlags	nFormatFlags = `ScRefFlags::VALID \| ScRefFlags::TAB_3D`
	)

static

Definition at line 674 of file rangeutl.cxx.

References GetStringFromRange(), ScArea::nColEnd, ScArea::nColStart, ScArea::nRowEnd, ScArea::nRowStart, and ScArea::nTab.

Referenced by ScXMLExport::WriteConsolidation().

◆ GetStringFromRange() [1/2]

static void ScRangeStringConverter::GetStringFromRange	(	OUString &	rString,
		const css::table::CellRangeAddress &	rRange,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`,
		bool	bAppendStr = `false`,
		ScRefFlags	nFormatFlags = `ScRefFlags::VALID\|ScRefFlags::TAB_3D`
	)

static

◆ GetStringFromRange() [2/2]

static void ScRangeStringConverter::GetStringFromRange	(	OUString &	rString,
		const ScRange &	rRange,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`,
		bool	bAppendStr = `false`,
		ScRefFlags	nFormatFlags = `ScRefFlags::VALID\|ScRefFlags::TAB_3D`
	)

static

Referenced by GetStringFromArea(), ScXMLExportDataPilot::WriteDataPilots(), ScXMLExport::WriteDataStream(), ScXMLExport::WriteDetective(), ScXMLExportDataPilot::WriteDPFilter(), and ScXMLExport::WriteLabelRanges().

◆ GetStringFromRangeList() [1/2]

static void ScRangeStringConverter::GetStringFromRangeList	(	OUString &	rString,
		const css::uno::Sequence< css::table::CellRangeAddress > &	rRangeSeq,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`
	)

static

◆ GetStringFromRangeList() [2/2]

static void ScRangeStringConverter::GetStringFromRangeList	(	OUString &	rString,
		const ScRangeList *	pRangeList,
		const ScDocument *	pDocument,
		formula::FormulaGrammar::AddressConvention	eConv,
		sal_Unicode	cSeparator = `' '`
	)

static

Referenced by sc::SparklineGroupsExport::addSparklineAttributes(), ScXMLExport::ExportConditionalFormat(), ScXMLExport::ExportShape(), ScGridWinUIObject::get_state(), ScXMLExport::GetChangeTrackViewSettings(), ScXMLExport::GetColumnRowHeader(), and ScXMLExport::WriteScenario().

◆ GetStringFromXMLRangeString()

void ScRangeStringConverter::GetStringFromXMLRangeString	(	OUString &	rString,
		std::u16string_view	rXMLRange,
		const ScDocument &	rDoc
	)

static

XML Range to Calc Range.

Definition at line 806 of file rangeutl.cxx.

References aBuf, formula::FormulaGrammar::CONV_OOO, ScDocument::GetAddressConvention(), formula::FormulaCompiler::GetNativeSymbolChar(), GetTokenByOffset(), IndexOf(), lcl_appendCellAddress(), lcl_appendCellRangeAddress(), ScAddress::ExternalInfo::mbExternal, ScAddress::ExternalInfo::mnFileId, ocSep, ScAddress::Parse(), VALID, and ZERO.

Referenced by ScChart2DataProvider::convertRangeFromXML(), and ScMyOLEFixer::CreateChartListener().

◆ GetTokenByOffset()

void ScRangeStringConverter::GetTokenByOffset	(	OUString &	rToken,
		std::u16string_view	rString,
		sal_Int32 &	nOffset,
		sal_Unicode	cSeparator = `' '`,
		sal_Unicode	cQuote = `'\''`
	)

static

Definition at line 414 of file rangeutl.cxx.

References IndexOf(), IndexOfDifferent(), and nLength.

Referenced by ScChart2DataProvider::convertRangeFromXML(), GetAddressFromString(), GetStringFromXMLRangeString(), GetTokenCount(), and ScXMLDataPilotTableContext::SetButtons().

◆ GetTokenCount()

sal_Int32 ScRangeStringConverter::GetTokenCount	(	std::u16string_view	rString,
		sal_Unicode	cSeparator = `' '`
	)

static

Definition at line 447 of file rangeutl.cxx.

References GetTokenByOffset(), and nCount.

Referenced by ScXMLConsolidationContext::endFastElement().

◆ IndexOf()

sal_Int32 ScRangeStringConverter::IndexOf	(	std::u16string_view	rString,
		sal_Unicode	cSearchChar,
		sal_Int32	nOffset,
		sal_Unicode	cQuote = `'\''`
	)

static

Definition at line 374 of file rangeutl.cxx.

References nIndex, and nLength.

Referenced by ScChart2DataProvider::convertRangeFromXML(), GetStringFromXMLRangeString(), and GetTokenByOffset().

◆ IndexOfDifferent()

sal_Int32 ScRangeStringConverter::IndexOfDifferent	(	std::u16string_view	rString,
		sal_Unicode	cSearchChar,
		sal_Int32	nOffset
	)

static

Definition at line 396 of file rangeutl.cxx.

References nIndex, and nLength.

Referenced by GetTokenByOffset().

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

Static Public Member Functions

Detailed Description

Member Function Documentation

◆ AppendTableName()

◆ AssignString()

◆ GetAddressFromString()

◆ GetAreaFromString()

◆ GetRangeDataFromString()

◆ GetRangeFromString() [1/2]

◆ GetRangeFromString() [2/2]

◆ GetRangeListFromString()

◆ GetStringFromAddress() [1/2]

◆ GetStringFromAddress() [2/2]

◆ GetStringFromArea()

◆ GetStringFromRange() [1/2]

◆ GetStringFromRange() [2/2]

◆ GetStringFromRangeList() [1/2]

◆ GetStringFromRangeList() [2/2]

◆ GetStringFromXMLRangeString()

◆ GetTokenByOffset()

◆ GetTokenCount()

◆ IndexOf()

◆ IndexOfDifferent()