LibreOffice Module sc (master)  1
Public Member Functions | Static Public Member Functions | Private Attributes | Friends | List of all members
ScDBDocFunc Class Reference

#include <dbdocfun.hxx>

Collaboration diagram for ScDBDocFunc:
[legend]

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

ScDocShellrDocShell
 

Friends

class ScDBFunc
 

Detailed Description

Definition at line 44 of file dbdocfun.hxx.

Constructor & Destructor Documentation

ScDBDocFunc::ScDBDocFunc ( ScDocShell rDocSh)
inline

Definition at line 52 of file dbdocfun.hxx.

Member Function Documentation

bool ScDBDocFunc::AddDBRange ( const OUString &  rName,
const ScRange rRange 
)
bool ScDBDocFunc::CreatePivotTable ( const ScDPObject rDPObj,
bool  bRecord,
bool  bApi 
)
bool ScDBDocFunc::DataPilotUpdate ( ScDPObject pOldObj,
const ScDPObject pNewObj,
bool  bRecord,
bool  bApi,
bool  bAllowMove = false 
)
bool ScDBDocFunc::DeleteDBRange ( const OUString &  rName)
bool ScDBDocFunc::DoImport ( SCTAB  nTab,
const ScImportParam rParam,
const svx::ODataAccessDescriptor pDescriptor 
)

error message

Definition at line 120 of file dbdocimp.cxx.

References ScImportParam::aDBName, 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(), ScDocument::GetDocumentShell(), SfxSetItem::GetItemSet(), ScEditableTester::GetMessageId(), ScDocument::GetPattern(), comphelper::getProcessComponentContext(), comphelper::getProcessServiceFactory(), ScDocument::GetSheetLimits(), ScPatternAttr::GetStyleSheet(), 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, nColCount, NOTE, ScImportParam::nRow1, ScImportParam::nRow2, nType, ScImportParam::nType, SfxItemSet::Put(), ScDatabaseDocUtil::PutData(), QUERY, 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(), ScDocument::ValidRow(), and xRow.

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

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

Definition at line 107 of file dbdocimp.cxx.

References DBG_ASSERT, ScDBData::GetName(), Keep, and SC_DB_IMPORT.

Referenced by ScDispatch::dispatch().

void ScDBDocFunc::DoSubTotals ( SCTAB  nTab,
const ScSubTotalParam rParam,
bool  bRecord,
bool  bApi 
)
void ScDBDocFunc::ModifyAllDBData ( const ScDBCollection rNewColl,
const std::vector< ScRange > &  rDelAreaList 
)
void ScDBDocFunc::ModifyDBData ( const ScDBData rNewData)
bool ScDBDocFunc::Query ( SCTAB  nTab,
const ScQueryParam rQueryParam,
const ScRange pAdvSource,
bool  bRecord,
bool  bApi 
)

Undo (Query and Repeat) !!!

???

Definition at line 624 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(), 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(), 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(), and RepeatDB().

void ScDBDocFunc::RefreshPivotTableGroups ( ScDPObject pDPObj)
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 1608 of file dbdocfun.cxx.

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

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

bool ScDBDocFunc::RemovePivotTable ( ScDPObject rDPObj,
bool  bRecord,
bool  bApi 
)
bool ScDBDocFunc::RenameDBRange ( const OUString &  rOld,
const OUString &  rNew 
)
bool ScDBDocFunc::RepeatDB ( const OUString &  rDBName,
bool  bApi,
bool  bIsUnnamed,
SCTAB  aTab = 0 
)
void ScDBDocFunc::ShowInBeamer ( const ScImportParam rParam,
const SfxViewFrame pFrame 
)
static
bool ScDBDocFunc::Sort ( SCTAB  nTab,
const ScSortParam rSortParam,
bool  bRecord,
bool  bPaint,
bool  bApi 
)

Definition at line 465 of file dbdocfun.cxx.

References SfxUndoManager::AddUndoAction(), ScDocShell::AdjustRowHeight(), ScSortParam::bByRow, ScQueryEntry::bDoQuery, ScSortParam::bHasHeader, ScSortParam::bIncludeComments, ScSortParam::bIncludeGraphicObjects, ScSortParam::bIncludePattern, ScSortParam::bInplace, ScDocShell::ErrorMessage(), ScDocShell::GetActiveDialogParent(), ScDBCollection::getAnonDBs(), ScDocument::GetAnonymousDBData(), ScDocument::GetDBAtArea(), ScDocument::GetDBCollection(), ScDocShell::GetDocFunc(), ScDocShell::GetDocument(), ScQueryParamBase::GetEntry(), ScEditableTester::GetMessageId(), ScDBData::GetQueryParam(), ScSortParam::GetSortKeyCount(), ScInputOptions::GetSortRefUpdate(), ScDocShell::GetUndoManager(), Grid, ScDBCollection::AnonDBs::has(), ScDocument::HasAttrib(), ScDocument::HasUniformRowHeight(), ScEditableTester::IsEditable(), ScDocument::IsUndoEnabled(), Left, ScSortParam::maKeyState, ScDocument::MaxCol(), Merged, ScDocFunc::MoveBlock(), ScSortParam::MoveToDest(), ScSortParam::nCol1, ScSortParam::nCol2, ScSortParam::nDestCol, ScSortParam::nDestRow, ScSortParam::nDestTab, ScSortParam::nRow1, ScSortParam::nRow2, Overlapped, ScDocShell::PostPaint(), rDocShell, SC_MOD, ScResId(), ScDocument::SetDirty(), ScDocShellModificator::SetDocumentModified(), ScDBData::SetSortParam(), ScDocument::ShrinkToUsedDataArea(), ScDocument::Sort(), ScDBData::UpdateFromSortParam(), and ScDocument::UpdateScriptTypes().

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

void ScDBDocFunc::UpdateImport ( const OUString &  rTarget,
const svx::ODataAccessDescriptor rDescriptor 
)
bool ScDBDocFunc::UpdatePivotTable ( ScDPObject rDPObj,
bool  bRecord,
bool  bApi 
)

Friends And Related Function Documentation

friend class ScDBFunc
friend

Definition at line 46 of file dbdocfun.hxx.

Member Data Documentation

ScDocShell& ScDBDocFunc::rDocShell
private

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