#include <address.hxx>

Collaboration diagram for ScRange:

Public Member Functions
	ScRange ()

	ScRange (ScAddress::Uninitialized eUninitialized)

	ScRange (ScAddress::InitializeInvalid eInvalid)

	ScRange (const ScAddress &aInputStart, const ScAddress &aInputEnd)

	ScRange (const ScRange &rRange)

	ScRange (const ScAddress &rRange)

	ScRange (SCCOL nCol, SCROW nRow, SCTAB nTab)

	ScRange (SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2)

ScRange &	operator= (const ScRange &rRange)

ScRange &	operator= (const ScAddress &rPos)

void	SetInvalid ()

bool	IsValid () const

bool	Contains (const ScAddress &) const
	is Address& fully in Range? More...

bool	Contains (const ScRange &) const
	is Range& fully in Range? More...

bool	Intersects (const ScRange &rRange) const

ScRefFlags	Parse (const OUString &, const ScDocument &, const ScAddress::Details &rDetails=ScAddress::detailsOOOa1, ScAddress::ExternalInfo pExtInfo=nullptr, const css::uno::Sequence< css::sheet::ExternalLinkInfo > pExternalLinks=nullptr, const OUString *pErrRef=nullptr)

ScRefFlags	ParseAny (const OUString &, const ScDocument &, const ScAddress::Details &rDetails=ScAddress::detailsOOOa1)

ScRefFlags	ParseCols (const ScDocument &rDoc, const OUString &, const ScAddress::Details &rDetails=ScAddress::detailsOOOa1)

void	ParseRows (const ScDocument &rDoc, const OUString &, const ScAddress::Details &rDetails=ScAddress::detailsOOOa1)

const sal_Unicode *	Parse_XL_Header (const sal_Unicode pString, const ScDocument &rDocument, OUString &rExternDocName, OUString &rStartTabName, OUString &rEndTabName, ScRefFlags &nFlags, bool bOnlyAcceptSingle, const css::uno::Sequence< css::sheet::ExternalLinkInfo > pExternalLinks=nullptr, const OUString *pErrRef=nullptr)
	Parse an Excel style reference up to and including the sheet name separator '!', including detection of external documents and sheet names, and in case of MOOXML import the bracketed index is used to determine the actual document name passed in pExternalLinks. More...

OUString	Format (const ScDocument &rDocument, ScRefFlags nFlags=ScRefFlags::ZERO, const ScAddress::Details &rDetails=ScAddress::detailsOOOa1, bool bFullAddressNotation=false) const
	Returns string with formatted cell range from aStart to aEnd, according to provided address convention. More...

void	GetVars (SCCOL &nCol1, SCROW &nRow1, SCTAB &nTab1, SCCOL &nCol2, SCROW &nRow2, SCTAB &nTab2) const

void	PutInOrder ()

bool	Move (SCCOL aDeltaX, SCROW aDeltaY, SCTAB aDeltaZ, ScRange &rErrorRange, const ScDocument &rDoc)

bool	MoveSticky (const ScDocument &rDoc, SCCOL aDeltaX, SCROW aDeltaY, SCTAB aDeltaZ, ScRange &rErrorRange)
	Same as Move() but with sticky end col/row anchors. More...

void	IncColIfNotLessThan (const ScDocument &rDoc, SCCOL nStartCol, SCCOL nOffset)

void	IncRowIfNotLessThan (const ScDocument &rDoc, SCROW nStartRow, SCROW nOffset)

void	ExtendTo (const ScRange &rRange)

ScRange	Intersection (const ScRange &rOther) const

bool	IsEndColSticky (const ScDocument &rDoc) const
	If maximum end column should not be adapted during reference update. More...

bool	IsEndRowSticky (const ScDocument &rDoc) const
	If maximum end row should not be adapted during reference update. More...

void	IncEndColSticky (const ScDocument &rDoc, SCCOL nDelta)
	Increment or decrement end column unless sticky or until it becomes sticky. More...

void	IncEndRowSticky (const ScDocument &rDoc, SCROW nDelta)
	Increment or decrement end row unless sticky or until it becomes sticky. More...

bool	operator== (const ScRange &rRange) const

bool	operator!= (const ScRange &rRange) const

bool	operator< (const ScRange &rRange) const
	Sort on upper left corner tab,col,row, if equal then use lower right too. More...

bool	operator<= (const ScRange &rRange) const

size_t	hashArea () const
	Hash 2D area ignoring table number. More...

size_t	hashStartColumn () const
	Hash start column and start and end rows. More...

Public Attributes
ScAddress	aStart

ScAddress	aEnd

Detailed Description

Definition at line 494 of file address.hxx.

Constructor & Destructor Documentation

◆ ScRange() [1/8]

ScRange::ScRange ( )

inline

Definition at line 500 of file address.hxx.

◆ ScRange() [2/8]

ScRange::ScRange ( ScAddress::Uninitialized eUninitialized )

inline

Definition at line 504 of file address.hxx.

◆ ScRange() [3/8]

ScRange::ScRange ( ScAddress::InitializeInvalid eInvalid )

inline

Definition at line 507 of file address.hxx.

◆ ScRange() [4/8]

ScRange::ScRange	(	const ScAddress &	aInputStart,
		const ScAddress &	aInputEnd
	)

inline

Definition at line 510 of file address.hxx.

References PutInOrder().

◆ ScRange() [5/8]

ScRange::ScRange ( const ScRange & rRange )

inline

Definition at line 515 of file address.hxx.

◆ ScRange() [6/8]

ScRange::ScRange ( const ScAddress & rRange )

inline

Definition at line 518 of file address.hxx.

◆ ScRange() [7/8]

ScRange::ScRange	(	SCCOL	nCol,
		SCROW	nRow,
		SCTAB	nTab
	)

inline

Definition at line 521 of file address.hxx.

◆ ScRange() [8/8]

ScRange::ScRange	(	SCCOL	nCol1,
		SCROW	nRow1,
		SCTAB	nTab1,
		SCCOL	nCol2,
		SCROW	nRow2,
		SCTAB	nTab2
	)

inline

Definition at line 524 of file address.hxx.

Member Function Documentation

◆ Contains() [1/2]

bool ScRange::Contains ( const ScAddress & rAddress ) const

inline

is Address& fully in Range?

Definition at line 718 of file address.hxx.

References aEnd, aStart, ScAddress::Col(), ScAddress::Row(), and ScAddress::Tab().

Referenced by sc::RefQueryFormulaGroup::add(), ScTokenArray::AdjustReferenceInMovedName(), ScTokenArray::AdjustReferenceInName(), ScTokenArray::AdjustReferenceOnMove(), ScTokenArray::AdjustReferenceOnShift(), ScPivotLayoutDialog::ApplyChanges(), ScAccessibleSpreadsheet::CalcScRangeDifferenceMax(), CanBeUsedForSorterCache(), ScDrawLayer::CopyFromClip(), ScDrawLayer::CopyToClip(), ScBroadcastAreaSlot::DelBroadcastAreasInRange(), ScRangeList::DeleteArea(), ScDocFunc::DeleteCells(), ScAccessibleCell::FillDependents(), ScBroadcastAreaSlot::GetAllListeners(), XclExpMergedcells::GetBaseXFId(), ScDocument::GetCellChangeTrackNote(), ScCellRangeObj::getCellRangeByName(), ScDocShell::GetChangeAction(), ScDrawLayer::GetObjectsAnchoredToCols(), ScDrawLayer::GetObjectsAnchoredToRange(), ScDrawLayer::GetObjectsAnchoredToRows(), ScCompiler::HandleColRowName(), ScDrawLayer::HasObjectsAnchoredInRange(), ScGridWindow::HitRangeFinder(), ScDocFunc::InsertCells(), ScDocument::IsAddressInRangeName(), ScDocument::IsCellInChangeTrack(), ScInterpreter::IsTableOpInRange(), ScRangeList::Join(), ScRangePairList::Join(), lcl_IsAllInRange(), lcl_MoveRanges(), ScDBData::Notify(), ScAccessibleSpreadsheet::Notify(), ScGridWindow::ShowNoteMarker(), ScFormulaCell::UpdatePosOnShift(), ScConditionEntry::UpdateReference(), ScFormulaCell::UpdateReferenceOnCopy(), ScFormulaCell::UpdateReferenceOnMove(), ScRefUpdate::UpdateTranspose(), and ScFormulaCell::UpdateTranspose().

◆ Contains() [2/2]

bool ScRange::Contains ( const ScRange & rRange ) const

inline

is Range& fully in Range?

Definition at line 726 of file address.hxx.

References aEnd, aStart, ScAddress::Col(), ScAddress::Row(), and ScAddress::Tab().

◆ ExtendTo()

void ScRange::ExtendTo ( const ScRange & rRange )

Definition at line 1562 of file address.cxx.

References aEnd, aStart, ScAddress::Col(), ScAddress::IsValid(), IsValid(), ScAddress::Row(), and ScAddress::Tab().

Referenced by FuInsertChart::FuInsertChart(), XclImpSheetDrawing::OnObjectInserted(), ImportExcel::PostDocLoad(), ScDocFunc::ReplaceConditionalFormat(), and ScFormulaListener::startListening().

◆ Format()

OUString ScRange::Format	(	const ScDocument &	rDocument,
		ScRefFlags	nFlags = `ScRefFlags::ZERO`,
		const ScAddress::Details &	rDetails = `ScAddress::detailsOOOa1`,
		bool	bFullAddressNotation = `false`
	)		const

Returns string with formatted cell range from aStart to aEnd, according to provided address convention.

Parameters

nFlags	Cell reference flags
rDocument	Reference to document which is used for example to get tab names.
rDetails	Provide information about required address convention. Supported address conventions are: CONV_OOO 'doc'#sheet.A1:sheet2.B2 CONV_XL_A1, [doc]sheet:sheet2!A1:B2 CONV_XL_OOX, [#]sheet:sheet2!A1:B2 CONV_XL_R1C1, [doc]sheet:sheet2!R1C1:R2C2
bFullAddressNotation	If TRUE, the full address notation will be used. For example in case all columns are used, "A1:AMJ177" is full address notation and "1:177" is shortened address notation.

Returns: String contains formatted cell range in address convention

Definition at line 2170 of file address.cxx.

References BITS, COL2_ABS, COL_ABS, formula::FormulaGrammar::CONV_OOO, formula::FormulaGrammar::CONV_XL_A1, formula::FormulaGrammar::CONV_XL_OOX, formula::FormulaGrammar::CONV_XL_R1C1, ScAddress::Details::eConv, formula::FormulaCompiler::GetNativeSymbol(), lcl_a1_append_c(), lcl_a1_append_r(), lcl_ColAbsFlagDiffer(), lcl_r1c1_append_c(), lcl_r1c1_append_r(), lcl_RowAbsFlagDiffer(), lcl_ScRange_Format_XL_Header(), ScDocument::MaxCol(), ScDocument::MaxRow(), ocErrRef, ROW2_ABS, ROW_ABS, TAB_3D, o3tl::to_underlying(), VALID, and ZERO.

◆ GetVars()

void ScRange::GetVars	(	SCCOL &	nCol1,
		SCROW &	nRow1,
		SCTAB &	nTab1,
		SCCOL &	nCol2,
		SCROW &	nRow2,
		SCTAB &	nTab2
	)		const

inline

Definition at line 690 of file address.hxx.

References aEnd, aStart, and ScAddress::GetVars().

Referenced by ScChangeTrack::AppendContentRange(), ScChangeTrack::AppendDeleteRange(), ScChartPositioner::CheckColRowHeaders(), ScChartPositioner::CreatePositionMap(), ScRangeList::GetIntersectedRange(), ScInterpreter::GetMatrix(), ScMarkData::GetSelectionCover(), ScTabViewShell::GetSelectionText(), ScViewData::GetSimpleArea(), XclImpHyperlink::InsertUrl(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), ScViewFunc::PasteFromClip(), ScInterpreter::ScConcat_MS(), ScInterpreter::ScCountIf(), ScInterpreter::ScIndex(), ScInterpreter::ScTextJoin_MS(), ScGridWindow::SetCellSelectionPixel(), ScBroadcastAreaSlotMachine::UpdateBroadcastAreas(), ScDBData::UpdateReference(), ScRangeList::UpdateReference(), ScRangePairList::UpdateReference(), and ScBroadcastAreaSlot::UpdateRemove().

◆ hashArea()

size_t ScRange::hashArea ( ) const

inline

Hash 2D area ignoring table number.

Definition at line 742 of file address.hxx.

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

Referenced by ScBroadcastAreaHash::operator()().

◆ hashStartColumn()

size_t ScRange::hashStartColumn ( ) const

inline

Hash start column and start and end rows.

Definition at line 767 of file address.hxx.

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

Referenced by ScSortedRangeCache::Hash::operator()(), and ScLookupCache::Hash::operator()().

◆ IncColIfNotLessThan()

void ScRange::IncColIfNotLessThan	(	const ScDocument &	rDoc,
		SCCOL	nStartCol,
		SCCOL	nOffset
	)

Definition at line 2372 of file address.cxx.

References ScDocument::MaxCol().

Referenced by ScMarkData::ShiftCols().

◆ IncEndColSticky()

void ScRange::IncEndColSticky	(	const ScDocument &	rDoc,
		SCCOL	nDelta
	)

Increment or decrement end column unless sticky or until it becomes sticky.

Checks if the range encompasses at least two columns so should be called before adjusting the start column.

Definition at line 2424 of file address.cxx.

References ScDocument::MaxCol(), and ScAddress::nCol.

◆ IncEndRowSticky()

void ScRange::IncEndRowSticky	(	const ScDocument &	rDoc,
		SCROW	nDelta
	)

Increment or decrement end row unless sticky or until it becomes sticky.

Checks if the range encompasses at least two rows so should be called before adjusting the start row.

Definition at line 2445 of file address.cxx.

References ScDocument::MaxRow(), and ScAddress::nRow.

◆ IncRowIfNotLessThan()

void ScRange::IncRowIfNotLessThan	(	const ScDocument &	rDoc,
		SCROW	nStartRow,
		SCROW	nOffset
	)

Definition at line 2392 of file address.cxx.

References ScDocument::MaxRow().

Referenced by ScMarkData::ShiftRows().

◆ Intersection()

ScRange ScRange::Intersection ( const ScRange & rOther ) const

Definition at line 1547 of file address.cxx.

References aEnd, aStart, ScAddress::Col(), ScAddress::INITIALIZE_INVALID, ScAddress::Row(), and ScAddress::Tab().

Referenced by ScBroadcastAreaSlot::AreaBroadcast(), and ScCompiler::HandleTableRef().

◆ Intersects()

bool ScRange::Intersects ( const ScRange & rRange ) const

inline

Definition at line 734 of file address.hxx.

References aEnd, aStart, ScAddress::Col(), ScAddress::Row(), and ScAddress::Tab().

Referenced by ScColRowNameRangesDlg::AdjustColRowData(), ScTokenArray::AdjustReferenceInName(), ScTokenArray::AdjustReferenceOnShift(), ScAcceptChgDlg::AppendChangeAction(), ScAcceptChgDlg::AppendFilteredAction(), ScBroadcastAreaSlot::AreaBroadcast(), ScAccessibleSpreadsheet::CalcScRangeDifferenceMax(), ScOutputData::DrawChangeTrack(), ScCellShell::ExecuteEdit(), ScBroadcastAreaSlot::GetAllListeners(), ScTable::HasScenarioRange(), ScAcceptChgDlg::InsertChangeActionContent(), ScAcceptChgDlg::IsValidAction(), lcl_DrawScenarioFrames(), ScAccessibleSpreadsheet::Notify(), ScDocShell::RefreshPivotTables(), ScHTMLLayoutParser::SkipLocked(), ScTable::SortReorderByRowRefUpdate(), and ScTabViewShell::UseSubTotal().

◆ IsEndColSticky()

bool ScRange::IsEndColSticky ( const ScDocument & rDoc ) const

If maximum end column should not be adapted during reference update.

Definition at line 2412 of file address.cxx.

References ScDocument::MaxCol().

Referenced by ScTokenArray::AdjustReferenceInName().

◆ IsEndRowSticky()

bool ScRange::IsEndRowSticky ( const ScDocument & rDoc ) const

If maximum end row should not be adapted during reference update.

Definition at line 2418 of file address.cxx.

References ScDocument::MaxRow().

Referenced by ScTokenArray::AdjustReferenceInName().

◆ IsValid()

bool ScRange::IsValid ( ) const

inline

Definition at line 544 of file address.hxx.

References ScAddress::IsValid().

Referenced by sc::RefQueryFormulaGroup::add(), ScBroadcastAreaSlot::AreaBroadcast(), ScSheetSourceDesc::CheckSourceRange(), sc::SparklineDialog::checkValidInputOutput(), ScXMLDataStreamContext::endFastElement(), ExtendTo(), ScPivotLayoutDialog::GetDestination(), ScSamplingDialog::GetPopulationSize(), sc::DataStreamDlg::GetStartRange(), ScCompiler::HandleTableRef(), ScDocument::HasFormulaCell(), ScStatisticsInputOutputDialog::InputRangesValid(), ScStatisticsTwoVariableDialog::InputRangesValid(), ScFourierAnalysisDialog::InputRangesValid(), ScRegressionDialog::InputRangesValid(), XclImpPivotCache::IsValid(), ScDBData::Notify(), XclImpSheetDrawing::OnObjectInserted(), ScViewFunc::PasteDataFormat(), ImportExcel::PostDocLoad(), ScDBData::RefreshTableColumnNames(), ScOrcusRefResolver::resolve_range(), XclExpXmlPivotTables::SavePivotTableXml(), ScRandomNumberGeneratorDialog::SelectGeneratorAndGenerateNumbers(), ScSamplingDialog::SetReference(), oox::xls::ViewSettings::setSheetUsedArea(), ScPivotLayoutDialog::SetupSource(), ScFormulaListener::startListening(), sc::DataStreamDlg::StartStream(), ScDocument::SwapNonEmpty(), ScTable::SwapNonEmpty(), sc::DataStreamDlg::UpdateEnable(), and ScPivotLayoutDialog::UpdateSourceRange().

◆ Move()

bool ScRange::Move	(	SCCOL	aDeltaX,
		SCROW	aDeltaY,
		SCTAB	aDeltaZ,
		ScRange &	rErrorRange,
		const ScDocument &	rDoc
	)

Parameters

rErrorRange	If FALSE is returned, the positions contain <0 or >MAX... values if shifted out of bounds.
pDocument	The document for the maximum defined sheet number.

Definition at line 2328 of file address.cxx.

References aEnd, aStart, ScDocument::MaxCol(), and ScDocument::MaxRow().

Referenced by ScTokenArray::AdjustReferenceInMovedName(), ScTokenArray::AdjustReferenceOnMove(), ScGridWindow::DropTransferObj(), ScDocFunc::InsertCells(), lcl_MoveRanges(), and ScHTMLImport::WriteToDocument().

◆ MoveSticky()

bool ScRange::MoveSticky	(	const ScDocument &	rDoc,
		SCCOL	aDeltaX,
		SCROW	aDeltaY,
		SCTAB	aDeltaZ,
		ScRange &	rErrorRange
	)

Same as Move() but with sticky end col/row anchors.

Definition at line 2341 of file address.cxx.

References aEnd, aStart, ScDocument::MaxCol(), ScDocument::MaxRow(), ScAddress::SetCol(), and ScAddress::SetRow().

Referenced by ScTokenArray::AdjustReferenceOnShift().

◆ operator!=()

bool ScRange::operator!= ( const ScRange & rRange ) const

inline

Definition at line 702 of file address.hxx.

References operator==().

◆ operator<()

bool ScRange::operator< ( const ScRange & rRange ) const

inline

Sort on upper left corner tab,col,row, if equal then use lower right too.

Definition at line 708 of file address.hxx.

References aEnd, and aStart.

Referenced by operator<=().

◆ operator<=()

bool ScRange::operator<= ( const ScRange & rRange ) const

inline

Definition at line 713 of file address.hxx.

References operator<(), and operator==().

◆ operator=() [1/2]

ScRange & ScRange::operator= ( const ScAddress & rPos )

inline

Definition at line 534 of file address.hxx.

◆ operator=() [2/2]

ScRange & ScRange::operator= ( const ScRange & rRange )

inline

Definition at line 528 of file address.hxx.

References aEnd, and aStart.

◆ operator==()

bool ScRange::operator== ( const ScRange & rRange ) const

inline

Definition at line 697 of file address.hxx.

References aEnd, and aStart.

Referenced by operator!=(), and operator<=().

◆ Parse()

ScRefFlags ScRange::Parse	(	const OUString &	,
		const ScDocument &	,
		const ScAddress::Details &	rDetails = `ScAddress::detailsOOOa1`,
		ScAddress::ExternalInfo *	pExtInfo = `nullptr`,
		const css::uno::Sequence< css::sheet::ExternalLinkInfo > *	pExternalLinks = `nullptr`,
		const OUString *	pErrRef = `nullptr`
	)

◆ Parse_XL_Header()

const sal_Unicode * ScRange::Parse_XL_Header	(	const sal_Unicode *	pString,
		const ScDocument &	rDocument,
		OUString &	rExternDocName,
		OUString &	rStartTabName,
		OUString &	rEndTabName,
		ScRefFlags &	nFlags,
		bool	bOnlyAcceptSingle,
		const css::uno::Sequence< css::sheet::ExternalLinkInfo > *	pExternalLinks = `nullptr`,
		const OUString *	pErrRef = `nullptr`
	)

Parse an Excel style reference up to and including the sheet name separator '!', including detection of external documents and sheet names, and in case of MOOXML import the bracketed index is used to determine the actual document name passed in pExternalLinks.

For internal references (resulting rExternDocName empty), aStart.nTab and aEnd.nTab are set, or -1 if sheet name not found.

Parameters

bOnlyAcceptSingle	If <TRUE>, a 3D reference (Sheet1:Sheet2) encountered results in an error (NULL returned).
pExternalLinks	pointer to ExternalLinkInfo sequence, may be NULL for non-filter usage, in which case indices such as [1] are not resolved.
pErrRef	pointer to "#REF!" string if to be accepted.

Returns: Pointer to the position after '!' if successfully parsed, and rExternDocName, rStartTabName and/or rEndTabName filled if applicable. ScRefFlags::... flags set in nFlags. Or if no valid document and/or sheet header could be parsed the start position passed with pString. Or NULL if a 3D sheet header could be parsed but bOnlyAcceptSingle==true was given.

Definition at line 473 of file address.cxx.

References ScExternalRefManager::convertToAbsName(), ScGlobal::GetAbsDocName(), ScDocument::GetDocumentShell(), ScDocument::GetExternalRefManager(), ScDocument::GetTable(), lcl_eatWhiteSpace(), lcl_XL_getExternalDoc(), lcl_XL_ParseSheetRef(), ScAddress::nTab, p, start, TAB2_3D, TAB2_ABS, TAB2_VALID, TAB_3D, TAB_ABS, TAB_VALID, u, and ScGlobal::UnicodeStrChr().

Referenced by oox::xls::DefinedName::isValid(), lcl_parseExternalName(), lcl_ScRange_Parse_XL_A1(), and lcl_ScRange_Parse_XL_R1C1().

◆ ParseAny()

ScRefFlags ScRange::ParseAny	(	const OUString &	rString,
		const ScDocument &	rDoc,
		const ScAddress::Details &	rDetails = `ScAddress::detailsOOOa1`
	)

◆ ParseCols()

ScRefFlags ScRange::ParseCols	(	const ScDocument &	rDoc,
		const OUString &	rStr,
		const ScAddress::Details &	rDetails = `ScAddress::detailsOOOa1`
	)

Definition at line 1750 of file address.cxx.

References COL_VALID, formula::FormulaGrammar::CONV_OOO, formula::FormulaGrammar::CONV_XL_A1, formula::FormulaGrammar::CONV_XL_OOX, formula::FormulaGrammar::CONV_XL_R1C1, ScAddress::Details::eConv, ScDocument::GetSheetLimits(), lcl_a1_get_col(), lcl_r1c1_get_col(), p, and ZERO.

Referenced by ScVbaRange::CellsHelper(), and ScVbaRange::Columns().

◆ ParseRows()

void ScRange::ParseRows	(	const ScDocument &	rDoc,
		const OUString &	rStr,
		const ScAddress::Details &	rDetails = `ScAddress::detailsOOOa1`
	)

Definition at line 1809 of file address.cxx.

References formula::FormulaGrammar::CONV_OOO, formula::FormulaGrammar::CONV_XL_A1, formula::FormulaGrammar::CONV_XL_OOX, formula::FormulaGrammar::CONV_XL_R1C1, ScAddress::Details::eConv, ScDocument::GetSheetLimits(), lcl_a1_get_row(), lcl_r1c1_get_row(), p, and ZERO.

Referenced by ScVbaRange::Rows().

◆ PutInOrder()

void ScRange::PutInOrder ( )

inline

Definition at line 622 of file address.hxx.

References ScAddress::PutInOrder().

◆ SetInvalid()

void ScRange::SetInvalid ( )

inline

Definition at line 539 of file address.hxx.

References ScAddress::SetInvalid().

Referenced by sc::DataStreamDlg::GetStartRange(), oox::xls::PCWorksheetSourceModel::PCWorksheetSourceModel(), and ScXMLDataStreamContext::ScXMLDataStreamContext().

Member Data Documentation

◆ aEnd

ScAddress ScRange::aEnd

Definition at line 498 of file address.hxx.

Referenced by ScGridWindow::AcceptDrop(), ScGridWindow::AcceptPrivateDrop(), RangeNameBufferWK3::Add(), ScRangeList::AddAndPartialCombine(), ScTable::AddCondFormatData(), ScDBDocFunc::AddDBRange(), ScMyStylesImportHelper::AddDefaultRange(), ScTabView::AddHighlightRange(), ScMyEmptyDatabaseRangesContainer::AddNewEmptyDatabaseRange(), ScMyDetectiveObjContainer::AddObject(), ScMyMergedRangesContainer::AddRange(), ScMyStylesImportHelper::AddRange(), XclExpPivotCache::AddStdFields(), ScTransferObj::AddSupportedFormats(), ScColRowNameRangesDlg::AdjustColRowData(), ScBlockUndo::AdjustHeight(), ScDocShell::AdjustPrintZoom(), ScTokenArray::AdjustReferenceInName(), ScTokenArray::AdjustReferenceOnMove(), ScTokenArray::AdjustReferenceOnMovedOriginIfOtherSheet(), ScTokenArray::AdjustReferenceOnMovedTab(), ScTokenArray::AdjustReferenceOnShift(), ScDocFunc::AdjustRowHeight(), ScCompiler::AdjustSumRangeShape(), ScChangeTrack::AppendContentRange(), ScChangeTrack::AppendDeleteRange(), ScChangeTrack::AppendOneDeleteRange(), XclImpValidationManager::Apply(), ScDocFunc::ApplyAttributes(), oox::xls::SheetDataBuffer::applyCellMerging(), ScDocument::ApplyFrameAreaTab(), ScMatrixComparisonGenerator::ApplyOutput(), ScColumn::ApplyPatternIfNumberformatIncompatible(), ScTable::ApplyPatternIfNumberformatIncompatible(), ScViewFunc::ApplyPatternLines(), ScTable::ApplySelectionCache(), ScDocument::ApplySelectionFrame(), ScViewFunc::ApplySelectionPattern(), ScDocument::ApplySelectionPattern(), ScDocument::ApplySelectionStyle(), ScDocFunc::ApplyStyle(), ScCellRangeObj::applySubTotals(), ScBroadcastAreaSlotMachine::AreaBroadcast(), ScVbaRange::AutoFill(), ScDocFunc::AutoFormat(), ScOutlineDocFunc::AutoOutline(), ScViewFunc::AutoSum(), ScDBFuncUndo::BeginRedo(), ScDocument::BroadcastCells(), ScChart2DataSequence::BuildDataCache(), ScAccessibleSpreadsheet::CalcScAddressFromRangeList(), ScAccessibleSpreadsheet::CalcScRangeDifferenceMax(), ScAccessibleSpreadsheet::CalcScRangeListDifferenceMax(), ScDocument::CalculateInColumnInThread(), sc::calculateOrientation(), ScPrintFunc::CalcZoom(), ScTabView::CalcZoom(), ScFunctionAccess::callFunction(), ScOptSolverDlg::CallSolver(), ScDocument::CanFitBlock(), ScDocument::CanInsertCol(), ScDocument::CanInsertRow(), ImportExcel::Cellmerging(), ScDocFunc::ChangeIndent(), ScTable::ChangeSelectionIndent(), oox::xls::AddressConverter::checkCellRange(), ScClipUtil::CheckDestRanges(), ScTokenArray::CheckExpandReferenceBounds(), XclExpAddressConverter::CheckRange(), ScTabView::CheckSelectionTransfer(), ScSheetSourceDesc::CheckSourceRange(), sc::SparklineDialog::checkValidInputOutput(), ScTabView::ClearHighlightRanges(), ScDocFunc::ClearItems(), ScTable::ClearSelectionItems(), ScColumnData::ClearSelectionItems(), ScXMLExport::CloseRow(), ScCellCursorObj::collapseToCurrentRegion(), ScCellCursorObj::collapseToSize(), sc::FormulaGroupAreaListener::collectFormulaCells(), ScVbaRange::Columns(), ScRangeList::Combine(), ScBroadcastAreaSlotMachine::ComputeAreaPoints(), Contains(), ScTable::ContainsNotesInRange(), ScDocument::ContainsNotesInRange(), ScGroupTokenConverter::convert(), ExcelToSc8::Convert(), ConvertDoubleRef(), oox::xls::DefinedName::convertFormula(), ScDocument::ConvertFormulaToValue(), ScDocShell::ConvertFrom(), XclImpAddressConverter::ConvertRange(), XclExpAddressConverter::ConvertRange(), XclExpControlHelper::ConvertSheetLinks(), oox::xls::AddressConverter::convertToCellRangeUnchecked(), ScXMLDatabaseRangeContext::ConvertToDBData(), convertToTokenArray(), ScDocument::CopyFromClip(), ScDocument::CopyMultiRangeFromClip(), ScTable::CopyOneCellFromClip(), ScDocument::CopyOneCellFromClip(), ScDocument::CopyRangeNamesToClip(), ScDocument::CopyStaticToDocument(), ScDocument::CopyToClip(), ScTable::CopyToClip(), ScViewFunc::CopyToClip(), ScViewFunc::CopyToClipSingleRange(), ScDocument::CopyToDocument(), ScDPCollection::CopyToTab(), ScViewFunc::CopyToTransferable(), ScPrintFunc::CountNotePages(), ScPrintFunc::CountPages(), XclExpNameManagerImpl::CreateBuiltInNames(), oox::xls::WorkbookGlobals::createDatabaseRangeObject(), sc::DocFuncUtil::createDeleteContentsUndoDoc(), ScSelectionTransferObj::CreateFromView(), ScChartArray::CreateMemChart(), ScDocFunc::CreateNames(), XclImpExtName::CreateOleData(), ScDBDocFunc::CreatePivotTable(), ScDBInternalRange::createQueryParam(), ScDocument::CreateQueryParam(), ScDocument::CreateSelectionPattern(), ScTable::CreateSortInfoArray(), oox::xls::WorkbookGlobals::createUnnamedDatabaseRangeObject(), ScViewFunc::CutToClip(), ScDBFunc::DataPilotMove(), sc::DataStream::Decode(), ScBroadcastAreaSlotMachine::DelBroadcastAreasInRange(), ScDocument::DeleteArea(), ScDocument::DeleteAreaTab(), ScColumn::DeleteBeforeCopyFromClip(), ScTable::DeleteBeforeCopyFromClip(), ScDocFunc::DeleteCells(), ScViewFunc::DeleteCells(), ScDocument::DeleteCol(), ScDocFunc::DeleteContents(), ScViewFunc::DeleteContents(), ScDrawLayer::DeleteObjectsInSelection(), ScDocument::DeleteRow(), ScTable::DeleteSelection(), ScDocument::DeleteSelectionTab(), ScDocument::DeleteTab(), ScImportExport::Dif2Doc(), ScTable::DoAutoOutline(), ScDocShell::DoAutoStyle(), ScTabViewShell::DoAutoSum(), ScImportExport::Doc2Sylk(), ScImportExport::Doc2Text(), ScUndoPaste::DoChange(), ScUndoMerge::DoChange(), ScUndoInsertCells::DoChange(), ScUndoDeleteCells::DoChange(), ScUndoCut::DoChange(), ScUndoDeleteContents::DoChange(), ScUndoFillTable::DoChange(), ScUndoSelectionAttr::DoChange(), ScUndoSelectionStyle::DoChange(), ScUndoDataForm::DoChange(), ScUndoUpdateAreaLink::DoChange(), sc::UndoSetCells::DoChange(), ScUndoRefConversion::DoChange(), ScTabView::DoChartSelection(), ScDocShell::DoConsolidate(), ScCellRangeObj::doImport(), ScPreview::DoPrint(), ScViewFunc::DoRefConversion(), ScGridWindow::DoScenarioMenu(), ScInterpreter::DoubleRefToPosSingleRef(), ScCompiler::DoubleRefToPosSingleRefScalarCase(), ScInterpreter::DoubleRefToRange(), ScUndoDragDrop::DoUndo(), ScDetectiveFunc::DrawAlienEntry(), ScOutputData::DrawChangeTrack(), ScGridWindow::DrawContent(), ScDetectiveFunc::DrawEntry(), ScGridWindow::DrawPagePreview(), ScPrintFunc::DrawToDev(), ScGridWindow::DropTransferObj(), sc::BroadcasterState::dump(), ScGridWindow::dumpCellProperties(), ScXMLTableScenarioContext::endFastElement(), ScBroadcastAreaSlotMachine::EndListeningArea(), ScDocument::EndListeningIntersectedGroups(), ScNavigatorDlg::EndOfDataArea(), ScImportExport::EndPaste(), ScDocument::EnsureFormulaCellResults(), ScDocFunc::EnterMatrix(), ExcAutoFilterRecs::ExcAutoFilterRecs(), ExcEScenario::ExcEScenario(), sc::UndoSort::Execute(), ScDocShell::Execute(), ScTabViewShell::Execute(), sc::RangeColumnSpanSet::executeColumnAction(), ScCellShell::ExecuteDataPilotDialog(), ScCellShell::ExecuteEdit(), ScCellCursorObj::expandToEntireColumns(), ScCellCursorObj::expandToEntireRows(), ScXMLExport::ExportColumns(), ScImportExport::ExportStream(), ScComplexRefData::Extend(), ScDocument::ExtendMerge(), ScDocument::ExtendOverlapped(), ScMarkData::ExtendRangeListTables(), ScTabView::extendTiledAreaIfNeeded(), ExtendTo(), ScDocument::ExtendTotalMerge(), oox::xls::WorksheetGlobals::extendUsedArea(), oox::xls::WorksheetHelper::extendUsedArea(), ScDocument::Fill(), ScUnoConversion::FillApiRange(), ScCellRangeObj::fillAuto(), ScViewFunc::FillAuto(), ScDocFunc::FillAuto(), ScConditionEntry::FillCache(), ScViewFunc::FillCrossDblClick(), ScHTMLTable::FillEmptyCells(), ScHTMLExport::FillGraphList(), ScMarkData::FillRangeListWithMarks(), sc::SearchResultsDlg::FillResults(), ScUnoConversion::FillScRange(), ScDocFunc::FillSeries(), ScDocFunc::FillSimple(), ScViewFunc::FillSimple(), ScDocument::FillTab(), ScViewFunc::FillTab(), ScDocument::FillTabMarked(), ScCellRangeObj::filter(), XclImpXFRangeBuffer::Finalize(), ScOrcusFactory::finalize(), oox::xls::WorksheetGlobals::finalizeDrawings(), oox::xls::Comment::finalizeImport(), oox::xls::PivotTable::finalizeImport(), oox::xls::ViewSettings::finalizeImport(), oox::xls::AutoFilter::finalizeImport(), oox::xls::AutoFilterBuffer::finalizeImport(), oox::xls::PivotCache::finalizeInternalSheetSource(), oox::xls::WorksheetGlobals::finalizeWorksheetImport(), ScDBInternalRange::findFieldColumn(), ScDetectiveFunc::FindFrameForObject(), ScDetectiveFunc::FindPredLevel(), ScDetectiveFunc::FindSuccLevel(), sc::RangeTraverser::first(), ScDocument::FitBlock(), ScViewUtil::FitToUnfilteredRows(), ScDocument::ForgetNoteCaptions(), ScDPCollection::FreeTable(), ScRandomNumberGeneratorDialog::GenerateNumbers(), DataRangeByColumnIterator::get(), DataRangeByRowIterator::get(), ScAccessibleSpreadsheet::getAccessibleCellAt(), ScAccessibleTableBase::getAccessibleChild(), ScAccessibleTableBase::getAccessibleChildCount(), ScAccessibleTableBase::getAccessibleColumn(), ScAccessibleTableBase::getAccessibleColumnCount(), ScAccessibleTableBase::getAccessibleColumnDescription(), ScAccessibleTableBase::getAccessibleColumnExtentAt(), ScAccessibleTableBase::getAccessibleIndex(), ScAccessibleTableBase::getAccessibleRow(), ScAccessibleTableBase::getAccessibleRowCount(), ScAccessibleTableBase::getAccessibleRowDescription(), ScAccessibleTableBase::getAccessibleRowExtentAt(), ScTokenArray::GetAdjacentExtendOfOuterFuncRefs(), ScBroadcastAreaSlotMachine::GetAllListeners(), ScBroadcastAreaSlot::GetAllListeners(), ScTable::GetAllNoteCaptionsState(), ScDocument::GetAllNoteCaptionsState(), ScDBFunc::GetAnonymousDBData(), ScDocShell::GetAnonymousDBData(), ScRangeStringConverter::GetAreaFromString(), ScCellRangeObj::getArrayFormula(), ScCellRangeObj::getArrayTokens(), ScTable::GetAutoFillPreview(), ScCellShell::GetBlockState(), ScDBCollection::AnonDBs::getByRange(), ScDrawLayer::GetCellAnchorFromPosition(), ScCellRangeObj::GetCellByPosition_Impl(), ScDocument::GetCellChangeTrackNote(), oox::xls::WorksheetGlobals::getCellRange(), ScCellRangeObj::getCellRangeByName(), ScCellRangeObj::getCellRangeByPosition(), ScExternalRefCache::getCellRangeData(), oox::xls::WorkbookHelper::getCellRangeFromDoc(), ScCellShell::GetCellState(), sc::TableValues::Impl::getCellValues(), ScDocShell::GetChangeAction(), ScTabView::GetChartInsertPos(), ScDocument::GetClipArea(), ScMyAreaLink::GetColCount(), ScDBInternalRange::getColSize(), ScCellRangeObj::getColumns(), ScCellFormatsObj::getCount(), ScFormatShell::GetCurrentNumberFormatType(), ScTransferObj::GetData(), ScDatabaseRangeObj::getDataArea(), ScDocument::GetDataAreaSubrange(), ScTable::GetDataAreaSubrange(), ScDBFunc::GetDBData(), ScDocShell::GetDBData(), ScHTMLTable::GetDocRange(), ScExternalRefManager::getDoubleRefTokensFromSrcDoc(), ScDocument::GetEmbeddedRect(), ScPaintHint::GetEndCol(), sc::PrintPageRangesInput::getEndColumn(), ScPaintHint::GetEndRow(), sc::PrintPageRangesInput::getEndRow(), ScPaintHint::GetEndTab(), ScVbaRange::getEntireColumnOrRow(), ScInterpreter::GetExternalDoubleRef(), ScDocument::GetFirstEditTextRow(), ScCellRangeObj::getFormulaArray(), oox::xls::Table::getHeight(), sc::FormulaGroupAreaListener::getListeningRange(), ScMarkData::GetMarkedColSpans(), ScMarkData::GetMarkedRowSpans(), ScDocument::GetMatrixFormulaRange(), ScXMLExport::GetMerged(), ScTableColumnObj::getName(), ScTable::GetNextPos(), ScDetectiveRefIter::GetNextRef(), sc::DocFuncUtil::getNonEmptyCellSpans(), ScTable::GetNotesInRange(), ScDocument::GetNotesInRange(), ScDocument::GetNumberFormat(), ScInterpreter::GetNumberSequenceArray(), ScCellFormatsObj::GetObjectByIndex_Impl(), ScCellRangeObj::GetOnePropertyValue(), ScTableColumnObj::GetOnePropertyValue(), ScTableRowObj::GetOnePropertyValue(), ScDataPilotTableObj::getOutputRange(), ScClipParam::getPasteColSize(), ScClipParam::getPasteRowSize(), ScSamplingDialog::GetPopulationSize(), ScDrawLayer::GetPrintArea(), ScDocument::GetPrintArea(), ScDocument::GetPrintAreaHor(), ScDocument::GetPrintAreaVer(), ScPrintRangeSaver::GetPrintRangesInfo(), ScAddressConversionObj::getPropertyValue(), sc::DataStream::GetRange(), ScDocument::GetRangeAtBlock(), ScStatisticsTwoVariableDialog::GetRangeFromSelection(), ScRefTokenHelper::getRangeFromToken(), ScTableSheetObj::getRanges(), ScChartObj::getRanges(), ScDocument::GetRangeScriptType(), ScInterpreter::GetRankNumberArray(), ScGridWindow::GetRectsAnyFor(), ScDatabaseRangeObj::getReferredCells(), ScNamedRangeObj::getReferredCells(), ScViewPaneBase::getReferredCells(), ScChangeAction::GetRefString(), DataCellIterator::getRelative(), ScModelObj::getRenderer(), ScTabView::getRowColumnHeaders(), ScMyAreaLink::GetRowCount(), ScCellRangeObj::getRows(), ScDBInternalRange::getRowSize(), getScRangeListForAddress(), ScAccessibleSpreadsheet::getSelectedAccessibleColumns(), ScAccessibleSpreadsheet::getSelectedAccessibleRows(), ScDBFunc::GetSelectedMemberList(), ScTabViewObj::getSelection(), ScMarkData::GetSelectionCover(), ScDocument::GetSelectionFrame(), ScDocument::GetSelectionStyle(), ScTabViewShell::GetSelectionText(), ScHTMLTable::GetSpan(), ScDocument::GetSparklineGroupInRange(), ScMarkData::GetStartOfEqualColumns(), sc::DataStreamDlg::GetStartRange(), ScCellShell::GetState(), ScRefTokenHelper::getTokenFromRange(), XclImpDrawObjBase::GetUsedArea(), ScColorFormat::getValues(), GetVars(), oox::xls::Table::getWidth(), ScChartPositioner::GlueState(), ScCellCursorObj::gotoEnd(), ScCellCursorObj::gotoEndOfUsedArea(), ScCellCursorObj::gotoOffset(), ScCellCursorObj::gotoStart(), ScCellCursorObj::gotoStartOfUsedArea(), ScCompiler::HandleColRowName(), ScCompiler::HandleDbData(), ScCompiler::HandleTableRef(), ScDocument::HasAttrib(), ScDocument::HasClipFilteredRows(), ScViewUtil::HasFiltered(), ScDocument::HasFormulaCell(), hashArea(), hashStartColumn(), ScDocument::HasMultipleDataCells(), sc::RangeTraverser::hasNext(), DataCellIterator::hasNext(), DataRangeByColumnIterator::hasNext(), DataRangeByRowIterator::hasNext(), ScDrawLayer::HasObjectsAnchoredInRange(), ScDocument::HasOLEObjectsInArea(), ScFormulaCell::HasOneReference(), ScDocument::HasPartOfMerged(), ScGridWindow::HasScenarioButton(), ScTable::HasScenarioRange(), ScTabViewShell::HasSelection(), ScDBFunc::HasSelectionForDateGroup(), ScDBFunc::HasSelectionForNumGroup(), ScColumn::HasSelectionMatrixFragment(), ScDocument::HasStringCells(), ScOutlineDocFunc::HideMarkedOutlines(), ScGridWindow::HitPageBreak(), ScGridWindow::HitRangeFinder(), sc::TableValues::Impl::Impl(), IMPL_LINK(), IMPL_LINK_NOARG(), ScTokenArray::ImplGetReference(), oox::xls::WorksheetFragment::importDimension(), oox::xls::PivotCache::importPCRecord(), ScSortedRangeCache::indexForRow(), ScDbNameDlg::Init(), ScFilterOptionsMgr::Init(), sc::DataStreamDlg::Init(), ScPivotFilterDlg::Init(), ScTransferObj::InitDocShell(), ScDPCache::InitFromDoc(), ScTabView::InitOwnBlockMode(), ScPrintFunc::InitParam(), ScComplexRefData::InitRange(), ScInputHandler::InitRangeFinder(), ScComplexRefData::InitRangeRel(), XclExpPCField::InitStandardField(), ScFourierAnalysisDialog::InputRangesValid(), ScRegressionDialog::InputRangesValid(), ScDocFunc::InsertCells(), ScViewFunc::InsertCells(), ScDocument::InsertCol(), ScHTMLTable::InsertNewCell(), ScDPCollection::InsertNewTable(), ScDetectiveFunc::InsertObject(), ScDetectiveFunc::InsertPredLevel(), ScDocument::InsertRow(), ScDocFunc::InsertSparklines(), ScDetectiveFunc::InsertSuccLevel(), ScDocument::InterpretCellsIfNeeded(), ScDocument::InterpretDirtyCells(), Intersection(), Intersects(), ScAccessibleSpreadsheet::isAccessibleColumnSelected(), ScAccessibleSpreadsheet::isAccessibleRowSelected(), ScAccessibleSpreadsheet::isAccessibleSelected(), ScMarkData::IsAllMarked(), ScTableProtectionImpl::isBlockEditable(), ScDocument::IsCellInChangeTrack(), ScMarkData::IsCellMarked(), ScMarkData::IsColumnMarked(), ScTransferObj::isComplex(), ScTable::IsDataFiltered(), ScAccessibleCell::IsDropdown(), ScXMLExport::IsMatrix(), ScDocument::IsPrintEmpty(), ScMarkData::IsRowMarked(), ScDocument::IsSelectionEditable(), ScInterpreter::IsTableOpInRange(), oox::xls::CellFormulaModel::isValidSharedRef(), ScInterpreter::IterateParametersIfs(), ScRangeList::Join(), ScRangePairList::Join(), ScInterpreter::JumpMatrix(), lcl_AddRanges(), lcl_appendCellRangeAddress(), lcl_CheckRepeatString(), lcl_collectAllPredOrSuccRanges(), lcl_CopyData(), lcl_DoDragCells(), lcl_DrawHighlight(), lcl_DrawScenarioFrames(), lcl_extendMergeRange(), lcl_fillEmptyMatrix(), lcl_GetAutoSumForColumnRange(), lcl_GetAutoSumForRowRange(), lcl_GetColRowDeltas(), lcl_GetInsDelRanges(), lcl_getLastTabName(), lcl_GetNumRowsColsInRange(), lcl_GetRelativePos(), lcl_GetSortParam(), lcl_GetTextToColumnsRange(), lcl_IsEditableMatrix(), lcl_MakeDropRange(), lcl_PaintOneRange(), lcl_PaintRefChanged(), lcl_ParseTarget(), lcl_PutDataArray(), lcl_PutFormulaArray(), lcl_reduceBlock(), lcl_ScAddress_Parse_OOo(), lcl_ScRange_External_TabSpan(), lcl_ScRange_Format_XL_Header(), lcl_ScRange_Parse_OOo(), lcl_ScRange_Parse_XL_A1(), lcl_ScRange_Parse_XL_R1C1(), oox::xls::lcl_SetBorderLine(), lcl_TabInRanges(), lcl_ToRange(), lcl_TotalRange(), lcl_WholeSheet(), ScDocument::LimitChartIfAll(), ScDocument::LimitRangeToAvailableSheets(), ScViewFunc::LinkBlock(), ScOutlineDocFunc::MakeOutline(), ScTabView::MarkColumns(), ScTabView::MarkCursor(), ScNavigatorDlg::MarkDataArea(), ScTabView::MarkRange(), ScTabView::MarkRows(), ScColumn::MarkScenarioIn(), ScUndoUtil::MarkSimpleBlock(), ScMarkData::MarkToSimple(), ScCellRangeObj::merge(), ScViewFunc::MergeCells(), ScDocShell::MergeDocument(), ScDocument::MixDocument(), ScPreview::MouseButtonDown(), ScGridWindow::MouseButtonUp(), ScPreview::MouseMove(), Move(), ScDocFunc::MoveBlock(), ScViewFunc::MoveBlockTo(), sc::DataStream::MoveData(), ScTokenArray::MoveReferenceColReorder(), ScTokenArray::MoveReferenceRowReorder(), ScRefUpdate::MoveRelWrap(), MoveSticky(), ScCellFormatsEnumeration::NextObject_Impl(), ScAccessibleSpreadsheet::Notify(), ScModelObj::NotifyChanges(), ScVbaRange::Offset(), ScXMLExport::OpenNewRow(), ScXMLExport::OpenRow(), ScExternalRefCache::RangeHash::operator()(), AreaListenerKey::operator<(), operator<(), operator=(), operator==(), ScDPObject::Output(), ScConsData::OutputToDocument(), ScGridWindow::PagebreakMove(), ScHeaderControl::Paint(), ScUndoDragDrop::PaintArea(), ScTabView::PaintBlock(), ScUndoUtil::PaintMore(), ScTabView::PaintRangeFinderEntry(), ScTransferObj::PaintToDev(), ScCompiler::ParseColRowName(), ScOptSolverDlg::ParseRef(), ScCompiler::ParseTableRefColumn(), ScAddressConversionObj::ParseUIString(), ScFormulaReferenceHelper::ParseWithNames(), ScViewFunc::PasteDataFormat(), ScViewFunc::PasteFromClip(), ScViewFunc::PasteFromClipToMultiRanges(), ScViewFunc::PasteMultiRangesFromClip(), ScViewFunc::PasteRTF(), ScSamplingDialog::PerformPeriodicSampling(), ScSamplingDialog::PerformRandomSampling(), ScSamplingDialog::PerformRandomSamplingKeepOrder(), ImportExcel::PostDocLoad(), ScDocShell::PostPaint(), ScViewFunc::PostPasteFromClip(), oox::xls::PivotCache::prepareSourceDataSheet(), ScVbaRange::PreviousNext(), ScRangeList::push_back(), ScChangeActionContent::PutValueToDoc(), sc::FormulaGroupAreaListener::Query(), ScDBDocFunc::Query(), ImportLotus::Read(), ScEEImport::Read(), XclImpChangeTrack::Read2DRange(), XclImpChangeTrack::ReadChTrInsert(), XclImpChangeTrack::ReadChTrMoveRange(), XclImpLabelranges::ReadLabelranges(), XclImpPivotCache::ReadPivotCacheStream(), sc::UndoGroupSparklines::Redo(), sc::UndoUngroupSparklines::Redo(), ScUndoDeleteCells::Redo(), ScUndoDragDrop::Redo(), ScUndoAutoFill::Redo(), ScUndoAutoFormat::Redo(), ScUndoEnterMatrix::Redo(), ScUndoImportData::Redo(), ScAreaLink::Refresh(), ScTableLink::Refresh(), ScDPObject::RefreshAfterLoad(), ScTable::RefVisible(), ScDocument::RegroupFormulaCells(), ScChangeActionIns::Reject(), ScChangeActionDel::Reject(), ScChangeActionMove::Reject(), ScFormulaReferenceHelper::ReleaseFocus(), ScTable::RemoveCondFormatData(), ScViewFunc::RemoveMerge(), ScOutlineDocFunc::RemoveOutline(), ScDBDocFunc::RemovePivotTable(), ScCellRangeObj::removeSubTotals(), ScModelObj::render(), ScTable::Reorder(), ScDocFunc::ReplaceConditionalFormat(), ScCompiler::ReplaceDoubleRefII(), ScDocument::ResetChanged(), ScTable::ResetChanged(), ScOrcusRefResolver::resolve_range(), ScDocument::ResolveStaticReference(), ScGridWindow::RFMouseMove(), ScAnalysisOfVarianceDialog::RowColumn(), ScVbaRange::Rows(), XclExpTables::SaveTableXml(), XclExpFormulaCell::SaveXml(), XclExpDimensions::SaveXml(), sc::SingleColumnSpanSet::scan(), ScCellFormatsEnumeration::ScCellFormatsEnumeration(), ScCellFormatsObj::ScCellFormatsObj(), ScCellMergeOption::ScCellMergeOption(), ScChangeActionDel::ScChangeActionDel(), ScChangeActionIns::ScChangeActionIns(), ScInterpreter::ScColRowNameAuto(), ScInterpreter::ScColumn(), ScInterpreter::ScColumns(), ScInterpreter::ScCountEmptyCells(), ScDataFormDlg::ScDataFormDlg(), ScInterpreter::ScDBArea(), ScFormatFilterPluginImpl::ScExportDif(), ScHorizontalValueIterator::ScHorizontalValueIterator(), ScImportExport::ScImportExport(), ScFormatFilterPluginImpl::ScImportHTML(), ScFormatFilterPluginImpl::ScImportRTF(), ScInterpreter::ScIndirect(), ScInterpreter::ScOffset(), ScInterpreter::ScRow(), ScInterpreter::ScRows(), ScServerObject::ScServerObject(), ScInterpreter::ScSheets(), ScSortedRangeCache::ScSortedRangeCache(), ScUndoDeleteCells::ScUndoDeleteCells(), ScUndoDragDrop::ScUndoDragDrop(), ScUndoInsertCells::ScUndoInsertCells(), ScUndoUseScenario::ScUndoUseScenario(), ScUniqueCellFormatsObj::ScUniqueCellFormatsObj(), ScXMLDatabaseRangeContext::ScXMLDatabaseRangeContext(), ScTable::SearchAndReplaceEmptyCells(), ScTable::SearchRangeForAllEmptyCells(), ScTable::SearchRangeForEmptyCell(), ScChangeTrack::SelectContent(), ScViewData::SelectionFillDOOM(), ScViewData::SelectionForbidsPaste(), sc::ColumnSpanSet::set(), ScOrcusAutoFilter::set_range(), ScMarkData::SetAreaTab(), ScVbaWorksheet::setAutoFilterMode(), XclImpXFRangeBuffer::SetBorderLine(), ScMyMergedRangesContainer::SetCellData(), oox::xls::SheetDataBuffer::setCellFormat(), ScExternalRefCache::setCellRangeData(), ScUndoDeleteMulti::SetChangeTrack(), ScUndoFillTable::SetChangeTrack(), ScUndoInsertTables::SetChangeTrack(), ScUndoDeleteTab::SetChangeTrack(), ScColRowNameRangesDlg::SetColRowData(), ScXMLTableRowCellContext::SetContentValidation(), ScViewFunctionSet::SetCursorAtCell(), ScUndoRemoveMerge::SetCurTab(), ScDocument::SetDBCollection(), ScDocument::SetDirty(), ScTable::SetDirty(), ScDocFunc::SetFormulaCells(), ScChangeTrack::SetLastCutMoveRange(), ScDocumentImport::setMatrixCells(), ScMarkData::SetMultiMarkArea(), ScTableColumnObj::SetOnePropertyValue(), ScTableRowObj::SetOnePropertyValue(), ScOutputData::SetPagebreakMode(), ScDatabaseRangeObj::setPropertyValue(), ScShapeObj::setPropertyValue(), ScComplexRefData::SetRange(), ScCondFormatDlg::SetReference(), ScXMLSourceDlg::SetReference(), ScInputHandler::SetReference(), ScFormulaDlg::SetReference(), ScPrintAreasDlg::SetReference(), ScConsolidateDlg::SetReference(), ScColRowNameRangesDlg::SetReference(), ScDbNameDlg::SetReference(), ScFilterDlg::SetReference(), ScSpecialFilterDlg::SetReference(), ScHighlightChgDlg::SetReference(), ScNameDefDlg::SetReference(), ScNameDlg::SetReference(), ScOptSolverDlg::SetReference(), ScRandomNumberGeneratorDialog::SetReference(), ScSamplingDialog::SetReference(), ScSimpleRefDlg::SetReference(), ScSolverDlg::SetReference(), ScStatisticsInputOutputDialog::SetReference(), ScStatisticsTwoVariableDialog::SetReference(), ScTabOpDlg::SetReference(), ScModule::SetReference(), sc::SparklineDataRangeDialog::SetReference(), sc::SparklineDialog::SetReference(), ScPivotLayoutDialog::SetReference(), ScTPValidationValue::SetReferenceHdl(), ScViewFunc::SetSelectionFrameLines(), ScDPObject::SetSheetDesc(), ScViewFunc::SetStyleSheetToMarked(), ScDocumentImport::setTableOpCells(), ScColumn::SetTableOpDirty(), ScDocument::SetTableOpDirty(), ScTable::SetTableOpDirty(), ScDocFunc::SetValueCells(), XclImpXFRangeBuffer::SetXF(), sc::DocumentStreamAccess::shiftRangeDown(), sc::DocumentStreamAccess::shiftRangeUp(), ScBlockUndo::ShowBlock(), ScMultiBlockUndo::ShowBlock(), ScFormulaReferenceHelper::ShowFormulaReference(), ScOutlineDocFunc::ShowMarkedOutlines(), ScGridWindow::ShowNoteMarker(), ScSimpleUndo::ShowTable(), ShrinkToDataArea(), DataRangeByColumnIterator::size(), DataRangeByRowIterator::size(), ScHTMLLayoutParser::SkipLocked(), ScCellRangeObj::sort(), ScTable::SortReorderByColumn(), ScTable::SortReorderByRowRefUpdate(), ScColumn::SplitFormulaGroupByRelativeRef(), ScDocument::StartAllListeners(), ScViewFunc::StartFormatArea(), sc::DataStream::StartImport(), ScFormulaListener::startListening(), ScBroadcastAreaSlotMachine::StartListeningArea(), sc::SharedFormulaUtil::startListeningAsGroup(), ScImportExport::StartPaste(), ScTransferObj::StripRefs(), ScDocument::SwapNonEmpty(), ScColumn::SwapNonEmpty(), ScTable::SwapNonEmpty(), ScImportExport::Sylk2Doc(), ScDocFunc::TabOp(), ScViewFunc::TestFormatArea(), ScViewFunc::TestMergeCells(), ScGridWindow::TestMouse(), ScEditableTester::TestRange(), ScImportExport::Text2Doc(), ScDocument::TransferTab(), ScDocFunc::TransliterateText(), ScClipParam::transpose(), ScDocument::TransposeClip(), ScUndoDeleteCells::Undo(), ScUndoAutoFill::Undo(), ScUndoAutoFormat::Undo(), ScUndoIndent::Undo(), ScUndoTransliterate::Undo(), ScUndoQuery::Undo(), ScUndoImportData::Undo(), ScUndoRepeatDB::Undo(), ScUndoConsolidate::Undo(), ScDocument::UndoToDocument(), ScDocShell::UnlockPaint_Impl(), ScViewUtil::UnmarkFiltered(), ScDocFunc::UnmergeCells(), ScTabView::UpdateAutoFillMark(), ScGridWindow::UpdateAutoFillMark(), ScBroadcastAreaSlotMachine::UpdateBroadcastAreas(), ScDrawLayer::UpdateCellAnchorFromPositionEnd(), ScDocument::UpdateChartRef(), ScGridWindow::UpdateCopySourceOverlay(), ScConditionalFormat::UpdateDeleteTab(), ScGridWindow::UpdateDragRectOverlay(), ScRefUpdate::UpdateGrow(), ScConditionalFormat::UpdateInsertTab(), ScInputHandler::UpdateLokReferenceMarks(), ScConditionalFormat::UpdateMoveTab(), ScDBData::UpdateMoveTab(), ScTable::UpdatePageBreaks(), ScDocShell::UpdatePaintExt(), ScTabView::UpdateRef(), ScDocument::UpdateRefAreaLinks(), ScChangeActionContent::UpdateReference(), ScDetOpList::UpdateReference(), ScDBData::UpdateReference(), ScColumn::UpdateReference(), ScDocument::UpdateReference(), ScTable::UpdateReference(), ScDPCollection::SheetCaches::updateReference(), ScDPObject::UpdateReference(), ScRangePairList::UpdateReference(), ScColumn::UpdateReferenceOnCopy(), oox::xls::WorksheetGlobals::UpdateRowProgress(), ScViewFunc::UpdateSelectionArea(), ScTable::UpdateSelectionFunction(), ScGridWindow::UpdateShrinkOverlay(), ScPivotLayoutDialog::UpdateSourceRange(), ScDocument::UpdateTranspose(), ScRefUpdate::UpdateTranspose(), ScFormulaCell::UpdateTranspose(), ScDocShell::UseScenario(), ScTabViewShell::UseSubTotal(), oox::xls::AddressConverter::validateCellRange(), XclExpAddressConverter::ValidateRange(), ValidRange(), ScTransferObj::WasSourceCursorInSelection(), ScRTFExport::Write(), XclExpChTrAction::Write2DRange(), ScHTMLExport::WriteCell(), ScXMLExport::WriteCell(), ScXMLExportDataPilot::WriteDataPilots(), XclExpPivotCache::WriteDconref(), AddressWalkerWriter::writeMatrixFormula(), ScRTFExport::WriteRow(), oox::xls::PivotCache::writeSourceDataCell(), oox::xls::PivotCache::writeSourceHeaderCells(), ScRTFExport::WriteTab(), ScXMLExport::WriteTable(), ScHTMLExport::WriteTables(), sc::ScDBDataManager::WriteToDoc(), oox::xls::Xf::writeToDoc(), ScEEImport::WriteToDocument(), ScHTMLImport::WriteToDocument(), XclExpCellTable::XclExpCellTable(), XclExpChTrInsert::XclExpChTrInsert(), XclExpChTrMoveRange::XclExpChTrMoveRange(), XclExpDxfs::XclExpDxfs(), XclExpFormulaCell::XclExpFormulaCell(), XclExpLabelranges::XclExpLabelranges(), XclExpPivotCache::XclExpPivotCache(), XclExpRangeFmlaBase::XclExpRangeFmlaBase(), XclImpAutoFilterData::XclImpAutoFilterData(), and XclImpSheetDrawing::XclImpSheetDrawing().

◆ aStart

ScAddress ScRange::aStart

Definition at line 497 of file address.hxx.

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

Public Member Functions

Public Attributes

Detailed Description

Constructor & Destructor Documentation

◆ ScRange() [1/8]

◆ ScRange() [2/8]

◆ ScRange() [3/8]

◆ ScRange() [4/8]

◆ ScRange() [5/8]

◆ ScRange() [6/8]

◆ ScRange() [7/8]

◆ ScRange() [8/8]

Member Function Documentation

◆ Contains() [1/2]

◆ Contains() [2/2]

◆ ExtendTo()

◆ Format()

◆ GetVars()

◆ hashArea()

◆ hashStartColumn()

◆ IncColIfNotLessThan()

◆ IncEndColSticky()

◆ IncEndRowSticky()

◆ IncRowIfNotLessThan()

◆ Intersection()

◆ Intersects()

◆ IsEndColSticky()

◆ IsEndRowSticky()

◆ IsValid()

◆ Move()

◆ MoveSticky()

◆ operator!=()

◆ operator<()

◆ operator<=()

◆ operator=() [1/2]

◆ operator=() [2/2]

◆ operator==()

◆ Parse()

◆ Parse_XL_Header()

◆ ParseAny()

◆ ParseCols()

◆ ParseRows()

◆ PutInOrder()

◆ SetInvalid()

Member Data Documentation

◆ aEnd

◆ aStart