LibreOffice Module sc (master): ScDBDocFunc Class Reference

LibreOffice Module sc (master) 1

#include <dbdocfun.hxx>

Collaboration diagram for ScDBDocFunc:

Public Member Functions
	ScDBDocFunc (ScDocShell &rDocSh)

void	UpdateImport (const OUString &rTarget, const svx::ODataAccessDescriptor &rDescriptor)

bool	DoImport (SCTAB nTab, const ScImportParam &rParam, const svx::ODataAccessDescriptor *pDescriptor)

void	DoImportUno (const ScAddress &rPos, const css::uno::Sequence< css::beans::PropertyValue > &aArgs)

SC_DLLPUBLIC bool	Sort (SCTAB nTab, const ScSortParam &rSortParam, bool bRecord, bool bPaint, bool bApi)

SC_DLLPUBLIC bool	Query (SCTAB nTab, const ScQueryParam &rQueryParam, const ScRange *pAdvSource, bool bRecord, bool bApi)

void	DoSubTotals (SCTAB nTab, const ScSubTotalParam &rParam, bool bRecord, bool bApi)

bool	AddDBRange (const OUString &rName, const ScRange &rRange)

bool	DeleteDBRange (const OUString &rName)

bool	RenameDBRange (const OUString &rOld, const OUString &rNew)

void	ModifyDBData (const ScDBData &rNewData)

void	ModifyAllDBData (const ScDBCollection &rNewColl, const std::vector< ScRange > &rDelAreaList)

bool	RepeatDB (const OUString &rDBName, bool bApi, bool bIsUnnamed, SCTAB aTab=0)

bool	DataPilotUpdate (ScDPObject pOldObj, const ScDPObject pNewObj, bool bRecord, bool bApi, bool bAllowMove=false)

bool	RemovePivotTable (const ScDPObject &rDPObj, bool bRecord, bool bApi)

bool	CreatePivotTable (const ScDPObject &rDPObj, bool bRecord, bool bApi)

bool	UpdatePivotTable (ScDPObject &rDPObj, bool bRecord, bool bApi)

void	RefreshPivotTables (const ScDPObject *pDPObj, bool bApi)
	Reload the referenced pivot cache, and refresh all pivot tables that reference the cache. More...

void	RefreshPivotTableGroups (ScDPObject *pDPObj)
	Refresh the group dimensions of all pivot tables referencing the same cache. More...

Static Public Member Functions
static void	ShowInBeamer (const ScImportParam &rParam, const SfxViewFrame *pFrame)

Private Attributes
ScDocShell &	rDocShell

Friends
class	ScDBFunc

Detailed Description

Definition at line 43 of file dbdocfun.hxx.

Constructor & Destructor Documentation

◆ ScDBDocFunc()

ScDBDocFunc::ScDBDocFunc ( ScDocShell & rDocSh )

inline

Definition at line 51 of file dbdocfun.hxx.

Member Function Documentation

◆ AddDBRange()

bool ScDBDocFunc::AddDBRange	(	const OUString &	rName,
		const ScRange &	rRange
	)

◆ CreatePivotTable()

bool ScDBDocFunc::CreatePivotTable	(	const ScDPObject &	rDPObj,
		bool	bRecord,
		bool	bApi
	)

like above (not editable)

only necessary parts

Definition at line 1481 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ScRange::aEnd, ScRange::aStart, ScDocument::BroadcastUno(), ScAddress::Col(), Application::CreateMessageDialog(), ScDPCollection::CreateNewName(), ScDocShell::ErrorMessage(), ScDocShell::GetActiveDialogParent(), ScDPCollection::GetByName(), ScDocShell::GetDocument(), ScDocument::GetDPCollection(), ScEditableTester::GetMessageId(), ScDPObject::GetName(), ScDPObject::GetNewOutputRange(), ScDPObject::GetOutRange(), ScDPCollection::GetReferenceGroups(), ScDPObject::GetSaveData(), ScDocShell::GetUndoManager(), ScDPCollection::InsertNewTable(), ScDPObject::InvalidateData(), ScDocument::IsBlockEmpty(), ScEditableTester::IsEditable(), ScDocument::IsUndoEnabled(), ScDPObject::Output(), ScDocShell::PostPaintGridAll(), rDocShell, ScDPObject::ReloadGroupTableData(), RET_NO, RET_YES, ScAddress::Row(), ScResId(), ScDPSaveData::SetDimensionData(), ScDocShellModificator::SetDocumentModified(), ScDPObject::SetName(), ScDPObject::SyncAllDimensionMembers(), and ScAddress::Tab().

Referenced by DataPilotUpdate(), and ScDataPilotTablesObj::insertNewByName().

◆ DataPilotUpdate()

bool ScDBDocFunc::DataPilotUpdate	(	ScDPObject *	pOldObj,
		const ScDPObject *	pNewObj,
		bool	bRecord,
		bool	bApi,
		bool	bAllowMove = `false`
	)

like above (not editable)

only necessary parts

Definition at line 1297 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ScRange::aStart, ScDocument::BroadcastUno(), Application::CreateMessageDialog(), ScDPCollection::CreateNewName(), CreatePivotTable(), ScDocShell::GetActiveDialogParent(), ScDocShell::GetDocument(), ScDocument::GetDPCollection(), ScDPObject::GetName(), ScDPObject::GetOutRange(), ScDPObject::GetSaveData(), ScDocShell::GetUndoManager(), ScDPObject::InvalidateData(), ScDocument::IsUndoEnabled(), ScDPObject::Output(), pData, ScDocShell::PostPaintGridAll(), ScRangeList::push_back(), rDocShell, ScDPObject::ReloadGroupTableData(), RemovePivotTable(), RET_NO, RET_YES, ScResId(), ScDPObject::SetAllowMove(), ScDocShellModificator::SetDocumentModified(), ScDPObject::SetName(), ScDPObject::SetSaveData(), ScDPObject::SyncAllDimensionMembers(), UpdatePivotTable(), and ScDPObject::WriteSourceDataTo().

Referenced by ScDBFunc::DataPilotMove(), ScDBFunc::DataPilotSort(), ScGridWindow::DoPushPivotButton(), ScGridWindow::DoPushPivotToggle(), ScGridWindow::DPTestMouse(), ScPivotShell::Execute(), ScDBFunc::MakePivotTable(), ScGridWindow::MouseButtonUp(), ScUndoDataPilot::Redo(), ScDBFunc::SetDataPilotDetails(), and ScDataPilotTableObj::SetDPObject().

◆ DeleteDBRange()

bool ScDBDocFunc::DeleteDBRange ( const OUString & rName )

Definition at line 118 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ScDocument::CompileHybridFormula(), ScDBCollection::NamedDBs::end(), ScDBCollection::NamedDBs::erase(), ScDBCollection::NamedDBs::findByUpperName2(), ScGlobal::getCharClass(), ScDocument::GetDBCollection(), ScDocShell::GetDocument(), ScDBCollection::getNamedDBs(), ScDocShell::GetUndoManager(), ScDocument::IsUndoEnabled(), ScDocument::PreprocessDBDataUpdate(), rDocShell, ScDocShellModificator::SetDocumentModified(), and SfxGetpApp().

Referenced by ScDatabaseRangesObj::removeByName().

◆ DoImport()

bool ScDBDocFunc::DoImport	(	SCTAB	nTab,
		const ScImportParam &	rParam,
		const svx::ODataAccessDescriptor *	pDescriptor
	)

error message

Definition at line 121 of file dbdocimp.cxx.

References ScImportParam::aDBName, SfxUndoManager::AddUndoAction(), ALL, ScChangeTrack::AppendInsert(), ScImportParam::aStatement, ATTRIB, svx::BookmarkSelection, ScDocument::BroadcastUno(), ScImportParam::bSql, ScDocument::CanFitBlock(), CELLTYPE_FORMULA, ScDocument::CompileDBFormula(), CONTENTS, ScDocument::CopyToDocument(), createInstance(), Application::CreateMessageDialog(), svx::Cursor, ScDocument::DeleteArea(), ScDocument::DeleteAreaTab(), ScDocument::Fill(), FILL_SIMPLE, FILL_TO_BOTTOM, ScDocument::FitBlock(), ScDocShell::GetActiveDialogParent(), ScDocument::GetAutoCalc(), ScUnoHelpFunctions::GetBoolFromAny(), ScDocument::GetCellType(), ScDocument::GetChangeTrack(), ScDocument::GetDBAtArea(), ScDocShell::GetDocument(), ScDocument::GetDocumentShell(), ScPatternAttr::GetItemSet(), ScEditableTester::GetMessageId(), ScDocument::GetPattern(), comphelper::getProcessComponentContext(), comphelper::getProcessServiceFactory(), ScDocument::GetSheetLimits(), ScPatternAttr::GetStyleSheet(), ScDocShell::GetUndoManager(), Grid, ErrorHandler::HandleError(), svx::ODataAccessDescriptor::has(), i, ScDBData::IsDoSize(), ScEditableTester::IsEditable(), ScDBData::IsKeepFmt(), ScDocument::IsTabProtected(), ScDocument::IsUndoEnabled(), ScDocument::MaxCol(), ScDocument::MaxRow(), ScImportParam::nCol1, ScImportParam::nCol2, NOTE, ScImportParam::nRow1, ScImportParam::nRow2, ScImportParam::nType, nType, ScDocShell::PostPaint(), SfxItemSet::Put(), ScDatabaseDocUtil::PutData(), QUERY, rDocShell, SAL_WARN, SC_DBPROP_COMMAND, SC_DBPROP_COMMANDTYPE, SC_DBPROP_DATASOURCENAME, SC_SERVICE_ROWSET, ScDbQuery, SCDOCMODE_UNDO, ScResId(), SCWARN_IMPORT_RANGE_OVERFLOW, svx::Selection, ScMarkData::SelectOneTable(), ScDocument::SetAllFormulasDirty(), ScDBData::SetArea(), ScDocument::SetAutoCalc(), ScDBData::SetByRow(), ScDocShellModificator::SetDocumentModified(), ScDBData::SetHeader(), ScDBData::SetImportParam(), ScDBData::SetImportSelection(), ScProgress::SetState(), TABLE, ScEditableTester::TestBlock(), TOOLS_WARN_EXCEPTION, and ScDocument::ValidRow().

Referenced by ScCellRangeObj::doImport(), IMPL_LINK(), ScDBFunc::ImportData(), ScDatabaseRangeObj::refresh(), and UpdateImport().

◆ DoImportUno()

void ScDBDocFunc::DoImportUno	(	const ScAddress &	rPos,
		const css::uno::Sequence< css::beans::PropertyValue > &	aArgs
	)

Definition at line 108 of file dbdocimp.cxx.

References DBG_ASSERT, ScDocShell::GetDBData(), ScDBData::GetName(), Keep, rDocShell, SC_DB_IMPORT, and UpdateImport().

Referenced by ScDispatch::dispatch().

◆ DoSubTotals()

void ScDBDocFunc::DoSubTotals	(	SCTAB	nTab,
		const ScSubTotalParam &	rParam,
		bool	bRecord,
		bool	bApi
	)

use also for ScDBFunc::DoSubTotals !

Definition at line 1038 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ALL, ScSubTotalParam::bDoSort, ScSubTotalParam::bRemoveOnly, ScSubTotalParam::bReplace, ScDocument::CompileDBFormula(), ScDocument::CopyToDocument(), Application::CreateMessageDialog(), ScDocument::DoSubTotals(), ScDBCollection::empty(), ScRangeName::empty(), ScDocShell::ErrorMessage(), FORMULA, ScDocShell::GetActiveDialogParent(), ScOutlineTable::GetColArray(), ScDocument::GetDBAtArea(), ScDocument::GetDBCollection(), ScDocShell::GetDocument(), ScEditableTester::GetMessageId(), ScDocument::GetOutlineTable(), ScOutlineArray::GetRange(), ScDocument::GetRangeName(), ScOutlineTable::GetRowArray(), ScDBData::GetSortParam(), ScDocument::GetTableCount(), ScDocShell::GetUndoManager(), Grid, ScDocument::HasAttrib(), ScEditableTester::IsEditable(), ScDocument::IsUndoEnabled(), Left, ScDocument::MaxCol(), ScDocument::MaxRow(), Merged, ScSubTotalParam::nCol1, ScSubTotalParam::nCol2, NONE, ScSubTotalParam::nRow1, ScSubTotalParam::nRow2, Overlapped, ScDocShell::PostPaint(), pOut, rDocShell, ScDocument::RemoveSubTotals(), RET_YES, SCDOCMODE_UNDO, ScResId(), ScDBData::SetArea(), ScDocument::SetDirty(), ScDocShellModificator::SetDocumentModified(), ScDocument::SetDrawPageSize(), ScDBData::SetSubTotalParam(), Size, Sort(), ScDocument::TestRemoveSubTotals(), and Top.

Referenced by ScCellRangeObj::applySubTotals(), ScCellRangeObj::removeSubTotals(), and RepeatDB().

◆ ModifyAllDBData()

void ScDBDocFunc::ModifyAllDBData	(	const ScDBCollection &	rNewColl,
		const std::vector< ScRange > &	rDelAreaList
	)

◆ ModifyDBData()

void ScDBDocFunc::ModifyDBData ( const ScDBData & rNewData )

◆ Query()

bool ScDBDocFunc::Query	(	SCTAB	nTab,
		const ScQueryParam &	rQueryParam,
		const ScRange *	pAdvSource,
		bool	bRecord,
		bool	bApi
	)

Undo (Query and Repeat) !!!

???

Definition at line 678 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ScRange::aEnd, ALL, ScDocument::ApplyPatternAreaTab(), ScDocument::ApplyStyleAreaTab(), ScRange::aStart, ATTRIB, ScQueryParam::bDestPers, ScQueryEntry::bDoQuery, ScQueryParamBase::bDuplicate, ScDocument::BeginDrawUndo(), ScSubTotalParam::bGroupActive, ScQueryParamBase::bHasHeader, ScQueryParamBase::bInplace, ScSubTotalParam::bRemoveOnly, ScDBData::CalcSaveFilteredCount(), ScDocument::CanFitBlock(), CELLTYPE_FORMULA, ScAddress::Col(), ScDocument::CopyToDocument(), ScDocShell::DBAreaDeleted(), ScDocument::DeleteAreaTab(), ScDBCollection::empty(), ScDocShell::ErrorMessage(), ScDocument::Fill(), FILL_SIMPLE, FILL_TO_BOTTOM, ScDocument::FitBlock(), ForceMark, ScDocShell::GetActiveDialogParent(), ScDBData::GetArea(), ScDocShell::GetBestViewShell(), ScDocument::GetCellType(), ScDocument::GetDBAtArea(), ScDocument::GetDBAtCursor(), ScDocument::GetDBCollection(), ScDocShell::GetDBData(), ScDocShell::GetDocument(), ScDocument::GetDocumentShell(), ScQueryParamBase::GetEntry(), ScQueryParamBase::GetEntryCount(), ScEditableTester::GetMessageId(), ScDBData::GetQueryParam(), ScDocument::GetSheetLimits(), ScPatternAttr::GetStyleSheet(), ScDBData::GetSubTotalParam(), ScDocShell::GetUndoManager(), Grid, ScDBData::HasQueryParam(), i, ScDocument::InvalidatePageBreaks(), ScTabViewShell::isAnyEditViewInRange(), ScDBData::IsDoSize(), ScEditableTester::IsEditable(), ScDBData::IsKeepFmt(), ScDocument::IsUndoEnabled(), Left, ScDocument::MaxCol(), ScDocument::MaxRow(), ScQueryParam::MoveToDest(), ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, nCount, ScQueryParam::nDestCol, ScQueryParam::nDestRow, ScQueryParam::nDestTab, NONE, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, ScDBFunc::OnLOKShowHideColRow(), ScDocShell::PostPaint(), ScDocument::Query(), Query(), rDocShell, ScAddress::Row(), SC_DB_MAKE, SCDOCMODE_UNDO, ScResId(), ScMarkData::SelectOneTable(), ScDBData::SetAdvancedQuerySource(), ScDBData::SetArea(), ScAddress::SetCol(), ScDocShellModificator::SetDocumentModified(), ScDBData::SetHeader(), ScDBData::SetQueryParam(), ScAddress::SetRow(), ScDocument::SetSubTotalCellsDirty(), TOP_LEFT, ScDocument::UpdatePageBreaks(), and ScDocument::ValidColRow().

Referenced by ScCellRangeObj::filter(), ScDBFunc::Query(), Query(), and RepeatDB().

◆ RefreshPivotTableGroups()

void ScDBDocFunc::RefreshPivotTableGroups ( ScDPObject * pDPObj )

Refresh the group dimensions of all pivot tables referencing the same cache.

Definition at line 1684 of file dbdocfun.cxx.

References ScDocShell::GetDocument(), ScDocument::GetDPCollection(), ScDPSaveData::GetExistingDimensionData(), ScDPObject::GetSaveData(), ScDPCollection::HasTable(), rDocShell, ScDPCollection::ReloadGroupsInCache(), ScDPObject::ReloadGroupTableData(), ScDPSaveData::SetDimensionData(), and UpdatePivotTable().

Referenced by ScDataPilotFieldObj::createDateGroup(), ScDataPilotFieldObj::createNameGroup(), ScDBFunc::DateGroupDataPilot(), ScDBFunc::GroupDataPilot(), ScDBFunc::NumGroupDataPilot(), and ScDBFunc::UngroupDataPilot().

◆ RefreshPivotTables()

void ScDBDocFunc::RefreshPivotTables	(	const ScDPObject *	pDPObj,
		bool	bApi
	)

Reload the referenced pivot cache, and refresh all pivot tables that reference the cache.

Definition at line 1666 of file dbdocfun.cxx.

References ScDocShell::GetDocument(), ScDocument::GetDPCollection(), rDocShell, ScDPCollection::ReloadCache(), and UpdatePivotTable().

Referenced by ScDBFunc::RecalcPivotTable(), and ScDataPilotTableObj::refresh().

◆ RemovePivotTable()

bool ScDBDocFunc::RemovePivotTable	(	const ScDPObject &	rDPObj,
		bool	bRecord,
		bool	bApi
	)

only necessary parts

Definition at line 1399 of file dbdocfun.cxx.

References SdrModel::AddUndo(), SfxUndoManager::AddUndoAction(), ScRange::aEnd, ALL, ScRange::aStart, Auto, ScAddress::Col(), Application::CreateMessageDialog(), ScDocument::DeleteAreaTab(), ScDPCollection::FreeTable(), ScDocShell::GetActiveDialogParent(), sc::tools::getAllPivotChartsConnectedTo(), ScDocument::GetChartListenerCollection(), ScDocShell::GetDocument(), ScDocument::GetDPCollection(), ScDocument::GetDrawLayer(), ScDPObject::GetName(), ScDPObject::GetOutRange(), ScDocShell::GetUndoManager(), Grid, ScDocument::IsUndoEnabled(), ScDocShell::PostPaint(), ScDocShell::PostPaintGridAll(), rDocShell, ScChartListenerCollection::removeByName(), ScDocument::RemoveFlagsTab(), RET_NO, RET_YES, ScAddress::Row(), ScResId(), ScDocShellModificator::SetDocumentModified(), and ScAddress::Tab().

Referenced by ScPivotLayoutDialog::ApplyChanges(), DataPilotUpdate(), ScDBFunc::DeletePivotTable(), and ScDataPilotTablesObj::removeByName().

◆ RenameDBRange()

bool ScDBDocFunc::RenameDBRange	(	const OUString &	rOld,
		const OUString &	rNew
	)

◆ RepeatDB()

bool ScDBDocFunc::RepeatDB	(	const OUString &	rDBName,
		bool	bApi,
		bool	bIsUnnamed,
		SCTAB	aTab = `0`
	)

use also for ScDBFunc::RepeatDB !

Undo needed data only ?

Definition at line 283 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ALL, ScQueryEntry::bDoQuery, ScSubTotalParam::bGroupActive, ScQueryParamBase::bInplace, ScSubTotalParam::bRemoveOnly, ScDocument::CopyToDocument(), DoSubTotals(), ScDBCollection::empty(), ScRangeName::empty(), ScDocShell::ErrorMessage(), ScDBCollection::NamedDBs::findByUpperName(), FORMULA, ScDBData::GetAdvancedQuerySource(), ScDocument::GetAnonymousDBData(), ScDBData::GetArea(), ScGlobal::getCharClass(), ScOutlineTable::GetColArray(), ScDocument::GetDBAtCursor(), ScDocument::GetDBCollection(), ScDocShell::GetDocument(), ScQueryParamBase::GetEntry(), ScDBCollection::getNamedDBs(), ScDocument::GetOutlineTable(), ScDBData::GetQueryParam(), ScOutlineArray::GetRange(), ScDocument::GetRangeName(), ScOutlineTable::GetRowArray(), ScDBData::GetSortParam(), ScDBData::GetSubTotalParam(), ScDocument::GetTableCount(), ScDocShell::GetUndoManager(), Grid, ScDBData::IsDoSize(), ScDocument::IsUndoEnabled(), Left, ScSortParam::maKeyState, ScDocument::MaxCol(), ScDocument::MaxRow(), ScQueryParam::nDestCol, ScQueryParam::nDestRow, ScQueryParam::nDestTab, NONE, ScDocShell::PostPaint(), Query(), rDocShell, SCDOCMODE_UNDO, Size, Sort(), Top, and TOP_LEFT.

Referenced by IMPL_LINK(), and ScDatabaseRangeObj::refresh().

◆ ShowInBeamer()

void ScDBDocFunc::ShowInBeamer	(	const ScImportParam &	rParam,
		const SfxViewFrame *	pFrame
	)

static

Definition at line 72 of file dbdocimp.cxx.

References ScImportParam::aDBName, ScImportParam::aStatement, ScImportParam::bImport, ScImportParam::bSql, svx::Command, svx::CommandType, svx::ODataAccessDescriptor::createPropertyValueSequence(), SfxViewFrame::GetFrame(), SfxFrame::GetFrameInterface(), ScImportParam::nType, nType, QUERY, ScDbQuery, svx::ODataAccessDescriptor::setDataSource(), TABLE, xController, and xFrame.

Referenced by ScCellShell::ExecuteDB().

◆ Sort()

bool ScDBDocFunc::Sort	(	SCTAB	nTab,
		const ScSortParam &	rSortParam,
		bool	bRecord,
		bool	bPaint,
		bool	bApi
	)

Definition at line 466 of file dbdocfun.cxx.

References ScSortParam::aDataAreaExtras, SfxUndoManager::AddUndoAction(), ScDocShell::AdjustRowHeight(), ScDataAreaExtras::anyExtrasWanted(), ScSortParam::bByRow, ScQueryEntry::bDoQuery, ScSortParam::bHasHeader, ScSortParam::bInplace, ScDataAreaExtras::Col, ScDocShell::ErrorMessage(), ScDocShell::GetActiveDialogParent(), ScDBCollection::getAnonDBs(), ScDocument::GetAnonymousDBData(), ScDocShell::GetBestViewShell(), ScDocument::GetDBAtArea(), ScDocument::GetDBCollection(), ScDocShell::GetDocFunc(), SfxViewShell::GetDocId(), ScDocShell::GetDocument(), ScQueryParamBase::GetEntry(), SfxViewShell::GetFirst(), ScViewData::GetLOKHeightHelper(), ScEditableTester::GetMessageId(), SfxViewShell::GetNext(), ScDataAreaExtras::GetOverallRange(), ScDBData::GetQueryParam(), ScSortParam::GetSortKeyCount(), ScInputOptions::GetSortRefUpdate(), ScDocShell::GetUndoManager(), ScTabView::GetViewData(), Grid, ScDBCollection::AnonDBs::has(), ScDocument::HasAttrib(), ScDocument::HasHiddenRows(), ScDocument::HasUniformRowHeight(), comphelper::LibreOfficeKit::isActive(), ScEditableTester::IsEditable(), ScDocument::IsUndoEnabled(), Left, ScSortParam::maKeyState, ScDocument::MaxCol(), ScDataAreaExtras::mbCellFormats, Merged, ScDocFunc::MoveBlock(), ScSortParam::MoveToDest(), ScSortParam::nCol1, ScSortParam::nCol2, ScSortParam::nDestCol, ScSortParam::nDestRow, ScSortParam::nDestTab, ScTabViewShell::notifyAllViewsSheetGeomInvalidation(), ScSortParam::nRow1, ScSortParam::nRow2, Overlapped, ScDocShell::PostPaint(), rDocShell, ScDataAreaExtras::resetArea(), ScDataAreaExtras::Row, SC_MOD, ScResId(), ScDocument::SetDirty(), ScDocShellModificator::SetDocumentModified(), ScDataAreaExtras::SetOverallRange(), ScDBData::SetSortParam(), ScDocument::ShrinkToUsedDataArea(), ScDocument::Sort(), ScDBData::UpdateFromSortParam(), and ScDocument::UpdateScriptTypes().

Referenced by DoSubTotals(), RepeatDB(), ScCellRangeObj::sort(), and ScDBFunc::Sort().

◆ UpdateImport()

void ScDBDocFunc::UpdateImport	(	const OUString &	rTarget,
		const svx::ODataAccessDescriptor &	rDescriptor
	)

◆ UpdatePivotTable()

bool ScDBDocFunc::UpdatePivotTable	(	ScDPObject &	rDPObj,
		bool	bRecord,
		bool	bApi
	)

only necessary parts

Definition at line 1592 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ScRange::aStart, ScDocument::BroadcastUno(), Application::CreateMessageDialog(), ScDPCollection::CreateNewName(), ScDocShell::GetActiveDialogParent(), ScDocShell::GetDocument(), ScDocument::GetDPCollection(), ScDPObject::GetName(), ScDPObject::GetOutRange(), ScDocShell::GetUndoManager(), ScDPObject::InvalidateData(), ScDocument::IsUndoEnabled(), ScDPObject::Output(), ScDocShell::PostPaintGridAll(), rDocShell, ScDPObject::ReloadGroupTableData(), RET_NO, RET_YES, ScResId(), ScDPObject::SetAllowMove(), ScDocShellModificator::SetDocumentModified(), ScDPObject::SetName(), and ScDPObject::SyncAllDimensionMembers().

Referenced by ScDBFunc::DataPilotInput(), DataPilotUpdate(), RefreshPivotTableGroups(), RefreshPivotTables(), ScDocShell::RefreshPivotTables(), and ScGridWindow::UpdateDPFromFieldPopupMenu().

Friends And Related Function Documentation

◆ ScDBFunc

friend class ScDBFunc

friend

Definition at line 45 of file dbdocfun.hxx.

Member Data Documentation

◆ rDocShell

ScDocShell& ScDBDocFunc::rDocShell

private

Definition at line 48 of file dbdocfun.hxx.

Referenced by AddDBRange(), CreatePivotTable(), DataPilotUpdate(), DeleteDBRange(), DoImport(), DoImportUno(), DoSubTotals(), ModifyAllDBData(), ModifyDBData(), Query(), RefreshPivotTableGroups(), RefreshPivotTables(), RemovePivotTable(), RenameDBRange(), RepeatDB(), Sort(), UpdateImport(), and UpdatePivotTable().

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