/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the Collabora Office project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed * with this work for additional information regarding copyright * ownership. The ASF licenses this file to you under the Apache * License, Version 2.0 (the "License"); you may not use this file * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include using namespace com::sun::star; static bool lcl_GetTextToColumnsRange( const ScViewData& rData, ScRange& rRange, bool bDoEmptyCheckOnly ) { bool bRet = false; const ScMarkData& rMark = rData.GetMarkData(); if ( rMark.IsMarked() ) { if ( !rMark.IsMultiMarked() ) { rRange = rMark.GetMarkArea(); if ( rRange.aStart.Col() == rRange.aEnd.Col() ) { bRet = true; } } } else { const SCCOL nCol = rData.GetCurX(); const SCROW nRow = rData.GetCurY(); const SCTAB nTab = rData.CurrentTabForData(); rRange = ScRange( nCol, nRow, nTab, nCol, nRow, nTab ); bRet = true; } const ScDocument& rDoc = rData.GetDocument(); if ( bDoEmptyCheckOnly ) { if ( bRet && rDoc.IsBlockEmpty( rRange.aStart.Col(), rRange.aStart.Row(), rRange.aEnd.Col(), rRange.aEnd.Row(), rRange.aStart.Tab() ) ) { bRet = false; } } else if ( bRet ) { rRange.PutInOrder(); SCCOL nStartCol = rRange.aStart.Col(), nEndCol = rRange.aEnd.Col(); SCROW nStartRow = rRange.aStart.Row(), nEndRow = rRange.aEnd.Row(); bool bShrunk = false; rDoc.ShrinkToUsedDataArea( bShrunk, rRange.aStart.Tab(), nStartCol, nStartRow, nEndCol, nEndRow, false, false, true ); if ( bShrunk ) { rRange.aStart.SetRow( nStartRow ); rRange.aEnd.SetRow( nEndRow ); } } return bRet; } static bool lcl_GetSortParam( const ScViewData& rData, const ScSortParam& rSortParam ) { ScTabViewShell* pTabViewShell = rData.GetViewShell(); ScDBData* pDBData = pTabViewShell->GetDBData(); ScDocument& rDoc = rData.GetDocument(); SCTAB nTab = rData.CurrentTabForData(); ScDirection eFillDir = DIR_TOP; bool bSort = true; ScRange aExternalRange; if( rSortParam.nCol1 != rSortParam.nCol2 ) eFillDir = DIR_LEFT; if( rSortParam.nRow1 != rSortParam.nRow2 ) eFillDir = DIR_TOP; if( rSortParam.nRow2 == rDoc.MaxRow() ) { // Assume that user selected entire column(s), but cater for the // possibility that the start row is not the first row. SCSIZE nCount = rDoc.GetEmptyLinesInBlock( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab, eFillDir ); aExternalRange = ScRange( rSortParam.nCol1, ::std::min( rSortParam.nRow1 + sal::static_int_cast( nCount ), rDoc.MaxRow()), nTab, rSortParam.nCol2, rSortParam.nRow2, nTab); aExternalRange.PutInOrder(); } else if (rSortParam.nCol1 != rSortParam.nCol2 || rSortParam.nRow1 != rSortParam.nRow2) { // Preserve a preselected area. aExternalRange = ScRange( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab); aExternalRange.PutInOrder(); } else aExternalRange = ScRange( rData.GetCurX(), rData.GetCurY(), nTab ); SCROW nStartRow = aExternalRange.aStart.Row(); SCCOL nStartCol = aExternalRange.aStart.Col(); SCROW nEndRow = aExternalRange.aEnd.Row(); SCCOL nEndCol = aExternalRange.aEnd.Col(); rDoc.GetDataArea( aExternalRange.aStart.Tab(), nStartCol, nStartRow, nEndCol, nEndRow, false, false ); aExternalRange.aStart.SetRow( nStartRow ); aExternalRange.aStart.SetCol( nStartCol ); aExternalRange.aEnd.SetRow( nEndRow ); aExternalRange.aEnd.SetCol( nEndCol ); // with COKit, don't try to interact with the user if (!comphelper::COKit::isActive() && ((rSortParam.nCol1 == rSortParam.nCol2 && aExternalRange.aStart.Col() != aExternalRange.aEnd.Col()) || (rSortParam.nRow1 == rSortParam.nRow2 && aExternalRange.aStart.Row() != aExternalRange.aEnd.Row()))) { pTabViewShell->AddHighlightRange( aExternalRange,COL_LIGHTBLUE ); OUString aExtendStr( aExternalRange.Format(rDoc, ScRefFlags::VALID)); ScRange aCurrentRange( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab ); OUString aCurrentStr(aCurrentRange.Format(rDoc, ScRefFlags::VALID)); ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create(); ScopedVclPtr pWarningDlg(pFact->CreateScSortWarningDlg(pTabViewShell->GetFrameWeld(), aExtendStr, aCurrentStr)); short bResult = pWarningDlg->Execute(); if( bResult == BTN_EXTEND_RANGE || bResult == BTN_CURRENT_SELECTION ) { if( bResult == BTN_EXTEND_RANGE ) { pTabViewShell->MarkRange( aExternalRange, false ); pDBData->SetArea( nTab, aExternalRange.aStart.Col(), aExternalRange.aStart.Row(), aExternalRange.aEnd.Col(), aExternalRange.aEnd.Row() ); } } else { bSort = false; rData.GetDocShell()->CancelAutoDBRange(); } pTabViewShell->ClearHighlightRanges(); } return bSort; } namespace { // this registers the dialog which Find1RefWindow search for class ScValidationRegisteredDlg { std::shared_ptr m_xDlg; public: ScValidationRegisteredDlg(weld::Window* pParent, std::shared_ptr xDlg) : m_xDlg(std::move(xDlg)) { ScModule::get()->RegisterRefController(static_cast(ScValidationDlg::SLOTID), m_xDlg, pParent); } ~ScValidationRegisteredDlg() { m_xDlg->Close(); ScModule::get()->UnregisterRefController(static_cast(ScValidationDlg::SLOTID), m_xDlg); } }; } void ScCellShell::ExecuteDB( SfxRequest& rReq ) { ScTabViewShell* pTabViewShell = GetViewData().GetViewShell(); sal_uInt16 nSlotId = rReq.GetSlot(); const SfxItemSet* pReqArgs = rReq.GetArgs(); ScModule* pScMod = ScModule::get(); pTabViewShell->HideListBox(); // Autofilter-DropDown-Listbox if ( GetViewData().HasEditView( GetViewData().GetActivePart() ) ) { pScMod->InputEnterHandler(); pTabViewShell->UpdateInputHandler(); } switch ( nSlotId ) { case SID_VIEW_DATA_SOURCE_BROWSER: { // check if database beamer is open SfxViewFrame& rViewFrame = pTabViewShell->GetViewFrame(); bool bWasOpen = false; { uno::Reference xFrame = rViewFrame.GetFrame().GetFrameInterface(); uno::Reference xBeamerFrame = xFrame->findFrame( u"_beamer"_ustr, frame::FrameSearchFlag::CHILDREN); if ( xBeamerFrame.is() ) bWasOpen = true; } if ( bWasOpen ) { // close database beamer: just forward to SfxViewFrame rViewFrame.ExecuteSlot( rReq ); } else { // show database beamer: SfxViewFrame call must be synchronous rViewFrame.ExecuteSlot( rReq, false ); // false = synchronous // select current database in database beamer ScImportParam aImportParam; ScDBData* pDBData = pTabViewShell->GetDBData(true,SC_DB_OLD); // don't create if none found if (pDBData) pDBData->GetImportParam( aImportParam ); ScDBDocFunc::ShowInBeamer( aImportParam, &pTabViewShell->GetViewFrame() ); } rReq.Done(); // needed because it's a toggle slot } break; case SID_REIMPORT_DATA: { bool bOk = false; ScDBData* pDBData = pTabViewShell->GetDBData(true,SC_DB_OLD); if (pDBData) { ScImportParam aImportParam; pDBData->GetImportParam( aImportParam ); if (aImportParam.bImport && !pDBData->HasImportSelection()) { pTabViewShell->ImportData( aImportParam ); pDBData->SetImportParam( aImportParam ); //! Undo ?? bOk = true; } } if (!bOk && ! rReq.IsAPI() ) pTabViewShell->ErrorMessage(STR_REIMPORT_EMPTY); if( bOk ) rReq.Done(); } break; case SID_REFRESH_DBAREA: { ScDBData* pDBData = pTabViewShell->GetDBData(true,SC_DB_OLD); if (pDBData) { // repeat import like SID_REIMPORT_DATA bool bContinue = true; ScImportParam aImportParam; pDBData->GetImportParam( aImportParam ); if (aImportParam.bImport && !pDBData->HasImportSelection()) { bContinue = pTabViewShell->ImportData( aImportParam ); pDBData->SetImportParam( aImportParam ); //! Undo ?? // mark (size may have been changed) ScRange aNewRange; pDBData->GetArea(aNewRange); pTabViewShell->MarkRange(aNewRange); } if ( bContinue ) // fail at import -> break { // internal operations, when any stored if ( pDBData->HasQueryParam() || pDBData->HasSortParam() || pDBData->HasSubTotalParam() ) pTabViewShell->RepeatDB(); // pivot tables that have the range as data source ScRange aRange; pDBData->GetArea(aRange); GetViewData().GetDocShell()->RefreshPivotTables(aRange); } } rReq.Done(); } break; case SID_SBA_BRW_INSERT: { OSL_FAIL( "Deprecated Slot" ); } break; case SID_DATA_FORM: { ScViewData& rData = GetViewData(); ScRange aRange; rData.GetSimpleArea( aRange ); ScAddress aStart = aRange.aStart; ScAddress aEnd = aRange.aEnd; if((aEnd.Col() - aStart.Col()) >= MAX_DATAFORM_COLS) { rData.GetDocShell()->ErrorMessage(STR_TOO_MANY_COLUMNS_DATA_FORM); break; } ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create(); ScopedVclPtr pDlg(pFact->CreateScDataFormDlg( pTabViewShell->GetFrameWeld(), *pTabViewShell)); pDlg->Execute(); rReq.Done(); } break; case SID_SUBTOTALS: ExecuteSubtotals(rReq); break; case SID_SORT_DESCENDING: case SID_SORT_ASCENDING: { if (ScDBData* pDBData = pTabViewShell->GetDBData()) { //#i60401 ux-ctest: Calc does not support all users' strategies regarding sorting data //the patch comes from maoyg ScSortParam aSortParam; ScViewData& rData = GetViewData(); pDBData->GetSortParam( aSortParam ); if( lcl_GetSortParam( rData, aSortParam ) ) { SCCOL nCol = GetViewData().GetCurX(); SCCOL nTab = GetViewData().CurrentTabForData(); ScDocument& rDoc = GetViewData().GetDocument(); pDBData->GetSortParam( aSortParam ); bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, nTab ); if( nCol < aSortParam.nCol1 ) nCol = aSortParam.nCol1; else if( nCol > aSortParam.nCol2 ) nCol = aSortParam.nCol2; aSortParam.bHasHeader = bHasHeader; aSortParam.bByRow = true; aSortParam.bCaseSens = false; aSortParam.eSortNumberBehavior = ScSortNumberBehavior::ALPHA_NUMERIC; aSortParam.aDataAreaExtras.mbCellNotes = false; aSortParam.aDataAreaExtras.mbCellDrawObjects = true; aSortParam.aDataAreaExtras.mbCellFormats = true; aSortParam.bInplace = true; aSortParam.maKeyState[0].bDoSort = true; aSortParam.maKeyState[0].nField = nCol; aSortParam.maKeyState[0].bAscending = ( nSlotId == SID_SORT_ASCENDING ); for ( sal_uInt16 i=1; iUISort( aSortParam ); // subtotal when needed new rReq.Done(); } } } break; case SID_SHUFFLE: { if (ScDBData* pDBData = pTabViewShell->GetDBData()) { ScSortParam aSortParam; ScViewData& rData = GetViewData(); pDBData->GetSortParam(aSortParam); if (lcl_GetSortParam(rData, aSortParam)) { pDBData->GetSortParam(aSortParam); ScDocument& rDoc = rData.GetDocument(); SCTAB nTab = rData.CurrentTabForData(); bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, nTab); aSortParam.bHasHeader = bHasHeader; aSortParam.bByRow = true; aSortParam.meSortOrderType = SortOrderType::Random; pTabViewShell->Sort(aSortParam); rReq.Done(); } } } break; case SID_SORT: { if (ScDBData* pDBData = pTabViewShell->GetDBData()) { const SfxItemSet* pArgs = rReq.GetArgs(); //#i60401 ux-ctest: Calc does not support all users' strategies regarding sorting data //the patch comes from maoyg if ( pArgs ) // Basic { ScSortParam aSortParam; ScViewData& rData = GetViewData(); pDBData->GetSortParam( aSortParam ); if( lcl_GetSortParam( rData, aSortParam ) ) { ScDocument& rDoc = GetViewData().GetDocument(); pDBData->GetSortParam( aSortParam ); bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, rData.CurrentTabForData() ); if( bHasHeader ) aSortParam.bHasHeader = bHasHeader; aSortParam.bInplace = true; // from Basic always if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_BYROW ) ) aSortParam.bByRow = pItem->GetValue(); if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_HASHEADER ) ) aSortParam.bHasHeader = pItem->GetValue(); if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_CASESENS ) ) aSortParam.bCaseSens = pItem->GetValue(); if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_NATURALSORT ) ) { // For to keep old macros working. Its value will be overwritten by // SID_SORT_NUMBERBEHAVIOR if that one is set. sal_Int32 nVal = pItem->GetValue() ? 1 : 0; aSortParam.eSortNumberBehavior = static_cast(nVal); } if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_INCCOMMENTS ) ) aSortParam.aDataAreaExtras.mbCellNotes = pItem->GetValue(); if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_INCIMAGES ) ) aSortParam.aDataAreaExtras.mbCellDrawObjects = pItem->GetValue(); if ( const SfxBoolItem* pItem = pArgs->GetItemIfSet( SID_SORT_ATTRIBS ) ) aSortParam.aDataAreaExtras.mbCellFormats = pItem->GetValue(); if ( const SfxUInt16Item* pItem = pArgs->GetItemIfSet( SID_SORT_USERDEF ) ) { sal_uInt16 nUserIndex = pItem->GetValue(); aSortParam.bUserDef = ( nUserIndex != 0 ); if ( nUserIndex ) aSortParam.nUserIndex = nUserIndex - 1; // Basic: 1-based } if (const SfxInt32Item* pItem = pArgs->GetItemIfSet( SID_SORT_NUMBERBEHAVIOR)) { sal_Int32 nVal = pItem->GetValue(); if (nVal < 0 || nVal >2) nVal = 0; // invalid value, use default aSortParam.eSortNumberBehavior = static_cast(nVal); } SCCOLROW nField0 = 0; const SfxPoolItem* pItem = nullptr; if ( pArgs->GetItemState( FN_PARAM_1, true, &pItem ) == SfxItemState::SET ) nField0 = static_cast(pItem)->GetValue(); aSortParam.maKeyState[0].bDoSort = ( nField0 != 0 ); aSortParam.maKeyState[0].nField = nField0 > 0 ? (nField0-1) : 0; if ( pArgs->GetItemState( FN_PARAM_2, true, &pItem ) == SfxItemState::SET ) aSortParam.maKeyState[0].bAscending = static_cast(pItem)->GetValue(); SCCOLROW nField1 = 0; if ( pArgs->GetItemState( FN_PARAM_3, true, &pItem ) == SfxItemState::SET ) nField1 = static_cast(pItem)->GetValue(); aSortParam.maKeyState[1].bDoSort = ( nField1 != 0 ); aSortParam.maKeyState[1].nField = nField1 > 0 ? (nField1-1) : 0; if ( pArgs->GetItemState( FN_PARAM_4, true, &pItem ) == SfxItemState::SET ) aSortParam.maKeyState[1].bAscending = static_cast(pItem)->GetValue(); SCCOLROW nField2 = 0; if ( pArgs->GetItemState( FN_PARAM_5, true, &pItem ) == SfxItemState::SET ) nField2 = static_cast(pItem)->GetValue(); aSortParam.maKeyState[2].bDoSort = ( nField2 != 0 ); aSortParam.maKeyState[2].nField = nField2 > 0 ? (nField2-1) : 0; if ( pArgs->GetItemState( FN_PARAM_6, true, &pItem ) == SfxItemState::SET ) aSortParam.maKeyState[2].bAscending = static_cast(pItem)->GetValue(); // subtotal when needed new pTabViewShell->UISort( aSortParam ); rReq.Done(); } } else { ScSortParam aSortParam; ScViewData& rData = GetViewData(); pDBData->GetSortParam( aSortParam ); if( lcl_GetSortParam( rData, aSortParam ) ) { ScDocument& rDoc = GetViewData().GetDocument(); SfxItemSetFixed aArgSet( GetPool() ); pDBData->GetSortParam( aSortParam ); bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, rData.CurrentTabForData() ); if( bHasHeader ) aSortParam.bHasHeader = bHasHeader; aArgSet.Put( ScSortItem( SCITEM_SORTDATA, &GetViewData(), &aSortParam ) ); ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create(); std::shared_ptr pDlg(pFact->CreateScSortDlg(pTabViewShell->GetFrameWeld(), &aArgSet)); pDlg->SetCurPageId(u"criteria"_ustr); // 1=sort field tab 2=sort options tab VclAbstractDialog::AsyncContext aContext; aContext.maEndDialogFn = [pDlg, &rData, pTabViewShell](sal_Int32 nResult) { if ( nResult == RET_OK ) { const SfxItemSet* pOutSet = pDlg->GetOutputItemSet(); const ScSortParam& rOutParam = pOutSet->Get( SCITEM_SORTDATA ).GetSortData(); // subtotal when needed new pTabViewShell->UISort( rOutParam ); SfxViewFrame& rViewFrm = pTabViewShell->GetViewFrame(); SfxRequest aRequest(rViewFrm, SID_SORT); if ( rOutParam.bInplace ) { aRequest.AppendItem( SfxBoolItem( SID_SORT_BYROW, rOutParam.bByRow ) ); aRequest.AppendItem( SfxBoolItem( SID_SORT_HASHEADER, rOutParam.bHasHeader ) ); aRequest.AppendItem( SfxBoolItem( SID_SORT_CASESENS, rOutParam.bCaseSens ) ); aRequest.AppendItem( SfxBoolItem( SID_SORT_INCCOMMENTS, rOutParam.aDataAreaExtras.mbCellNotes ) ); aRequest.AppendItem( SfxBoolItem( SID_SORT_INCIMAGES, rOutParam.aDataAreaExtras.mbCellDrawObjects ) ); aRequest.AppendItem( SfxBoolItem( SID_SORT_ATTRIBS, rOutParam.aDataAreaExtras.mbCellFormats ) ); sal_uInt16 nUser = rOutParam.bUserDef ? ( rOutParam.nUserIndex + 1 ) : 0; aRequest.AppendItem( SfxUInt16Item( SID_SORT_USERDEF, nUser ) ); if ( rOutParam.maKeyState[0].bDoSort ) { aRequest.AppendItem( SfxInt32Item( TypedWhichId(FN_PARAM_1), rOutParam.maKeyState[0].nField + 1 ) ); aRequest.AppendItem( SfxBoolItem( FN_PARAM_2, rOutParam.maKeyState[0].bAscending ) ); } if ( rOutParam.maKeyState[1].bDoSort ) { aRequest.AppendItem( SfxInt32Item( TypedWhichId(FN_PARAM_3), rOutParam.maKeyState[1].nField + 1 ) ); aRequest.AppendItem( SfxBoolItem( FN_PARAM_4, rOutParam.maKeyState[1].bAscending ) ); } if ( rOutParam.maKeyState[2].bDoSort ) { aRequest.AppendItem( SfxInt32Item( TypedWhichId(FN_PARAM_5), rOutParam.maKeyState[2].nField + 1 ) ); aRequest.AppendItem( SfxBoolItem( FN_PARAM_6, rOutParam.maKeyState[2].bAscending ) ); } } aRequest.Done(); } else { rData.GetDocShell()->CancelAutoDBRange(); } }; pDlg->StartExecuteAsync(aContext); } } } } break; case SID_FILTER: { const SfxItemSet* pArgs = rReq.GetArgs(); if ( pArgs ) { OSL_FAIL("SID_FILTER with arguments?"); pTabViewShell->Query( pArgs->Get( SCITEM_QUERYDATA ).GetQueryData(), nullptr, true ); rReq.Done(); } else { sal_uInt16 nId = ScFilterDlgWrapper::GetChildWindowId(); SfxViewFrame& rViewFrm = pTabViewShell->GetViewFrame(); SfxChildWindow* pWnd = rViewFrm.GetChildWindow( nId ); pScMod->SetRefDialog( nId, pWnd == nullptr ); } } break; case SID_SPECIAL_FILTER: { const SfxItemSet* pArgs = rReq.GetArgs(); if ( pArgs ) { OSL_FAIL("SID_SPECIAL_FILTER with arguments?"); pTabViewShell->Query( pArgs->Get( SCITEM_QUERYDATA ).GetQueryData(), nullptr, true ); rReq.Done(); } else { sal_uInt16 nId = ScSpecialFilterDlgWrapper::GetChildWindowId(); SfxViewFrame& rViewFrm = pTabViewShell->GetViewFrame(); SfxChildWindow* pWnd = rViewFrm.GetChildWindow( nId ); pScMod->SetRefDialog( nId, pWnd == nullptr ); } } break; case FID_FILTER_OK: { const ScQueryItem* pQueryItem; if ( pReqArgs && (pQueryItem = pReqArgs->GetItemIfSet( SCITEM_QUERYDATA )) ) { SCTAB nCurTab = GetViewData().CurrentTabForData(); SCTAB nRefTab = GetViewData().GetRefTabNo(); // If RefInput switched to a different sheet from the data sheet, // switch back: if ( nCurTab != nRefTab ) { pTabViewShell->SetTabNo( nRefTab ); pTabViewShell->PaintExtras(); } ScRange aAdvSource; if (pQueryItem->GetAdvancedQuerySource(aAdvSource)) pTabViewShell->Query( pQueryItem->GetQueryData(), &aAdvSource, true ); else pTabViewShell->Query( pQueryItem->GetQueryData(), nullptr, true ); rReq.Done( *pReqArgs ); } } break; case SID_UNFILTER: { // tdf#117346 - show current data range of the filter with selection if (ScDBData* pDBData = pTabViewShell->GetDBData(true, SC_DB_OLD)) { ScQueryParam aParam; pDBData->GetQueryParam( aParam ); SCSIZE nEC = aParam.GetEntryCount(); for (SCSIZE i=0; iQuery( aParam, nullptr, true ); rReq.Done(); } } break; case SID_CLEAR_AUTO_FILTER: pTabViewShell->ClearAutoFilter(); rReq.Done(); break; case SID_AUTO_FILTER: pTabViewShell->ToggleAutoFilter(); rReq.Done(); break; case SID_AUTOFILTER_HIDE: pTabViewShell->HideAutoFilter(); rReq.Done(); break; case SID_PIVOT_TABLE: { const ScPivotItem* pPItem; if ( pReqArgs && (pPItem = pReqArgs->GetItemIfSet( SCITEM_PIVOTDATA )) ) { SCTAB nCurTab = GetViewData().CurrentTabForData(); SCTAB nRefTab = GetViewData().GetRefTabNo(); // If RefInput switched to a different sheet from the data sheet, // switch back: if ( nCurTab != nRefTab ) { pTabViewShell->SetTabNo( nRefTab ); pTabViewShell->PaintExtras(); } const ScDPObject* pDPObject = pTabViewShell->GetDialogDPObject(); if ( pDPObject ) { bool bSuccess = pTabViewShell->MakePivotTable( pPItem->GetData(), pPItem->GetDestRange(), pPItem->IsNewSheet(), *pDPObject ); SfxBoolItem aRet(0, bSuccess); rReq.SetReturnValue(aRet); } rReq.Done(); } #if HAVE_FEATURE_SCRIPTING else if (rReq.IsAPI()) SbxBase::SetError(ERRCODE_BASIC_BAD_PARAMETER); #endif } break; case SID_OPENDLG_PIVOTTABLE: ExecuteDataPilotDialog(); break; case SID_DEFINE_DBNAME: { sal_uInt16 nId = ScDbNameDlgWrapper::GetChildWindowId(); SfxViewFrame& rViewFrm = pTabViewShell->GetViewFrame(); SfxChildWindow* pWnd = rViewFrm.GetChildWindow( nId ); pScMod->SetRefDialog( nId, pWnd == nullptr ); } break; case SID_INSERT_CALCTABLE: { sal_uInt16 nId = ScTableLayoutWrapper::GetChildWindowId(); SfxViewFrame& rViewFrm = pTabViewShell->GetViewFrame(); SfxChildWindow* pWnd = rViewFrm.GetChildWindow(nId); pScMod->SetRefDialog(nId, pWnd == nullptr); } break; case SID_SELECT_DB: { if ( pReqArgs ) { const SfxStringItem& rItem = pReqArgs->Get(SID_SELECT_DB); pTabViewShell->GotoDBArea(rItem.GetValue()); rReq.Done(); } else { ScDocument& rDoc = GetViewData().GetDocument(); ScDBCollection* pDBCol = rDoc.GetDBCollection(); if ( pDBCol ) { std::vector aList; const ScDBCollection::NamedDBs& rDBs = pDBCol->getNamedDBs(); for (const auto& rxDB : rDBs) aList.push_back(rxDB->GetName()); ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create(); VclPtr pDlg( pFact->CreateScSelEntryDlg(pTabViewShell->GetFrameWeld(), aList)); pDlg->StartExecuteAsync( [pTabViewShell, pDlg](sal_Int32 nResult) { if (nResult == RET_OK) { OUString aName = pDlg->GetSelectedEntry(); pTabViewShell->GotoDBArea(aName); SfxRequest aRequest(pTabViewShell->GetViewFrame(), SID_SELECT_DB); aRequest.AppendItem(SfxStringItem(SID_SELECT_DB, aName)); aRequest.Done(); } pDlg->disposeOnce(); }); } } } break; case SID_DATA_STREAMS: { sc::DataStreamDlg aDialog(*GetViewData().GetDocShell(), pTabViewShell->GetFrameWeld()); ScDocument& rDoc = GetViewData().GetDocument(); sc::DocumentLinkManager& rMgr = rDoc.GetDocLinkManager(); sc::DataStream* pStrm = rMgr.getDataStream(); if (pStrm) aDialog.Init(*pStrm); if (aDialog.run() == RET_OK) aDialog.StartStream(); } break; case SID_DATA_STREAMS_PLAY: { ScDocument& rDoc = GetViewData().GetDocument(); sc::DocumentLinkManager& rMgr = rDoc.GetDocLinkManager(); sc::DataStream* pStrm = rMgr.getDataStream(); if (pStrm) pStrm->StartImport(); } break; case SID_DATA_STREAMS_STOP: { ScDocument& rDoc = GetViewData().GetDocument(); sc::DocumentLinkManager& rMgr = rDoc.GetDocLinkManager(); sc::DataStream* pStrm = rMgr.getDataStream(); if (pStrm) pStrm->StopImport(); } break; case SID_DATA_PROVIDER: { auto xDoc = std::make_shared(); xDoc->InsertTab(0, u"test"_ustr); ScDocument& rDoc = GetViewData().GetDocument(); ScDataProviderDlg aDialog(pTabViewShell->GetDialogParent(), std::move(xDoc), &rDoc); if (aDialog.run() == RET_OK) { aDialog.import(rDoc); } } break; case SID_DATA_PROVIDER_REFRESH: { ScDocument& rDoc = GetViewData().GetDocument(); auto& rDataMapper = rDoc.GetExternalDataMapper(); for (auto& rDataSource : rDataMapper.getDataSources()) { rDataSource.refresh(&rDoc, false); } } break; case SID_MANAGE_XML_SOURCE: ExecuteXMLSourceDialog(); break; case FID_VALIDATION: case FID_CURRENTVALIDATION: { const SfxItemSet* pArgs = rReq.GetArgs(); if ( pArgs ) { OSL_FAIL("later..."); } else { SfxItemSet aArgSet( GetPool(), ScTPValidationValue::GetRanges() ); ScValidationMode eMode = SC_VALID_ANY; ScConditionMode eOper = ScConditionMode::Equal; OUString aExpr1, aExpr2; bool bBlank = true; bool bCaseSensitive = false; sal_Int16 nListType = css::sheet::TableValidationVisibility::UNSORTED; bool bShowHelp = false; OUString aHelpTitle, aHelpText; bool bShowError = false; ScValidErrorStyle eErrStyle = SC_VALERR_STOP; OUString aErrTitle, aErrText; ScDocument& rDoc = GetViewData().GetDocument(); SCCOL nCurX = GetViewData().GetCurX(); SCROW nCurY = GetViewData().GetCurY(); SCTAB nTab = GetViewData().CurrentTabForData(); ScAddress aCursorPos( nCurX, nCurY, nTab ); sal_uInt32 nIndex = rDoc.GetAttr( nCurX, nCurY, nTab, ATTR_VALIDDATA ).GetValue(); if ( nIndex ) { const ScValidationData* pOldData = rDoc.GetValidationEntry( nIndex ); if ( pOldData ) { eMode = pOldData->GetDataMode(); eOper = pOldData->GetOperation(); sal_uInt32 nNumFmt = 0; if ( eMode == SC_VALID_DATE || eMode == SC_VALID_TIME ) { SvNumFormatType nType = ( eMode == SC_VALID_DATE ) ? SvNumFormatType::DATE : SvNumFormatType::TIME; nNumFmt = rDoc.GetFormatTable()->GetStandardFormat( nType, ScGlobal::eLnge ); } aExpr1 = pOldData->GetExpression( aCursorPos, 0, nNumFmt ); aExpr2 = pOldData->GetExpression( aCursorPos, 1, nNumFmt ); bBlank = pOldData->IsIgnoreBlank(); bCaseSensitive = pOldData->IsCaseSensitive(); nListType = pOldData->GetListType(); bShowHelp = pOldData->GetInput( aHelpTitle, aHelpText ); bShowError = pOldData->GetErrMsg( aErrTitle, aErrText, eErrStyle ); aArgSet.Put( SfxUInt16Item( FID_VALID_MODE, sal::static_int_cast(eMode) ) ); aArgSet.Put( SfxUInt16Item( FID_VALID_CONDMODE, sal::static_int_cast(eOper) ) ); aArgSet.Put( SfxStringItem( FID_VALID_VALUE1, aExpr1 ) ); aArgSet.Put( SfxStringItem( FID_VALID_VALUE2, aExpr2 ) ); aArgSet.Put( SfxBoolItem( FID_VALID_BLANK, bBlank ) ); aArgSet.Put( SfxBoolItem( FID_VALID_CASESENS, bCaseSensitive ) ); aArgSet.Put( SfxInt16Item( FID_VALID_LISTTYPE, nListType ) ); aArgSet.Put( SfxBoolItem( FID_VALID_SHOWHELP, bShowHelp ) ); aArgSet.Put( SfxStringItem( FID_VALID_HELPTITLE, aHelpTitle ) ); aArgSet.Put( SfxStringItem( FID_VALID_HELPTEXT, aHelpText ) ); aArgSet.Put( SfxBoolItem( FID_VALID_SHOWERR, bShowError ) ); aArgSet.Put( SfxUInt16Item( FID_VALID_ERRSTYLE, sal::static_int_cast(eErrStyle) ) ); aArgSet.Put( SfxStringItem( FID_VALID_ERRTITLE, aErrTitle ) ); aArgSet.Put( SfxStringItem( FID_VALID_ERRTEXT, aErrText ) ); } } // cell range picker vcl::Window* pWin = GetViewData().GetActiveWin(); weld::Window* pParentWin = pWin ? pWin->GetFrameWeld() : nullptr; auto xDlg = std::make_shared(pParentWin, &aArgSet, pTabViewShell); std::shared_ptr xRegisterThatDlgExists = std::make_shared(pParentWin, xDlg); struct lcl_auxData { ScAddress aCursorPos; ScValidationMode eMode; ScConditionMode eOper; OUString aExpr1; OUString aExpr2; bool bBlank; sal_Int16 nListType; bool bShowHelp; OUString aHelpTitle; OUString aHelpText; bool bShowError; ScValidErrorStyle eErrStyle; OUString aErrTitle; OUString aErrText; bool bCaseSensitive; std::shared_ptr aRegisterThatDlgExists; }; std::shared_ptr xAuxData = std::make_shared( lcl_auxData{ aCursorPos, eMode, eOper, aExpr1, aExpr2, bBlank, nListType, bShowHelp, aHelpTitle, aHelpText, bShowError, eErrStyle, aErrTitle, aErrText, bCaseSensitive, std::move(xRegisterThatDlgExists) }); auto xRequest = std::make_shared(rReq); rReq.Ignore(); // the 'old' request is not relevant any more SfxTabDialogController::runAsync( xDlg, [&rDoc, xRequest=std::move(xRequest), xAuxData=std::move(xAuxData), xDlg, pTabViewShell](sal_Int32 nResult) { if ( nResult == RET_OK ) { const SfxItemSet* pOutSet = xDlg->GetOutputItemSet(); if ( const SfxUInt16Item* pItem = pOutSet->GetItemIfSet( FID_VALID_MODE ) ) xAuxData->eMode = static_cast(pItem->GetValue()); if ( const SfxUInt16Item* pItem = pOutSet->GetItemIfSet( FID_VALID_CONDMODE ) ) xAuxData->eOper = static_cast(pItem->GetValue()); if ( const SfxStringItem* pItem = pOutSet->GetItemIfSet( FID_VALID_VALUE1 ) ) { OUString aTemp1 = pItem->GetValue(); if (xAuxData->eMode == SC_VALID_DATE || xAuxData->eMode == SC_VALID_TIME) { sal_uInt32 nNumIndex = 0; double nVal; if (rDoc.GetFormatTable()->IsNumberFormat(aTemp1, nNumIndex, nVal)) xAuxData->aExpr1 = ::rtl::math::doubleToUString( nVal, rtl_math_StringFormat_Automatic, rtl_math_DecimalPlaces_Max, ScGlobal::getLocaleData().getNumDecimalSep()[0], true); else xAuxData->aExpr1 = aTemp1; } else xAuxData->aExpr1 = aTemp1; } if ( const SfxStringItem* pItem = pOutSet->GetItemIfSet( FID_VALID_VALUE2 ) ) { OUString aTemp2 = pItem->GetValue(); if (xAuxData->eMode == SC_VALID_DATE || xAuxData->eMode == SC_VALID_TIME) { sal_uInt32 nNumIndex = 0; double nVal; if (rDoc.GetFormatTable()->IsNumberFormat(aTemp2, nNumIndex, nVal)) xAuxData->aExpr2 = ::rtl::math::doubleToUString( nVal, rtl_math_StringFormat_Automatic, rtl_math_DecimalPlaces_Max, ScGlobal::getLocaleData().getNumDecimalSep()[0], true); else xAuxData->aExpr2 = aTemp2; if ( xAuxData->eMode == SC_VALID_TIME ) { sal_Int32 wraparound = xAuxData->aExpr1.compareTo(xAuxData->aExpr2); if (wraparound > 0) { if (xAuxData->eOper == ScConditionMode::Between) { xAuxData->eOper = ScConditionMode::NotBetween; std::swap( xAuxData->aExpr1, xAuxData->aExpr2 ); } else if (xAuxData->eOper == ScConditionMode::NotBetween) { xAuxData->eOper = ScConditionMode::Between; std::swap( xAuxData->aExpr1, xAuxData->aExpr2 ); } } } } else xAuxData->aExpr2 = aTemp2; } if ( const SfxBoolItem* pItem = pOutSet->GetItemIfSet( FID_VALID_BLANK ) ) xAuxData->bBlank = pItem->GetValue(); if ( const SfxBoolItem* pItem = pOutSet->GetItemIfSet( FID_VALID_CASESENS ) ) xAuxData->bCaseSensitive = pItem->GetValue(); if ( const SfxInt16Item* pItem = pOutSet->GetItemIfSet( FID_VALID_LISTTYPE ) ) xAuxData->nListType = pItem->GetValue(); if ( const SfxBoolItem* pItem = pOutSet->GetItemIfSet( FID_VALID_SHOWHELP ) ) xAuxData->bShowHelp = pItem->GetValue(); if ( const SfxStringItem* pItem = pOutSet->GetItemIfSet( FID_VALID_HELPTITLE ) ) xAuxData->aHelpTitle = pItem->GetValue(); if ( const SfxStringItem* pItem = pOutSet->GetItemIfSet( FID_VALID_HELPTEXT ) ) xAuxData->aHelpText = pItem->GetValue(); if ( const SfxBoolItem* pItem = pOutSet->GetItemIfSet( FID_VALID_SHOWERR ) ) xAuxData->bShowError = pItem->GetValue(); if ( const SfxUInt16Item* pItem = pOutSet->GetItemIfSet( FID_VALID_ERRSTYLE ) ) xAuxData->eErrStyle = static_cast(pItem->GetValue()); if ( const SfxStringItem* pItem = pOutSet->GetItemIfSet( FID_VALID_ERRTITLE ) ) xAuxData->aErrTitle = pItem->GetValue(); if ( const SfxStringItem* pItem = pOutSet->GetItemIfSet( FID_VALID_ERRTEXT ) ) xAuxData->aErrText = pItem->GetValue(); ScValidationData aData( xAuxData->eMode, xAuxData->eOper, xAuxData->aExpr1, xAuxData->aExpr2, rDoc, xAuxData->aCursorPos ); aData.SetIgnoreBlank( xAuxData->bBlank ); aData.SetCaseSensitive( xAuxData->bCaseSensitive ); aData.SetListType( xAuxData->nListType ); aData.SetInput(xAuxData->aHelpTitle, xAuxData->aHelpText); // sets bShowInput to TRUE if (!xAuxData->bShowHelp) aData.ResetInput(); // reset only bShowInput aData.SetError(xAuxData->aErrTitle, xAuxData->aErrText, xAuxData->eErrStyle); // sets bShowError to TRUE if (!xAuxData->bShowError) aData.ResetError(); // reset only bShowError pTabViewShell->SetValidation( aData ); pTabViewShell->TestHintWindow(); xRequest->Done( *pOutSet ); } else { pTabViewShell->TestHintWindow(); } }); } } break; case SID_TEXT_TO_COLUMNS: { ScViewData& rData = GetViewData(); ScRange aRange; if ( lcl_GetTextToColumnsRange( rData, aRange, false ) ) { ScDocument& rDoc = rData.GetDocument(); ScImportExport aExport( rDoc, aRange ); aExport.SetExportTextOptions( ScExportTextOptions( ScExportTextOptions::None, 0, false ) ); // #i87703# text to columns fails with tab separator aExport.SetDelimiter( u'\0' ); // The stream must outlive the (async) dialog, so keep it in a shared_ptr // that the callback captures. auto pStream = std::make_shared(); pStream->SetStreamEncoding( RTL_TEXTENCODING_UNICODE ); pStream->ResetEndianSwap(); aExport.ExportStream( *pStream, OUString(), SotClipboardFormatId::STRING ); pStream->Seek(0); ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create(); VclPtr pDlg(pFact->CreateScImportAsciiDlg( pTabViewShell->GetFrameWeld(), OUString(), pStream.get(), SC_TEXTTOCOLUMNS)); ScDocShell* pDocSh = rData.GetDocShell(); const ViewShellId nViewShellId = rData.GetViewShell()->GetViewShellId(); pDlg->StartExecuteAsync( [pDlg, pStream, pDocSh, aRange, nViewShellId](sal_Int32 nResult) { if ( nResult == RET_OK ) { ScDocument& rImportDoc = pDocSh->GetDocument(); OUString aUndo = ScResId( STR_UNDO_TEXTTOCOLUMNS ); pDocSh->GetUndoManager()->EnterListAction( aUndo, aUndo, 0, nViewShellId ); ScImportExport aImport( rImportDoc, aRange.aStart ); ScAsciiOptions aOptions; pDlg->GetOptions( aOptions ); pDlg->SaveParameters(); aImport.SetExtOptions( aOptions ); aImport.SetApi( false ); aImport.SetImportBroadcast( true ); aImport.SetOverwriting( true ); pStream->Seek( 0 ); aImport.ImportStream( *pStream, OUString(), SotClipboardFormatId::STRING ); pDocSh->GetUndoManager()->LeaveListAction(); } pDlg->disposeOnce(); }); } } break; } } void ScCellShell::GetDBState( SfxItemSet& rSet ) { ScTabViewShell* pTabViewShell = GetViewData().GetViewShell(); ScViewData& rData = GetViewData(); ScDocShell* pDocSh = rData.GetDocShell(); ScDocument& rDoc = pDocSh->GetDocument(); SCCOL nPosX = rData.GetCurX(); SCROW nPosY = rData.GetCurY(); SCTAB nTab = rData.CurrentTabForData(); bool bAutoFilter = false; bool bAutoFilterTested = false; SfxWhichIter aIter(rSet); sal_uInt16 nWhich = aIter.FirstWhich(); while (nWhich) { switch (nWhich) { case SID_REFRESH_DBAREA: { // imported data without selection // or filter,sort,subtotal (also without import) bool bOk = false; ScDBData* pDBData = pTabViewShell->GetDBData(false,SC_DB_OLD); if (pDBData && rDoc.GetChangeTrack() == nullptr) { if ( pDBData->HasImportParam() ) bOk = !pDBData->HasImportSelection(); else { bOk = pDBData->HasQueryParam() || pDBData->HasSortParam() || pDBData->HasSubTotalParam(); } } if (!bOk) rSet.DisableItem( nWhich ); } break; case SID_FILTER: case SID_SPECIAL_FILTER: { const ScTableProtection* pTabProt = rDoc.GetTabProtection(nTab); if (pTabProt && pTabProt->isProtected() && !pTabProt->isOptionEnabled(ScTableProtection::AUTOFILTER)) { rSet.DisableItem(nWhich); } else { ScRange aDummy; ScMarkType eMarkType = GetViewData().GetSimpleArea(aDummy); if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED) { rSet.DisableItem(nWhich); } } } break; //in case of Redlining and multiselection disable case SID_SORT_ASCENDING: case SID_SORT_DESCENDING: case SCITEM_SORTDATA: case SCITEM_SUBTDATA: case SID_OPENDLG_PIVOTTABLE: { //! move ReadOnly check to idl flags if ( pDocSh->IsReadOnly() || rDoc.GetChangeTrack()!=nullptr || GetViewData().IsMultiMarked() ) { rSet.DisableItem( nWhich ); } else { if (nWhich == SID_OPENDLG_PIVOTTABLE) { const ScTableProtection* pTabProt = rDoc.GetTabProtection(nTab); if (pTabProt && pTabProt->isProtected() && !pTabProt->isOptionEnabled(ScTableProtection::PIVOT_TABLES)) { rSet.DisableItem(nWhich); } } else if (nWhich == SCITEM_SUBTDATA) { // Disable if table style is applied (same as MSO) ScDBData* pDBData = pTabViewShell->GetDBData(false, SC_DB_OLD); if (pDBData && pDBData->GetTableStyleInfo()) { rSet.DisableItem(nWhich); } } } } break; case SID_REIMPORT_DATA: { // only imported data without selection ScDBData* pDBData = pTabViewShell->GetDBData(false,SC_DB_OLD); if (!pDBData || !pDBData->HasImportParam() || pDBData->HasImportSelection() || rDoc.GetChangeTrack()!=nullptr) { rSet.DisableItem( nWhich ); } } break; case SID_VIEW_DATA_SOURCE_BROWSER: { if (!SvtModuleOptions().IsDataBaseInstalled()) rSet.Put(SfxVisibilityItem(nWhich, false)); else // get state (BoolItem) from SfxViewFrame pTabViewShell->GetViewFrame().GetSlotState( nWhich, nullptr, &rSet ); } break; case SID_SBA_BRW_INSERT: { // SBA wants a bool-item, enabled rSet.Put(SfxBoolItem(nWhich, true)); } break; case SID_AUTO_FILTER: case SID_AUTOFILTER_HIDE: { const ScTableProtection* pTabProt = rDoc.GetTabProtection(nTab); if (pTabProt && pTabProt->isProtected() && !pTabProt->isOptionEnabled(ScTableProtection::AUTOFILTER)) { rSet.DisableItem(nWhich); } else { if (!bAutoFilterTested) { bAutoFilter = rDoc.HasAutoFilter(nPosX, nPosY, nTab); bAutoFilterTested = true; } if (nWhich == SID_AUTO_FILTER) { ScRange aDummy; ScMarkType eMarkType = GetViewData().GetSimpleArea(aDummy); if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED) { rSet.DisableItem(nWhich); } else if (rDoc.GetDPAtBlock(aDummy)) { rSet.DisableItem(nWhich); } else rSet.Put(SfxBoolItem(nWhich, bAutoFilter)); } else if (!bAutoFilter) rSet.DisableItem(nWhich); } } break; case SID_UNFILTER: { SCCOL nStartCol, nEndCol; SCROW nStartRow, nEndRow; SCTAB nStartTab, nEndTab; bool bAnyQuery = false; bool bSelected = (GetViewData().GetSimpleArea( nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nEndTab ) == SC_MARK_SIMPLE); if ( bSelected ) { if (nStartCol==nEndCol && nStartRow==nEndRow) bSelected = false; } else { nStartCol = GetViewData().GetCurX(); nStartRow = GetViewData().GetCurY(); nStartTab = GetViewData().CurrentTabForData(); } ScDBData* pDBData = bSelected ? rDoc.GetDBAtArea( nStartTab, nStartCol, nStartRow, nEndCol, nEndRow ) : rDoc.GetDBAtCursor( nStartCol, nStartRow, nStartTab, ScDBDataPortion::AREA ); if ( pDBData ) { ScQueryParam aParam; pDBData->GetQueryParam( aParam ); if ( aParam.GetEntry(0).bDoQuery ) bAnyQuery = true; } if ( !bAnyQuery ) rSet.DisableItem( nWhich ); } break; case SID_CLEAR_AUTO_FILTER: { const ScTableProtection* pTabProt = rDoc.GetTabProtection(nTab); if (pTabProt && pTabProt->isProtected() && !pTabProt->isOptionEnabled(ScTableProtection::AUTOFILTER)) { rSet.DisableItem(nWhich); } else { if (!bAutoFilterTested) { bAutoFilter = rDoc.HasAutoFilter(nPosX, nPosY, nTab); bAutoFilterTested = true; } SCCOL nStartCol = GetViewData().GetCurX(); SCROW nStartRow = GetViewData().GetCurY(); SCTAB nStartTab = GetViewData().CurrentTabForData(); bool bAnyQuery = false; ScQueryParam aParam; ScDBData* pDBData = rDoc.GetDBAtCursor( nStartCol, nStartRow, nStartTab, ScDBDataPortion::AREA ); if(pDBData) { pDBData->GetQueryParam(aParam); std::vector aEntries = aParam.FindAllEntriesByField(nStartCol); if(aEntries.size()) { bAnyQuery = true; } } if(!bAutoFilter || !bAnyQuery) rSet.DisableItem(nWhich); } } break; case SID_DEFINE_DBNAME: { if ( pDocSh->IsDocShared() ) { rSet.DisableItem( nWhich ); } } break; case SID_INSERT_CALCTABLE: { bool bDisable = false; if (!rDoc.HasTableStyles() || pDocSh->IsDocShared()) bDisable = true; else { SCCOL nStartCol, nEndCol; SCROW nStartRow, nEndRow; SCTAB nStartTab, nEndTab; bool bSelected = (GetViewData().GetSimpleArea(nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nEndTab) == SC_MARK_SIMPLE); if (bSelected) { if (nStartCol == nEndCol && nStartRow == nEndRow) bSelected = false; } else { nStartCol = GetViewData().GetCurX(); nStartRow = GetViewData().GetCurY(); nStartTab = GetViewData().CurrentTabForData(); } if (!bSelected) { if (rDoc.GetTableDBAtCursor(nStartCol, nStartRow, nStartTab, ScDBDataPortion::AREA) || rDoc.HasDataPilotAtPosition(ScAddress(nStartCol, nStartRow, nStartTab))) { bDisable = true; } } else { ScRange aRange(nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nStartTab); if (rDoc.GetDPAtBlock(aRange)) { bDisable = true; } else { std::vector aDBData = rDoc.GetAllNamedDBsInArea(aRange); for (const ScDBData* pDBData : aDBData) { if (pDBData->GetTableStyleInfo()) { bDisable = true; break; } } } } // Check if the selected cell range is protected if (!bDisable) { const SCCOL nTestEndCol = bSelected ? nEndCol : nStartCol; const SCROW nTestEndRow = bSelected ? nEndRow : nStartRow; ScEditableTester aTester = ScEditableTester::CreateAndTestBlock( rDoc, nStartTab, nStartCol, nStartRow, nTestEndCol, nTestEndRow); if (!aTester.IsEditable()) bDisable = true; } } if (bDisable) rSet.DisableItem( nWhich ); } break; case SID_DATA_PROVIDER: break; case SID_DATA_PROVIDER_REFRESH: { ScDocument& rViewDoc = GetViewData().GetDocument(); auto& rDataMapper = rViewDoc.GetExternalDataMapper(); if (rDataMapper.getDataSources().empty()) rSet.DisableItem(nWhich); } break; case SID_DATA_STREAMS: case SID_DATA_STREAMS_PLAY: case SID_DATA_STREAMS_STOP: { if ( !officecfg::Office::Common::Misc::ExperimentalMode::get() ) rSet.DisableItem( nWhich ); } break; case SID_TEXT_TO_COLUMNS: { ScRange aRange; if ( !lcl_GetTextToColumnsRange( rData, aRange, true ) ) { rSet.DisableItem( nWhich ); } } break; case SID_MANAGE_XML_SOURCE: break; } nWhich = aIter.NextWhich(); } } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */