#include <dbdata.hxx>

Inheritance diagram for ScDBData:

Collaboration diagram for ScDBData:

Classes
struct	less

Public Member Functions
SC_DLLPUBLIC	ScDBData (const OUString &rName, SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, bool bByR=true, bool bHasH=true, bool bTotals=false)

	ScDBData (const ScDBData &rData)

	ScDBData (const OUString &rName, const ScDBData &rData)

virtual SC_DLLPUBLIC	~ScDBData () override

virtual void	Notify (const SfxHint &rHint) override

ScDBData &	operator= (const ScDBData &rData)

bool	operator== (const ScDBData &rData) const

const OUString &	GetName () const

const OUString &	GetUpperName () const

SCTAB	GetTab () const

void	GetArea (SCTAB &rTab, SCCOL &rCol1, SCROW &rRow1, SCCOL &rCol2, SCROW &rRow2) const

SC_DLLPUBLIC void	GetArea (ScRange &rRange) const

void	SetArea (SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2)

void	MoveTo (SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, SCCOL nUpdateCol=-1)

void	SetByRow (bool bByR)

bool	HasHeader () const

void	SetHeader (bool bHasH)

bool	HasTotals () const

void	SetTotals (bool bTotals)

void	SetIndex (sal_uInt16 nInd)

sal_uInt16	GetIndex () const

bool	IsDoSize () const

void	SetDoSize (bool bSet)

bool	IsKeepFmt () const

void	SetKeepFmt (bool bSet)

bool	IsStripData () const

void	SetStripData (bool bSet)

void	SetContainer (ScDBDataContainerBase *pContainer)

ScRange	GetHeaderArea () const
	Returns header row range if has headers, else invalid range. More...

void	StartTableColumnNamesListener ()

void	EndTableColumnNamesListener ()

SC_DLLPUBLIC void	SetTableColumnNames (::std::vector< OUString > &&rNames)

SC_DLLPUBLIC const ::std::vector< OUString > &	GetTableColumnNames () const

SC_DLLPUBLIC void	SetTableColumnAttributes (::std::vector< TableColumnAttributes > &&rAttributes)

SC_DLLPUBLIC const ::std::vector< TableColumnAttributes > &	GetTableColumnAttributes () const

bool	AreTableColumnNamesDirty () const

SC_DLLPUBLIC void	RefreshTableColumnNames (ScDocument *pDoc)
	Refresh/update the column names with the header row's cell contents. More...

void	RefreshTableColumnNames (ScDocument *pDoc, const ScRange &rRange)
	Refresh/update the column names with the header row's cell contents within the given range. More...

sal_Int32	GetColumnNameOffset (const OUString &rName) const
	Finds the column named rName and returns the corresponding offset within the table. More...

OUString	GetTableColumnName (SCCOL nCol) const
	Returns table column name if nCol is within column range and name is stored, else empty string. More...

OUString	GetSourceString () const

OUString	GetOperations () const

SC_DLLPUBLIC void	GetSortParam (ScSortParam &rSortParam) const

SC_DLLPUBLIC void	SetSortParam (const ScSortParam &rSortParam)

void	UpdateFromSortParam (const ScSortParam &rSortParam)
	Remember some more settings of ScSortParam, only to be called at anonymous DB ranges as it at least overwrites bHasHeader. More...

SC_DLLPUBLIC void	GetQueryParam (ScQueryParam &rQueryParam) const

SC_DLLPUBLIC void	SetQueryParam (const ScQueryParam &rQueryParam)

SC_DLLPUBLIC bool	GetAdvancedQuerySource (ScRange &rSource) const

SC_DLLPUBLIC void	SetAdvancedQuerySource (const ScRange *pSource)

void	GetSubTotalParam (ScSubTotalParam &rSubTotalParam) const

void	SetSubTotalParam (const ScSubTotalParam &rSubTotalParam)

void	GetImportParam (ScImportParam &rImportParam) const

void	SetImportParam (const ScImportParam &rImportParam)

bool	IsDBAtCursor (SCCOL nCol, SCROW nRow, SCTAB nTab, ScDBDataPortion ePortion) const

bool	IsDBAtArea (SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const

bool	HasImportParam () const

SC_DLLPUBLIC bool	HasQueryParam () const

bool	HasSortParam () const

bool	HasSubTotalParam () const

bool	HasImportSelection () const

void	SetImportSelection (bool bSet)

bool	HasAutoFilter () const

void	SetAutoFilter (bool bSet)

bool	IsModified () const

void	SetModified (bool bMod)

void	UpdateMoveTab (SCTAB nOldPos, SCTAB nNewPos)

bool	UpdateReference (const ScDocument *pDoc, UpdateRefMode eUpdateRefMode, SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2, SCCOL nDx, SCROW nDy, SCTAB nDz)

void	ExtendDataArea (const ScDocument &rDoc)

void	CalcSaveFilteredCount (SCSIZE nNonFilteredRowCount)

void	GetFilterSelCount (SCSIZE &nSelected, SCSIZE &nTotal)

Public Member Functions inherited from SvtListener
	SvtListener ()=default

	SvtListener (const SvtListener &r)=default

virtual	~SvtListener () COVERITY_NOEXCEPT_FALSE

bool	StartListening (SvtBroadcaster &rBroadcaster)

void	EndListening (SvtBroadcaster &rBroadcaster)

void	EndListeningAll ()

void	CopyAllBroadcasters (const SvtListener &r)

bool	HasBroadcaster () const

virtual void	Notify (const SfxHint &rHint)

virtual void	Query (QueryBase &rQuery) const

Public Member Functions inherited from ScRefreshTimer
	ScRefreshTimer ()

	ScRefreshTimer (sal_Int32 nSeconds)

	ScRefreshTimer (const ScRefreshTimer &r)

virtual	~ScRefreshTimer () override

ScRefreshTimer &	operator= (const ScRefreshTimer &r)

bool	operator== (const ScRefreshTimer &r) const

bool	operator!= (const ScRefreshTimer &r) const

void	SetRefreshControl (std::unique_ptr< ScRefreshTimerControl > const *pp)

void	SetRefreshHandler (const Link< Timer *, void > &rLink)

sal_Int32	GetRefreshDelaySeconds () const

void	StopRefreshTimer ()

void	SetRefreshDelay (sal_Int32 nSeconds)

virtual SC_DLLPUBLIC void	Invoke () override

Public Member Functions inherited from AutoTimer
	AutoTimer (const char *pDebugName)

Public Member Functions inherited from Timer
	Timer (const char *pDebugName)

	Timer (const Timer &rTimer)

virtual	~Timer () override

Timer &	operator= (const Timer &rTimer)

virtual void	Invoke () override

void	Invoke (Timer *arg)

void	SetInvokeHandler (const Link< Timer *, void > &rLink)

void	ClearInvokeHandler ()

void	SetTimeout (sal_uInt64 nTimeoutMs)

sal_uInt64	GetTimeout () const

virtual void	Start (bool bStartTimer=true) override

Public Member Functions inherited from Task
	Task (const char *pDebugName)

	Task (const Task &rTask)

virtual	~Task () COVERITY_NOEXCEPT_FALSE

Task &	operator= (const Task &rTask)

void	SetPriority (TaskPriority ePriority)

TaskPriority	GetPriority () const

const char *	GetDebugName () const

virtual void	Invoke ()=0

virtual void	Start (bool bStartTimer=true)

void	Stop ()

bool	IsActive () const

void	SetStatic ()

bool	IsStatic () const

Private Member Functions
void	AdjustTableColumnAttributes (UpdateRefMode eUpdateRefMode, SCCOL nDx, SCCOL nCol1, SCCOL nOldCol1, SCCOL nOldCol2, SCCOL nNewCol1, SCCOL nNewCol2)

void	InvalidateTableColumnNames (bool bSwapToEmptyNames)

bool	operator== (const ScRefreshTimer &r) const

Private Attributes
std::unique_ptr< ScSortParam >	mpSortParam

std::unique_ptr< ScQueryParam >	mpQueryParam

std::unique_ptr< ScSubTotalParam >	mpSubTotal

std::unique_ptr< ScImportParam >	mpImportParam

ScDBDataContainerBase *	mpContainer

const OUString	aName
	DBParam. More...

OUString	aUpper

SCTAB	nTable

SCCOL	nStartCol

SCROW	nStartRow

SCCOL	nEndCol

SCROW	nEndRow

bool	bByRow

bool	bHasHeader

bool	bHasTotals

bool	bDoSize

bool	bKeepFmt

bool	bStripData

bool	bIsAdvanced
	QueryParam. More...

ScRange	aAdvSource
	source range More...

bool	bDBSelection
	not in Param: if selection, block update More...

sal_uInt16	nIndex
	unique index formulas More...

bool	bAutoFilter
	AutoFilter? (not saved) More...

bool	bModified
	is set/cleared for/by(?) UpdateReference More...

::std::vector< OUString >	maTableColumnNames
	names of table columns More...

::std::vector< TableColumnAttributes >	maTableColumnAttributes
	attributes of table columns More...

bool	mbTableColumnNamesDirty

SCSIZE	nFilteredRowCount

Additional Inherited Members
Protected Member Functions inherited from Timer
virtual void	SetDeletionFlags () override

virtual sal_uInt64	UpdateMinPeriod (sal_uInt64 nTimeNow) const override

	Timer (bool bAuto, const char *pDebugName)

Protected Member Functions inherited from Task
const ImplSchedulerData *	GetSchedulerData () const

virtual void	SetDeletionFlags ()

virtual sal_uInt64	UpdateMinPeriod (sal_uInt64 nTimeNow) const=0

Static Protected Member Functions inherited from Task
static void	StartTimer (sal_uInt64 nMS)

Detailed Description

Definition at line 65 of file dbdata.hxx.

Constructor & Destructor Documentation

◆ ScDBData() [1/3]

ScDBData::ScDBData	(	const OUString &	rName,
		SCTAB	nTab,
		SCCOL	nCol1,
		SCROW	nRow1,
		SCCOL	nCol2,
		SCROW	nRow2,
		bool	bByR = `true`,
		bool	bHasH = `true`,
		bool	bTotals = `false`
	)

Definition at line 56 of file dbdata.cxx.

References aUpper, ScGlobal::getCharClass(), and CharClass::uppercase().

◆ ScDBData() [2/3]

ScDBData::ScDBData ( const ScDBData & rData )

Definition at line 90 of file dbdata.cxx.

References aName, and nIndex.

◆ ScDBData() [3/3]

ScDBData::ScDBData	(	const OUString &	rName,
		const ScDBData &	rData
	)

Definition at line 124 of file dbdata.cxx.

References aName, aUpper, ScGlobal::getCharClass(), nIndex, and CharClass::uppercase().

◆ ~ScDBData()

ScDBData::~ScDBData ( )

overridevirtual

Definition at line 253 of file dbdata.cxx.

References ScRefreshTimer::StopRefreshTimer().

Member Function Documentation

◆ AdjustTableColumnAttributes()

void ScDBData::AdjustTableColumnAttributes	(	UpdateRefMode	eUpdateRefMode,
		SCCOL	nDx,
		SCCOL	nCol1,
		SCCOL	nOldCol1,
		SCCOL	nOldCol2,
		SCCOL	nNewCol1,
		SCCOL	nNewCol2
	)

private

Definition at line 694 of file dbdata.cxx.

References i, InvalidateTableColumnNames(), maTableColumnAttributes, maTableColumnNames, mbTableColumnNamesDirty, n, SAL_WARN_IF, and URM_INSDEL.

Referenced by UpdateReference().

◆ AreTableColumnNamesDirty()

bool ScDBData::AreTableColumnNamesDirty ( ) const

inline

Definition at line 158 of file dbdata.hxx.

◆ CalcSaveFilteredCount()

void ScDBData::CalcSaveFilteredCount ( SCSIZE nNonFilteredRowCount )

Definition at line 973 of file dbdata.cxx.

References bHasHeader, nEndRow, nFilteredRowCount, and nStartRow.

Referenced by ScDBDocFunc::Query().

◆ EndTableColumnNamesListener()

void ScDBData::EndTableColumnNamesListener ( )

Definition at line 678 of file dbdata.cxx.

References SvtListener::EndListeningAll().

Referenced by operator=(), and SetArea().

◆ ExtendDataArea()

void ScDBData::ExtendDataArea ( const ScDocument & rDoc )

Definition at line 649 of file dbdata.cxx.

References ScDocument::GetDataArea(), InvalidateTableColumnNames(), maTableColumnNames, ScDocument::MaxRow(), nEndCol, nEndRow, nStartCol, nStartRow, nTable, and SAL_WARN_IF.

Referenced by ScTabViewShell::CreateRefDialogController(), and ScDocument::GetFilterEntries().

◆ GetAdvancedQuerySource()

bool ScDBData::GetAdvancedQuerySource ( ScRange & rSource ) const

Definition at line 457 of file dbdata.cxx.

References aAdvSource, and bIsAdvanced.

Referenced by ScTabViewShell::CreateRefDialogController(), XclImpAutoFilterData::InsertQueryParam(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), ScDatabaseRangeObj::setPropertyValue(), and UpdateReference().

◆ GetArea() [1/2]

void ScDBData::GetArea ( ScRange & rRange ) const

Definition at line 309 of file dbdata.cxx.

References nEndCol, nEndRow, nStartCol, nStartRow, and nTable.

◆ GetArea() [2/2]

void ScDBData::GetArea	(	SCTAB &	rTab,
		SCCOL &	rCol1,
		SCROW &	rRow1,
		SCCOL &	rCol2,
		SCROW &	rRow2
	)		const

Definition at line 300 of file dbdata.cxx.

References nEndCol, nEndRow, nStartCol, nStartRow, and nTable.

Referenced by ScDBFunc::ApplyAutoFilter(), ScDBFuncUndo::BeginRedo(), ScDocShell::CancelAutoDBRange(), ScTabViewShell::CreateRefDialogController(), ScUndoAutoFilter::DoChange(), ScDocShell::DoConsolidate(), ScGridWindow::DrawButtons(), ScDBFuncUndo::EndUndo(), ScDocShell::Execute(), ScCellShell::ExecuteDB(), ScCellShell::ExecuteSubtotals(), oox::xls::WorksheetGlobals::finalizeWorksheetImport(), ScAreaLink::FindExtRange(), ScDocShell::GetDBData(), ScDBCollection::GetDBNearCursor(), ScDocument::GetFilterEntries(), ScCompiler::HandleDbData(), ScCompiler::HandleTableRef(), ScDBFunc::HideAutoFilter(), IMPL_LINK(), ScDbNameDlg::Init(), XclExpTablesManager::Initialize(), ScDBDocFunc::ModifyDBData(), ScAreaNameIterator::Next(), ScHeaderControl::Paint(), ScCompiler::ParseTableRefColumn(), ScDBFunc::Query(), ScDBDocFunc::Query(), ScUndoImportData::Repeat(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), XclExpTables::SaveTableXml(), ScInterpreter::ScDBArea(), ScVbaWorksheet::setAutoFilterMode(), ScDocument::SetDBCollection(), ScDatabaseRangeObj::setPropertyValue(), ScDBFunc::ToggleAutoFilter(), ScGridWindow::UpdateAutoFilterFromMenu(), UpdateMoveTab(), UpdateReference(), ScTabViewShell::UseSubTotal(), and sc::ScDBDataManager::WriteToDoc().

◆ GetColumnNameOffset()

sal_Int32 ScDBData::GetColumnNameOffset ( const OUString & rName ) const

Finds the column named rName and returns the corresponding offset within the table.

Returns: -1 if not found.

XXX NOTE: there is no refresh of names or anything implemented yet, use this only during document load time.

Definition at line 903 of file dbdata.cxx.

References maTableColumnNames.

Referenced by ScCompiler::ParseTableRefColumn().

◆ GetFilterSelCount()

void ScDBData::GetFilterSelCount	(	SCSIZE &	nSelected,
		SCSIZE &	nTotal
	)

Definition at line 981 of file dbdata.cxx.

References bHasHeader, nEndRow, nFilteredRowCount, nStartRow, and SCSIZE_MAX.

Referenced by ScDocument::GetFilterSelCount(), and ScHeaderControl::Paint().

◆ GetHeaderArea()

ScRange ScDBData::GetHeaderArea ( ) const

Returns header row range if has headers, else invalid range.

Definition at line 315 of file dbdata.cxx.

References HasHeader(), ScAddress::INITIALIZE_INVALID, nEndCol, nStartCol, nStartRow, and nTable.

Referenced by InvalidateTableColumnNames(), Notify(), RefreshTableColumnNames(), and StartTableColumnNamesListener().

◆ GetImportParam()

void ScDBData::GetImportParam ( ScImportParam & rImportParam ) const

Definition at line 480 of file dbdata.cxx.

References mpImportParam, ScImportParam::nCol1, ScImportParam::nCol2, nEndCol, nEndRow, ScImportParam::nRow1, ScImportParam::nRow2, nStartCol, and nStartRow.

Referenced by ScDispatch::addStatusListener(), ScDocShell::Execute(), ScCellShell::ExecuteDB(), IMPL_LINK(), ScDatabaseRangeObj::Notify(), operator==(), and ScDispatch::selectionChanged().

◆ GetIndex()

sal_uInt16 ScDBData::GetIndex ( ) const

inline

Definition at line 141 of file dbdata.hxx.

References nIndex.

Referenced by sc::TokenStringContext::TokenStringContext().

◆ GetName()

const OUString & ScDBData::GetName ( ) const

inline

◆ GetOperations()

OUString ScDBData::GetOperations ( ) const

Definition at line 270 of file dbdata.cxx.

References aBuf, ScQueryEntry::bDoQuery, mpQueryParam, mpSortParam, mpSubTotal, and ScResId().

Referenced by ScDbNameDlg::SetInfoStrings().

◆ GetQueryParam()

void ScDBData::GetQueryParam ( ScQueryParam & rQueryParam ) const

◆ GetSortParam()

void ScDBData::GetSortParam ( ScSortParam & rSortParam ) const

Definition at line 401 of file dbdata.cxx.

References bByRow, ScSortParam::bByRow, bHasHeader, ScSortParam::bHasHeader, mpSortParam, ScSortParam::nCol1, ScSortParam::nCol2, nEndCol, nEndRow, ScSortParam::nRow1, ScSortParam::nRow2, nStartCol, and nStartRow.

Referenced by ScDBFunc::DoSubTotals(), ScDBDocFunc::DoSubTotals(), ScCellShell::ExecuteDB(), operator==(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), and ScGridWindow::UpdateAutoFilterFromMenu().

◆ GetSourceString()

OUString ScDBData::GetSourceString ( ) const

Definition at line 258 of file dbdata.cxx.

References aBuf, and mpImportParam.

Referenced by ScDbNameDlg::SetInfoStrings().

◆ GetSubTotalParam()

void ScDBData::GetSubTotalParam ( ScSubTotalParam & rSubTotalParam ) const

Definition at line 463 of file dbdata.cxx.

References mpSubTotal, ScSubTotalParam::nCol1, ScSubTotalParam::nCol2, nEndCol, nEndRow, ScSubTotalParam::nRow1, ScSubTotalParam::nRow2, nStartCol, and nStartRow.

Referenced by ScCellShell::ExecuteSubtotals(), operator==(), ScDBDocFunc::Query(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), and ScDBFunc::UISort().

◆ GetTab()

SCTAB ScDBData::GetTab ( ) const

inline

Definition at line 129 of file dbdata.hxx.

Referenced by ScDocShell::GetDBData().

◆ GetTableColumnAttributes()

SC_DLLPUBLIC const ::std::vector< TableColumnAttributes > & ScDBData::GetTableColumnAttributes ( ) const

inline

Definition at line 157 of file dbdata.hxx.

Referenced by XclExpTables::SaveTableXml().

◆ GetTableColumnName()

OUString ScDBData::GetTableColumnName ( SCCOL nCol ) const

Returns table column name if nCol is within column range and name is stored, else empty string.

Definition at line 916 of file dbdata.cxx.

References o3tl::make_unsigned(), maTableColumnNames, and nStartCol.

◆ GetTableColumnNames()

SC_DLLPUBLIC const ::std::vector< OUString > & ScDBData::GetTableColumnNames ( ) const

inline

Definition at line 155 of file dbdata.hxx.

Referenced by XclExpTables::SaveTableXml().

◆ GetUpperName()

const OUString & ScDBData::GetUpperName ( ) const

inline

Definition at line 128 of file dbdata.hxx.

Referenced by ScDBDocFunc::ModifyDBData(), and ScDocument::SetDBCollection().

◆ HasAutoFilter()

bool ScDBData::HasAutoFilter ( ) const

inline

Definition at line 212 of file dbdata.hxx.

Referenced by oox::xls::WorksheetGlobals::finalizeWorksheetImport(), ScVbaWorksheet::getAutoFilterMode(), ScDocShell::GetDBData(), ScDocument::GetFilterSelCount(), ScHeaderControl::Paint(), XclExpTables::SaveTableXml(), ScDocument::SetDBCollection(), UpdateReference(), and ScTabViewShell::UseSubTotal().

◆ HasHeader()

bool ScDBData::HasHeader ( ) const

inline

Definition at line 136 of file dbdata.hxx.

Referenced by ScDocShell::GetDBData(), ScDocument::GetFilterEntries(), GetHeaderArea(), ScCompiler::HandleTableRef(), ScDocument::HasAutoFilter(), ScDbNameDlg::Init(), ScFilterOptionsMgr::Init(), ScTabPageSortFields::Init(), InvalidateTableColumnNames(), ScHeaderControl::Paint(), ScCompiler::ParseTableRefColumn(), RefreshTableColumnNames(), XclExpTables::SaveTableXml(), ScDBFunc::ToggleAutoFilter(), and ScGridWindow::UpdateAutoFilterFromMenu().

◆ HasImportParam()

bool ScDBData::HasImportParam ( ) const

Definition at line 519 of file dbdata.cxx.

References mpImportParam.

Referenced by ScDocShell::Execute(), and ScCellShell::GetDBState().

◆ HasImportSelection()

bool ScDBData::HasImportSelection ( ) const

inline

Definition at line 209 of file dbdata.hxx.

Referenced by ScDocShell::Execute(), ScCellShell::ExecuteDB(), ScCellShell::GetDBState(), ScDatabaseRangeObj::getPropertyValue(), and IMPL_LINK().

◆ HasQueryParam()

bool ScDBData::HasQueryParam ( ) const

Definition at line 524 of file dbdata.cxx.

References mpQueryParam.

Referenced by ScDocShell::Execute(), ScCellShell::ExecuteDB(), ScCellShell::GetDBState(), and ScDBDocFunc::Query().

◆ HasSortParam()

bool ScDBData::HasSortParam ( ) const

Definition at line 535 of file dbdata.cxx.

References mpSortParam.

Referenced by ScDocShell::Execute(), ScCellShell::ExecuteDB(), and ScCellShell::GetDBState().

◆ HasSubTotalParam()

bool ScDBData::HasSubTotalParam ( ) const

Definition at line 542 of file dbdata.cxx.

References mpSubTotal.

Referenced by ScDocShell::Execute(), ScCellShell::ExecuteDB(), and ScCellShell::GetDBState().

◆ HasTotals()

bool ScDBData::HasTotals ( ) const

inline

Definition at line 138 of file dbdata.hxx.

Referenced by ScCompiler::HandleTableRef(), ScDbNameDlg::Init(), and XclExpTables::SaveTableXml().

◆ InvalidateTableColumnNames()

void ScDBData::InvalidateTableColumnNames ( bool bSwapToEmptyNames )

private

Definition at line 750 of file dbdata.cxx.

References ScDBDataContainerBase::GetDirtyTableColumnNames(), GetHeaderArea(), HasHeader(), ScRangeList::Join(), maTableColumnNames, mbTableColumnNamesDirty, mpContainer, nStartCol, nStartRow, and nTable.

Referenced by AdjustTableColumnAttributes(), ExtendDataArea(), operator=(), and SetArea().

◆ IsDBAtArea()

bool ScDBData::IsDBAtArea	(	SCTAB	nTab,
		SCCOL	nCol1,
		SCROW	nRow1,
		SCCOL	nCol2,
		SCROW	nRow2
	)		const

Definition at line 512 of file dbdata.cxx.

References nEndCol, nEndRow, nStartCol, nStartRow, and nTable.

Referenced by ScDBCollection::GetDBAtArea().

◆ IsDBAtCursor()

bool ScDBData::IsDBAtCursor	(	SCCOL	nCol,
		SCROW	nRow,
		SCTAB	nTab,
		ScDBDataPortion	ePortion
	)		const

Definition at line 496 of file dbdata.cxx.

References AREA, nEndRow, nStartCol, nStartRow, nTable, and TOP_LEFT.

Referenced by ScDBCollection::GetDBAtCursor().

◆ IsDoSize()

bool ScDBData::IsDoSize ( ) const

inline

Definition at line 142 of file dbdata.hxx.

Referenced by ScDBDocFunc::DoImport(), ScDbNameDlg::Init(), ScDBDocFunc::Query(), ScDBFunc::RepeatDB(), and ScDBDocFunc::RepeatDB().

◆ IsKeepFmt()

bool ScDBData::IsKeepFmt ( ) const

inline

Definition at line 144 of file dbdata.hxx.

Referenced by ScDBDocFunc::DoImport(), ScDbNameDlg::Init(), and ScDBDocFunc::Query().

◆ IsModified()

bool ScDBData::IsModified ( ) const

inline

Definition at line 215 of file dbdata.hxx.

◆ IsStripData()

bool ScDBData::IsStripData ( ) const

inline

Definition at line 146 of file dbdata.hxx.

Referenced by ScDocShell::Execute(), and ScDbNameDlg::Init().

◆ MoveTo()

void ScDBData::MoveTo	(	SCTAB	nTab,
		SCCOL	nCol1,
		SCROW	nRow1,
		SCCOL	nCol2,
		SCROW	nRow2,
		SCCOL	nUpdateCol = `-1`
	)

Definition at line 344 of file dbdata.cxx.

References bByRow, ScQueryEntry::bDoQuery, ScQueryEntry::Clear(), i, MAXSUBTOTAL, mpQueryParam, mpSortParam, mpSubTotal, nCount, nEndCol, ScQueryEntry::nField, nStartCol, nStartRow, and SetArea().

Referenced by IMPL_LINK_NOARG(), and UpdateReference().

◆ Notify()

void ScDBData::Notify ( const SfxHint & rHint )

overridevirtual

Reimplemented from SvtListener.

Definition at line 928 of file dbdata.cxx.

References ScRange::aStart, ScRange::Contains(), ScDBDataContainerBase::GetDirtyTableColumnNames(), GetHeaderArea(), SfxHint::GetId(), ScHint::GetRowCount(), ScHint::GetStartAddress(), ScRange::IsValid(), ScRangeList::Join(), mbTableColumnNamesDirty, mpContainer, nStartRow, ScAddress::Row(), and ScAddress::SetRow().

◆ operator=()

ScDBData & ScDBData::operator= ( const ScDBData & rData )

Definition at line 159 of file dbdata.cxx.

References aAdvSource, bAutoFilter, bByRow, bDBSelection, bDoSize, bHasHeader, bHasTotals, bIsAdvanced, bKeepFmt, bStripData, EndTableColumnNamesListener(), InvalidateTableColumnNames(), maTableColumnNames, mbTableColumnNamesDirty, mpImportParam, mpQueryParam, mpSortParam, mpSubTotal, nEndCol, nEndRow, nFilteredRowCount, nIndex, nStartCol, nStartRow, nTable, ScRefreshTimer::operator=(), and StartTableColumnNamesListener().

◆ operator==() [1/2]

bool ScDBData::operator== ( const ScDBData & rData ) const

Definition at line 211 of file dbdata.cxx.

References aAdvSource, bDoSize, bIsAdvanced, bKeepFmt, bStripData, GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), and nTable.

◆ operator==() [2/2]

bool ScRefreshTimer::operator== ( const ScRefreshTimer & r ) const

private

Definition at line 52 of file refreshtimer.cxx.

◆ RefreshTableColumnNames() [1/2]

void ScDBData::RefreshTableColumnNames ( ScDocument * pDoc )

Refresh/update the column names with the header row's cell contents.

Definition at line 814 of file dbdata.cxx.

References ScHorizontalCellIterator::GetNext(), ScRefCellValue::getString(), HasHeader(), ScRefCellValue::hasString(), i, maTableColumnNames, mbTableColumnNamesDirty, n, nEndCol, nStartCol, nStartRow, nTable, and ScResId().

Referenced by XclExpTablesManager::Initialize(), and RefreshTableColumnNames().

◆ RefreshTableColumnNames() [2/2]

void ScDBData::RefreshTableColumnNames	(	ScDocument *	pDoc,
		const ScRange &	rRange
	)

Refresh/update the column names with the header row's cell contents within the given range.

Definition at line 882 of file dbdata.cxx.

References GetHeaderArea(), HasHeader(), ScRange::IsValid(), maTableColumnNames, mbTableColumnNamesDirty, and RefreshTableColumnNames().

◆ SetAdvancedQuerySource()

void ScDBData::SetAdvancedQuerySource ( const ScRange * pSource )

Definition at line 446 of file dbdata.cxx.

References aAdvSource, and bIsAdvanced.

Referenced by XclImpAutoFilterData::Apply(), XclImpAutoFilterData::InsertQueryParam(), ScDBDocFunc::Query(), ScDatabaseRangeObj::setPropertyValue(), and UpdateReference().

◆ SetArea()

void ScDBData::SetArea	(	SCTAB	nTab,
		SCCOL	nCol1,
		SCROW	nRow1,
		SCCOL	nCol2,
		SCROW	nRow2
	)

Definition at line 322 of file dbdata.cxx.

References EndTableColumnNamesListener(), InvalidateTableColumnNames(), maTableColumnNames, nEndCol, nEndRow, nStartCol, nStartRow, nTable, SAL_WARN_IF, and StartTableColumnNamesListener().

Referenced by ScDBFuncUndo::BeginRedo(), ScDocShell::DoConsolidate(), ScDBDocFunc::DoImport(), ScDBFunc::DoSubTotals(), ScDBDocFunc::DoSubTotals(), ScDocShell::GetDBData(), lcl_GetSortParam(), MoveTo(), ScDBDocFunc::Query(), ScDatabaseRangeObj::setDataArea(), and UpdateMoveTab().

◆ SetAutoFilter()

void ScDBData::SetAutoFilter ( bool bSet )

inline

Definition at line 213 of file dbdata.hxx.

Referenced by ScDBFunc::ApplyAutoFilter(), ScDBFuncUndo::BeginRedo(), ScUndoAutoFilter::DoChange(), ScDocShell::GetDBData(), ScDBFunc::HideAutoFilter(), XclImpAutoFilterData::InsertQueryParam(), ScVbaWorksheet::setAutoFilterMode(), ScDatabaseRangeObj::setPropertyValue(), and ScDBFunc::ToggleAutoFilter().

◆ SetByRow()

void ScDBData::SetByRow ( bool bByR )

inline

Definition at line 135 of file dbdata.hxx.

Referenced by ScDBFuncUndo::BeginRedo(), ScDBDocFunc::DoImport(), ScDocShell::GetDBData(), IMPL_LINK_NOARG(), and ScDBFunc::ToggleAutoFilter().

◆ SetContainer()

void ScDBData::SetContainer ( ScDBDataContainerBase * pContainer )

inline

Definition at line 149 of file dbdata.hxx.

◆ SetDoSize()

void ScDBData::SetDoSize ( bool bSet )

inline

Definition at line 143 of file dbdata.hxx.

Referenced by IMPL_LINK_NOARG(), and ScDatabaseRangeObj::setPropertyValue().

◆ SetHeader()

void ScDBData::SetHeader ( bool bHasH )

inline

Definition at line 137 of file dbdata.hxx.

Referenced by ScDocShell::DoConsolidate(), ScDBDocFunc::DoImport(), ScDocShell::GetDBData(), IMPL_LINK_NOARG(), ScDBDocFunc::Query(), ScDatabaseRangeObj::setPropertyValue(), ScDatabaseRangeObj::SetQueryParam(), and ScDBFunc::ToggleAutoFilter().

◆ SetImportParam()

void ScDBData::SetImportParam ( const ScImportParam & rImportParam )

Definition at line 490 of file dbdata.cxx.

References mpImportParam.

Referenced by ScDBDocFunc::DoImport(), ScDocShell::Execute(), and ScCellShell::ExecuteDB().

◆ SetImportSelection()

void ScDBData::SetImportSelection ( bool bSet )

inline

Definition at line 210 of file dbdata.hxx.

Referenced by ScDBDocFunc::DoImport(), and ScDatabaseRangeObj::setPropertyValue().

◆ SetIndex()

void ScDBData::SetIndex ( sal_uInt16 nInd )

inline

Definition at line 140 of file dbdata.hxx.

References nIndex.

◆ SetKeepFmt()

void ScDBData::SetKeepFmt ( bool bSet )

inline

Definition at line 145 of file dbdata.hxx.

Referenced by IMPL_LINK_NOARG(), and ScDatabaseRangeObj::setPropertyValue().

◆ SetModified()

void ScDBData::SetModified ( bool bMod )

inline

Definition at line 216 of file dbdata.hxx.

Referenced by UpdateMoveTab(), and UpdateReference().

◆ SetQueryParam()

void ScDBData::SetQueryParam ( const ScQueryParam & rQueryParam )

Definition at line 437 of file dbdata.cxx.

References bIsAdvanced, and mpQueryParam.

Referenced by XclImpAutoFilterData::Apply(), ScDBFuncUndo::BeginRedo(), ScDocShell::GetDBData(), XclImpAutoFilterData::InsertQueryParam(), ScDBDocFunc::Query(), ScDatabaseRangeObj::SetQueryParam(), and ScGridWindow::UpdateAutoFilterFromMenu().

◆ SetSortParam()

void ScDBData::SetSortParam ( const ScSortParam & rSortParam )

Definition at line 413 of file dbdata.cxx.

References bByRow, ScSortParam::bByRow, and mpSortParam.

Referenced by ScDBFuncUndo::BeginRedo(), oox::xls::AutoFilter::finalizeImport(), ScDocShell::GetDBData(), and ScDBDocFunc::Sort().

◆ SetStripData()

void ScDBData::SetStripData ( bool bSet )

inline

Definition at line 147 of file dbdata.hxx.

Referenced by IMPL_LINK_NOARG(), and ScDatabaseRangeObj::setPropertyValue().

◆ SetSubTotalParam()

void ScDBData::SetSubTotalParam ( const ScSubTotalParam & rSubTotalParam )

Definition at line 475 of file dbdata.cxx.

References mpSubTotal.

Referenced by ScDBFuncUndo::BeginRedo(), ScDBFunc::DoSubTotals(), ScDBDocFunc::DoSubTotals(), ScDocShell::GetDBData(), and ScDatabaseRangeObj::SetSubTotalParam().

◆ SetTableColumnAttributes()

void ScDBData::SetTableColumnAttributes ( ::std::vector< TableColumnAttributes > && rAttributes )

Definition at line 689 of file dbdata.cxx.

References maTableColumnAttributes.

Referenced by oox::xls::TableColumns::finalizeImport().

◆ SetTableColumnNames()

void ScDBData::SetTableColumnNames ( ::std::vector< OUString > && rNames )

Definition at line 683 of file dbdata.cxx.

References maTableColumnNames, and mbTableColumnNamesDirty.

Referenced by oox::xls::TableColumns::finalizeImport().

◆ SetTotals()

void ScDBData::SetTotals ( bool bTotals )

inline

Definition at line 139 of file dbdata.hxx.

Referenced by IMPL_LINK_NOARG(), and ScDatabaseRangeObj::setPropertyValue().

◆ StartTableColumnNamesListener()

void ScDBData::StartTableColumnNamesListener ( )

Definition at line 668 of file dbdata.cxx.

References bHasHeader, ScDBDataContainerBase::GetDocument(), GetHeaderArea(), ScDocument::IsClipOrUndo(), mpContainer, and ScDocument::StartListeningArea().

Referenced by operator=(), and SetArea().

◆ UpdateFromSortParam()

void ScDBData::UpdateFromSortParam ( const ScSortParam & rSortParam )

Remember some more settings of ScSortParam, only to be called at anonymous DB ranges as it at least overwrites bHasHeader.

Definition at line 419 of file dbdata.cxx.

References bHasHeader, and ScSortParam::bHasHeader.

Referenced by ScDBDocFunc::Sort().

◆ UpdateMoveTab()

void ScDBData::UpdateMoveTab	(	SCTAB	nOldPos,
		SCTAB	nNewPos
	)

Definition at line 547 of file dbdata.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), GetArea(), maTableColumnNames, mbTableColumnNamesDirty, ScAddress::Row(), SetArea(), SetModified(), and ScAddress::Tab().

◆ UpdateReference()

bool ScDBData::UpdateReference	(	const ScDocument *	pDoc,
		UpdateRefMode	eUpdateRefMode,
		SCCOL	nCol1,
		SCROW	nRow1,
		SCTAB	nTab1,
		SCCOL	nCol2,
		SCROW	nRow2,
		SCTAB	nTab2,
		SCCOL	nDx,
		SCROW	nDy,
		SCTAB	nDz
	)

Definition at line 588 of file dbdata.cxx.

References AdjustTableColumnAttributes(), ScRange::aEnd, ScRange::aStart, GetAdvancedQuerySource(), GetArea(), ScRange::GetVars(), HasAutoFilter(), maTableColumnNames, mbTableColumnNamesDirty, MoveTo(), ScAddress::Set(), SetAdvancedQuerySource(), SetModified(), ScRefUpdate::Update(), UR_INVALID, and UR_NOTHING.

Member Data Documentation

◆ aAdvSource

ScRange ScDBData::aAdvSource

private

source range

Definition at line 92 of file dbdata.hxx.

Referenced by GetAdvancedQuerySource(), operator=(), operator==(), and SetAdvancedQuerySource().

◆ aName

const OUString ScDBData::aName

private

DBParam.

Definition at line 76 of file dbdata.hxx.

◆ aUpper

OUString ScDBData::aUpper

private

Definition at line 77 of file dbdata.hxx.

Referenced by ScDBData().

◆ bAutoFilter

bool ScDBData::bAutoFilter

private

AutoFilter? (not saved)

Definition at line 97 of file dbdata.hxx.

Referenced by operator=().

◆ bByRow

bool ScDBData::bByRow

private

Definition at line 83 of file dbdata.hxx.

Referenced by GetQueryParam(), GetSortParam(), MoveTo(), operator=(), and SetSortParam().

◆ bDBSelection

bool ScDBData::bDBSelection

private

not in Param: if selection, block update

Definition at line 94 of file dbdata.hxx.

Referenced by operator=().

◆ bDoSize

bool ScDBData::bDoSize

private

Definition at line 86 of file dbdata.hxx.

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

◆ bHasHeader

bool ScDBData::bHasHeader

private

Definition at line 84 of file dbdata.hxx.

Referenced by CalcSaveFilteredCount(), GetFilterSelCount(), GetQueryParam(), GetSortParam(), operator=(), StartTableColumnNamesListener(), and UpdateFromSortParam().

◆ bHasTotals

bool ScDBData::bHasTotals

private

Definition at line 85 of file dbdata.hxx.

Referenced by operator=().

◆ bIsAdvanced

bool ScDBData::bIsAdvanced

private

QueryParam.

true if created by advanced filter

Definition at line 91 of file dbdata.hxx.

Referenced by GetAdvancedQuerySource(), operator=(), operator==(), SetAdvancedQuerySource(), and SetQueryParam().

◆ bKeepFmt

bool ScDBData::bKeepFmt

private

Definition at line 87 of file dbdata.hxx.

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

◆ bModified

bool ScDBData::bModified

private

is set/cleared for/by(?) UpdateReference

Definition at line 98 of file dbdata.hxx.

◆ bStripData

bool ScDBData::bStripData

private

Definition at line 88 of file dbdata.hxx.

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

◆ maTableColumnAttributes

::std::vector< TableColumnAttributes > ScDBData::maTableColumnAttributes

private

attributes of table columns

Definition at line 101 of file dbdata.hxx.

Referenced by AdjustTableColumnAttributes(), and SetTableColumnAttributes().

◆ maTableColumnNames

::std::vector< OUString > ScDBData::maTableColumnNames

private

names of table columns

Definition at line 100 of file dbdata.hxx.

Referenced by AdjustTableColumnAttributes(), ExtendDataArea(), GetColumnNameOffset(), GetTableColumnName(), InvalidateTableColumnNames(), operator=(), RefreshTableColumnNames(), SetArea(), SetTableColumnNames(), UpdateMoveTab(), and UpdateReference().

◆ mbTableColumnNamesDirty

bool ScDBData::mbTableColumnNamesDirty

private

Definition at line 102 of file dbdata.hxx.

Referenced by AdjustTableColumnAttributes(), InvalidateTableColumnNames(), Notify(), operator=(), RefreshTableColumnNames(), SetTableColumnNames(), UpdateMoveTab(), and UpdateReference().

◆ mpContainer

ScDBDataContainerBase* ScDBData::mpContainer

private

Definition at line 73 of file dbdata.hxx.

Referenced by InvalidateTableColumnNames(), Notify(), and StartTableColumnNamesListener().

◆ mpImportParam

std::unique_ptr<ScImportParam> ScDBData::mpImportParam

private

Definition at line 71 of file dbdata.hxx.

Referenced by GetImportParam(), GetSourceString(), HasImportParam(), operator=(), and SetImportParam().

◆ mpQueryParam

std::unique_ptr<ScQueryParam> ScDBData::mpQueryParam

private

Definition at line 69 of file dbdata.hxx.

Referenced by GetOperations(), GetQueryParam(), HasQueryParam(), MoveTo(), operator=(), and SetQueryParam().

◆ mpSortParam

std::unique_ptr<ScSortParam> ScDBData::mpSortParam

private

Definition at line 68 of file dbdata.hxx.

Referenced by GetOperations(), GetSortParam(), HasSortParam(), MoveTo(), operator=(), and SetSortParam().

◆ mpSubTotal

std::unique_ptr<ScSubTotalParam> ScDBData::mpSubTotal

private

Definition at line 70 of file dbdata.hxx.

Referenced by GetOperations(), GetSubTotalParam(), HasSubTotalParam(), MoveTo(), operator=(), and SetSubTotalParam().

◆ nEndCol

SCCOL ScDBData::nEndCol

private

Definition at line 81 of file dbdata.hxx.

Referenced by ExtendDataArea(), GetArea(), GetHeaderArea(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), IsDBAtArea(), MoveTo(), operator=(), RefreshTableColumnNames(), and SetArea().

◆ nEndRow

SCROW ScDBData::nEndRow

private

Definition at line 82 of file dbdata.hxx.

Referenced by CalcSaveFilteredCount(), ExtendDataArea(), GetArea(), GetFilterSelCount(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), IsDBAtArea(), IsDBAtCursor(), operator=(), and SetArea().

◆ nFilteredRowCount

SCSIZE ScDBData::nFilteredRowCount

private

Definition at line 103 of file dbdata.hxx.

Referenced by CalcSaveFilteredCount(), GetFilterSelCount(), and operator=().

◆ nIndex

sal_uInt16 ScDBData::nIndex

private

unique index formulas

Definition at line 96 of file dbdata.hxx.

Referenced by operator=().

◆ nStartCol

SCCOL ScDBData::nStartCol

private

Definition at line 79 of file dbdata.hxx.

Referenced by ExtendDataArea(), GetArea(), GetHeaderArea(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), GetTableColumnName(), InvalidateTableColumnNames(), IsDBAtArea(), IsDBAtCursor(), MoveTo(), operator=(), RefreshTableColumnNames(), and SetArea().

◆ nStartRow

SCROW ScDBData::nStartRow

private

Definition at line 80 of file dbdata.hxx.

Referenced by CalcSaveFilteredCount(), ExtendDataArea(), GetArea(), GetFilterSelCount(), GetHeaderArea(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), InvalidateTableColumnNames(), IsDBAtArea(), IsDBAtCursor(), MoveTo(), Notify(), operator=(), RefreshTableColumnNames(), and SetArea().

◆ nTable

SCTAB ScDBData::nTable

private

Definition at line 78 of file dbdata.hxx.

Referenced by ExtendDataArea(), GetArea(), GetHeaderArea(), GetQueryParam(), InvalidateTableColumnNames(), IsDBAtArea(), IsDBAtCursor(), operator=(), operator==(), RefreshTableColumnNames(), and SetArea().

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

Classes

Public Member Functions

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ ScDBData() [1/3]

◆ ScDBData() [2/3]

◆ ScDBData() [3/3]

◆ ~ScDBData()

Member Function Documentation

◆ AdjustTableColumnAttributes()

◆ AreTableColumnNamesDirty()

◆ CalcSaveFilteredCount()

◆ EndTableColumnNamesListener()

◆ ExtendDataArea()

◆ GetAdvancedQuerySource()

◆ GetArea() [1/2]

◆ GetArea() [2/2]

◆ GetColumnNameOffset()

◆ GetFilterSelCount()

◆ GetHeaderArea()

◆ GetImportParam()

◆ GetIndex()

◆ GetName()

◆ GetOperations()

◆ GetQueryParam()

◆ GetSortParam()

◆ GetSourceString()

◆ GetSubTotalParam()

◆ GetTab()

◆ GetTableColumnAttributes()

◆ GetTableColumnName()

◆ GetTableColumnNames()

◆ GetUpperName()

◆ HasAutoFilter()

◆ HasHeader()

◆ HasImportParam()

◆ HasImportSelection()

◆ HasQueryParam()

◆ HasSortParam()

◆ HasSubTotalParam()

◆ HasTotals()

◆ InvalidateTableColumnNames()

◆ IsDBAtArea()

◆ IsDBAtCursor()

◆ IsDoSize()

◆ IsKeepFmt()

◆ IsModified()

◆ IsStripData()

◆ MoveTo()

◆ Notify()

◆ operator=()

◆ operator==() [1/2]

◆ operator==() [2/2]

◆ RefreshTableColumnNames() [1/2]

◆ RefreshTableColumnNames() [2/2]

◆ SetAdvancedQuerySource()

◆ SetArea()

◆ SetAutoFilter()

◆ SetByRow()

◆ SetContainer()

◆ SetDoSize()

◆ SetHeader()

◆ SetImportParam()

◆ SetImportSelection()

◆ SetIndex()

◆ SetKeepFmt()

◆ SetModified()

◆ SetQueryParam()

◆ SetSortParam()

◆ SetStripData()

◆ SetSubTotalParam()

◆ SetTableColumnAttributes()

◆ SetTableColumnNames()

◆ SetTotals()

◆ StartTableColumnNamesListener()

◆ UpdateFromSortParam()

◆ UpdateMoveTab()