diff options
author | Csikós Tamás <csks.tomi@gmail.com> | 2013-07-18 18:08:46 +0200 |
---|---|---|
committer | Caolán McNamara <caolanm@redhat.com> | 2013-07-19 11:53:29 +0000 |
commit | 1399a51fd6c2644dd1dc2c79d3448deeacbb2c9d (patch) | |
tree | c99fdd9cc15d10f6e79a7514f893552554eef7b7 /sc | |
parent | d44f14946aecd179fadc9c473f212181a035da1f (diff) |
modern .ui widgetlayout for filtdlg
Change-Id: Ibb6b9111ce718f0513f57373108887f91e3bc569
Reviewed-on: https://gerrit.libreoffice.org/4972
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
Diffstat (limited to 'sc')
-rw-r--r-- | sc/UIConfig_scalc.mk | 1 | ||||
-rw-r--r-- | sc/source/ui/dbgui/filtdlg.cxx | 589 | ||||
-rw-r--r-- | sc/source/ui/dbgui/foptmgr.cxx | 15 | ||||
-rw-r--r-- | sc/source/ui/inc/filtdlg.hxx | 80 | ||||
-rw-r--r-- | sc/source/ui/inc/filter.hrc | 12 | ||||
-rw-r--r-- | sc/source/ui/inc/foptmgr.hxx | 1 | ||||
-rw-r--r-- | sc/source/ui/src/filter.src | 422 | ||||
-rw-r--r-- | sc/uiconfig/scalc/ui/standardfilterdialog.ui | 817 |
8 files changed, 1151 insertions, 786 deletions
diff --git a/sc/UIConfig_scalc.mk b/sc/UIConfig_scalc.mk index 0dc6338086f5..dd6c63ef4e97 100644 --- a/sc/UIConfig_scalc.mk +++ b/sc/UIConfig_scalc.mk @@ -95,6 +95,7 @@ $(eval $(call gb_UIConfig_add_uifiles,modules/scalc,\ sc/uiconfig/scalc/ui/randomnumbergenerator \ sc/uiconfig/scalc/ui/rightfooterdialog \ sc/uiconfig/scalc/ui/rightheaderdialog \ + sc/uiconfig/scalc/ui/standardfilterdialog \ sc/uiconfig/scalc/ui/scgeneralpage \ sc/uiconfig/scalc/ui/selectrange \ sc/uiconfig/scalc/ui/selectsource \ diff --git a/sc/source/ui/dbgui/filtdlg.cxx b/sc/source/ui/dbgui/filtdlg.cxx index 1d6114594d4e..ba88eea33d1a 100644 --- a/sc/source/ui/dbgui/filtdlg.cxx +++ b/sc/source/ui/dbgui/filtdlg.cxx @@ -55,47 +55,8 @@ ScFilterDlg::EntryList::EntryList() : ScFilterDlg::ScFilterDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent, const SfxItemSet& rArgSet ) - : ScAnyRefDlg ( pB, pCW, pParent, RID_SCDLG_FILTER ), + : ScAnyRefDlg ( pB, pCW, pParent, "StandardFilterDialog", "modules/scalc/ui/standardfilterdialog.ui" ), // - aFlCriteria ( this, ScResId( FL_CRITERIA ) ), - aLbConnect1 ( this, ScResId( LB_OP1 ) ), - aLbField1 ( this, ScResId( LB_FIELD1 ) ), - aLbCond1 ( this, ScResId( LB_COND1 ) ), - aEdVal1 ( this, ScResId( ED_VAL1 ) ), - aLbConnect2 ( this, ScResId( LB_OP2 ) ), - aLbField2 ( this, ScResId( LB_FIELD2 ) ), - aLbCond2 ( this, ScResId( LB_COND2 ) ), - aEdVal2 ( this, ScResId( ED_VAL2 ) ), - aLbConnect3 ( this, ScResId( LB_OP3 ) ), - aLbField3 ( this, ScResId( LB_FIELD3 ) ), - aLbCond3 ( this, ScResId( LB_COND3 ) ), - aEdVal3 ( this, ScResId( ED_VAL3 ) ), - aLbConnect4 ( this, ScResId( LB_OP4 ) ), - aLbField4 ( this, ScResId( LB_FIELD4 ) ), - aLbCond4 ( this, ScResId( LB_COND4 ) ), - aEdVal4 ( this, ScResId( ED_VAL4 ) ), - aFtConnect ( this, ScResId( FT_OP ) ), - aFtField ( this, ScResId( FT_FIELD ) ), - aFtCond ( this, ScResId( FT_COND ) ), - aFtVal ( this, ScResId( FT_VAL ) ), - aFlSeparator ( this, ScResId( FL_SEPARATOR ) ), - aScrollBar ( this, ScResId( LB_SCROLL ) ), - aFlOptions ( this, ScResId( FL_OPTIONS ) ), - aBtnMore ( this, ScResId( BTN_MORE ) ), - aBtnHelp ( this, ScResId( BTN_HELP ) ), - aBtnOk ( this, ScResId( BTN_OK ) ), - aBtnCancel ( this, ScResId( BTN_CANCEL ) ), - aBtnCase ( this, ScResId( BTN_CASE ) ), - aBtnRegExp ( this, ScResId( BTN_REGEXP ) ), - aBtnHeader ( this, ScResId( BTN_HEADER ) ), - aBtnUnique ( this, ScResId( BTN_UNIQUE ) ), - aBtnCopyResult ( this, ScResId( BTN_COPY_RESULT ) ), - aLbCopyArea ( this, ScResId( LB_COPY_AREA ) ), - aEdCopyArea ( this, this, NULL, ScResId( ED_COPY_AREA ) ), - aRbCopyArea ( this, ScResId( RB_COPY_AREA ), &aEdCopyArea, this ), - aBtnDestPers ( this, ScResId( BTN_DEST_PERS ) ), - aFtDbAreaLabel ( this, ScResId( FT_DBAREA_LABEL ) ), - aFtDbArea ( this, ScResId( FT_DBAREA ) ), aStrUndefined ( SC_RESSTR(SCSTR_UNDEFINED) ), aStrNone ( SC_RESSTR(SCSTR_NONE) ), aStrEmpty ( SC_RESSTR(SCSTR_FILTER_EMPTY) ), @@ -114,10 +75,40 @@ ScFilterDlg::ScFilterDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent, bRefInputMode ( false ), pTimer ( NULL ) { - aBtnMore.SetMoreText( String(ScResId( SCSTR_MOREBTN_MOREOPTIONS )) ); - aBtnMore.SetLessText( String(ScResId( SCSTR_MOREBTN_FEWEROPTIONS )) ); + get(pLbConnect1,"connect1"); + get(pLbField1,"field1"); + get(pLbCond1,"cond1"); + get(pEdVal1,"val1"); + get(pLbConnect2,"connect2"); + get(pLbField2,"field2"); + get(pLbCond2,"cond2"); + get(pEdVal2,"val2"); + get(pLbConnect3,"connect3"); + get(pLbField3,"field3"); + get(pLbCond3,"cond3"); + get(pEdVal3,"val3"); + get(pLbConnect4,"connect4"); + get(pLbField4,"field4"); + get(pLbCond4,"cond4"); + get(pEdVal4,"val4"); + get(pScrollBar,"scrollbar"); + get(pExpander,"more"); + get(pBtnOk,"ok"); + get(pBtnCancel,"cancel"); + get(pBtnCase,"case"); + get(pBtnRegExp,"regexp"); + get(pBtnHeader,"header"); + get(pBtnUnique,"unique"); + get(pBtnCopyResult,"copyresult"); + get(pLbCopyArea,"lbcopyarea"); + get(pEdCopyArea,"edcopyarea"); + get(pRbCopyArea,"rbcopyarea"); + pRbCopyArea->SetReferences(this, pEdCopyArea); + get(pBtnDestPers,"destpers"); + get(pFtDbAreaLabel,"dbarealabel"); + get(pFtDbArea,"dbarea"); + Init( rArgSet ); - FreeResource(); // Hack: RefInput control pTimer = new Timer; @@ -129,60 +120,47 @@ ScFilterDlg::ScFilterDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent, OUString sAccName = SC_RESSTR(RID_FILTER_OPERATOR); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 1")); - aLbConnect1.SetAccessibleName(aBuf.makeStringAndClear()); + pLbConnect1->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 2")); - aLbConnect2.SetAccessibleName(aBuf.makeStringAndClear()); + pLbConnect2->SetAccessibleName(aBuf.makeStringAndClear()); sAccName = SC_RESSTR(RID_FILTER_FIELDNAME); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 1")); - aLbField1.SetAccessibleName(aBuf.makeStringAndClear()); + pLbField1->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 2")); - aLbField2.SetAccessibleName(aBuf.makeStringAndClear()); + pLbField2->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 3")); - aLbField3.SetAccessibleName(aBuf.makeStringAndClear()); + pLbField3->SetAccessibleName(aBuf.makeStringAndClear()); sAccName = SC_RESSTR(RID_FILTER_CONDITION); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 1")); - aLbCond1.SetAccessibleName(aBuf.makeStringAndClear()); + pLbCond1->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 2")); - aLbCond2.SetAccessibleName(aBuf.makeStringAndClear()); + pLbCond2->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 3")); - aLbCond3.SetAccessibleName(aBuf.makeStringAndClear()); + pLbCond3->SetAccessibleName(aBuf.makeStringAndClear()); sAccName = SC_RESSTR(RID_FILTER_VALUE); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 1")); - aEdVal1.SetAccessibleName(aBuf.makeStringAndClear()); + pEdVal1->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 2")); - aEdVal2.SetAccessibleName(aBuf.makeStringAndClear()); + pEdVal2->SetAccessibleName(aBuf.makeStringAndClear()); aBuf.append(sAccName); aBuf.appendAscii(RTL_CONSTASCII_STRINGPARAM (" 3")); - aEdVal3.SetAccessibleName(aBuf.makeStringAndClear()); - - aLbCopyArea.SetAccessibleName(ScResId(STR_COPY_AREA_TO)); - aEdCopyArea.SetAccessibleName(ScResId(STR_COPY_AREA_TO)); - aLbCopyArea.SetAccessibleRelationLabeledBy(&aBtnCopyResult); - aEdCopyArea.SetAccessibleRelationLabeledBy(&aBtnCopyResult); - - aLbConnect1.SetAccessibleRelationLabeledBy(&aFtConnect); - aLbConnect2.SetAccessibleRelationLabeledBy(&aFtConnect); - aLbField1.SetAccessibleRelationLabeledBy(&aFtField); - aLbField2.SetAccessibleRelationLabeledBy(&aFtField); - aLbField3.SetAccessibleRelationLabeledBy(&aFtField); - aLbCond1.SetAccessibleRelationLabeledBy(&aFtCond); - aLbCond2.SetAccessibleRelationLabeledBy(&aFtCond); - aLbCond3.SetAccessibleRelationLabeledBy(&aFtCond); - aEdVal1.SetAccessibleRelationLabeledBy(&aFtVal); - aEdVal2.SetAccessibleRelationLabeledBy(&aFtVal); - aEdVal3.SetAccessibleRelationLabeledBy(&aFtVal); + pEdVal3->SetAccessibleName(aBuf.makeStringAndClear()); + + pLbCopyArea->SetAccessibleName(ScResId(STR_COPY_AREA_TO)); + pEdCopyArea->SetAccessibleName(ScResId(STR_COPY_AREA_TO)); + } @@ -206,72 +184,69 @@ void ScFilterDlg::Init( const SfxItemSet& rArgSet ) const ScQueryItem& rQueryItem = (const ScQueryItem&) rArgSet.Get( nWhichQuery ); - aBtnOk.SetClickHdl ( LINK( this, ScFilterDlg, EndDlgHdl ) ); - aBtnCancel.SetClickHdl ( LINK( this, ScFilterDlg, EndDlgHdl ) ); - aBtnMore.SetClickHdl ( LINK( this, ScFilterDlg, MoreClickHdl ) ); - aBtnHeader.SetClickHdl ( LINK( this, ScFilterDlg, CheckBoxHdl ) ); - aBtnCase.SetClickHdl ( LINK( this, ScFilterDlg, CheckBoxHdl ) ); + pBtnOk->SetClickHdl ( LINK( this, ScFilterDlg, EndDlgHdl ) ); + pBtnCancel->SetClickHdl ( LINK( this, ScFilterDlg, EndDlgHdl ) ); + pBtnHeader->SetClickHdl ( LINK( this, ScFilterDlg, CheckBoxHdl ) ); + pBtnCase->SetClickHdl ( LINK( this, ScFilterDlg, CheckBoxHdl ) ); // - aLbField1.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbField2.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbField3.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbField4.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbConnect1.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbConnect2.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbConnect3.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbConnect4.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - - aLbCond1.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbCond2.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbCond3.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); - aLbCond4.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbField1->SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbField2->SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbField3->SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbField4->SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbConnect1->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbConnect2->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbConnect3->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbConnect4->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + + pLbCond1->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbCond2->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbCond3->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); + pLbCond4->SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) ); pViewData = rQueryItem.GetViewData(); pDoc = pViewData ? pViewData->GetDocument() : NULL; nSrcTab = pViewData ? pViewData->GetTabNo() : static_cast<SCTAB>(0); + + // for easier access: maFieldLbArr.reserve(QUERY_ENTRY_COUNT); - maFieldLbArr.push_back(&aLbField1); - maFieldLbArr.push_back(&aLbField2); - maFieldLbArr.push_back(&aLbField3); - maFieldLbArr.push_back(&aLbField4); + maFieldLbArr.push_back(pLbField1); + maFieldLbArr.push_back(pLbField2); + maFieldLbArr.push_back(pLbField3); + maFieldLbArr.push_back(pLbField4); maValueEdArr.reserve(QUERY_ENTRY_COUNT); - maValueEdArr.push_back(&aEdVal1); - maValueEdArr.push_back(&aEdVal2); - maValueEdArr.push_back(&aEdVal3); - maValueEdArr.push_back(&aEdVal4); + maValueEdArr.push_back(pEdVal1); + maValueEdArr.push_back(pEdVal2); + maValueEdArr.push_back(pEdVal3); + maValueEdArr.push_back(pEdVal4); maCondLbArr.reserve(QUERY_ENTRY_COUNT); - maCondLbArr.push_back(&aLbCond1); - maCondLbArr.push_back(&aLbCond2); - maCondLbArr.push_back(&aLbCond3); - maCondLbArr.push_back(&aLbCond4); + maCondLbArr.push_back(pLbCond1); + maCondLbArr.push_back(pLbCond2); + maCondLbArr.push_back(pLbCond3); + maCondLbArr.push_back(pLbCond4); maConnLbArr.reserve(QUERY_ENTRY_COUNT); - maConnLbArr.push_back(&aLbConnect1); - maConnLbArr.push_back(&aLbConnect2); - maConnLbArr.push_back(&aLbConnect3); - maConnLbArr.push_back(&aLbConnect4); + maConnLbArr.push_back(pLbConnect1); + maConnLbArr.push_back(pLbConnect2); + maConnLbArr.push_back(pLbConnect3); + maConnLbArr.push_back(pLbConnect4); // Option initialization: - - pOptionsMgr = new ScFilterOptionsMgr( + pOptionsMgr = new ScNewFilterOptionsMgr( pViewData, theQueryData, - aBtnMore, - aBtnCase, - aBtnRegExp, - aBtnHeader, - aBtnUnique, - aBtnCopyResult, - aBtnDestPers, - aLbCopyArea, - aEdCopyArea, - aRbCopyArea, - aFtDbAreaLabel, - aFtDbArea, - aFlOptions, + pBtnCase, + pBtnRegExp, + pBtnHeader, + pBtnUnique, + pBtnCopyResult, + pBtnDestPers, + pLbCopyArea, + pEdCopyArea, + pRbCopyArea, + pFtDbAreaLabel, + pFtDbArea, aStrUndefined ); - // Read in field lists and select entries FillFieldLists(); @@ -344,71 +319,71 @@ void ScFilterDlg::Init( const SfxItemSet& rArgSet ) UpdateValueList(i+1); } - aScrollBar.SetEndScrollHdl( LINK( this, ScFilterDlg, ScrollHdl ) ); - aScrollBar.SetScrollHdl( LINK( this, ScFilterDlg, ScrollHdl ) ); + pScrollBar->SetEndScrollHdl( LINK( this, ScFilterDlg, ScrollHdl ) ); + pScrollBar->SetScrollHdl( LINK( this, ScFilterDlg, ScrollHdl ) ); - aScrollBar.SetRange( Range( 0, 4 ) ); - aScrollBar.SetLineSize( 1 ); - aLbConnect1.Hide(); + pScrollBar->SetRange( Range( 0, 4 ) ); + pScrollBar->SetLineSize( 1 ); + pLbConnect1->Hide(); // Disable/Enable Logic: - (aLbField1.GetSelectEntryPos() != 0) - && (aLbField2.GetSelectEntryPos() != 0) - ? aLbConnect2.SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(1).eConnect ) - : aLbConnect2.SetNoSelection(); - - (aLbField2.GetSelectEntryPos() != 0) - && (aLbField3.GetSelectEntryPos() != 0) - ? aLbConnect3.SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(2).eConnect ) - : aLbConnect3.SetNoSelection(); - - (aLbField3.GetSelectEntryPos() != 0) - && (aLbField4.GetSelectEntryPos() != 0) - ? aLbConnect4.SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(3).eConnect ) - : aLbConnect4.SetNoSelection(); - if ( aLbField1.GetSelectEntryPos() == 0 ) + (pLbField1->GetSelectEntryPos() != 0) + && (pLbField2->GetSelectEntryPos() != 0) + ? pLbConnect2->SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(1).eConnect ) + : pLbConnect2->SetNoSelection(); + + (pLbField2->GetSelectEntryPos() != 0) + && (pLbField3->GetSelectEntryPos() != 0) + ? pLbConnect3->SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(2).eConnect ) + : pLbConnect3->SetNoSelection(); + + (pLbField3->GetSelectEntryPos() != 0) + && (pLbField4->GetSelectEntryPos() != 0) + ? pLbConnect4->SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(3).eConnect ) + : pLbConnect4->SetNoSelection(); + if ( pLbField1->GetSelectEntryPos() == 0 ) { - aLbConnect2.Disable(); - aLbField2.Disable(); - aLbCond2.Disable(); - aEdVal2.Disable(); + pLbConnect2->Disable(); + pLbField2->Disable(); + pLbCond2->Disable(); + pEdVal2->Disable(); } - else if ( aLbConnect2.GetSelectEntryCount() == 0 ) + else if ( pLbConnect2->GetSelectEntryCount() == 0 ) { - aLbField2.Disable(); - aLbCond2.Disable(); - aEdVal2.Disable(); + pLbField2->Disable(); + pLbCond2->Disable(); + pEdVal2->Disable(); } - if ( aLbField2.GetSelectEntryPos() == 0 ) + if ( pLbField2->GetSelectEntryPos() == 0 ) { - aLbConnect3.Disable(); - aLbField3.Disable(); - aLbCond3.Disable(); - aEdVal3.Disable(); + pLbConnect3->Disable(); + pLbField3->Disable(); + pLbCond3->Disable(); + pEdVal3->Disable(); } - else if ( aLbConnect3.GetSelectEntryCount() == 0 ) + else if ( pLbConnect3->GetSelectEntryCount() == 0 ) { - aLbField3.Disable(); - aLbCond3.Disable(); - aEdVal3.Disable(); + pLbField3->Disable(); + pLbCond3->Disable(); + pEdVal3->Disable(); } - if ( aLbField3.GetSelectEntryPos() == 0 ) + if ( pLbField3->GetSelectEntryPos() == 0 ) { - aLbConnect4.Disable(); - aLbField4.Disable(); - aLbCond4.Disable(); - aEdVal4.Disable(); + pLbConnect4->Disable(); + pLbField4->Disable(); + pLbCond4->Disable(); + pEdVal4->Disable(); } - else if ( aLbConnect4.GetSelectEntryCount() == 0 ) + else if ( pLbConnect4->GetSelectEntryCount() == 0 ) { - aLbField4.Disable(); - aLbCond4.Disable(); - aEdVal4.Disable(); + pLbField4->Disable(); + pLbCond4->Disable(); + pEdVal4->Disable(); } if(pDoc!=NULL && - pDoc->GetChangeTrack()!=NULL) aBtnCopyResult.Disable(); + pDoc->GetChangeTrack()!=NULL) pBtnCopyResult->Disable(); // Switch on modal mode // SetDispatcherLock( true ); //@BugID 54702 Enable/disable only in Basic class @@ -436,10 +411,10 @@ void ScFilterDlg::SetReference( const ScRange& rRef, ScDocument* pDocP ) if ( bRefInputMode ) // Only possible if in reference edit mode { if ( rRef.aStart != rRef.aEnd ) - RefInputStart( &aEdCopyArea ); + RefInputStart( pEdCopyArea ); OUString aRefStr; rRef.aStart.Format( aRefStr, SCA_ABS_3D, pDocP, pDocP->GetAddressConvention() ); - aEdCopyArea.SetRefString( aRefStr ); + pEdCopyArea->SetRefString( aRefStr ); } } @@ -450,9 +425,9 @@ void ScFilterDlg::SetActive() { if ( bRefInputMode ) { - aEdCopyArea.GrabFocus(); - if ( aEdCopyArea.GetModifyHdl().IsSet() ) - ((Link&)aEdCopyArea.GetModifyHdl()).Call( &aEdCopyArea ); + pEdCopyArea->GrabFocus(); + if ( pEdCopyArea->GetModifyHdl().IsSet() ) + ((Link&)pEdCopyArea->GetModifyHdl()).Call( pEdCopyArea ); } else GrabFocus(); @@ -464,14 +439,14 @@ void ScFilterDlg::SetActive() void ScFilterDlg::FillFieldLists() { - aLbField1.Clear(); - aLbField2.Clear(); - aLbField3.Clear(); - aLbField4.Clear(); - aLbField1.InsertEntry( aStrNone, 0 ); - aLbField2.InsertEntry( aStrNone, 0 ); - aLbField3.InsertEntry( aStrNone, 0 ); - aLbField4.InsertEntry( aStrNone, 0 ); + pLbField1->Clear(); + pLbField2->Clear(); + pLbField3->Clear(); + pLbField4->Clear(); + pLbField1->InsertEntry( aStrNone, 0 ); + pLbField2->InsertEntry( aStrNone, 0 ); + pLbField3->InsertEntry( aStrNone, 0 ); + pLbField4->InsertEntry( aStrNone, 0 ); if ( pDoc ) { @@ -486,7 +461,7 @@ void ScFilterDlg::FillFieldLists() for ( col=nFirstCol; col<=nMaxCol; col++ ) { aFieldName = pDoc->GetString(col, nFirstRow, nTab); - if (!aBtnHeader.IsChecked() || aFieldName.isEmpty()) + if (!pBtnHeader->IsChecked() || aFieldName.isEmpty()) { OUStringBuffer aBuf; aBuf.append(aStrColumn); @@ -494,10 +469,10 @@ void ScFilterDlg::FillFieldLists() aBuf.append(ScColToAlpha(col)); aFieldName = aBuf.makeStringAndClear(); } - aLbField1.InsertEntry( aFieldName, i ); - aLbField2.InsertEntry( aFieldName, i ); - aLbField3.InsertEntry( aFieldName, i ); - aLbField4.InsertEntry( aFieldName, i ); + pLbField1->InsertEntry( aFieldName, i ); + pLbField2->InsertEntry( aFieldName, i ); + pLbField3->InsertEntry( aFieldName, i ); + pLbField4->InsertEntry( aFieldName, i ); i++; } } @@ -505,7 +480,7 @@ void ScFilterDlg::FillFieldLists() void ScFilterDlg::UpdateValueList( size_t nList ) { - bool bCaseSens = aBtnCase.IsChecked(); + bool bCaseSens = pBtnCase->IsChecked(); if (pDoc && nList > 0 && nList <= QUERY_ENTRY_COUNT) { @@ -629,7 +604,7 @@ void ScFilterDlg::UpdateHdrInValueList( size_t nList ) const OUString& aHdrStr = rHdrEntry.GetString(); bool bWasThere = aHdrStr.equals(pValList->GetEntry(nListPos)); - bool bInclude = !aBtnHeader.IsChecked(); + bool bInclude = !pBtnHeader->IsChecked(); if (bInclude) // Include entry { @@ -676,14 +651,14 @@ ScQueryItem* ScFilterDlg::GetOutputItem() ScQueryParam theParam( theQueryData ); bool bCopyPosOk = false; - if ( aBtnCopyResult.IsChecked() ) + if ( pBtnCopyResult->IsChecked() ) { sal_uInt16 nResult = theCopyPos.Parse( - aEdCopyArea.GetText(), pDoc, pDoc->GetAddressConvention()); + pEdCopyArea->GetText(), pDoc, pDoc->GetAddressConvention()); bCopyPosOk = ( SCA_VALID == (nResult & SCA_VALID) ); } - if ( aBtnCopyResult.IsChecked() && bCopyPosOk ) + if ( pBtnCopyResult->IsChecked() && bCopyPosOk ) { theParam.bInplace = false; theParam.nDestTab = theCopyPos.Tab(); @@ -698,12 +673,12 @@ ScQueryItem* ScFilterDlg::GetOutputItem() theParam.nDestRow = 0; } - theParam.bHasHeader = aBtnHeader.IsChecked(); + theParam.bHasHeader = pBtnHeader->IsChecked(); theParam.bByRow = true; - theParam.bDuplicate = !aBtnUnique.IsChecked(); - theParam.bCaseSens = aBtnCase.IsChecked(); - theParam.bRegExp = aBtnRegExp.IsChecked(); - theParam.bDestPers = aBtnDestPers.IsChecked(); + theParam.bDuplicate = !pBtnUnique->IsChecked(); + theParam.bCaseSens = pBtnCase->IsChecked(); + theParam.bRegExp = pBtnRegExp->IsChecked(); + theParam.bDestPers = pBtnDestPers->IsChecked(); // only set the three - reset everything else @@ -728,19 +703,19 @@ sal_Bool ScFilterDlg::IsRefInputMode() const IMPL_LINK( ScFilterDlg, EndDlgHdl, Button*, pBtn ) { - if ( pBtn == &aBtnOk ) + if ( pBtn == pBtnOk ) { bool bAreaInputOk = true; - if ( aBtnCopyResult.IsChecked() ) + if ( pBtnCopyResult->IsChecked() ) { - if ( !pOptionsMgr->VerifyPosStr( aEdCopyArea.GetText() ) ) + if ( !pOptionsMgr->VerifyPosStr( pEdCopyArea->GetText() ) ) { - if ( !aBtnMore.GetState() ) - aBtnMore.SetState( true ); + if (!pExpander->get_expanded()) + pExpander->set_expanded(true); ERRORBOX( STR_INVALID_TABREF ); - aEdCopyArea.GrabFocus(); + pEdCopyArea->GrabFocus(); bAreaInputOk = false; } } @@ -755,7 +730,7 @@ IMPL_LINK( ScFilterDlg, EndDlgHdl, Button*, pBtn ) Close(); } } - else if ( pBtn == &aBtnCancel ) + else if ( pBtn == pBtnCancel ) { Close(); } @@ -768,7 +743,7 @@ IMPL_LINK( ScFilterDlg, EndDlgHdl, Button*, pBtn ) IMPL_LINK_NOARG(ScFilterDlg, MoreClickHdl) { - if ( aBtnMore.GetState() ) + if ( pExpander->get_expanded() ) pTimer->Start(); else { @@ -788,9 +763,9 @@ IMPL_LINK( ScFilterDlg, TimeOutHdl, Timer*, _pTimer ) // Check if RefInputMode is still true every 50ms if( _pTimer == pTimer && IsActive() ) - bRefInputMode = (aEdCopyArea.HasFocus() || aRbCopyArea.HasFocus()); + bRefInputMode = (pEdCopyArea->HasFocus() || pRbCopyArea->HasFocus()); - if ( aBtnMore.GetState() ) + if ( pExpander->get_expanded() ) pTimer->Start(); return 0; @@ -806,13 +781,13 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) */ sal_uInt16 nOffset = GetSliderPos(); - if ( pLb == &aLbConnect1 ) + if ( pLb == pLbConnect1 ) { - aLbField1.Enable(); - aLbCond1.Enable(); - aEdVal1.Enable(); + pLbField1->Enable(); + pLbCond1->Enable(); + pEdVal1->Enable(); - sal_uInt16 nConnect1 = aLbConnect1.GetSelectEntryPos(); + sal_uInt16 nConnect1 = pLbConnect1->GetSelectEntryPos(); size_t nQE = nOffset; theQueryData.GetEntry(nQE).eConnect =(ScQueryConnect)nConnect1; if (maRefreshExceptQuery.size() < nQE + 1) @@ -820,26 +795,26 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) maRefreshExceptQuery[nQE] = true; } - else if ( pLb == &aLbConnect2 ) + else if ( pLb == pLbConnect2 ) { - aLbField2.Enable(); - aLbCond2.Enable(); - aEdVal2.Enable(); + pLbField2->Enable(); + pLbCond2->Enable(); + pEdVal2->Enable(); - sal_uInt16 nConnect2 = aLbConnect2.GetSelectEntryPos(); + sal_uInt16 nConnect2 = pLbConnect2->GetSelectEntryPos(); size_t nQE = 1+nOffset; theQueryData.GetEntry(nQE).eConnect =(ScQueryConnect)nConnect2; if (maRefreshExceptQuery.size() < nQE + 1) maRefreshExceptQuery.resize(nQE + 1, false); maRefreshExceptQuery[nQE]=true; } - else if ( pLb == &aLbConnect3 ) + else if ( pLb == pLbConnect3 ) { - aLbField3.Enable(); - aLbCond3.Enable(); - aEdVal3.Enable(); + pLbField3->Enable(); + pLbCond3->Enable(); + pEdVal3->Enable(); - sal_uInt16 nConnect3 = aLbConnect3.GetSelectEntryPos(); + sal_uInt16 nConnect3 = pLbConnect3->GetSelectEntryPos(); size_t nQE = 2 + nOffset; theQueryData.GetEntry(nQE).eConnect = (ScQueryConnect)nConnect3; if (maRefreshExceptQuery.size() < nQE + 1) @@ -847,49 +822,49 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) maRefreshExceptQuery[nQE] = true; } - else if ( pLb == &aLbConnect4 ) + else if ( pLb == pLbConnect4 ) { - aLbField4.Enable(); - aLbCond4.Enable(); - aEdVal4.Enable(); + pLbField4->Enable(); + pLbCond4->Enable(); + pEdVal4->Enable(); - sal_uInt16 nConnect4 = aLbConnect4.GetSelectEntryPos(); + sal_uInt16 nConnect4 = pLbConnect4->GetSelectEntryPos(); size_t nQE = 3 + nOffset; theQueryData.GetEntry(nQE).eConnect = (ScQueryConnect)nConnect4; if (maRefreshExceptQuery.size() < nQE + 1) maRefreshExceptQuery.resize(nQE + 1, false); maRefreshExceptQuery[nQE] = true; } - else if ( pLb == &aLbField1 ) + else if ( pLb == pLbField1 ) { - if ( aLbField1.GetSelectEntryPos() == 0 ) + if ( pLbField1->GetSelectEntryPos() == 0 ) { - aLbConnect2.SetNoSelection(); - aLbConnect3.SetNoSelection(); - aLbConnect4.SetNoSelection(); - aLbField2.SelectEntryPos( 0 ); - aLbField3.SelectEntryPos( 0 ); - aLbField4.SelectEntryPos( 0 ); - aLbCond2.SelectEntryPos( 0 ); - aLbCond3.SelectEntryPos( 0 ); - aLbCond4.SelectEntryPos( 0 ); + pLbConnect2->SetNoSelection(); + pLbConnect3->SetNoSelection(); + pLbConnect4->SetNoSelection(); + pLbField2->SelectEntryPos( 0 ); + pLbField3->SelectEntryPos( 0 ); + pLbField4->SelectEntryPos( 0 ); + pLbCond2->SelectEntryPos( 0 ); + pLbCond3->SelectEntryPos( 0 ); + pLbCond4->SelectEntryPos( 0 ); ClearValueList( 1 ); ClearValueList( 2 ); ClearValueList( 3 ); ClearValueList( 4 ); - aLbConnect2.Disable(); - aLbConnect3.Disable(); - aLbConnect4.Disable(); - aLbField2.Disable(); - aLbField3.Disable(); - aLbField4.Disable(); - aLbCond2.Disable(); - aLbCond3.Disable(); - aLbCond4.Disable(); - aEdVal2.Disable(); - aEdVal3.Disable(); - aEdVal4.Disable(); + pLbConnect2->Disable(); + pLbConnect3->Disable(); + pLbConnect4->Disable(); + pLbField2->Disable(); + pLbField3->Disable(); + pLbField4->Disable(); + pLbCond2->Disable(); + pLbCond3->Disable(); + pLbCond4->Disable(); + pEdVal2->Disable(); + pEdVal3->Disable(); + pEdVal4->Disable(); SCSIZE nCount = theQueryData.GetEntryCount(); if (maRefreshExceptQuery.size() < nCount + 1) maRefreshExceptQuery.resize(nCount + 1, false); @@ -904,37 +879,37 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) else { UpdateValueList( 1 ); - if ( !aLbConnect2.IsEnabled() ) + if ( !pLbConnect2->IsEnabled() ) { - aLbConnect2.Enable(); + pLbConnect2->Enable(); } theQueryData.GetEntry(nOffset).bDoQuery = true; sal_uInt16 nField = pLb->GetSelectEntryPos(); theQueryData.GetEntry(nOffset).nField = theQueryData.nCol1 + static_cast<SCCOL>(nField) - 1 ; } } - else if ( pLb == &aLbField2 ) + else if ( pLb == pLbField2 ) { - if ( aLbField2.GetSelectEntryPos() == 0 ) + if ( pLbField2->GetSelectEntryPos() == 0 ) { - aLbConnect3.SetNoSelection(); - aLbConnect4.SetNoSelection(); - aLbField3.SelectEntryPos( 0 ); - aLbField4.SelectEntryPos( 0 ); - aLbCond3.SelectEntryPos( 0 ); - aLbCond4.SelectEntryPos( 0 ); + pLbConnect3->SetNoSelection(); + pLbConnect4->SetNoSelection(); + pLbField3->SelectEntryPos( 0 ); + pLbField4->SelectEntryPos( 0 ); + pLbCond3->SelectEntryPos( 0 ); + pLbCond4->SelectEntryPos( 0 ); ClearValueList( 2 ); ClearValueList( 3 ); ClearValueList( 4 ); - aLbConnect3.Disable(); - aLbConnect4.Disable(); - aLbField3.Disable(); - aLbField4.Disable(); - aLbCond3.Disable(); - aLbCond4.Disable(); - aEdVal3.Disable(); - aEdVal4.Disable(); + pLbConnect3->Disable(); + pLbConnect4->Disable(); + pLbField3->Disable(); + pLbField4->Disable(); + pLbCond3->Disable(); + pLbCond4->Disable(); + pEdVal3->Disable(); + pEdVal4->Disable(); sal_uInt16 nTemp=nOffset+1; SCSIZE nCount = theQueryData.GetEntryCount(); @@ -951,9 +926,9 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) else { UpdateValueList( 2 ); - if ( !aLbConnect3.IsEnabled() ) + if ( !pLbConnect3->IsEnabled() ) { - aLbConnect3.Enable(); + pLbConnect3->Enable(); } sal_uInt16 nField = pLb->GetSelectEntryPos(); sal_uInt16 nQ=1+nOffset; @@ -961,20 +936,20 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) theQueryData.GetEntry(nQ).nField = theQueryData.nCol1 + static_cast<SCCOL>(nField) - 1 ; } } - else if ( pLb == &aLbField3 ) + else if ( pLb == pLbField3 ) { - if ( aLbField3.GetSelectEntryPos() == 0 ) + if ( pLbField3->GetSelectEntryPos() == 0 ) { - aLbConnect4.SetNoSelection(); - aLbField4.SelectEntryPos( 0 ); - aLbCond4.SelectEntryPos( 0 ); + pLbConnect4->SetNoSelection(); + pLbField4->SelectEntryPos( 0 ); + pLbCond4->SelectEntryPos( 0 ); ClearValueList( 3 ); ClearValueList( 4 ); - aLbConnect4.Disable(); - aLbField4.Disable(); - aLbCond4.Disable(); - aEdVal4.Disable(); + pLbConnect4->Disable(); + pLbField4->Disable(); + pLbCond4->Disable(); + pEdVal4->Disable(); sal_uInt16 nTemp=nOffset+2; SCSIZE nCount = theQueryData.GetEntryCount(); @@ -991,9 +966,9 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) else { UpdateValueList( 3 ); - if ( !aLbConnect4.IsEnabled() ) + if ( !pLbConnect4->IsEnabled() ) { - aLbConnect4.Enable(); + pLbConnect4->Enable(); } sal_uInt16 nField = pLb->GetSelectEntryPos(); @@ -1003,9 +978,9 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) } } - else if ( pLb == &aLbField4 ) + else if ( pLb == pLbField4 ) { - if ( aLbField4.GetSelectEntryPos() == 0 ) + if ( pLbField4->GetSelectEntryPos() == 0 ) { ClearValueList( 4 ); sal_uInt16 nTemp=nOffset+3; @@ -1030,16 +1005,16 @@ IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb ) } } - else if ( pLb == &aLbCond1) + else if ( pLb == pLbCond1) { theQueryData.GetEntry(nOffset).eOp=(ScQueryOp)pLb->GetSelectEntryPos(); } - else if ( pLb == &aLbCond2) + else if ( pLb == pLbCond2) { sal_uInt16 nQ=1+nOffset; theQueryData.GetEntry(nQ).eOp=(ScQueryOp)pLb->GetSelectEntryPos(); } - else if ( pLb == &aLbCond3) + else if ( pLb == pLbCond3) { sal_uInt16 nQ=2+nOffset; theQueryData.GetEntry(nQ).eOp=(ScQueryOp)pLb->GetSelectEntryPos(); @@ -1064,17 +1039,17 @@ IMPL_LINK( ScFilterDlg, CheckBoxHdl, CheckBox*, pBox ) // Upper/lower case: // Value list: completely new - if ( pBox == &aBtnHeader ) // Field list and value list + if ( pBox == pBtnHeader ) // Field list and value list { - sal_uInt16 nCurSel1 = aLbField1.GetSelectEntryPos(); - sal_uInt16 nCurSel2 = aLbField2.GetSelectEntryPos(); - sal_uInt16 nCurSel3 = aLbField3.GetSelectEntryPos(); - sal_uInt16 nCurSel4 = aLbField4.GetSelectEntryPos(); + sal_uInt16 nCurSel1 = pLbField1->GetSelectEntryPos(); + sal_uInt16 nCurSel2 = pLbField2->GetSelectEntryPos(); + sal_uInt16 nCurSel3 = pLbField3->GetSelectEntryPos(); + sal_uInt16 nCurSel4 = pLbField4->GetSelectEntryPos(); FillFieldLists(); - aLbField1.SelectEntryPos( nCurSel1 ); - aLbField2.SelectEntryPos( nCurSel2 ); - aLbField3.SelectEntryPos( nCurSel3 ); - aLbField4.SelectEntryPos( nCurSel4 ); + pLbField1->SelectEntryPos( nCurSel1 ); + pLbField2->SelectEntryPos( nCurSel2 ); + pLbField3->SelectEntryPos( nCurSel3 ); + pLbField4->SelectEntryPos( nCurSel4 ); UpdateHdrInValueList( 1 ); UpdateHdrInValueList( 2 ); @@ -1082,7 +1057,7 @@ IMPL_LINK( ScFilterDlg, CheckBoxHdl, CheckBox*, pBox ) UpdateHdrInValueList( 4 ); } - if ( pBox == &aBtnCase ) // Complete value list + if ( pBox == pBtnCase ) // Complete value list { maEntryLists.clear(); UpdateValueList( 1 ); // current text is recorded @@ -1105,26 +1080,26 @@ IMPL_LINK( ScFilterDlg, ValModifyHdl, ComboBox*, pEd ) if ( pEd ) { OUString aStrVal = pEd->GetText(); - ListBox* pLbCond = &aLbCond1; - ListBox* pLbField = &aLbField1; - if ( pEd == &aEdVal2 ) + ListBox* pLbCond = pLbCond1; + ListBox* pLbField = pLbField1; + if ( pEd == pEdVal2 ) { - pLbCond = &aLbCond2; - pLbField = &aLbField2; + pLbCond = pLbCond2; + pLbField = pLbField2; i=1; nQE=i+nOffset; } - if ( pEd == &aEdVal3 ) + if ( pEd == pEdVal3 ) { - pLbCond = &aLbCond3; - pLbField = &aLbField3; + pLbCond = pLbCond3; + pLbField = pLbField3; i=2; nQE=i+nOffset; } - if ( pEd == &aEdVal4 ) + if ( pEd == pEdVal4 ) { - pLbCond = &aLbCond4; - pLbField = &aLbField4; + pLbCond = pLbCond4; + pLbField = pLbField4; i=3; nQE=i+nOffset; } @@ -1196,7 +1171,7 @@ void ScFilterDlg::SliderMoved() size_t ScFilterDlg::GetSliderPos() { - return static_cast<size_t>(aScrollBar.GetThumbPos()); + return static_cast<size_t>(pScrollBar->GetThumbPos()); } void ScFilterDlg::RefreshEditRow( size_t nOffset ) diff --git a/sc/source/ui/dbgui/foptmgr.cxx b/sc/source/ui/dbgui/foptmgr.cxx index 3d02a9739e42..895103101377 100644 --- a/sc/source/ui/dbgui/foptmgr.cxx +++ b/sc/source/ui/dbgui/foptmgr.cxx @@ -503,6 +503,21 @@ void ScNewFilterOptionsMgr::Init() } //---------------------------------------------------------------------------- + +sal_Bool ScNewFilterOptionsMgr::VerifyPosStr( const String& rPosStr ) const +{ + String aPosStr( rPosStr ); + xub_StrLen nColonPos = aPosStr.Search( ':' ); + + if ( STRING_NOTFOUND != nColonPos ) + aPosStr.Erase( nColonPos ); + + sal_uInt16 nResult = ScAddress().Parse( aPosStr, pDoc, pDoc->GetAddressConvention() ); + + return ( SCA_VALID == (nResult & SCA_VALID) ); +} + +//---------------------------------------------------------------------------- // Handler: //---------------------------------------------------------------------------- diff --git a/sc/source/ui/inc/filtdlg.hxx b/sc/source/ui/inc/filtdlg.hxx index 023962047503..2a789bd884b9 100644 --- a/sc/source/ui/inc/filtdlg.hxx +++ b/sc/source/ui/inc/filtdlg.hxx @@ -40,7 +40,6 @@ //---------------------------------------------------------------------------- -class ScFilterOptionsMgr; class ScNewFilterOptionsMgr; class ScViewData; class ScDocument; @@ -71,53 +70,44 @@ public: void RefreshEditRow( size_t nOffset ); private: - FixedLine aFlCriteria; + ListBox* pLbConnect1; + ListBox* pLbField1; + ListBox* pLbCond1; + ComboBox* pEdVal1; //---------------------------- - ListBox aLbConnect1; - ListBox aLbField1; - ListBox aLbCond1; - ComboBox aEdVal1; + ListBox* pLbConnect2; + ListBox* pLbField2; + ListBox* pLbCond2; + ComboBox* pEdVal2; //---------------------------- - ListBox aLbConnect2; - ListBox aLbField2; - ListBox aLbCond2; - ComboBox aEdVal2; + ListBox* pLbConnect3; + ListBox* pLbField3; + ListBox* pLbCond3; + ComboBox* pEdVal3; //---------------------------- - ListBox aLbConnect3; - ListBox aLbField3; - ListBox aLbCond3; - ComboBox aEdVal3; + ListBox* pLbConnect4; + ListBox* pLbField4; + ListBox* pLbCond4; + ComboBox* pEdVal4; //---------------------------- - ListBox aLbConnect4; - ListBox aLbField4; - ListBox aLbCond4; - ComboBox aEdVal4; - //---------------------------- - FixedText aFtConnect; - FixedText aFtField; - FixedText aFtCond; - FixedText aFtVal; - FixedLine aFlSeparator; - - ScrollBar aScrollBar; - - FixedLine aFlOptions; - MoreButton aBtnMore; - HelpButton aBtnHelp; - OKButton aBtnOk; - CancelButton aBtnCancel; - - CheckBox aBtnCase; - CheckBox aBtnRegExp; - CheckBox aBtnHeader; - CheckBox aBtnUnique; - CheckBox aBtnCopyResult; - ListBox aLbCopyArea; - formula::RefEdit aEdCopyArea; - formula::RefButton aRbCopyArea; - CheckBox aBtnDestPers; - FixedText aFtDbAreaLabel; - FixedInfo aFtDbArea; + ScrollBar* pScrollBar; + VclExpander* pExpander; + + HelpButton* pBtnHelp; + OKButton* pBtnOk; + CancelButton* pBtnCancel; + + CheckBox* pBtnCase; + CheckBox* pBtnRegExp; + CheckBox* pBtnHeader; + CheckBox* pBtnUnique; + CheckBox* pBtnCopyResult; + ListBox* pLbCopyArea; + formula::RefEdit* pEdCopyArea; + formula::RefButton* pRbCopyArea; + CheckBox* pBtnDestPers; + FixedText* pFtDbAreaLabel; + FixedText* pFtDbArea; const OUString aStrUndefined; const OUString aStrNone; @@ -126,7 +116,7 @@ private: const OUString aStrRow; const OUString aStrColumn; - ScFilterOptionsMgr* pOptionsMgr; + ScNewFilterOptionsMgr* pOptionsMgr; const sal_uInt16 nWhichQuery; ScQueryParam theQueryData; diff --git a/sc/source/ui/inc/filter.hrc b/sc/source/ui/inc/filter.hrc index 8335f632f42e..3d1f94011445 100644 --- a/sc/source/ui/inc/filter.hrc +++ b/sc/source/ui/inc/filter.hrc @@ -30,15 +30,9 @@ #define BTN_UNIQUE 1 #define BTN_CASE 2 #define BTN_REGEXP 3 -#define BTN_HEADER 4 -#define BTN_COPY_RESULT 5 -#define LB_COPY_AREA 6 -#define ED_COPY_AREA 7 -#define RB_COPY_AREA 8 #define FL_OPTIONS 9 #define FT_DBAREA_LABEL 10 #define FT_DBAREA 11 -#define BTN_DEST_PERS 12 // Filter: #define FT_OP 20 @@ -57,13 +51,7 @@ #define ED_VAL2 33 #define ED_VAL3 34 #define FL_CRITERIA 35 -#define FL_SEPARATOR 36 #define LB_OP3 37 -#define LB_FIELD4 38 -#define LB_COND4 39 -#define ED_VAL4 40 -#define LB_SCROLL 41 -#define LB_OP4 42 // Special filter #define STR_COPY_AREA_TO 5054 diff --git a/sc/source/ui/inc/foptmgr.hxx b/sc/source/ui/inc/foptmgr.hxx index 298727ef358b..f138d360ddfe 100644 --- a/sc/source/ui/inc/foptmgr.hxx +++ b/sc/source/ui/inc/foptmgr.hxx @@ -139,6 +139,7 @@ public: FixedText* refFtDbArea, const String& refStrUndefined ); ~ScNewFilterOptionsMgr(); + sal_Bool VerifyPosStr ( const String& rPosStr ) const; private: ScViewData* pViewData; diff --git a/sc/source/ui/src/filter.src b/sc/source/ui/src/filter.src index 53975db9ee86..9b23647d87a8 100644 --- a/sc/source/ui/src/filter.src +++ b/sc/source/ui/src/filter.src @@ -17,428 +17,6 @@ * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ #include "filter.hrc" -ModelessDialog RID_SCDLG_FILTER -{ - OutputSize = TRUE ; - HelpId = CMD_SID_FILTER ; - Hide = TRUE ; - SVLook = TRUE ; - Size = MAP_APPFONT ( 279 , 121 ) ; - Text [ en-US ] = "Standard Filter" ; - Moveable = TRUE ; - Closeable = FALSE ; - FixedText FT_OP - { - Pos = MAP_APPFONT ( 12 , 14 ) ; - Size = MAP_APPFONT ( 44 , 8 ) ; - Text [ en-US ] = "Operator" ; - }; - FixedText FT_FIELD - { - Pos = MAP_APPFONT ( 58 , 14 ) ; - Size = MAP_APPFONT ( 60 , 8 ) ; - Text [ en-US ] = "Field name" ; - }; - FixedText FT_COND - { - Pos = MAP_APPFONT ( 122 , 14 ) ; - Size = MAP_APPFONT ( 47 , 8 ) ; - Text [ en-US ] = "Condition" ; - }; - FixedText FT_VAL - { - Pos = MAP_APPFONT ( 201 , 14 ) ; - Size = MAP_APPFONT ( 60 , 8 ) ; - Text [ en-US ] = "Value" ; - }; - ListBox LB_OP1 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP1"; - Border = TRUE ; - Pos = MAP_APPFONT ( 12 , 25 ) ; - Size = MAP_APPFONT ( 40 , 46 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - StringList [ en-US ] = - { - < "AND" ; Default ; > ; - < "OR" ; Default ; > ; - }; - }; - ListBox LB_OP2 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP2"; - Border = TRUE ; - Pos = MAP_APPFONT ( 12 , 41 ) ; - Size = MAP_APPFONT ( 40 , 46 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - StringList [ en-US ] = - { - < "AND" ; Default ; > ; - < "OR" ; Default ; > ; - }; - }; - ListBox LB_OP3 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP3"; - Border = TRUE ; - Pos = MAP_APPFONT ( 12 , 57 ) ; - Size = MAP_APPFONT ( 40 , 46 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - StringList [ en-US ] = - { - < "AND" ; Default ; > ; - < "OR" ; Default ; > ; - }; - }; - ListBox LB_OP4 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_OP4"; - Border = TRUE ; - Pos = MAP_APPFONT ( 12 , 73 ) ; - Size = MAP_APPFONT ( 40 , 46 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - StringList [ en-US ] = - { - < "AND" ; Default ; > ; - < "OR" ; Default ; > ; - }; - }; - ListBox LB_FIELD1 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD1"; - Border = TRUE ; - Pos = MAP_APPFONT ( 58 , 25 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ListBox LB_FIELD2 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD2"; - Border = TRUE ; - Pos = MAP_APPFONT ( 58 , 41 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ListBox LB_FIELD3 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD3"; - Border = TRUE ; - Pos = MAP_APPFONT ( 58 , 57 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ListBox LB_FIELD4 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_FIELD4"; - Border = TRUE ; - Pos = MAP_APPFONT ( 58 , 73 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ListBox LB_COND1 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND1"; - Border = TRUE ; - Pos = MAP_APPFONT ( 122 , 25 ) ; - Size = MAP_APPFONT ( 75 , 145 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - stringlist [ en-US ] = - { - < "=" ; Default ; > ; - < "<" ; Default ; > ; - < ">" ; Default ; > ; - < "<=" ; Default ; > ; - < ">=" ; Default ; > ; - < "<>" ; Default ; > ; - < "Largest" ; Default ; > ; - < "Smallest" ; Default ; > ; - < "Largest %" ; Default ; > ; - < "Smallest %" ; Default ; > ; - < "Contains" ; Default ; > ; - < "Does not contain" ; Default ; > ; - < "Begins with" ; Default ; > ; - < "Does not begin with" ; Default ; > ; - < "Ends with" ; Default ; > ; - < "Does not end with" ; Default ; > ; - }; - }; - ListBox LB_COND2 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND2"; - Border = TRUE ; - Pos = MAP_APPFONT ( 122 , 41 ) ; - Size = MAP_APPFONT ( 75 , 145 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - stringlist [ en-US ] = - { - < "=" ; Default ; > ; - < "<" ; Default ; > ; - < ">" ; Default ; > ; - < "<=" ; Default ; > ; - < ">=" ; Default ; > ; - < "<>" ; Default ; > ; - < "Largest" ; Default ; > ; - < "Smallest" ; Default ; > ; - < "Largest %" ; Default ; > ; - < "Smallest %" ; Default ; > ; - < "Contains" ; Default ; > ; - < "Does not contain" ; Default ; > ; - < "Begins with" ; Default ; > ; - < "Does not begin with" ; Default ; > ; - < "Ends with" ; Default ; > ; - < "Does not end with" ; Default ; > ; - }; - }; - ListBox LB_COND3 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND3"; - Border = TRUE ; - Pos = MAP_APPFONT ( 122 , 57 ) ; - Size = MAP_APPFONT ( 75 , 145 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - stringlist [ en-US ] = - { - < "=" ; Default ; > ; - < "<" ; Default ; > ; - < ">" ; Default ; > ; - < "<=" ; Default ; > ; - < ">=" ; Default ; > ; - < "<>" ; Default ; > ; - < "Largest" ; Default ; > ; - < "Smallest" ; Default ; > ; - < "Largest %" ; Default ; > ; - < "Smallest %" ; Default ; > ; - < "Contains" ; Default ; > ; - < "Does not contain" ; Default ; > ; - < "Begins with" ; Default ; > ; - < "Does not begin with" ; Default ; > ; - < "Ends with" ; Default ; > ; - < "Does not end with" ; Default ; > ; - }; - }; - ListBox LB_COND4 - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COND4"; - Border = TRUE ; - Pos = MAP_APPFONT ( 122 , 73 ) ; - Size = MAP_APPFONT ( 75 , 145 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - stringlist [ en-US ] = - { - < "=" ; Default ; > ; - < "<" ; Default ; > ; - < ">" ; Default ; > ; - < "<=" ; Default ; > ; - < ">=" ; Default ; > ; - < "<>" ; Default ; > ; - < "Largest" ; Default ; > ; - < "Smallest" ; Default ; > ; - < "Largest %" ; Default ; > ; - < "Smallest %" ; Default ; > ; - < "Contains" ; Default ; > ; - < "Does not contain" ; Default ; > ; - < "Begins with" ; Default ; > ; - < "Does not begin with" ; Default ; > ; - < "Ends with" ; Default ; > ; - < "Does not end with" ; Default ; > ; - }; - }; - ComboBox ED_VAL1 - { - HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL1"; - Pos = MAP_APPFONT ( 201 , 25 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ComboBox ED_VAL2 - { - HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL2"; - Pos = MAP_APPFONT ( 201 , 41 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ComboBox ED_VAL3 - { - HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL3"; - Pos = MAP_APPFONT ( 201 , 57 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ComboBox ED_VAL4 - { - HelpID = "sc:ComboBox:RID_SCDLG_FILTER:ED_VAL4"; - Pos = MAP_APPFONT ( 201 , 73 ) ; - Size = MAP_APPFONT ( 60 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - ScrollBar LB_SCROLL - { - Pos = MAP_APPFONT ( 265, 25 ) ; - Size = MAP_APPFONT ( 8 , 60 ) ; - TabStop = TRUE ; - VScroll = TRUE ; - }; - - FixedLine FL_CRITERIA - { - Pos = MAP_APPFONT ( 6 , 3 ) ; - Size = MAP_APPFONT ( 267 , 8 ) ; - Text [ en-US ] = "Filter criteria"; - }; - CheckBox BTN_CASE - { - HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_CASE"; - Hide = TRUE ; - Pos = MAP_APPFONT ( 12 , 130 ) ; - Size = MAP_APPFONT ( 128 , 10 ) ; - TabStop = TRUE ; - Text [ en-US ] = "Case ~sensitive" ; - }; - CheckBox BTN_REGEXP - { - HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_REGEXP"; - Hide = TRUE ; - Pos = MAP_APPFONT ( 142 , 130 ) ; - Size = MAP_APPFONT ( 94 , 10 ) ; - TabStop = TRUE ; - Text [ en-US ] = "Regular ~expression" ; - }; - CheckBox BTN_HEADER - { - HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_HEADER"; - Hide = TRUE ; - Pos = MAP_APPFONT ( 12 , 144 ) ; - Size = MAP_APPFONT ( 128 , 10 ) ; - TabStop = TRUE ; - Text [ en-US ] = "Range contains ~column labels" ; - }; - CheckBox BTN_UNIQUE - { - HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_UNIQUE"; - Hide = TRUE ; - Pos = MAP_APPFONT ( 142 , 144 ) ; - Size = MAP_APPFONT ( 94 , 10 ) ; - TabStop = TRUE ; - Text [ en-US ] = "~No duplication" ; - }; - CheckBox BTN_COPY_RESULT - { - HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_COPY_RESULT"; - Hide = TRUE ; - Pos = MAP_APPFONT ( 12 , 158 ) ; - Size = MAP_APPFONT ( 128 , 10 ) ; - TabStop = TRUE ; - Text [ en-US ] = "Copy ~results to..." ; - }; - CheckBox BTN_DEST_PERS - { - HelpID = "sc:CheckBox:RID_SCDLG_FILTER:BTN_DEST_PERS"; - Hide = TRUE ; - Pos = MAP_APPFONT ( 142 , 158 ) ; - Size = MAP_APPFONT ( 94 , 10 ) ; - TabStop = TRUE ; - Text [ en-US ] = "~Keep filter criteria" ; - }; - ListBox LB_COPY_AREA - { - HelpID = "sc:ListBox:RID_SCDLG_FILTER:LB_COPY_AREA"; - Border = TRUE ; - Hide = TRUE ; - Pos = MAP_APPFONT ( 21 , 170 ) ; - Size = MAP_APPFONT ( 110 , 90 ) ; - TabStop = TRUE ; - DropDown = TRUE ; - }; - Edit ED_COPY_AREA - { - HelpID = "sc:Edit:RID_SCDLG_FILTER:ED_COPY_AREA"; - Border = TRUE ; - Hide = TRUE ; - Pos = MAP_APPFONT ( 136 , 170 ) ; - Size = MAP_APPFONT ( 110 , 12 ) ; - TabStop = TRUE ; - }; - ImageButton RB_COPY_AREA - { - HelpID = "sc:ImageButton:RID_SCDLG_FILTER:RB_COPY_AREA"; - Pos = MAP_APPFONT ( 248 , 169 ) ; - Size = MAP_APPFONT ( 13 , 15 ) ; - TabStop = FALSE ; - QuickHelpText [ en-US ] = "Shrink" ; - }; - FixedLine FL_OPTIONS - { - Hide = TRUE ; - Pos = MAP_APPFONT ( 6 , 118 ) ; - Size = MAP_APPFONT ( 267 , 8 ) ; - }; - FixedText FT_DBAREA - { - Hide = TRUE ; - Pos = MAP_APPFONT ( 66 , 188 ) ; - Size = MAP_APPFONT ( 167 , 8 ) ; - Left = TRUE ; - Text [ en-US ] = "dummy" ; - }; - FixedText FT_DBAREA_LABEL - { - Hide = TRUE ; - Pos = MAP_APPFONT ( 6 , 188 ) ; - Size = MAP_APPFONT ( 58 , 8 ) ; - Text [ en-US ] = "Data range:" ; - }; - OKButton BTN_OK - { - Pos = MAP_APPFONT ( 169 , 101 ) ; - Size = MAP_APPFONT ( 50 , 14 ) ; - TabStop = TRUE ; - DefButton = TRUE ; - }; - CancelButton BTN_CANCEL - { - Pos = MAP_APPFONT ( 223 , 101 ) ; - Size = MAP_APPFONT ( 50 , 14 ) ; - TabStop = TRUE ; - }; - HelpButton BTN_HELP - { - Pos = MAP_APPFONT ( 72 , 101 ) ; - Size = MAP_APPFONT ( 50 , 14 ) ; - TabStop = TRUE ; - }; - MoreButton BTN_MORE - { - HelpID = "sc:MoreButton:RID_SCDLG_FILTER:BTN_MORE"; - Pos = MAP_APPFONT ( 6 , 101 ) ; - Size = MAP_APPFONT ( 60 , 14 ) ; - TabStop = TRUE ; - MapUnit = MAP_APPFONT ; - Delta = 81 ; - }; - FixedLine FL_SEPARATOR - { - Pos = MAP_APPFONT ( 0 , 91 ) ; - Size = MAP_APPFONT ( 279 , 6 ) ; - }; -}; - -//============================================================================ ModalDialog RID_SCDLG_PIVOTFILTER { diff --git a/sc/uiconfig/scalc/ui/standardfilterdialog.ui b/sc/uiconfig/scalc/ui/standardfilterdialog.ui new file mode 100644 index 000000000000..32d7dccf90e9 --- /dev/null +++ b/sc/uiconfig/scalc/ui/standardfilterdialog.ui @@ -0,0 +1,817 @@ +<?xml version="1.0" encoding="UTF-8"?> +<interface> + <!-- interface-requires gtk+ 3.0 --> + <!-- interface-requires LibreOffice 1.0 --> + <object class="GtkDialog" id="StandardFilterDialog"> + <property name="can_focus">False</property> + <property name="border_width">6</property> + <property name="title" translatable="yes">Standard Filter</property> + <property name="type_hint">dialog</property> + <child internal-child="vbox"> + <object class="GtkBox" id="dialog-vbox1"> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="orientation">vertical</property> + <property name="spacing">12</property> + <child internal-child="action_area"> + <object class="GtkButtonBox" id="dialog-action_area1"> + <property name="can_focus">False</property> + <property name="layout_style">end</property> + <child> + <object class="GtkButton" id="ok"> + <property name="label">gtk-ok</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="can_default">True</property> + <property name="has_default">True</property> + <property name="receives_default">True</property> + <property name="use_stock">True</property> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">0</property> + </packing> + </child> + <child> + <object class="GtkButton" id="cancel"> + <property name="label">gtk-cancel</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="can_default">True</property> + <property name="receives_default">True</property> + <property name="use_stock">True</property> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">1</property> + </packing> + </child> + <child> + <object class="GtkButton" id="help"> + <property name="label">gtk-help</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="can_default">True</property> + <property name="receives_default">True</property> + <property name="use_stock">True</property> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">2</property> + </packing> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="pack_type">end</property> + <property name="position">0</property> + </packing> + </child> + <child> + <object class="GtkFrame" id="frame1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="label_xalign">0</property> + <property name="shadow_type">none</property> + <child> + <object class="GtkAlignment" id="alignment1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="top_padding">6</property> + <property name="left_padding">12</property> + <child> + <object class="GtkGrid" id="grid1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="row_spacing">6</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkScrollbar" id="scrollbar"> + <property name="height_request">1</property> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="orientation">vertical</property> + </object> + <packing> + <property name="left_attach">4</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">5</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="connect1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label2"/> + </accessibility> + <items> + <item>AND</item> + <item>OR</item> + </items> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="connect2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label2"/> + </accessibility> + <items> + <item>AND</item> + <item>OR</item> + </items> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="connect3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <items> + <item>AND</item> + <item>OR</item> + </items> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">3</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="connect4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <items> + <item>AND</item> + <item>OR</item> + </items> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">4</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="label2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Operator</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="label3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Field name</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="label4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Condition</property> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="label5"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Value</property> + </object> + <packing> + <property name="left_attach">3</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="field1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label3"/> + </accessibility> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="field2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label3"/> + </accessibility> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="field3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label3"/> + </accessibility> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">3</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="field4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">4</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBox" id="cond1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label4"/> + </accessibility> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="cond2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label4"/> + </accessibility> + <items> + <item>=</item> + <item><</item> + <item>></item> + <item><=</item> + <item>>=</item> + <item><></item> + <item>Largest</item> + <item>Smallest</item> + <item>Largest %</item> + <item>Smallest %</item> + <item>Contains</item> + <item>Does not contain</item> + <item>Begins with</item> + <item>Does not begin with</item> + <item>Ends with</item> + <item>Does not end with</item> + </items> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="cond3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label4"/> + </accessibility> + <items> + <item>=</item> + <item><</item> + <item>></item> + <item><=</item> + <item>>=</item> + <item><></item> + <item>Largest</item> + <item>Smallest</item> + <item>Largest %</item> + <item>Smallest %</item> + <item>Contains</item> + <item>Does not contain</item> + <item>Begins with</item> + <item>Does not begin with</item> + <item>Ends with</item> + <item>Does not end with</item> + </items> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">3</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="cond4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <items> + <item>=</item> + <item><</item> + <item>></item> + <item><=</item> + <item>>=</item> + <item><></item> + <item>Largest</item> + <item>Smallest</item> + <item>Largest %</item> + <item>Smallest %</item> + <item>Contains</item> + <item>Does not contain</item> + <item>Begins with</item> + <item>Does not begin with</item> + <item>Ends with</item> + <item>Does not end with</item> + </items> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">4</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="val1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="has_entry">True</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label5"/> + </accessibility> + <child internal-child="entry"> + <object class="GtkEntry" id="comboboxtext-entry2"> + <property name="can_focus">False</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">3</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="val2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="has_entry">True</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label5"/> + </accessibility> + <child internal-child="entry"> + <object class="GtkEntry" id="comboboxtext-entry4"> + <property name="can_focus">False</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">3</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="val3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="has_entry">True</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="label5"/> + </accessibility> + <child internal-child="entry"> + <object class="GtkEntry" id="comboboxtext-entry6"> + <property name="can_focus">False</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">3</property> + <property name="top_attach">3</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkComboBoxText" id="val4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="has_entry">True</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <child internal-child="entry"> + <object class="GtkEntry" id="comboboxtext-entry8"> + <property name="can_focus">False</property> + </object> + </child> + </object> + <packing> + <property name="left_attach">3</property> + <property name="top_attach">4</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Filter criteria</property> + <attributes> + <attribute name="weight" value="bold"/> + </attributes> + </object> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">1</property> + </packing> + </child> + <child> + <object class="GtkExpander" id="more"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="hexpand">True</property> + <property name="spacing">6</property> + <property name="resize_toplevel">True</property> + <child> + <object class="GtkGrid" id="grid2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="margin_top">6</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="row_spacing">6</property> + <child> + <object class="GtkGrid" id="grid3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="vexpand">True</property> + <property name="row_spacing">6</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkCheckButton" id="case"> + <property name="label" translatable="yes">_Case sensitive</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="header"> + <property name="label" translatable="yes">Range c_ontains column labels</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="regexp"> + <property name="label" translatable="yes">Regular _expressions</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="unique"> + <property name="label" translatable="yes">_No duplications</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="copyresult"> + <property name="label" translatable="yes">Co_py results to:</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + <accessibility> + <relation type="label-for" target="lbcopyarea"/> + <relation type="label-for" target="edcopyarea"/> + </accessibility> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="destpers"> + <property name="label" translatable="yes">_Keep filter criteria</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="hexpand">True</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkGrid" id="grid4"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="margin_left">12</property> + <property name="hexpand">True</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkComboBoxText" id="lbcopyarea"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="entry_text_column">0</property> + <property name="id_column">1</property> + <accessibility> + <relation type="labelled-by" target="copyresult"/> + </accessibility> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="foruilo-RefEdit" id="edcopyarea"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="margin_bottom">1</property> + <property name="hexpand">True</property> + <property name="invisible_char">●</property> + <property name="width_chars">30</property> + <accessibility> + <relation type="labelled-by" target="copyresult"/> + </accessibility> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="foruilo-RefButton" id="rbcopyarea"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">True</property> + <child> + <placeholder/> + </child> + </object> + <packing> + <property name="left_attach">2</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkGrid" id="grid5"> + <property name="sensitive">False</property> + <property name="can_focus">False</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkLabel" id="dbarealabel"> + <property name="sensitive">False</property> + <property name="can_focus">False</property> + <property name="xalign">0</property> + <property name="label" translatable="yes">Data range:</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="dbarea"> + <property name="sensitive">False</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="xalign">0</property> + <property name="label" translatable="yes">dummy</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label6"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Op_tions</property> + <property name="use_underline">True</property> + </object> + </child> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">2</property> + </packing> + </child> + </object> + </child> + <action-widgets> + <action-widget response="0">ok</action-widget> + <action-widget response="0">cancel</action-widget> + <action-widget response="0">help</action-widget> + </action-widgets> + </object> +</interface> |