LibreOffice Module sc (master)
1
|
#include <dbdata.hxx>
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) |
![]() | |
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 |
![]() | |
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 |
![]() | |
AutoTimer (const char *pDebugName=nullptr) | |
![]() | |
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 |
![]() | |
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 | |
![]() | |
virtual void | SetDeletionFlags () override |
virtual sal_uInt64 | UpdateMinPeriod (sal_uInt64 nTimeNow) const override |
Timer (bool bAuto, const char *pDebugName) | |
![]() | |
const ImplSchedulerData * | GetSchedulerData () const |
![]() | |
static void | StartTimer (sal_uInt64 nMS) |
Definition at line 60 of file dbdata.hxx.
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.
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().
|
overridevirtual |
Definition at line 253 of file dbdata.cxx.
References ScRefreshTimer::StopRefreshTimer().
|
private |
Definition at line 665 of file dbdata.cxx.
References i, InvalidateTableColumnNames(), maTableColumnNames, mbTableColumnNamesDirty, n, SAL_WARN_IF, and URM_INSDEL.
Referenced by UpdateReference().
|
inline |
Definition at line 149 of file dbdata.hxx.
Referenced by ScDBCollection::NamedDBs::initInserted().
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.
Referenced by ScDBFuncUndo::BeginRedo(), ScDocShell::CancelAutoDBRange(), ScCellRangeObj::createFilterDescriptor(), ScCellRangeObj::createSortDescriptor(), ScCellRangeObj::createSubTotalDescriptor(), ScUndoAutoFilter::DoChange(), ScDocShell::DoConsolidate(), ScGridWindow::DrawButtons(), ScDBFuncUndo::EndUndo(), ScDocShell::Execute(), ScCellShell::ExecuteDB(), ScCellShell::ExecuteSubtotals(), oox::xls::WorksheetGlobals::finalizeWorksheetImport(), ScAreaLink::FindExtRange(), ScDatabaseRangeObj::getDataArea(), ScDBFunc::GetDBData(), ScDocShell::GetDBData(), ScDBCollection::GetDBNearCursor(), ScDocument::GetFilterEntries(), ScDatabaseRangeObj::GetQueryParam(), ScDatabaseRangeObj::getReferredCells(), ScDatabaseRangeObj::getSortDescriptor(), ScDatabaseRangeObj::GetSubTotalParam(), ScDBFunc::GotoDBArea(), ScCompiler::HandleDbData(), ScCompiler::HandleTableRef(), ScDBFunc::HideAutoFilter(), IMPL_LINK(), ScDbNameDlg::Init(), XclExpTablesManager::Initialize(), ScCompiler::IsTableRefColumn(), lcl_GetDBAreaRange(), lcl_GetRange(), ScRangeUtil::MakeRangeFromName(), ScDBDocFunc::ModifyDBData(), ScAreaNameIterator::Next(), ScHeaderControl::Paint(), ScDBFunc::Query(), ScDBDocFunc::Query(), ScDatabaseRangeObj::refresh(), ScDocument::RefreshAutoFilter(), ScUndoImportData::Repeat(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), XclExpTables::SaveTableXml(), ScInterpreter::ScIndirect(), ScVbaWorksheet::setAutoFilterMode(), ScDocument::SetDBCollection(), ScDatabaseRangeObj::setPropertyValue(), ScDatabaseRangeObj::SetQueryParam(), ScDatabaseRangeObj::SetSubTotalParam(), ScDBFunc::ToggleAutoFilter(), ScUndoQuery::Undo(), ScGridWindow::UpdateAutoFilterFromMenu(), ScDbNameDlg::UpdateDBData(), ScDBDocFunc::UpdateImport(), UpdateMoveTab(), UpdateReference(), ScTabViewShell::UseSubTotal(), and sc::ScDBDataManager::WriteToDoc().
sal_Int32 ScDBData::GetColumnNameOffset | ( | const OUString & | rName | ) | const |
Finds the column named rName and returns the corresponding offset within the table.
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().
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 |
Definition at line 465 of file dbdata.cxx.
References mpImportParam, ScImportParam::nCol1, ScImportParam::nCol2, nEndCol, nEndRow, ScImportParam::nRow1, ScImportParam::nRow2, nStartCol, and nStartRow.
Referenced by ScDispatch::addStatusListener(), ScCellRangeObj::createImportDescriptor(), ScDocShell::Execute(), ScCellShell::ExecuteDB(), ScDatabaseRangeObj::getImportDescriptor(), IMPL_LINK(), ScDatabaseRangeObj::Notify(), operator==(), ScDatabaseRangeObj::refresh(), ScDispatch::selectionChanged(), and ScDBDocFunc::UpdateImport().
|
inline |
Definition at line 134 of file dbdata.hxx.
Referenced by ScDatabaseRangeObj::getPropertyValue(), ScCompiler::IsDBRange(), and sc::TokenStringContext::TokenStringContext().
|
inline |
Definition at line 121 of file dbdata.hxx.
Referenced by ScCompiler::CreateStringFromIndex(), ScDBDocFunc::DoImportUno(), ScDocShell::Execute(), ScDocShell::GetDBData(), sc::ExternalDataSource::getDBName(), ScUndoUtil::GetOldDBData(), ScDatabaseRangeObj::getPropertyValue(), ScDBFunc::HideAutoFilter(), IMPL_LINK(), ScDataProviderDlg::import(), ScFilterOptionsMgr::Init(), ScPivotFilterDlg::Init(), ScDbNameDlg::Init(), lcl_GetAreaName(), ScDBDocFunc::ModifyDBData(), ScAreaNameIterator::Next(), ScViewFunc::PasteDataFormat(), ScDatabaseRangeObj::refresh(), XclExpTables::SaveTableXml(), ScDBFunc::ToggleAutoFilter(), 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 |
Definition at line 386 of file dbdata.cxx.
References ScSortParam::bByRow, bByRow, ScSortParam::bHasHeader, bHasHeader, mpSortParam, ScSortParam::nCol1, ScSortParam::nCol2, nEndCol, nEndRow, ScSortParam::nRow1, ScSortParam::nRow2, nStartCol, and nStartRow.
Referenced by ScCellRangeObj::createSortDescriptor(), ScDBFunc::DoSubTotals(), ScDBDocFunc::DoSubTotals(), ExcAutoFilterRecs::ExcAutoFilterRecs(), ScCellShell::ExecuteDB(), ScDatabaseRangeObj::getSortDescriptor(), operator==(), ScDBFunc::RepeatDB(), ScDBDocFunc::RepeatDB(), ScCellRangeObj::sort(), and ScGridWindow::UpdateAutoFilterFromMenu().
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().
|
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().
|
inline |
Definition at line 148 of file dbdata.hxx.
Referenced by XclExpTables::SaveTableXml().
|
inline |
Definition at line 122 of file dbdata.hxx.
Referenced by ScDBDocFunc::ModifyDBData(), and ScDocument::SetDBCollection().
|
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().
|
inline |
Definition at line 129 of file dbdata.hxx.
Referenced by ScCompiler::CreateStringFromSingleRef(), ScDocShell::GetAnonymousDBData(), ScDocShell::GetDBData(), ScDocument::GetFilterEntries(), GetHeaderArea(), ScCompiler::HandleTableRef(), ScDocument::HasAutoFilter(), ScFilterOptionsMgr::Init(), ScDbNameDlg::Init(), ScTabPageSortOptions::Init(), ScDBCollection::NamedDBs::initInserted(), InvalidateTableColumnNames(), ScCompiler::IsTableRefColumn(), ScHeaderControl::Paint(), RefreshTableColumnNames(), XclExpTables::SaveTableXml(), ScInterpreter::ScIndirect(), ScDBFunc::ToggleAutoFilter(), ScGridWindow::UpdateAutoFilterFromMenu(), and ScDbNameDlg::UpdateDBData().
bool ScDBData::HasImportParam | ( | ) | const |
Definition at line 504 of file dbdata.cxx.
References mpImportParam.
Referenced by ScDocShell::Execute(), and ScCellShell::GetDBState().
|
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().
|
inline |
Definition at line 131 of file dbdata.hxx.
Referenced by ScCompiler::HandleTableRef(), ScDbNameDlg::Init(), XclExpTables::SaveTableXml(), ScInterpreter::ScIndirect(), and ScDbNameDlg::UpdateDBData().
|
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().
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().
|
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().
|
inline |
Definition at line 137 of file dbdata.hxx.
Referenced by ScDBDocFunc::DoImport(), ScDatabaseRangeObj::getPropertyValue(), ScDbNameDlg::Init(), ScDBDocFunc::Query(), and ScDbNameDlg::UpdateDBData().
|
inline |
Definition at line 206 of file dbdata.hxx.
|
inline |
Definition at line 139 of file dbdata.hxx.
Referenced by ScDocShell::Execute(), ScDatabaseRangeObj::getPropertyValue(), ScDbNameDlg::Init(), and ScDbNameDlg::UpdateDBData().
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().
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.
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().
Definition at line 431 of file dbdata.cxx.
References aAdvSource, and bIsAdvanced.
Referenced by XclImpAutoFilterData::Apply(), XclImpAutoFilterData::InsertQueryParam(), ScDBDocFunc::Query(), ScDatabaseRangeObj::setPropertyValue(), and UpdateReference().
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().
|
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().
|
inline |
Definition at line 128 of file dbdata.hxx.
Referenced by ScDBFuncUndo::BeginRedo(), ScDBDocFunc::DoImport(), ScDocShell::GetDBData(), IMPL_LINK_NOARG(), and ScDBFunc::ToggleAutoFilter().
|
inline |
Definition at line 142 of file dbdata.hxx.
Referenced by ScDBCollection::NamedDBs::initInserted().
|
inline |
Definition at line 136 of file dbdata.hxx.
Referenced by IMPL_LINK_NOARG(), and ScDatabaseRangeObj::setPropertyValue().
|
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().
|
inline |
Definition at line 201 of file dbdata.hxx.
Referenced by ScDBDocFunc::DoImport(), and ScDatabaseRangeObj::setPropertyValue().
|
inline |
Definition at line 133 of file dbdata.hxx.
|
inline |
Definition at line 138 of file dbdata.hxx.
Referenced by IMPL_LINK_NOARG(), and ScDatabaseRangeObj::setPropertyValue().
|
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().
|
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().
|
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().
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 | ||
) |
Definition at line 574 of file dbdata.cxx.
References AdjustTableColumnNames(), ScRange::aEnd, ScRange::aStart, GetAdvancedQuerySource(), GetArea(), ScRange::GetVars(), maTableColumnNames, mbTableColumnNamesDirty, MoveTo(), ScAddress::Set(), SetAdvancedQuerySource(), SetModified(), ScRefUpdate::Update(), and UR_NOTHING.
Referenced by ScDBCollection::UpdateReference().
|
private |
source range
Definition at line 87 of file dbdata.hxx.
Referenced by GetAdvancedQuerySource(), operator=(), operator==(), and SetAdvancedQuerySource().
|
private |
DBParam.
Definition at line 71 of file dbdata.hxx.
|
private |
Definition at line 72 of file dbdata.hxx.
Referenced by ScDBData().
|
private |
|
private |
Definition at line 78 of file dbdata.hxx.
Referenced by GetQueryParam(), GetSortParam(), MoveTo(), operator=(), and SetSortParam().
|
private |
not in Param: if selection, block update
Definition at line 89 of file dbdata.hxx.
Referenced by operator=().
|
private |
Definition at line 81 of file dbdata.hxx.
Referenced by operator=(), and operator==().
|
private |
Definition at line 79 of file dbdata.hxx.
Referenced by CalcSaveFilteredCount(), GetFilterSelCount(), GetQueryParam(), GetSortParam(), operator=(), StartTableColumnNamesListener(), and UpdateFromSortParam().
|
private |
Definition at line 80 of file dbdata.hxx.
Referenced by operator=().
|
private |
QueryParam.
true if created by advanced filter
Definition at line 86 of file dbdata.hxx.
Referenced by GetAdvancedQuerySource(), operator=(), operator==(), SetAdvancedQuerySource(), and SetQueryParam().
|
private |
Definition at line 82 of file dbdata.hxx.
Referenced by operator=(), and operator==().
|
private |
is set/cleared for/by(?) UpdateReference
Definition at line 93 of file dbdata.hxx.
|
private |
Definition at line 83 of file dbdata.hxx.
Referenced by operator=(), and operator==().
|
private |
names of table columns
Definition at line 95 of file dbdata.hxx.
Referenced by AdjustTableColumnNames(), ExtendDataArea(), GetColumnNameOffset(), GetTableColumnName(), InvalidateTableColumnNames(), operator=(), RefreshTableColumnNames(), SetArea(), SetTableColumnNames(), UpdateMoveTab(), and UpdateReference().
|
private |
Definition at line 96 of file dbdata.hxx.
Referenced by AdjustTableColumnNames(), InvalidateTableColumnNames(), Notify(), operator=(), RefreshTableColumnNames(), SetTableColumnNames(), UpdateMoveTab(), and UpdateReference().
|
private |
Definition at line 68 of file dbdata.hxx.
Referenced by InvalidateTableColumnNames(), Notify(), and StartTableColumnNamesListener().
|
private |
Definition at line 66 of file dbdata.hxx.
Referenced by GetImportParam(), GetSourceString(), HasImportParam(), operator=(), and SetImportParam().
|
private |
Definition at line 64 of file dbdata.hxx.
Referenced by GetOperations(), GetQueryParam(), HasQueryParam(), MoveTo(), operator=(), and SetQueryParam().
|
private |
Definition at line 63 of file dbdata.hxx.
Referenced by GetOperations(), GetSortParam(), HasSortParam(), MoveTo(), operator=(), and SetSortParam().
|
private |
Definition at line 65 of file dbdata.hxx.
Referenced by GetOperations(), GetSubTotalParam(), HasSubTotalParam(), MoveTo(), operator=(), and SetSubTotalParam().
|
private |
Definition at line 76 of file dbdata.hxx.
Referenced by ExtendDataArea(), GetArea(), GetHeaderArea(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), IsDBAtArea(), operator=(), RefreshTableColumnNames(), and SetArea().
|
private |
Definition at line 77 of file dbdata.hxx.
Referenced by CalcSaveFilteredCount(), ExtendDataArea(), GetArea(), GetFilterSelCount(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), IsDBAtArea(), IsDBAtCursor(), operator=(), and SetArea().
|
private |
Definition at line 97 of file dbdata.hxx.
Referenced by CalcSaveFilteredCount(), GetFilterSelCount(), and operator=().
|
private |
|
private |
Definition at line 74 of file dbdata.hxx.
Referenced by ExtendDataArea(), GetArea(), GetHeaderArea(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), GetTableColumnName(), InvalidateTableColumnNames(), IsDBAtArea(), IsDBAtCursor(), MoveTo(), operator=(), RefreshTableColumnNames(), and SetArea().
|
private |
Definition at line 75 of file dbdata.hxx.
Referenced by CalcSaveFilteredCount(), ExtendDataArea(), GetArea(), GetFilterSelCount(), GetHeaderArea(), GetImportParam(), GetQueryParam(), GetSortParam(), GetSubTotalParam(), InvalidateTableColumnNames(), IsDBAtArea(), IsDBAtCursor(), MoveTo(), operator=(), RefreshTableColumnNames(), and SetArea().
|
private |
Definition at line 73 of file dbdata.hxx.
Referenced by ExtendDataArea(), GetArea(), GetHeaderArea(), GetQueryParam(), InvalidateTableColumnNames(), IsDBAtArea(), IsDBAtCursor(), operator=(), operator==(), RefreshTableColumnNames(), and SetArea().