diff options
Diffstat (limited to 'sc/source/ui/dbgui/sfiltdlg.cxx')
| -rw-r--r-- | sc/source/ui/dbgui/sfiltdlg.cxx | 437 |
1 files changed, 437 insertions, 0 deletions
diff --git a/sc/source/ui/dbgui/sfiltdlg.cxx b/sc/source/ui/dbgui/sfiltdlg.cxx new file mode 100644 index 000000000..b482588fb --- /dev/null +++ b/sc/source/ui/dbgui/sfiltdlg.cxx @@ -0,0 +1,437 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice 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 <sfx2/dispatch.hxx> + +#include <uiitems.hxx> +#include <rangenam.hxx> +#include <reffact.hxx> +#include <viewdata.hxx> +#include <document.hxx> +#include <docsh.hxx> +#include <scresid.hxx> + +#include <foptmgr.hxx> + +#include <globstr.hrc> +#include <strings.hrc> + +#include <filtdlg.hxx> +#include <vcl/idle.hxx> +#include <vcl/svapp.hxx> +#include <vcl/weld.hxx> + +// DEFINE -------------------------------------------------------------------- + +namespace +{ + void ERRORBOX(weld::Window* pParent, const char* rid) + { + std::unique_ptr<weld::MessageDialog> xBox(Application::CreateMessageDialog(pParent, + VclMessageType::Warning, VclButtonsType::Ok, + ScResId(rid))); + xBox->run(); + } +} + + +ScSpecialFilterDlg::ScSpecialFilterDlg( SfxBindings* pB, SfxChildWindow* pCW, weld::Window* pParent, + const SfxItemSet& rArgSet ) + + : ScAnyRefDlgController(pB, pCW, pParent, "modules/scalc/ui/advancedfilterdialog.ui", "AdvancedFilterDialog") + , aStrUndefined ( ScResId(SCSTR_UNDEFINED) ) + , nWhichQuery ( rArgSet.GetPool()->GetWhich( SID_QUERY ) ) + , theQueryData ( static_cast<const ScQueryItem&>( + rArgSet.Get( nWhichQuery )).GetQueryData() ) + , pViewData(nullptr) + , pDoc(nullptr) + , bRefInputMode(false) + , m_pRefInputEdit(nullptr) + , m_xLbFilterArea(m_xBuilder->weld_combo_box("lbfilterarea")) + , m_xEdFilterArea(new formula::RefEdit(m_xBuilder->weld_entry("edfilterarea"))) + , m_xRbFilterArea(new formula::RefButton(m_xBuilder->weld_button("rbfilterarea"))) + , m_xExpander(m_xBuilder->weld_expander("more")) + , m_xBtnCase(m_xBuilder->weld_check_button("case")) + , m_xBtnRegExp(m_xBuilder->weld_check_button("regexp")) + , m_xBtnHeader(m_xBuilder->weld_check_button("header")) + , m_xBtnUnique(m_xBuilder->weld_check_button("unique")) + , m_xBtnCopyResult(m_xBuilder->weld_check_button("copyresult")) + , m_xLbCopyArea(m_xBuilder->weld_combo_box("lbcopyarea")) + , m_xEdCopyArea(new formula::RefEdit(m_xBuilder->weld_entry("edcopyarea"))) + , m_xRbCopyArea(new formula::RefButton(m_xBuilder->weld_button("rbcopyarea"))) + , m_xBtnDestPers(m_xBuilder->weld_check_button("destpers")) + , m_xFtDbAreaLabel(m_xBuilder->weld_label("dbarealabel")) + , m_xFtDbArea(m_xBuilder->weld_label("dbarea")) + , m_xBtnOk(m_xBuilder->weld_button("ok")) + , m_xBtnCancel(m_xBuilder->weld_button("cancel")) + , m_xFilterFrame(m_xBuilder->weld_frame("filterframe")) + , m_xFilterLabel(m_xFilterFrame->weld_label_widget()) +{ + m_xEdFilterArea->SetReferences(this, m_xFilterLabel.get()); + m_xRbFilterArea->SetReferences(this, m_xEdFilterArea.get()); + m_xEdCopyArea->SetReferences(this, m_xFtDbAreaLabel.get()); + m_xRbCopyArea->SetReferences(this, m_xEdCopyArea.get()); + + Init( rArgSet ); + + Link<formula::RefEdit&, void> aLinkEdit = LINK(this, ScSpecialFilterDlg, RefInputEditHdl); + Link<formula::RefButton&, void> aLinkButton = LINK(this, ScSpecialFilterDlg, RefInputButtonHdl); + m_xEdCopyArea->SetGetFocusHdl(aLinkEdit); + m_xRbCopyArea->SetGetFocusHdl(aLinkButton); + m_xEdFilterArea->SetGetFocusHdl(aLinkEdit); + m_xRbFilterArea->SetGetFocusHdl(aLinkButton); + m_xEdCopyArea->SetLoseFocusHdl(aLinkEdit); + m_xRbCopyArea->SetLoseFocusHdl(aLinkButton); + m_xEdFilterArea->SetLoseFocusHdl(aLinkEdit); + m_xRbFilterArea->SetLoseFocusHdl(aLinkButton); + + m_xEdFilterArea->GrabFocus(); +} + +ScSpecialFilterDlg::~ScSpecialFilterDlg() +{ + pOptionsMgr.reset(); + + pOutItem.reset(); +} + +void ScSpecialFilterDlg::Init( const SfxItemSet& rArgSet ) +{ + const ScQueryItem& rQueryItem = static_cast<const ScQueryItem&>( + rArgSet.Get( nWhichQuery )); + + m_xBtnOk->connect_clicked( LINK( this, ScSpecialFilterDlg, EndDlgHdl ) ); + m_xBtnCancel->connect_clicked( LINK( this, ScSpecialFilterDlg, EndDlgHdl ) ); + m_xLbFilterArea->connect_changed( LINK( this, ScSpecialFilterDlg, FilterAreaSelHdl ) ); + m_xEdFilterArea->SetModifyHdl ( LINK( this, ScSpecialFilterDlg, FilterAreaModHdl ) ); + + pViewData = rQueryItem.GetViewData(); + pDoc = pViewData ? pViewData->GetDocument() : nullptr; + + m_xEdFilterArea->SetText( EMPTY_OUSTRING ); // may be overwritten below + + if ( pViewData && pDoc ) + { + if(pDoc->GetChangeTrack()!=nullptr) m_xBtnCopyResult->set_sensitive(false); + + ScRangeName* pRangeNames = pDoc->GetRangeName(); + m_xLbFilterArea->clear(); + m_xLbFilterArea->append_text(aStrUndefined); + + for (const auto& rEntry : *pRangeNames) + { + if (!rEntry.second->HasType(ScRangeData::Type::Criteria)) + continue; + + OUString aSymbol; + rEntry.second->GetSymbol(aSymbol); + m_xLbFilterArea->append(aSymbol, rEntry.second->GetName()); + } + + // is there a stored source range? + + ScRange aAdvSource; + if (rQueryItem.GetAdvancedQuerySource(aAdvSource)) + { + OUString aRefStr(aAdvSource.Format(*pDoc, ScRefFlags::RANGE_ABS_3D, pDoc->GetAddressConvention())); + m_xEdFilterArea->SetRefString( aRefStr ); + } + } + + m_xLbFilterArea->set_active( 0 ); + + // let options be initialized: + + pOptionsMgr.reset( new ScFilterOptionsMgr( + pViewData, + theQueryData, + m_xBtnCase.get(), + m_xBtnRegExp.get(), + m_xBtnHeader.get(), + m_xBtnUnique.get(), + m_xBtnCopyResult.get(), + m_xBtnDestPers.get(), + m_xLbCopyArea.get(), + m_xEdCopyArea.get(), + m_xRbCopyArea.get(), + m_xFtDbAreaLabel.get(), + m_xFtDbArea.get(), + aStrUndefined ) ); + + // special filter always needs column headers + m_xBtnHeader->set_active(true); + m_xBtnHeader->set_sensitive(false); + + // turn on modal mode + // SetDispatcherLock( true ); + //@BugID 54702 enable/disable in base class only + //SFX_APPWINDOW->Disable(false); //! general method in ScAnyRefDlg +} + +void ScSpecialFilterDlg::Close() +{ + if (pViewData) + pViewData->GetDocShell()->CancelAutoDBRange(); + + DoClose( ScSpecialFilterDlgWrapper::GetChildWindowId() ); +} + +// Transfer of a table area selected with the mouse, which is then displayed +// as a new selection in the reference edit. + +void ScSpecialFilterDlg::SetReference( const ScRange& rRef, ScDocument& rDocP ) +{ + if ( bRefInputMode && m_pRefInputEdit ) // only possible if in the reference edit mode + { + if ( rRef.aStart != rRef.aEnd ) + RefInputStart( m_pRefInputEdit ); + + OUString aRefStr; + const formula::FormulaGrammar::AddressConvention eConv = rDocP.GetAddressConvention(); + + if (m_pRefInputEdit == m_xEdCopyArea.get()) + aRefStr = rRef.aStart.Format(ScRefFlags::ADDR_ABS_3D, &rDocP, eConv); + else if (m_pRefInputEdit == m_xEdFilterArea.get()) + aRefStr = rRef.Format(rDocP, ScRefFlags::RANGE_ABS_3D, eConv); + + m_pRefInputEdit->SetRefString( aRefStr ); + } +} + +void ScSpecialFilterDlg::SetActive() +{ + if ( bRefInputMode ) + { + if (m_pRefInputEdit == m_xEdCopyArea.get()) + { + m_xEdCopyArea->GrabFocus(); + m_xEdCopyArea->GetModifyHdl().Call( *m_xEdCopyArea ); + } + else if (m_pRefInputEdit == m_xEdFilterArea.get()) + { + m_xEdFilterArea->GrabFocus(); + FilterAreaModHdl( *m_xEdFilterArea ); + } + } + else + m_xDialog->grab_focus(); + + RefInputDone(); +} + +ScQueryItem* ScSpecialFilterDlg::GetOutputItem( const ScQueryParam& rParam, + const ScRange& rSource ) +{ + pOutItem.reset(new ScQueryItem( nWhichQuery, &rParam )); + pOutItem->SetAdvancedQuerySource( &rSource ); + return pOutItem.get(); +} + +bool ScSpecialFilterDlg::IsRefInputMode() const +{ + return bRefInputMode; +} + +// Handler: + +IMPL_LINK(ScSpecialFilterDlg, EndDlgHdl, weld::Button&, rBtn, void) +{ + OSL_ENSURE( pDoc && pViewData, "Document or ViewData not found. :-/" ); + + if (&rBtn == m_xBtnOk.get() && pDoc && pViewData) + { + OUString theCopyStr( m_xEdCopyArea->GetText() ); + OUString theAreaStr( m_xEdFilterArea->GetText() ); + ScQueryParam theOutParam( theQueryData ); + ScAddress theAdrCopy; + bool bEditInputOk = true; + bool bQueryOk = false; + ScRange theFilterArea; + const formula::FormulaGrammar::AddressConvention eConv = pDoc->GetAddressConvention(); + + if ( m_xBtnCopyResult->get_active() ) + { + sal_Int32 nColonPos = theCopyStr.indexOf( ':' ); + + if ( -1 != nColonPos ) + theCopyStr = theCopyStr.copy( 0, nColonPos ); + + ScRefFlags nResult = theAdrCopy.Parse( theCopyStr, pDoc, eConv ); + + if ( (nResult & ScRefFlags::VALID) == ScRefFlags::ZERO ) + { + if (!m_xExpander->get_expanded()) + m_xExpander->set_expanded(true); + + ERRORBOX(m_xDialog.get(), STR_INVALID_TABREF); + m_xEdCopyArea->GrabFocus(); + bEditInputOk = false; + } + } + + if ( bEditInputOk ) + { + ScRefFlags nResult = ScRange().Parse( theAreaStr, pDoc, eConv ); + + if ( (nResult & ScRefFlags::VALID) == ScRefFlags::ZERO ) + { + ERRORBOX(m_xDialog.get(), STR_INVALID_TABREF); + m_xEdFilterArea->GrabFocus(); + bEditInputOk = false; + } + } + + if ( bEditInputOk ) + { + /* + * All edit fields contain valid areas. Now try to create + * a ScQueryParam from the filter area: + */ + + ScRefFlags nResult = theFilterArea.Parse( theAreaStr, pDoc, eConv ); + + if ( (nResult & ScRefFlags::VALID) == ScRefFlags::VALID ) + { + ScAddress& rStart = theFilterArea.aStart; + ScAddress& rEnd = theFilterArea.aEnd; + + if ( m_xBtnCopyResult->get_active() ) + { + theOutParam.bInplace = false; + theOutParam.nDestTab = theAdrCopy.Tab(); + theOutParam.nDestCol = theAdrCopy.Col(); + theOutParam.nDestRow = theAdrCopy.Row(); + } + else + { + theOutParam.bInplace = true; + theOutParam.nDestTab = 0; + theOutParam.nDestCol = 0; + theOutParam.nDestRow = 0; + } + + theOutParam.bHasHeader = m_xBtnHeader->get_active(); + theOutParam.bByRow = true; + theOutParam.bCaseSens = m_xBtnCase->get_active(); + theOutParam.eSearchType = m_xBtnRegExp->get_active() ? utl::SearchParam::SearchType::Regexp : + utl::SearchParam::SearchType::Normal; + theOutParam.bDuplicate = !m_xBtnUnique->get_active(); + theOutParam.bDestPers = m_xBtnDestPers->get_active(); + + bQueryOk = pDoc->CreateQueryParam(ScRange(rStart,rEnd), theOutParam); + } + } + + if ( bQueryOk ) + { + SetDispatcherLock( false ); + SwitchToDocument(); + GetBindings().GetDispatcher()->ExecuteList(FID_FILTER_OK, + SfxCallMode::SLOT | SfxCallMode::RECORD, + { GetOutputItem(theOutParam, theFilterArea) }); + response(RET_OK); + } + else + { + ERRORBOX(m_xDialog.get(), STR_INVALID_QUERYAREA); + m_xEdFilterArea->GrabFocus(); + } + } + else if (&rBtn == m_xBtnCancel.get()) + { + response(RET_CANCEL); + } +} + +IMPL_LINK_NOARG(ScSpecialFilterDlg, RefInputEditHdl, formula::RefEdit&, void) +{ + RefInputHdl(); +} + +IMPL_LINK_NOARG(ScSpecialFilterDlg, RefInputButtonHdl, formula::RefButton&, void) +{ + RefInputHdl(); +} + +void ScSpecialFilterDlg::RefInputHdl() +{ + if (m_xDialog->has_toplevel_focus()) + { + if( m_xEdCopyArea->GetWidget()->has_focus() || m_xRbCopyArea->GetWidget()->has_focus() ) + { + m_pRefInputEdit = m_xEdCopyArea.get(); + bRefInputMode = true; + } + else if( m_xEdFilterArea->GetWidget()->has_focus() || m_xRbFilterArea->GetWidget()->has_focus() ) + { + m_pRefInputEdit = m_xEdFilterArea.get(); + bRefInputMode = true; + } + else if( bRefInputMode ) + { + m_pRefInputEdit = nullptr; + bRefInputMode = false; + } + } +} + +IMPL_LINK(ScSpecialFilterDlg, FilterAreaSelHdl, weld::ComboBox&, rLb, void) +{ + if (&rLb == m_xLbFilterArea.get()) + { + OUString aString; + const sal_Int32 nSelPos = m_xLbFilterArea->get_active(); + + if ( nSelPos > 0 ) + aString = m_xLbFilterArea->get_id(nSelPos); + + m_xEdFilterArea->SetText( aString ); + } +} + +IMPL_LINK( ScSpecialFilterDlg, FilterAreaModHdl, formula::RefEdit&, rEd, void ) +{ + if (&rEd == m_xEdFilterArea.get()) + { + if ( pDoc && pViewData ) + { + OUString theCurAreaStr = rEd.GetText(); + ScRefFlags nResult = ScRange().Parse( theCurAreaStr, pDoc ); + + if ( (nResult & ScRefFlags::VALID) == ScRefFlags::VALID ) + { + const sal_Int32 nCount = m_xLbFilterArea->get_count(); + for (sal_Int32 i = 1; i < nCount; ++i) + { + OUString aStr = m_xLbFilterArea->get_id(i); + if (theCurAreaStr == aStr) + { + m_xLbFilterArea->set_active( i ); + return; + } + } + m_xLbFilterArea->set_active( 0 ); + } + } + else + m_xLbFilterArea->set_active( 0 ); + } +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |