#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)

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 (const ::std::vector< OUString > &rNames)

SC_DLLPUBLIC const ::std::vector< OUString > &	GetTableColumnNames () 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...

const 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)

void	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 ()

	SvtListener (const SvtListener &r)

virtual	~SvtListener () COVERITY_NOEXCEPT_FALSE

bool	StartListening (SvtBroadcaster &rBroadcaster)

bool	EndListening (SvtBroadcaster &rBroadcaster)

void	EndListeningAll ()

void	CopyAllBroadcasters (const SvtListener &r)

bool	HasBroadcaster () const

virtual void	Query (QueryBase &rQuery) const

Public Member Functions inherited from ScRefreshTimer
	ScRefreshTimer ()

	ScRefreshTimer (sal_uLong 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_uLong	GetRefreshDelay () const

void	StopRefreshTimer ()

void	SetRefreshDelay (sal_uLong nSeconds)

virtual SC_DLLPUBLIC void	Invoke () override

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

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

	Timer (const Timer &rTimer)

virtual	~Timer () override

Timer &	operator= (const Timer &rTimer)

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 () 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

void	SetDebugName (const char *pDebugName)

const char *	GetDebugName () const

void	Stop ()

bool	IsActive () const

void	SetStatic ()

bool	IsStatic () const

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

void	InvalidateTableColumnNames (bool bSwapToEmptyNames)

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...

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

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

Detailed Description

Definition at line 60 of file dbdata.hxx.

Constructor & Destructor Documentation

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::getCharClassPtr(), and CharClass::uppercase().

ScDBData::ScDBData ( const ScDBData & rData )

Definition at line 90 of file dbdata.cxx.

References aName, and nIndex.

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

Definition at line 124 of file dbdata.cxx.

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

ScDBData::~ScDBData ( )

overridevirtual

Definition at line 253 of file dbdata.cxx.

References ScRefreshTimer::StopRefreshTimer().

Member Function Documentation

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

private

Definition at line 665 of file dbdata.cxx.

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

Referenced by UpdateReference().

bool ScDBData::AreTableColumnNamesDirty ( ) const

inline

Definition at line 149 of file dbdata.hxx.

Referenced by ScDBCollection::NamedDBs::initInserted().

void ScDBData::CalcSaveFilteredCount ( SCSIZE nNonFilteredRowCount )

Definition at line 926 of file dbdata.cxx.

References bHasHeader, nEndRow, nFilteredRowCount, and nStartRow.

Referenced by ScDBDocFunc::Query().

void ScDBData::EndTableColumnNamesListener ( )

Definition at line 654 of file dbdata.cxx.

References SvtListener::EndListeningAll().

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

void ScDBData::ExtendDataArea ( const ScDocument & rDoc )

Definition at line 625 of file dbdata.cxx.

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

Referenced by ScDocument::GetFilterEntries().

bool ScDBData::GetAdvancedQuerySource ( ScRange & rSource ) const

Definition at line 442 of file dbdata.cxx.

References aAdvSource, and bIsAdvanced.

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

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.

void ScDBData::GetArea ( ScRange & rRange ) const

Definition at line 309 of file dbdata.cxx.

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

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 868 of file dbdata.cxx.

References maTableColumnNames.

Referenced by ScCompiler::IsTableRefColumn().

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

Definition at line 934 of file dbdata.cxx.

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

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

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 ScDBCollection::NamedDBs::initInserted(), InvalidateTableColumnNames(), Notify(), RefreshTableColumnNames(), and StartTableColumnNamesListener().

void ScDBData::GetImportParam ( ScImportParam & rImportParam ) const

sal_uInt16 ScDBData::GetIndex ( ) const

inline

Definition at line 134 of file dbdata.hxx.

Referenced by ScDatabaseRangeObj::getPropertyValue(), ScCompiler::IsDBRange(), and sc::TokenStringContext::TokenStringContext().

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().

void ScDBData::GetQueryParam ( ScQueryParam & rQueryParam ) const

Definition at line 409 of file dbdata.cxx.

References ScQueryParamBase::bByRow, bByRow, ScQueryParamBase::bHasHeader, bHasHeader, mpQueryParam, ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, nEndCol, nEndRow, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, nStartCol, nStartRow, ScQueryParamTable::nTab, and nTable.

Referenced by ScCellRangeObj::createFilterDescriptor(), ScGridWindow::DrawButtons(), ExcAutoFilterRecs::ExcAutoFilterRecs(), ScCellShell::ExecuteDB(), ScCellShell::GetDBState(), ScDocument::GetFilterEntries(), ScDatabaseRangeObj::GetQueryParam(), ScDocument::HasAutoFilter(), ScGridWindow::IsAutoFilterActive(), ScGridWindow::LaunchAutoFilterMenu(), lcl_GetQueryParam(), operator==(), ScDBDocFunc::Query(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), ScDBDocFunc::Sort(), ScDBFunc::ToggleAutoFilter(), and ScGridWindow::UpdateAutoFilterFromMenu().

void ScDBData::GetSortParam ( ScSortParam & rSortParam ) const

OUString ScDBData::GetSourceString ( ) const

Definition at line 258 of file dbdata.cxx.

References aBuf, and mpImportParam.

Referenced by ScDbNameDlg::SetInfoStrings().

void ScDBData::GetSubTotalParam ( ScSubTotalParam & rSubTotalParam ) const

Definition at line 448 of file dbdata.cxx.

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

Referenced by ScCellRangeObj::createSubTotalDescriptor(), ScCellShell::ExecuteSubtotals(), ScDatabaseRangeObj::GetSubTotalParam(), operator==(), ScDBDocFunc::Query(), ScCellRangeObj::removeSubTotals(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), and ScDBFunc::UISort().

SCTAB ScDBData::GetTab ( ) const

inline

Definition at line 123 of file dbdata.hxx.

Referenced by ScDocShell::GetDBData().

const 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 881 of file dbdata.cxx.

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

Referenced by ScCompiler::CreateStringFromSingleRef().

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

inline

Definition at line 148 of file dbdata.hxx.

Referenced by XclExpTables::SaveTableXml().

const OUString& ScDBData::GetUpperName ( ) const

inline

Definition at line 122 of file dbdata.hxx.

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

bool ScDBData::HasAutoFilter ( ) const

inline

Definition at line 203 of file dbdata.hxx.

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

bool ScDBData::HasImportParam ( ) const

Definition at line 504 of file dbdata.cxx.

References mpImportParam.

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

bool ScDBData::HasImportSelection ( ) const

inline

Definition at line 200 of file dbdata.hxx.

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

bool ScDBData::HasQueryParam ( ) const

Definition at line 509 of file dbdata.cxx.

References mpQueryParam.

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

bool ScDBData::HasSortParam ( ) const

Definition at line 520 of file dbdata.cxx.

References mpSortParam.

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

bool ScDBData::HasSubTotalParam ( ) const

Definition at line 527 of file dbdata.cxx.

References mpSubTotal.

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

bool ScDBData::HasTotals ( ) const

inline

Definition at line 131 of file dbdata.hxx.

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

void ScDBData::InvalidateTableColumnNames ( bool bSwapToEmptyNames )

private

Definition at line 715 of file dbdata.cxx.

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

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

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

Definition at line 497 of file dbdata.cxx.

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

Referenced by ScDBCollection::GetDBAtArea().

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

Definition at line 481 of file dbdata.cxx.

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

Referenced by ScDBCollection::GetDBAtCursor().

bool ScDBData::IsDoSize ( ) const

inline

Definition at line 135 of file dbdata.hxx.

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

bool ScDBData::IsKeepFmt ( ) const

inline

Definition at line 137 of file dbdata.hxx.

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

bool ScDBData::IsModified ( ) const

inline

Definition at line 206 of file dbdata.hxx.

bool ScDBData::IsStripData ( ) const

inline

Definition at line 139 of file dbdata.hxx.

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

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

Definition at line 344 of file dbdata.cxx.

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

Referenced by IMPL_LINK_NOARG(), and UpdateReference().

void ScDBData::Notify ( const SfxHint & rHint )

overridevirtual

Reimplemented from SvtListener.

Definition at line 893 of file dbdata.cxx.

References assert(), ScHint::GetAddress(), ScDBDataContainerBase::GetDirtyTableColumnNames(), GetHeaderArea(), SfxHint::GetId(), ScRange::In(), ScRange::IsValid(), ScRangeList::Join(), mbTableColumnNamesDirty, and mpContainer.

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().

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.

void ScDBData::RefreshTableColumnNames ( ScDocument * pDoc )

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

Definition at line 779 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(), ScDBCollection::NamedDBs::initInserted(), and RefreshTableColumnNames().

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 847 of file dbdata.cxx.

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

void ScDBData::SetAdvancedQuerySource ( const ScRange * pSource )

Definition at line 431 of file dbdata.cxx.

References aAdvSource, and bIsAdvanced.

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

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().

void ScDBData::SetAutoFilter ( bool bSet )

inline

Definition at line 204 of file dbdata.hxx.

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

void ScDBData::SetByRow ( bool bByR )

inline

Definition at line 128 of file dbdata.hxx.

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

void ScDBData::SetContainer ( ScDBDataContainerBase * pContainer )

inline

Definition at line 142 of file dbdata.hxx.

Referenced by ScDBCollection::NamedDBs::initInserted().

void ScDBData::SetDoSize ( bool bSet )

inline

Definition at line 136 of file dbdata.hxx.

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

void ScDBData::SetHeader ( bool bHasH )

inline

Definition at line 130 of file dbdata.hxx.

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

void ScDBData::SetImportParam ( const ScImportParam & rImportParam )

Definition at line 475 of file dbdata.cxx.

References mpImportParam.

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

void ScDBData::SetImportSelection ( bool bSet )

inline

Definition at line 201 of file dbdata.hxx.

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

void ScDBData::SetIndex ( sal_uInt16 nInd )

inline

Definition at line 133 of file dbdata.hxx.

void ScDBData::SetKeepFmt ( bool bSet )

inline

Definition at line 138 of file dbdata.hxx.

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

void ScDBData::SetModified ( bool bMod )

inline

Definition at line 207 of file dbdata.hxx.

Referenced by UpdateMoveTab(), and UpdateReference().

void ScDBData::SetQueryParam ( const ScQueryParam & rQueryParam )

Definition at line 422 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().

void ScDBData::SetSortParam ( const ScSortParam & rSortParam )

Definition at line 398 of file dbdata.cxx.

References ScSortParam::bByRow, bByRow, and mpSortParam.

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

void ScDBData::SetStripData ( bool bSet )

inline

Definition at line 140 of file dbdata.hxx.

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

void ScDBData::SetSubTotalParam ( const ScSubTotalParam & rSubTotalParam )

Definition at line 460 of file dbdata.cxx.

References mpSubTotal.

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

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

Definition at line 659 of file dbdata.cxx.

References maTableColumnNames, and mbTableColumnNamesDirty.

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

void ScDBData::SetTotals ( bool bTotals )

inline

Definition at line 132 of file dbdata.hxx.

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

void ScDBData::StartTableColumnNamesListener ( )

Definition at line 644 of file dbdata.cxx.

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

Referenced by ScDBCollection::NamedDBs::initInserted(), operator=(), and SetArea().

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 404 of file dbdata.cxx.

References ScSortParam::bHasHeader, and bHasHeader.

Referenced by ScDBDocFunc::Sort().

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

Definition at line 532 of file dbdata.cxx.

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

void 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
	)