#include <dociter.hxx>

Collaboration diagram for ScQueryCellIterator:

Public Member Functions
	ScQueryCellIterator (ScDocument &rDocument, const ScInterpreterContext &rContext, SCTAB nTable, const ScQueryParam &aParam, bool bMod)

bool	GetFirst ()

bool	GetNext ()

SCCOL	GetCol () const

SCROW	GetRow () const

void	SetAdvanceQueryParamEntryField (bool bVal)

void	AdvanceQueryParamEntryField ()

void	SetStopOnMismatch (bool bVal)
	If set, iterator stops on first non-matching cell content. More...

bool	StoppedOnMismatch () const

void	SetTestEqualCondition (bool bVal)
	If set, an additional test for SC_EQUAL condition is executed in ScTable::ValidQuery() if SC_LESS_EQUAL or SC_GREATER_EQUAL conditions are to be tested. More...

bool	IsEqualConditionFulfilled () const

bool	FindEqualOrSortedLastInRange (SCCOL &nFoundCol, SCROW &nFoundRow)
	In a range assumed to be sorted find either the last of a sequence of equal entries or the last being less than (or greater than) the queried value. More...

Private Types
enum	StopOnMismatchBits { nStopOnMismatchDisabled = 0x00, nStopOnMismatchEnabled = 0x01, nStopOnMismatchOccurred = 0x02, nStopOnMismatchExecuted = nStopOnMismatchEnabled \| nStopOnMismatchOccurred }

enum	TestEqualConditionBits { nTestEqualConditionDisabled = 0x00, nTestEqualConditionEnabled = 0x01, nTestEqualConditionMatched = 0x02, nTestEqualConditionFulfilled = nTestEqualConditionEnabled \| nTestEqualConditionMatched }

typedef sc::CellStoreType::const_position_type	PositionType

Private Member Functions
void	InitPos ()
	Initialize position for new column. More...

void	IncPos ()

void	IncBlock ()

bool	GetThis ()

bool	BinarySearch ()

Private Attributes
PositionType	maCurPos

ScQueryParam	maParam

ScDocument &	rDoc

const ScInterpreterContext &	mrContext

SCTAB	nTab

SCCOL	nCol

SCROW	nRow

sal_uInt8	nStopOnMismatch

sal_uInt8	nTestEqualCondition

bool	bAdvanceQuery

bool	bIgnoreMismatchOnLeadingStrings

Detailed Description

Definition at line 251 of file dociter.hxx.

Member Typedef Documentation

typedef sc::CellStoreType::const_position_type ScQueryCellIterator::PositionType

private

Definition at line 269 of file dociter.hxx.

Member Enumeration Documentation

enum ScQueryCellIterator::StopOnMismatchBits

private

Enumerator
nStopOnMismatchDisabled
nStopOnMismatchEnabled
nStopOnMismatchOccurred
nStopOnMismatchExecuted

Definition at line 253 of file dociter.hxx.

enum ScQueryCellIterator::TestEqualConditionBits

private

Enumerator
nTestEqualConditionDisabled
nTestEqualConditionEnabled
nTestEqualConditionMatched
nTestEqualConditionFulfilled

Definition at line 261 of file dociter.hxx.

Constructor & Destructor Documentation

ScQueryCellIterator::ScQueryCellIterator	(	ScDocument &	rDocument,
		const ScInterpreterContext &	rContext,
		SCTAB	nTable,
		const ScQueryParam &	aParam,
		bool	bMod
	)

Member Function Documentation

void ScQueryCellIterator::AdvanceQueryParamEntryField ( )

Definition at line 1252 of file dociter.cxx.

References ScQueryEntry::bDoQuery, ScQueryParamBase::GetEntry(), ScQueryParamBase::GetEntryCount(), maParam, ScDocument::MaxCol(), ScQueryEntry::nField, and rDoc.

Referenced by GetThis().

bool ScQueryCellIterator::BinarySearch ( )

private

Definition at line 1801 of file dociter.cxx.

References aStr, ScQueryParamBase::bCaseSens, ScQueryParamBase::bHasHeader, bIgnoreMismatchOnLeadingStrings, ScQueryEntry::ByString, CELLTYPE_FORMULA, CELLTYPE_VALUE, CollatorWrapper::compareString(), sc::element_type_edittext, sc::element_type_string, ScQueryEntry::eOp, ScGlobal::GetCollator(), ScQueryParamBase::GetEntry(), ScInterpreterContext::GetFormatTable(), ScCellFormat::GetInputString(), ScColumn::GetNumberFormat(), ScQueryEntry::GetQueryItem(), svl::SharedString::getString(), ScDocument::GetTableCount(), ScRefCellValue::getValue(), ScFormulaCell::GetValue(), ScRefCellValue::hasString(), i, ScColumn::IsEmptyData(), ScColumn::maCells, maCurPos, maParam, ScQueryEntry::Item::maString, ScDocument::maTabs, ScQueryEntry::Item::meType, ScRefCellValue::meType, ScQueryEntry::Item::mfVal, ScRefCellValue::mfValue, ScRefCellValue::mpFormula, mrContext, ScQueryParamTable::nCol1, nRow, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, nTab, rDoc, SC_EQUAL, SC_GREATER_EQUAL, SC_LESS_EQUAL, sc::toRefCell(), and u.

Referenced by FindEqualOrSortedLastInRange().

bool ScQueryCellIterator::FindEqualOrSortedLastInRange	(	SCCOL &	nFoundCol,
		SCROW &	nFoundRow
	)

In a range assumed to be sorted find either the last of a sequence of equal entries or the last being less than (or greater than) the queried value.

Used by the interpreter for [HV]?LOOKUP() and MATCH(). Column and row position of the found entry are returned, otherwise invalid.

The search does not stop when encountering a string and does not assume that no values follow anymore. If querying for a string a mismatch on the first entry, e.g. column header, is ignored.

! StopOnMismatch, TestEqualCondition and the internal IgnoreMismatchOnLeadingStrings and query params are in an undefined state upon return! The iterator is not usable anymore except for obtaining the number format!

Definition at line 1272 of file dociter.cxx.

References bAdvanceQuery, ScQueryParamBase::bByRow, ScQueryEntry::bDoQuery, bIgnoreMismatchOnLeadingStrings, BinarySearch(), ScQueryEntry::ByString, ScQueryEntry::ByValue, ScQueryEntry::eOp, ScQueryParamBase::eSearchType, GetCol(), ScQueryParamBase::GetEntry(), ScQueryParamBase::GetEntryCount(), GetFirst(), GetNext(), ScQueryEntry::GetQueryItem(), GetRow(), GetThis(), IsEqualConditionFulfilled(), maCurPos, maParam, ScDocument::MaxCol(), ScDocument::MaxRow(), ScQueryParamBase::mbRangeLookup, ScQueryEntry::Item::meType, ScQueryEntry::nField, utl::SearchParam::Normal, rDoc, SC_EQUAL, SC_GREATER_EQUAL, SC_LESS_EQUAL, SetStopOnMismatch(), SetTestEqualCondition(), and StoppedOnMismatch().

Referenced by ScInterpreter::CalculateLookup(), lcl_LookupQuery(), and ScInterpreter::ScMatch().

SCCOL ScQueryCellIterator::GetCol ( ) const

inline

Definition at line 307 of file dociter.hxx.

References nCol.

Referenced by ScInterpreter::CalculateLookup(), FindEqualOrSortedLastInRange(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), lcl_LookupQuery(), and ScInterpreter::ScMatch().

bool ScQueryCellIterator::GetFirst ( )

Definition at line 1234 of file dociter.cxx.

References ScDocument::GetTableCount(), GetThis(), InitPos(), maParam, ScQueryParamTable::nCol1, nTab, and rDoc.

Referenced by ScInterpreter::CalculateLookup(), FindEqualOrSortedLastInRange(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), lcl_LookupQuery(), ScInterpreter::ScDBCount(), and ScInterpreter::ScMatch().

bool ScQueryCellIterator::GetNext ( )

Definition at line 1242 of file dociter.cxx.

References GetThis(), IncPos(), nStopOnMismatch, nStopOnMismatchEnabled, nTestEqualCondition, and nTestEqualConditionEnabled.

Referenced by FindEqualOrSortedLastInRange(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), and ScInterpreter::ScDBCount().

SCROW ScQueryCellIterator::GetRow ( ) const

inline

Definition at line 308 of file dociter.hxx.

References nRow.

Referenced by FindEqualOrSortedLastInRange(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), and lcl_LookupQuery().

bool ScQueryCellIterator::GetThis ( )

private

Definition at line 1112 of file dociter.cxx.

References AdvanceQueryParamEntryField(), bAdvanceQuery, ScQueryParamBase::bByRow, ScQueryParamBase::bHasHeader, bIgnoreMismatchOnLeadingStrings, ScQueryEntry::ByString, sc::element_type_empty, ScQueryParamBase::GetEntry(), ScDocument::GetTableCount(), ScRefCellValue::hasString(), IncBlock(), IncPos(), InitPos(), ScColumn::IsEmptyData(), ScColumn::maCells, maCurPos, maParam, ScDocument::maTabs, ScQueryEntry::Item::mbMatchEmpty, ScQueryEntry::Item::meType, mrContext, nCol, ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, nStopOnMismatch, nStopOnMismatchOccurred, nTab, nTestEqualCondition, nTestEqualConditionMatched, rDoc, sc::toRefCell(), and ScQueryEvaluator::ValidQuery().

Referenced by FindEqualOrSortedLastInRange(), GetFirst(), and GetNext().

void ScQueryCellIterator::IncBlock ( )

private

Definition at line 1104 of file dociter.cxx.

References maCurPos.

Referenced by GetThis(), and IncPos().

void ScQueryCellIterator::IncPos ( )

private

Definition at line 1091 of file dociter.cxx.

References IncBlock(), maCurPos, and nRow.

Referenced by GetNext(), and GetThis().

void ScQueryCellIterator::InitPos ( )

private

Initialize position for new column.

Definition at line 1082 of file dociter.cxx.

References ScQueryParamBase::bByRow, ScQueryParamBase::bHasHeader, ScColumn::maCells, maCurPos, maParam, ScDocument::maTabs, nRow, ScQueryParamTable::nRow1, nTab, and rDoc.

Referenced by GetFirst(), and GetThis().

bool ScQueryCellIterator::IsEqualConditionFulfilled ( ) const

inline

Definition at line 345 of file dociter.hxx.

References nTestEqualConditionFulfilled.

Referenced by FindEqualOrSortedLastInRange().

void ScQueryCellIterator::SetAdvanceQueryParamEntryField ( bool bVal )

inline

Definition at line 312 of file dociter.hxx.

Referenced by ScInterpreter::CalculateLookup(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), and ScInterpreter::ScMatch().

void ScQueryCellIterator::SetStopOnMismatch ( bool bVal )

inline

If set, iterator stops on first non-matching cell content.

May be used in SC_LESS_EQUAL queries where a cell range is assumed to be sorted; stops on first value being greater than the queried value and GetFirst()/GetNext() return NULL. StoppedOnMismatch() returns true then. However, the iterator's conditions are not set to end all queries, GetCol() and GetRow() return values for the non-matching cell, further GetNext() calls may be executed.

Definition at line 326 of file dociter.hxx.

References nStopOnMismatchDisabled, and nStopOnMismatchEnabled.

Referenced by FindEqualOrSortedLastInRange().

void ScQueryCellIterator::SetTestEqualCondition ( bool bVal )

inline

If set, an additional test for SC_EQUAL condition is executed in ScTable::ValidQuery() if SC_LESS_EQUAL or SC_GREATER_EQUAL conditions are to be tested.

May be used where a cell range is assumed to be sorted to stop if an equal match is found.

Definition at line 339 of file dociter.hxx.

References nTestEqualConditionDisabled, and nTestEqualConditionEnabled.

Referenced by FindEqualOrSortedLastInRange().

bool ScQueryCellIterator::StoppedOnMismatch ( ) const

inline

Definition at line 331 of file dociter.hxx.

References nStopOnMismatchExecuted.

Referenced by FindEqualOrSortedLastInRange().