1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_sc.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski
28*b1cdbd2cSJim Jagielski
29*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
30*b1cdbd2cSJim Jagielski
31*b1cdbd2cSJim Jagielski #include "scitems.hxx"
32*b1cdbd2cSJim Jagielski #include <svl/srchitem.hxx>
33*b1cdbd2cSJim Jagielski #include <sfx2/app.hxx>
34*b1cdbd2cSJim Jagielski #include <sfx2/objface.hxx>
35*b1cdbd2cSJim Jagielski #include <sfx2/objsh.hxx>
36*b1cdbd2cSJim Jagielski #include <sfx2/request.hxx>
37*b1cdbd2cSJim Jagielski #include <svl/whiter.hxx>
38*b1cdbd2cSJim Jagielski #include <vcl/msgbox.hxx>
39*b1cdbd2cSJim Jagielski #include <sfx2/sidebar/EnumContext.hxx>
40*b1cdbd2cSJim Jagielski
41*b1cdbd2cSJim Jagielski #include "sc.hrc"
42*b1cdbd2cSJim Jagielski #include "pivotsh.hxx"
43*b1cdbd2cSJim Jagielski #include "tabvwsh.hxx"
44*b1cdbd2cSJim Jagielski #include "docsh.hxx"
45*b1cdbd2cSJim Jagielski #include "scresid.hxx"
46*b1cdbd2cSJim Jagielski #include "document.hxx"
47*b1cdbd2cSJim Jagielski #include "dpobject.hxx"
48*b1cdbd2cSJim Jagielski #include "dpshttab.hxx"
49*b1cdbd2cSJim Jagielski #include "dbdocfun.hxx"
50*b1cdbd2cSJim Jagielski #include "uiitems.hxx"
51*b1cdbd2cSJim Jagielski //CHINA001 #include "pfiltdlg.hxx"
52*b1cdbd2cSJim Jagielski #include "scabstdlg.hxx" //CHINA001
53*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
54*b1cdbd2cSJim Jagielski
55*b1cdbd2cSJim Jagielski #define ScPivotShell
56*b1cdbd2cSJim Jagielski #include "scslots.hxx"
57*b1cdbd2cSJim Jagielski
58*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
59*b1cdbd2cSJim Jagielski
60*b1cdbd2cSJim Jagielski TYPEINIT1( ScPivotShell, SfxShell );
61*b1cdbd2cSJim Jagielski
SFX_IMPL_INTERFACE(ScPivotShell,SfxShell,ScResId (SCSTR_PIVOTSHELL))62*b1cdbd2cSJim Jagielski SFX_IMPL_INTERFACE(ScPivotShell, SfxShell, ScResId(SCSTR_PIVOTSHELL))
63*b1cdbd2cSJim Jagielski {
64*b1cdbd2cSJim Jagielski SFX_POPUPMENU_REGISTRATION( ScResId(RID_POPUP_PIVOT) );
65*b1cdbd2cSJim Jagielski }
66*b1cdbd2cSJim Jagielski
67*b1cdbd2cSJim Jagielski
68*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
69*b1cdbd2cSJim Jagielski
ScPivotShell(ScTabViewShell * pViewSh)70*b1cdbd2cSJim Jagielski ScPivotShell::ScPivotShell( ScTabViewShell* pViewSh ) :
71*b1cdbd2cSJim Jagielski SfxShell(pViewSh),
72*b1cdbd2cSJim Jagielski pViewShell( pViewSh )
73*b1cdbd2cSJim Jagielski {
74*b1cdbd2cSJim Jagielski SetPool( &pViewSh->GetPool() );
75*b1cdbd2cSJim Jagielski ScViewData* pViewData = pViewSh->GetViewData();
76*b1cdbd2cSJim Jagielski ::svl::IUndoManager* pMgr = pViewData->GetSfxDocShell()->GetUndoManager();
77*b1cdbd2cSJim Jagielski SetUndoManager( pMgr );
78*b1cdbd2cSJim Jagielski if ( !pViewData->GetDocument()->IsUndoEnabled() )
79*b1cdbd2cSJim Jagielski {
80*b1cdbd2cSJim Jagielski pMgr->SetMaxUndoActionCount( 0 );
81*b1cdbd2cSJim Jagielski }
82*b1cdbd2cSJim Jagielski SetHelpId( HID_SCSHELL_PIVOTSH );
83*b1cdbd2cSJim Jagielski SetName(String::CreateFromAscii(RTL_CONSTASCII_STRINGPARAM("Pivot")));
84*b1cdbd2cSJim Jagielski SfxShell::SetContextName(sfx2::sidebar::EnumContext::GetContextName(sfx2::sidebar::EnumContext::Context_Pivot));
85*b1cdbd2cSJim Jagielski }
86*b1cdbd2cSJim Jagielski
87*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
~ScPivotShell()88*b1cdbd2cSJim Jagielski ScPivotShell::~ScPivotShell()
89*b1cdbd2cSJim Jagielski {
90*b1cdbd2cSJim Jagielski }
91*b1cdbd2cSJim Jagielski
92*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
Execute(SfxRequest & rReq)93*b1cdbd2cSJim Jagielski void ScPivotShell::Execute( SfxRequest& rReq )
94*b1cdbd2cSJim Jagielski {
95*b1cdbd2cSJim Jagielski switch ( rReq.GetSlot() )
96*b1cdbd2cSJim Jagielski {
97*b1cdbd2cSJim Jagielski case SID_PIVOT_RECALC:
98*b1cdbd2cSJim Jagielski pViewShell->RecalcPivotTable();
99*b1cdbd2cSJim Jagielski break;
100*b1cdbd2cSJim Jagielski
101*b1cdbd2cSJim Jagielski case SID_PIVOT_KILL:
102*b1cdbd2cSJim Jagielski pViewShell->DeletePivotTable();
103*b1cdbd2cSJim Jagielski break;
104*b1cdbd2cSJim Jagielski
105*b1cdbd2cSJim Jagielski case SID_DP_FILTER:
106*b1cdbd2cSJim Jagielski {
107*b1cdbd2cSJim Jagielski ScDPObject* pDPObj = GetCurrDPObject();
108*b1cdbd2cSJim Jagielski if( pDPObj )
109*b1cdbd2cSJim Jagielski {
110*b1cdbd2cSJim Jagielski ScQueryParam aQueryParam;
111*b1cdbd2cSJim Jagielski SCTAB nSrcTab = 0;
112*b1cdbd2cSJim Jagielski const ScSheetSourceDesc* pDesc = pDPObj->GetSheetDesc();
113*b1cdbd2cSJim Jagielski DBG_ASSERT( pDesc, "no sheet source for DP filter dialog" );
114*b1cdbd2cSJim Jagielski if( pDesc )
115*b1cdbd2cSJim Jagielski {
116*b1cdbd2cSJim Jagielski aQueryParam = pDesc->aQueryParam;
117*b1cdbd2cSJim Jagielski nSrcTab = pDesc->aSourceRange.aStart.Tab();
118*b1cdbd2cSJim Jagielski }
119*b1cdbd2cSJim Jagielski
120*b1cdbd2cSJim Jagielski ScViewData* pViewData = pViewShell->GetViewData();
121*b1cdbd2cSJim Jagielski SfxItemSet aArgSet( pViewShell->GetPool(),
122*b1cdbd2cSJim Jagielski SCITEM_QUERYDATA, SCITEM_QUERYDATA );
123*b1cdbd2cSJim Jagielski aArgSet.Put( ScQueryItem( SCITEM_QUERYDATA, pViewData, &aQueryParam ) );
124*b1cdbd2cSJim Jagielski
125*b1cdbd2cSJim Jagielski //CHINA001 ScPivotFilterDlg* pDlg = new ScPivotFilterDlg(
126*b1cdbd2cSJim Jagielski //CHINA001 pViewShell->GetDialogParent(), aArgSet, nSrcTab );
127*b1cdbd2cSJim Jagielski
128*b1cdbd2cSJim Jagielski ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
129*b1cdbd2cSJim Jagielski DBG_ASSERT(pFact, "ScAbstractFactory create fail!");//CHINA001
130*b1cdbd2cSJim Jagielski
131*b1cdbd2cSJim Jagielski AbstractScPivotFilterDlg* pDlg = pFact->CreateScPivotFilterDlg( pViewShell->GetDialogParent(),
132*b1cdbd2cSJim Jagielski aArgSet, nSrcTab,
133*b1cdbd2cSJim Jagielski RID_SCDLG_PIVOTFILTER);
134*b1cdbd2cSJim Jagielski DBG_ASSERT(pDlg, "Dialog create fail!");//CHINA001
135*b1cdbd2cSJim Jagielski
136*b1cdbd2cSJim Jagielski if( pDlg->Execute() == RET_OK )
137*b1cdbd2cSJim Jagielski {
138*b1cdbd2cSJim Jagielski ScSheetSourceDesc aNewDesc;
139*b1cdbd2cSJim Jagielski if( pDesc )
140*b1cdbd2cSJim Jagielski aNewDesc = *pDesc;
141*b1cdbd2cSJim Jagielski
142*b1cdbd2cSJim Jagielski const ScQueryItem& rQueryItem = pDlg->GetOutputItem();
143*b1cdbd2cSJim Jagielski aNewDesc.aQueryParam = rQueryItem.GetQueryData();
144*b1cdbd2cSJim Jagielski
145*b1cdbd2cSJim Jagielski ScDPObject aNewObj( *pDPObj );
146*b1cdbd2cSJim Jagielski aNewObj.SetSheetDesc( aNewDesc );
147*b1cdbd2cSJim Jagielski ScDBDocFunc aFunc( *pViewData->GetDocShell() );
148*b1cdbd2cSJim Jagielski aFunc.DataPilotUpdate( pDPObj, &aNewObj, sal_True, sal_False );
149*b1cdbd2cSJim Jagielski pViewData->GetView()->CursorPosChanged(); // shells may be switched
150*b1cdbd2cSJim Jagielski }
151*b1cdbd2cSJim Jagielski delete pDlg;
152*b1cdbd2cSJim Jagielski }
153*b1cdbd2cSJim Jagielski }
154*b1cdbd2cSJim Jagielski break;
155*b1cdbd2cSJim Jagielski }
156*b1cdbd2cSJim Jagielski }
157*b1cdbd2cSJim Jagielski
158*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
GetState(SfxItemSet & rSet)159*b1cdbd2cSJim Jagielski void __EXPORT ScPivotShell::GetState( SfxItemSet& rSet )
160*b1cdbd2cSJim Jagielski {
161*b1cdbd2cSJim Jagielski ScDocShell* pDocSh = pViewShell->GetViewData()->GetDocShell();
162*b1cdbd2cSJim Jagielski ScDocument* pDoc = pDocSh->GetDocument();
163*b1cdbd2cSJim Jagielski sal_Bool bDisable = pDocSh->IsReadOnly() || pDoc->GetChangeTrack();
164*b1cdbd2cSJim Jagielski
165*b1cdbd2cSJim Jagielski SfxWhichIter aIter(rSet);
166*b1cdbd2cSJim Jagielski sal_uInt16 nWhich = aIter.FirstWhich();
167*b1cdbd2cSJim Jagielski while (nWhich)
168*b1cdbd2cSJim Jagielski {
169*b1cdbd2cSJim Jagielski switch (nWhich)
170*b1cdbd2cSJim Jagielski {
171*b1cdbd2cSJim Jagielski case SID_PIVOT_RECALC:
172*b1cdbd2cSJim Jagielski case SID_PIVOT_KILL:
173*b1cdbd2cSJim Jagielski {
174*b1cdbd2cSJim Jagielski //! move ReadOnly check to idl flags
175*b1cdbd2cSJim Jagielski if ( bDisable )
176*b1cdbd2cSJim Jagielski {
177*b1cdbd2cSJim Jagielski rSet.DisableItem( nWhich );
178*b1cdbd2cSJim Jagielski }
179*b1cdbd2cSJim Jagielski }
180*b1cdbd2cSJim Jagielski break;
181*b1cdbd2cSJim Jagielski case SID_DP_FILTER:
182*b1cdbd2cSJim Jagielski {
183*b1cdbd2cSJim Jagielski ScDPObject* pDPObj = GetCurrDPObject();
184*b1cdbd2cSJim Jagielski if( bDisable || !pDPObj || !pDPObj->IsSheetData() )
185*b1cdbd2cSJim Jagielski rSet.DisableItem( nWhich );
186*b1cdbd2cSJim Jagielski }
187*b1cdbd2cSJim Jagielski break;
188*b1cdbd2cSJim Jagielski }
189*b1cdbd2cSJim Jagielski nWhich = aIter.NextWhich();
190*b1cdbd2cSJim Jagielski }
191*b1cdbd2cSJim Jagielski }
192*b1cdbd2cSJim Jagielski
193*b1cdbd2cSJim Jagielski
194*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
195*b1cdbd2cSJim Jagielski
GetCurrDPObject()196*b1cdbd2cSJim Jagielski ScDPObject* ScPivotShell::GetCurrDPObject()
197*b1cdbd2cSJim Jagielski {
198*b1cdbd2cSJim Jagielski const ScViewData& rViewData = *pViewShell->GetViewData();
199*b1cdbd2cSJim Jagielski return rViewData.GetDocument()->GetDPAtCursor(
200*b1cdbd2cSJim Jagielski rViewData.GetCurX(), rViewData.GetCurY(), rViewData.GetTabNo() );
201*b1cdbd2cSJim Jagielski }
202