LibreOffice Module sc (master) 1
Public Types | Public Member Functions | Public Attributes | Protected Types | Protected Member Functions | Protected Attributes | List of all members
ScQueryParamBase Struct Reference

#include <queryparam.hxx>

Inheritance diagram for ScQueryParamBase:
[legend]

Public Types

typedef EntriesType::const_iterator const_iterator
 

Public Member Functions

virtual ~ScQueryParamBase ()
 
virtual bool IsValidFieldIndex () const
 
SC_DLLPUBLIC SCSIZE GetEntryCount () const
 
SC_DLLPUBLIC const ScQueryEntry & GetEntry (SCSIZE n) const
 
SC_DLLPUBLIC ScQueryEntry & GetEntry (SCSIZE n)
 
SC_DLLPUBLIC ScQueryEntry & AppendEntry ()
 
ScQueryEntry * FindEntryByField (SCCOLROW nField, bool bNew)
 
std::vector< ScQueryEntry * > FindAllEntriesByField (SCCOLROW nField)
 
SC_DLLPUBLIC bool RemoveEntryByField (SCCOLROW nField)
 
SC_DLLPUBLIC void RemoveAllEntriesByField (SCCOLROW nField)
 
void Resize (size_t nNew)
 
void FillInExcelSyntax (svl::SharedStringPool &rPool, const OUString &aCellStr, SCSIZE nIndex, SvNumberFormatter *pFormatter)
 
const_iterator begin () const
 
const_iterator end () const
 

Public Attributes

utl::SearchParam::SearchType eSearchType
 
bool bHasHeader
 
bool bByRow
 
bool bInplace
 
bool bCaseSens
 
bool bDuplicate
 
bool mbRangeLookup
 for spreadsheet functions like MATCH, LOOKUP, HLOOKUP, VLOOKUP More...
 

Protected Types

typedef std::vector< ScQueryEntry > EntriesType
 

Protected Member Functions

 ScQueryParamBase ()
 
 ScQueryParamBase (const ScQueryParamBase &r)
 
ScQueryParamBase & operator= (const ScQueryParamBase &r)
 

Protected Attributes

EntriesType m_Entries
 

Detailed Description

Definition at line 41 of file queryparam.hxx.

Member Typedef Documentation

◆ const_iterator

typedef EntriesType::const_iterator ScQueryParamBase::const_iterator

Definition at line 71 of file queryparam.hxx.

◆ EntriesType

typedef std::vector<ScQueryEntry> ScQueryParamBase::EntriesType
protected

Definition at line 68 of file queryparam.hxx.

Constructor & Destructor Documentation

◆ ~ScQueryParamBase()

ScQueryParamBase::~ScQueryParamBase ( )
virtual

Definition at line 102 of file queryparam.cxx.

◆ ScQueryParamBase() [1/2]

ScQueryParamBase::ScQueryParamBase ( )
protected

Definition at line 67 of file queryparam.cxx.

References m_Entries, and Normal.

◆ ScQueryParamBase() [2/2]

ScQueryParamBase::ScQueryParamBase ( const ScQueryParamBase &  r)
protected

Definition at line 79 of file queryparam.cxx.

Member Function Documentation

◆ AppendEntry()

ScQueryEntry & ScQueryParamBase::AppendEntry ( )

Definition at line 126 of file queryparam.cxx.

References m_Entries.

Referenced by XclImpAutoFilterData::EnableRemoveFilter(), ScXMLConditionContext::endFastElement(), FindEntryByField(), and XclImpAutoFilterData::ReadAutoFilter().

◆ begin()

ScQueryParamBase::const_iterator ScQueryParamBase::begin ( ) const

Definition at line 57 of file queryparam.cxx.

References m_Entries.

Referenced by ScQueryEvaluator::ValidQuery().

◆ end()

ScQueryParamBase::const_iterator ScQueryParamBase::end ( ) const

Definition at line 62 of file queryparam.cxx.

References m_Entries.

Referenced by ScQueryEvaluator::ValidQuery().

◆ FillInExcelSyntax()

void ScQueryParamBase::FillInExcelSyntax ( svl::SharedStringPool &  rPool,
const OUString &  aCellStr,
SCSIZE  nIndex,
SvNumberFormatter *  pFormatter 
)

Definition at line 204 of file queryparam.cxx.

References ScQueryEntry::bDoQuery, ScQueryEntry::ByString, ScQueryEntry::ByValue, ScQueryEntry::eOp, svl::SharedString::getEmptyString(), GetEntry(), ScQueryEntry::GetQueryItem(), svl::SharedString::getString(), svl::SharedStringPool::intern(), svl::SharedString::isEmpty(), SvNumberFormatter::IsNumberFormat(), m_Entries, ScQueryEntry::Item::maString, ScQueryEntry::Item::mbMatchEmpty, ScQueryEntry::Item::meType, ScQueryEntry::Item::mfVal, nIndex, Resize(), SC_EQUAL, SC_GREATER, SC_GREATER_EQUAL, SC_LESS, SC_LESS_EQUAL, SC_NOT_EQUAL, ScQueryEntry::SetQueryByEmpty(), and ScQueryEntry::SetQueryByNonEmpty().

Referenced by ScTable::CreateExcelQuery(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), and ScInterpreter::ScCountIf().

◆ FindAllEntriesByField()

std::vector< ScQueryEntry * > ScQueryParamBase::FindAllEntriesByField ( SCCOLROW  nField)

Definition at line 159 of file queryparam.cxx.

References aEntries, and m_Entries.

Referenced by ScGridWindow::LaunchAutoFilterMenu().

◆ FindEntryByField()

ScQueryEntry * ScQueryParamBase::FindEntryByField ( SCCOLROW  nField,
bool  bNew 
)

Definition at line 141 of file queryparam.cxx.

References AppendEntry(), and m_Entries.

Referenced by ScGridWindow::UpdateAutoFilterFromMenu().

◆ GetEntry() [1/2]

ScQueryEntry & ScQueryParamBase::GetEntry ( SCSIZE  n)

Definition at line 121 of file queryparam.cxx.

References m_Entries, and n.

◆ GetEntry() [2/2]

const ScQueryEntry & ScQueryParamBase::GetEntry ( SCSIZE  n) const

Definition at line 116 of file queryparam.cxx.

References m_Entries, and n.

Referenced by ScXMLDPFilterContext::AddFilterField(), ScVbaRange::AutoFilter(), ScInterpreter::CalculateLookup(), ScTable::CreateExcelQuery(), ScCellRangeObj::createFilterDescriptor(), ScCellRangeObj::createFilterDescriptorByObject(), ScTable::CreateQueryParam(), ScTable::CreateStarQuery(), ScDBQueryDataIterator::DataAccessInternal::DataAccessInternal(), ExcAutoFilterRecs::ExcAutoFilterRecs(), ScCellShell::ExecuteDB(), FillInExcelSyntax(), ScCellRangeObj::filter(), ScCellShell::GetDBState(), ScDocument::GetFilterEntries(), ScFilterDescriptorBase::getFilterFields(), ScFilterDescriptorBase::getFilterFields2(), ScFilterDescriptorBase::getFilterFields3(), ScPivotFilterDlg::GetOutputItem(), ScDatabaseRangeObj::GetQueryParam(), ScFilterDlg::Init(), ScPivotFilterDlg::Init(), ScGridWindow::IsAutoFilterActive(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), lcl_getPrevRowWithEmptyValueLookup(), ScInterpreter::LookupQueryWithCache(), ScSortedRangeCache::makeHashKey(), ScDBDocFunc::Query(), ScFilterDlg::RefreshEditRow(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), ScInterpreter::ScCountIf(), ScInterpreter::ScLookup(), ScInterpreter::ScMatch(), ScSheetDPData::ScSheetDPData(), ScSortedRangeCache::ScSortedRangeCache(), ScFilterDescriptorBase::setFilterFields(), ScDatabaseRangeObj::SetQueryParam(), ScDBDocFunc::Sort(), ScDBFunc::ToggleAutoFilter(), ScTable::TopTenQuery(), toValueType(), ScFilterDlg::UpdateColorList(), ScDPObject::UpdateReference(), ScDPCache::ValidQuery(), ScQueryEvaluator::ValidQuery(), and ScXMLExportDataPilot::WriteDPFilter().

◆ GetEntryCount()

SCSIZE ScQueryParamBase::GetEntryCount ( ) const

Definition at line 111 of file queryparam.cxx.

References m_Entries.

Referenced by ScVbaRange::AutoFilter(), ScCellRangeObj::createFilterDescriptor(), ScCellRangeObj::createFilterDescriptorByObject(), ScTable::CreateQueryParam(), ScDBQueryDataIterator::DataAccessInternal::DataAccessInternal(), ExcAutoFilterRecs::ExcAutoFilterRecs(), ScCellShell::ExecuteDB(), ScCellRangeObj::filter(), ScDocument::GetFilterEntries(), ScFilterDescriptorBase::getFilterFields(), ScFilterDescriptorBase::getFilterFields2(), ScFilterDescriptorBase::getFilterFields3(), ScFilterDescriptorBase::getPropertyValue(), ScDatabaseRangeObj::GetQueryParam(), ScGridWindow::IsAutoFilterActive(), ScQueryParam::operator==(), ScDBDocFunc::Query(), ScSheetDPData::ScSheetDPData(), ScFilterDescriptorBase::setFilterFields(), ScDatabaseRangeObj::SetQueryParam(), ScDBFunc::ToggleAutoFilter(), ScTable::TopTenQuery(), ScDPObject::UpdateReference(), ScDPCache::ValidQuery(), and ScXMLExportDataPilot::WriteDPFilter().

◆ IsValidFieldIndex()

bool ScQueryParamBase::IsValidFieldIndex ( ) const
virtual

Reimplemented in ScDBQueryParamInternal, and ScDBQueryParamMatrix.

Definition at line 106 of file queryparam.cxx.

◆ operator=()

ScQueryParamBase & ScQueryParamBase::operator= ( const ScQueryParamBase &  r)
protected

Definition at line 86 of file queryparam.cxx.

References bByRow, bCaseSens, bDuplicate, bHasHeader, bInplace, eSearchType, m_Entries, and mbRangeLookup.

◆ RemoveAllEntriesByField()

void ScQueryParamBase::RemoveAllEntriesByField ( SCCOLROW  nField)

Definition at line 191 of file queryparam.cxx.

References RemoveEntryByField().

Referenced by ScGridWindow::UpdateAutoFilterFromMenu().

◆ RemoveEntryByField()

bool ScQueryParamBase::RemoveEntryByField ( SCCOLROW  nField)

Definition at line 172 of file queryparam.cxx.

References m_Entries.

Referenced by ScTable::GetFilteredFilterEntries(), lcl_SetAllQueryForField(), and RemoveAllEntriesByField().

◆ Resize()

void ScQueryParamBase::Resize ( size_t  nNew)

Definition at line 196 of file queryparam.cxx.

References m_Entries.

Referenced by ScXMLDPFilterContext::AddFilterField(), ScTable::CreateExcelQuery(), ScTable::CreateStarQuery(), FillInExcelSyntax(), and ScFilterDescriptorBase::setFilterFields().

Member Data Documentation

◆ bByRow

bool ScQueryParamBase::bByRow

Definition at line 45 of file queryparam.hxx.

Referenced by ScInterpreter::CalculateLookup(), ScQueryParam::Clear(), ScCellRangeObj::createFilterDescriptor(), ScCellRangeObj::createFilterDescriptorByObject(), ScXMLConditionContext::endFastElement(), ScDBRangeBase::fillQueryOptions(), ScCellRangeObj::filter(), ScFilterDlg::GetOutputItem(), ScFilterDescriptorBase::getPropertyValue(), ScDatabaseRangeObj::GetQueryParam(), ScDBData::GetQueryParam(), IMPL_LINK(), operator=(), ScQueryParam::operator==(), ScInterpreter::ScLookup(), ScInterpreter::ScMatch(), ScFilterDescriptorBase::setPropertyValue(), and ScDatabaseRangeObj::SetQueryParam().

◆ bCaseSens

bool ScQueryParamBase::bCaseSens

Definition at line 47 of file queryparam.hxx.

Referenced by ScQueryParam::Clear(), ScQueryEvaluator::compareByString(), ScXMLConditionContext::endFastElement(), ScXMLDPFilterContext::endFastElement(), ScDBRangeBase::fillQueryOptions(), ScDocument::GetFilterEntries(), ScFilterDlg::GetOutputItem(), ScPivotFilterDlg::GetOutputItem(), ScFilterDescriptorBase::getPropertyValue(), IMPL_LINK(), ScFilterOptionsMgr::Init(), ScPivotFilterDlg::Init(), operator=(), ScQueryParam::operator==(), ScQueryEvaluator::processEntry(), ScFilterDescriptorBase::setPropertyValue(), ScQueryEvaluator::setupCollatorIfNeeded(), ScQueryEvaluator::setupTransliteratorIfNeeded(), toValueType(), ScGridWindow::UpdateAutoFilterFromMenu(), ScDPCache::ValidQuery(), and ScXMLExportDataPilot::WriteDPFilter().

◆ bDuplicate

bool ScQueryParamBase::bDuplicate

Definition at line 48 of file queryparam.hxx.

Referenced by ScQueryParam::Clear(), ScXMLFilterContext::endFastElement(), ScXMLDPFilterContext::endFastElement(), ScCellShell::ExecuteDB(), ScDBRangeBase::fillQueryOptions(), ScFilterDlg::GetOutputItem(), ScPivotFilterDlg::GetOutputItem(), ScFilterDescriptorBase::getPropertyValue(), IMPL_LINK(), ScFilterOptionsMgr::Init(), ScPivotFilterDlg::Init(), operator=(), ScQueryParam::operator==(), ScTable::Query(), ScDBDocFunc::Query(), ScFilterDescriptorBase::setPropertyValue(), ScDBFunc::ToggleAutoFilter(), ScGridWindow::UpdateAutoFilterFromMenu(), and ScXMLExportDataPilot::WriteDPFilter().

◆ bHasHeader

bool ScQueryParamBase::bHasHeader

Definition at line 44 of file queryparam.hxx.

Referenced by ScQueryParam::Clear(), ScCellRangeObj::createFilterDescriptorByObject(), ScDBRangeBase::fillQueryOptions(), ScFilterDlg::GetOutputItem(), ScFilterDescriptorBase::getPropertyValue(), ScDBData::GetQueryParam(), IMPL_LINK(), ScFilterOptionsMgr::Init(), operator=(), ScQueryParam::operator==(), ScTable::Query(), ScDBDocFunc::Query(), ScFilterDescriptorBase::setPropertyValue(), ScDatabaseRangeObj::SetQueryParam(), ScDPObject::SetSheetDesc(), and ScTable::TopTenQuery().

◆ bInplace

bool ScQueryParamBase::bInplace

Definition at line 46 of file queryparam.hxx.

Referenced by ScQueryParam::Clear(), ScXMLFilterContext::endFastElement(), ExcAutoFilterRecs::ExcAutoFilterRecs(), ScDBRangeBase::fillQueryOptions(), ScFilterDlg::GetOutputItem(), ScPivotFilterDlg::GetOutputItem(), ScFilterDescriptorBase::getPropertyValue(), IMPL_LINK(), ScFilterOptionsMgr::Init(), ScGridWindow::IsAutoFilterActive(), ScQueryParam::MoveToDest(), operator=(), ScQueryParam::operator==(), ScTable::Query(), ScDBFunc::Query(), ScDBDocFunc::Query(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), XclImpAutoFilterData::SetExtractPos(), ScFilterDescriptorBase::setPropertyValue(), ScUndoQuery::Undo(), ScGridWindow::UpdateAutoFilterFromMenu(), and XclImpAutoFilterData::XclImpAutoFilterData().

◆ eSearchType

utl::SearchParam::SearchType ScQueryParamBase::eSearchType

Definition at line 43 of file queryparam.hxx.

Referenced by ScInterpreter::CalculateLookup(), ScQueryParam::Clear(), ScQueryEvaluator::compareByString(), ScXMLDPFilterContext::endFastElement(), ScDBRangeBase::fillQueryOptions(), ScXMLConditionContext::GetOperator(), ScFilterDlg::GetOutputItem(), ScPivotFilterDlg::GetOutputItem(), ScFilterDescriptorBase::getPropertyValue(), IMPL_LINK(), ScFilterOptionsMgr::Init(), ScPivotFilterDlg::Init(), ScQueryEvaluator::isRealWildOrRegExp(), ScQueryEvaluator::isTestWildOrRegExp(), ScInterpreter::IterateParametersIf(), ScInterpreter::IterateParametersIfs(), operator=(), ScQueryParam::operator==(), ScInterpreter::ScCountIf(), ScInterpreter::ScLookup(), ScInterpreter::ScMatch(), ScFilterDescriptorBase::setPropertyValue(), ScGridWindow::UpdateAutoFilterFromMenu(), ScDPCache::ValidQuery(), and ScXMLExportDataPilot::WriteDPFilter().

◆ m_Entries

EntriesType ScQueryParamBase::m_Entries
protected

Definition at line 81 of file queryparam.hxx.

Referenced by AppendEntry(), begin(), ScQueryParam::Clear(), end(), FillInExcelSyntax(), FindAllEntriesByField(), FindEntryByField(), GetEntry(), GetEntryCount(), ScQueryParam::MoveToDest(), operator=(), ScQueryParam::operator==(), RemoveEntryByField(), Resize(), and ScQueryParamBase().

◆ mbRangeLookup

bool ScQueryParamBase::mbRangeLookup

for spreadsheet functions like MATCH, LOOKUP, HLOOKUP, VLOOKUP

Definition at line 49 of file queryparam.hxx.

Referenced by operator=(), and ScQueryEvaluator::processEntry().

The documentation for this struct was generated from the following files:
Generated on Sun Jul 30 2023 04:31:00 for LibreOffice Module sc (master) by doxygen 1.9.3