sc/source/ui/view/tabvwshc.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: tabvwshc.cxx,v $
  10  * $Revision: 1.13.32.1 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_sc.hxx"
  33
  34
  35
  36 //------------------------------------------------------------------
  37
  38 // INCLUDE ---------------------------------------------------------------
  39 #include "scitems.hxx"
  40 #include <vcl/msgbox.hxx>
  41 #include <sfx2/childwin.hxx>
  42 #include <sfx2/dispatch.hxx>
  43
  44 #include "tabvwsh.hxx"
  45 #include "sc.hrc"
  46 #include "globstr.hrc"
  47 #include "global.hxx"
  48 #include "scmod.hxx"
  49 #include "docsh.hxx"
  50 #include "document.hxx"
  51 #include "uiitems.hxx"
  52 #include "pivot.hxx"
  53 #include "namedlg.hxx"
  54 #include "solvrdlg.hxx"
  55 #include "optsolver.hxx"
  56 #include "tabopdlg.hxx"
  57 #include "autoform.hxx"         // Core
  58 #include "autofmt.hxx"          // Dialog
  59 #include "consdlg.hxx"
  60 //CHINA001 #include "sortdlg.hxx"
  61 #include "filtdlg.hxx"
  62 #include "dbnamdlg.hxx"
  63 #include "pvlaydlg.hxx"
  64 #include "areasdlg.hxx"
  65 #include "condfrmt.hxx"
  66 #include "rangeutl.hxx"
  67 #include "crnrdlg.hxx"
  68 #include "formula.hxx"
  69 #include "cell.hxx"             // Input Status Edit-Zellen
  70 #include "acredlin.hxx"
  71 #include "highred.hxx"
  72 #include "simpref.hxx"
  73 #include "funcdesc.hxx"
  74 #include "dpobject.hxx"
  75
  76 //------------------------------------------------------------------
  77
  78 void ScTabViewShell::SetCurRefDlgId( USHORT nNew )
  79 {
  80     //  CurRefDlgId is stored in ScModule to find if a ref dialog is open,
  81     //  and in the view to identify the view that has opened the dialog
  82     nCurRefDlgId = nNew;
  83 }
  84
  85 SfxModelessDialog* ScTabViewShell::CreateRefDialog(
  86                         SfxBindings* pB, SfxChildWindow* pCW, SfxChildWinInfo* pInfo,
  87                         Window* pParent, USHORT nSlotId )
  88 {
  89     //  Dialog nur aufmachen, wenn ueber ScModule::SetRefDialog gerufen, damit
  90     //  z.B. nach einem Absturz offene Ref-Dialoge nicht wiederkommen (#42341#).
  91
  92     if ( SC_MOD()->GetCurRefDlgId() != nSlotId )
  93         return NULL;
  94
  95     if ( nCurRefDlgId != nSlotId )
  96     {
  97         //      the dialog has been opened in a different view
  98         //      -> lock the dispatcher for this view (modal mode)
  99
 100         GetViewData()->GetDispatcher().Lock( TRUE );    // lock is reset when closing dialog
 101         return NULL;
 102     }
 103
 104     SfxModelessDialog* pResult = 0;
 105
 106     if(pCW)
 107         pCW->SetHideNotDelete(TRUE);
 108
 109     switch( nSlotId )
 110     {
 111         case FID_DEFINE_NAME:
 112         pResult = new ScNameDlg( pB, pCW, pParent, GetViewData(),
 113                                  ScAddress( GetViewData()->GetCurX(),
 114                                             GetViewData()->GetCurY(),
 115                                             GetViewData()->GetTabNo() ) );
 116         break;
 117
 118         case SID_DEFINE_COLROWNAMERANGES:
 119         {
 120             pResult = new ScColRowNameRangesDlg( pB, pCW, pParent, GetViewData() );
 121         }
 122         break;
 123
 124         case SID_OPENDLG_CONSOLIDATE:
 125         {
 126             SfxItemSet aArgSet( GetPool(),
 127                                 SCITEM_CONSOLIDATEDATA,
 128                                 SCITEM_CONSOLIDATEDATA );
 129
 130             const ScConsolidateParam* pDlgData =
 131                             GetViewData()->GetDocument()->GetConsolidateDlgData();
 132
 133             if ( !pDlgData )
 134             {
 135                 ScConsolidateParam      aConsParam;
 136                 SCCOL nStartCol, nEndCol;
 137                 SCROW nStartRow, nEndRow;
 138                 SCTAB nStartTab, nEndTab;
 139
 140                 GetViewData()->GetSimpleArea( nStartCol, nStartRow, nStartTab,
 141                                               nEndCol,   nEndRow,       nEndTab );
 142
 143                 PutInOrder( nStartCol, nEndCol );
 144                 PutInOrder( nStartRow, nEndRow );
 145                 PutInOrder( nStartTab, nEndTab );
 146
 147                 aConsParam.nCol = nStartCol;
 148                 aConsParam.nRow = nStartRow;
 149                 aConsParam.nTab = nStartTab;
 150
 151                 aArgSet.Put( ScConsolidateItem( SCITEM_CONSOLIDATEDATA,
 152                                                 &aConsParam ) );
 153             }
 154             else
 155             {
 156                 aArgSet.Put( ScConsolidateItem( SCITEM_CONSOLIDATEDATA, pDlgData ) );
 157             }
 158             pResult = new ScConsolidateDlg( pB, pCW, pParent, aArgSet );
 159         }
 160         break;
 161
 162         case SID_DEFINE_DBNAME:
 163         {
 164             //  wenn auf einem bestehenden Bereich aufgerufen, den markieren
 165             GetDBData( TRUE, SC_DB_OLD );
 166             const ScMarkData& rMark = GetViewData()->GetMarkData();
 167             if ( !rMark.IsMarked() && !rMark.IsMultiMarked() )
 168                 MarkDataArea( FALSE );
 169
 170             pResult = new ScDbNameDlg( pB, pCW, pParent, GetViewData() );
 171         }
 172         break;
 173
 174         case SID_SPECIAL_FILTER:
 175         {
 176             ScQueryParam        aQueryParam;
 177             SfxItemSet          aArgSet( GetPool(),
 178                                      SCITEM_QUERYDATA,
 179                                      SCITEM_QUERYDATA );
 180
 181             ScDBData* pDBData = GetDBData(true, SC_DB_MAKE, true);
 182             pDBData->GetQueryParam( aQueryParam );
 183             aQueryParam.bUseDynamicRange = true;
 184
 185             ScQueryItem aItem( SCITEM_QUERYDATA, GetViewData(), &aQueryParam );
 186             ScRange aAdvSource;
 187             if (pDBData->GetAdvancedQuerySource(aAdvSource))
 188                 aItem.SetAdvancedQuerySource( &aAdvSource );
 189
 190             aArgSet.Put( aItem );
 191
 192             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 193             GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 194
 195             pResult = new ScSpecialFilterDlg( pB, pCW, pParent, aArgSet );
 196         }
 197         break;
 198
 199         case SID_FILTER:
 200         {
 201
 202             ScQueryParam        aQueryParam;
 203             SfxItemSet          aArgSet( GetPool(),
 204                                      SCITEM_QUERYDATA,
 205                                      SCITEM_QUERYDATA );
 206
 207             ScDBData* pDBData = GetDBData(true, SC_DB_MAKE, true);
 208             pDBData->GetQueryParam( aQueryParam );
 209             aQueryParam.bUseDynamicRange = true;
 210
 211             aArgSet.Put( ScQueryItem( SCITEM_QUERYDATA,
 212                                       GetViewData(),
 213                                       &aQueryParam ) );
 214
 215             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 216             GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 217
 218             pResult = new ScFilterDlg( pB, pCW, pParent, aArgSet );
 219         }
 220         break;
 221
 222         case SID_OPENDLG_TABOP:
 223         {
 224             ScViewData*  pViewData      = GetViewData();
 225             ScRefAddress  aCurPos       ( pViewData->GetCurX(),
 226                                       pViewData->GetCurY(),
 227                                       pViewData->GetTabNo(),
 228                                       FALSE, FALSE, FALSE );
 229
 230             pResult = new ScTabOpDlg( pB, pCW, pParent, pViewData->GetDocument(), aCurPos );
 231         }
 232         break;
 233
 234         case SID_OPENDLG_SOLVE:
 235         {
 236             ScViewData*  pViewData      = GetViewData();
 237             ScAddress aCurPos(  pViewData->GetCurX(),
 238                                 pViewData->GetCurY(),
 239                                 pViewData->GetTabNo());
 240             pResult = new ScSolverDlg( pB, pCW, pParent, pViewData->GetDocument(), aCurPos );
 241         }
 242         break;
 243
 244         case SID_OPENDLG_OPTSOLVER:
 245         {
 246             ScViewData* pViewData = GetViewData();
 247             ScAddress aCurPos( pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo());
 248             pResult = new ScOptSolverDlg( pB, pCW, pParent, pViewData->GetDocShell(), aCurPos );
 249         }
 250         break;
 251
 252         case SID_OPENDLG_PIVOTTABLE:
 253         {
 254             //  all settings must be in pDialogDPObject
 255
 256             if( pDialogDPObject )
 257             {
 258                 // Check for an existing datapilot output.
 259                 ScViewData* pViewData = GetViewData();
 260                 ScDPObject* pObj = GetViewData()->GetDocument()->GetDPAtCursor(
 261                     pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo());
 262
 263                 GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 264                 pResult = new ScDPLayoutDlg( pB, pCW, pParent, *pDialogDPObject, pObj == NULL);
 265             }
 266         }
 267         break;
 268
 269         case SID_OPENDLG_EDIT_PRINTAREA:
 270         {
 271             pResult = new ScPrintAreasDlg( pB, pCW, pParent );
 272         }
 273         break;
 274
 275         case SID_OPENDLG_CONDFRMT:
 276         {
 277             ScViewData* pViewData = GetViewData();
 278
 279             ScDocument* pDoc = pViewData->GetDocument();
 280             const ScConditionalFormat* pForm = pDoc->GetCondFormat(
 281                 pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo() );
 282
 283             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 284             pViewData->SetRefTabNo( pViewData->GetTabNo() );
 285
 286             pResult = new ScConditionalFormatDlg( pB, pCW, pParent, pDoc, pForm );
 287         }
 288         break;
 289
 290         case SID_OPENDLG_FUNCTION:
 291         {
 292             //  Dialog schaut selber, was in der Zelle steht
 293
 294             pResult = new ScFormulaDlg( pB, pCW, pParent, GetViewData(),ScGlobal::GetStarCalcFunctionMgr() );
 295         }
 296         break;
 297
 298         case FID_CHG_SHOW:
 299         {
 300             //  Dialog schaut selber, was in der Zelle steht
 301
 302             pResult = new ScHighlightChgDlg( pB, pCW, pParent, GetViewData() );
 303         }
 304         break;
 305
 306         case WID_SIMPLE_REF:
 307         {
 308             //  Dialog schaut selber, was in der Zelle steht
 309
 310             ScViewData* pViewData = GetViewData();
 311             pViewData->SetRefTabNo( pViewData->GetTabNo() );
 312             pResult = new ScSimpleRefDlg( pB, pCW, pParent, pViewData );
 313         }
 314         break;
 315
 316
 317         default:
 318         DBG_ERROR( "ScTabViewShell::CreateRefDialog: unbekannte ID" );
 319         break;
 320     }
 321
 322     if (pResult)
 323     {
 324         //      Die Dialoge gehen immer mit eingeklapptem Zusaetze-Button auf,
 325         //      darum muss die Groesse ueber das Initialize gerettet werden
 326         //      (oder den Zusaetze-Status mit speichern !!!)
 327
 328         Size aSize = pResult->GetSizePixel();
 329         pResult->Initialize( pInfo );
 330         pResult->SetSizePixel(aSize);
 331     }
 332
 333     return pResult;
 334 }
 335
 336
 337