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