sc/source/ui/view/tabvwshc.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include <config_mpl.h>
  21
  22 #include "scitems.hxx"
  23 #include <vcl/msgbox.hxx>
  24 #include <sfx2/childwin.hxx>
  25 #include <sfx2/dispatch.hxx>
  26
  27 #include "tabvwsh.hxx"
  28 #include "sc.hrc"
  29 #include "globstr.hrc"
  30 #include "global.hxx"
  31 #include "scmod.hxx"
  32 #include "docsh.hxx"
  33 #include "document.hxx"
  34 #include "uiitems.hxx"
  35 #include "pivot.hxx"
  36 #include "namedlg.hxx"
  37 #include "namedefdlg.hxx"
  38 #include "solvrdlg.hxx"
  39 #include "optsolver.hxx"
  40 #include "tabopdlg.hxx"
  41 #include "autoform.hxx"         // Core
  42 #include "autofmt.hxx"          // Dialog
  43 #include "consdlg.hxx"
  44 #include "filtdlg.hxx"
  45 #include "dbnamdlg.hxx"
  46 #if ! MPL_HAVE_SUBSET
  47 #  include "pvlaydlg.hxx"
  48 #endif
  49 #include "areasdlg.hxx"
  50 #include "rangeutl.hxx"
  51 #include "crnrdlg.hxx"
  52 #include "formula.hxx"
  53 #include "formulacell.hxx"             // Input Status Edit-Zellen
  54 #include "acredlin.hxx"
  55 #include "highred.hxx"
  56 #include "simpref.hxx"
  57 #include "funcdesc.hxx"
  58 #include "dpobject.hxx"
  59 #include "markdata.hxx"
  60 #include "reffact.hxx"
  61 #include "condformatdlg.hxx"
  62 #include "xmlsourcedlg.hxx"
  63
  64 //------------------------------------------------------------------
  65
  66 void ScTabViewShell::SetCurRefDlgId( sal_uInt16 nNew )
  67 {
  68     //  CurRefDlgId is stored in ScModule to find if a ref dialog is open,
  69     //  and in the view to identify the view that has opened the dialog
  70     nCurRefDlgId = nNew;
  71 }
  72
  73 //ugly hack to call Define Name from Manage Names
  74 void ScTabViewShell::SwitchBetweenRefDialogs(SfxModelessDialog* pDialog)
  75 {
  76    sal_uInt16 nSlotId = SC_MOD()->GetCurRefDlgId();
  77    if (nSlotId == FID_DEFINE_NAME)
  78    {
  79         mbInSwitch = true;
  80         static_cast<ScNameDlg*>(pDialog)->GetRangeNames(maRangeMap);
  81         static_cast<ScNameDlg*>(pDialog)->Close();
  82         sal_uInt16 nId  = ScNameDefDlgWrapper::GetChildWindowId();
  83         SfxViewFrame* pViewFrm = GetViewFrame();
  84         SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
  85
  86         SC_MOD()->SetRefDialog( nId, pWnd ? false : sal_True );
  87    }
  88    else if( nSlotId == FID_ADD_NAME )
  89    {
  90         static_cast<ScNameDefDlg*>(pDialog)->GetNewData(maName, maScope);
  91         static_cast<ScNameDlg*>(pDialog)->Close();
  92         sal_uInt16 nId  = ScNameDlgWrapper::GetChildWindowId();
  93         SfxViewFrame* pViewFrm = GetViewFrame();
  94         SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
  95
  96         SC_MOD()->SetRefDialog( nId, pWnd ? false : sal_True );
  97    }
  98    else
  99    {
 100
 101    }
 102 }
 103
 104 SfxModelessDialog* ScTabViewShell::CreateRefDialog(
 105                         SfxBindings* pB, SfxChildWindow* pCW, SfxChildWinInfo* pInfo,
 106                         Window* pParent, sal_uInt16 nSlotId )
 107 {
 108     //  Dialog nur aufmachen, wenn ueber ScModule::SetRefDialog gerufen, damit
 109     //  z.B. nach einem Absturz offene Ref-Dialoge nicht wiederkommen (#42341#).
 110
 111     if ( SC_MOD()->GetCurRefDlgId() != nSlotId )
 112         return NULL;
 113
 114     if ( nCurRefDlgId != nSlotId )
 115     {
 116         //  the dialog has been opened in a different view
 117         //  -> lock the dispatcher for this view (modal mode)
 118
 119         GetViewData()->GetDispatcher().Lock( sal_True );    // lock is reset when closing dialog
 120         return NULL;
 121     }
 122
 123     SfxModelessDialog* pResult = 0;
 124
 125     if(pCW)
 126         pCW->SetHideNotDelete(sal_True);
 127
 128     ScDocument* pDoc = GetViewData()->GetDocument();
 129
 130     switch( nSlotId )
 131     {
 132         case FID_DEFINE_NAME:
 133         {
 134             if (!mbInSwitch)
 135             {
 136                 pResult = new ScNameDlg( pB, pCW, pParent, GetViewData(),
 137                                      ScAddress( GetViewData()->GetCurX(),
 138                                                 GetViewData()->GetCurY(),
 139                                                 GetViewData()->GetTabNo() ) );
 140             }
 141             else
 142             {
 143                 pResult = new ScNameDlg( pB, pCW, pParent, GetViewData(),
 144                                      ScAddress( GetViewData()->GetCurX(),
 145                                                 GetViewData()->GetCurY(),
 146                                                 GetViewData()->GetTabNo() ), &maRangeMap);
 147                 static_cast<ScNameDlg*>(pResult)->SetEntry( maName, maScope);
 148                 mbInSwitch = false;
 149             }
 150         }
 151         break;
 152
 153         case FID_ADD_NAME:
 154         {
 155             if (!mbInSwitch)
 156             {
 157                 std::map<OUString, ScRangeName*> aRangeMap;
 158                 pDoc->GetRangeNameMap(aRangeMap);
 159                 pResult = new ScNameDefDlg( pB, pCW, pParent, GetViewData(), aRangeMap,
 160                                 ScAddress( GetViewData()->GetCurX(),
 161                                             GetViewData()->GetCurY(),
 162                                             GetViewData()->GetTabNo() ), true );
 163             }
 164             else
 165             {
 166                 std::map<OUString, ScRangeName*> aRangeMap;
 167                 for (boost::ptr_map<OUString, ScRangeName>::iterator itr = maRangeMap.begin();
 168                         itr != maRangeMap.end(); ++itr)
 169                 {
 170                     aRangeMap.insert(std::pair<OUString, ScRangeName*>(itr->first, itr->second));
 171                 }
 172                 pResult = new ScNameDefDlg( pB, pCW, pParent, GetViewData(), aRangeMap,
 173                                 ScAddress( GetViewData()->GetCurX(),
 174                                             GetViewData()->GetCurY(),
 175                                             GetViewData()->GetTabNo() ), false );
 176             }
 177         }
 178         break;
 179
 180         case SID_DEFINE_COLROWNAMERANGES:
 181         {
 182             pResult = new ScColRowNameRangesDlg( pB, pCW, pParent, GetViewData() );
 183         }
 184         break;
 185
 186         case SID_OPENDLG_CONSOLIDATE:
 187         {
 188             SfxItemSet aArgSet( GetPool(),
 189                                 SCITEM_CONSOLIDATEDATA,
 190                                 SCITEM_CONSOLIDATEDATA );
 191
 192             const ScConsolidateParam* pDlgData =
 193                             pDoc->GetConsolidateDlgData();
 194
 195             if ( !pDlgData )
 196             {
 197                 ScConsolidateParam  aConsParam;
 198                 SCCOL nStartCol, nEndCol;
 199                 SCROW nStartRow, nEndRow;
 200                 SCTAB nStartTab, nEndTab;
 201
 202                 GetViewData()->GetSimpleArea( nStartCol, nStartRow, nStartTab,
 203                                               nEndCol,   nEndRow,   nEndTab );
 204
 205                 PutInOrder( nStartCol, nEndCol );
 206                 PutInOrder( nStartRow, nEndRow );
 207                 PutInOrder( nStartTab, nEndTab );
 208
 209                 aConsParam.nCol = nStartCol;
 210                 aConsParam.nRow = nStartRow;
 211                 aConsParam.nTab = nStartTab;
 212
 213                 aArgSet.Put( ScConsolidateItem( SCITEM_CONSOLIDATEDATA,
 214                                                 &aConsParam ) );
 215             }
 216             else
 217             {
 218                 aArgSet.Put( ScConsolidateItem( SCITEM_CONSOLIDATEDATA, pDlgData ) );
 219             }
 220             pResult = new ScConsolidateDlg( pB, pCW, pParent, aArgSet );
 221         }
 222         break;
 223
 224         case SID_DEFINE_DBNAME:
 225         {
 226             //  wenn auf einem bestehenden Bereich aufgerufen, den markieren
 227             GetDBData( sal_True, SC_DB_OLD );
 228             const ScMarkData& rMark = GetViewData()->GetMarkData();
 229             if ( !rMark.IsMarked() && !rMark.IsMultiMarked() )
 230                 MarkDataArea( false );
 231
 232             pResult = new ScDbNameDlg( pB, pCW, pParent, GetViewData() );
 233         }
 234         break;
 235
 236         case SID_SPECIAL_FILTER:
 237         {
 238             ScQueryParam    aQueryParam;
 239             SfxItemSet      aArgSet( GetPool(),
 240                                      SCITEM_QUERYDATA,
 241                                      SCITEM_QUERYDATA );
 242
 243             ScDBData* pDBData = GetDBData(false, SC_DB_MAKE, SC_DBSEL_ROW_DOWN);
 244             pDBData->ExtendDataArea(pDoc);
 245             pDBData->GetQueryParam( aQueryParam );
 246
 247             ScRange aArea;
 248             pDBData->GetArea(aArea);
 249             MarkRange(aArea, false);
 250
 251             ScQueryItem aItem( SCITEM_QUERYDATA, GetViewData(), &aQueryParam );
 252             ScRange aAdvSource;
 253             if (pDBData->GetAdvancedQuerySource(aAdvSource))
 254                 aItem.SetAdvancedQuerySource( &aAdvSource );
 255
 256             aArgSet.Put( aItem );
 257
 258             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 259             GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 260
 261             pResult = new ScSpecialFilterDlg( pB, pCW, pParent, aArgSet );
 262         }
 263         break;
 264
 265         case SID_FILTER:
 266         {
 267
 268             ScQueryParam    aQueryParam;
 269             SfxItemSet      aArgSet( GetPool(),
 270                                      SCITEM_QUERYDATA,
 271                                      SCITEM_QUERYDATA );
 272
 273             ScDBData* pDBData = GetDBData(false, SC_DB_MAKE, SC_DBSEL_ROW_DOWN);
 274             pDBData->ExtendDataArea(pDoc);
 275             pDBData->GetQueryParam( aQueryParam );
 276
 277             ScRange aArea;
 278             pDBData->GetArea(aArea);
 279             MarkRange(aArea, false);
 280
 281             aArgSet.Put( ScQueryItem( SCITEM_QUERYDATA,
 282                                       GetViewData(),
 283                                       &aQueryParam ) );
 284
 285             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 286             GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 287
 288             pResult = new ScFilterDlg( pB, pCW, pParent, aArgSet );
 289         }
 290         break;
 291
 292         case SID_OPENDLG_TABOP:
 293         {
 294             ScViewData*  pViewData  = GetViewData();
 295             ScRefAddress  aCurPos   ( pViewData->GetCurX(),
 296                                       pViewData->GetCurY(),
 297                                       pViewData->GetTabNo(),
 298                                       false, false, false );
 299
 300             pResult = new ScTabOpDlg( pB, pCW, pParent, pViewData->GetDocument(), aCurPos );
 301         }
 302         break;
 303
 304         case SID_OPENDLG_SOLVE:
 305         {
 306             ScViewData*  pViewData  = GetViewData();
 307             ScAddress aCurPos(  pViewData->GetCurX(),
 308                                 pViewData->GetCurY(),
 309                                 pViewData->GetTabNo());
 310             pResult = new ScSolverDlg( pB, pCW, pParent, pViewData->GetDocument(), aCurPos );
 311         }
 312         break;
 313
 314         case SID_OPENDLG_OPTSOLVER:
 315         {
 316             ScViewData* pViewData = GetViewData();
 317             ScAddress aCurPos( pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo());
 318             pResult = new ScOptSolverDlg( pB, pCW, pParent, pViewData->GetDocShell(), aCurPos );
 319         }
 320         break;
 321
 322         case SID_OPENDLG_PIVOTTABLE:
 323         {
 324 #if ! MPL_HAVE_SUBSET
 325             //  all settings must be in pDialogDPObject
 326
 327             if( pDialogDPObject )
 328             {
 329                 // Check for an existing datapilot output.
 330                 ScViewData* pViewData = GetViewData();
 331                 ScDPObject* pObj = pDoc->GetDPAtCursor(
 332                     pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo());
 333
 334                 GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 335                 pResult = new ScPivotLayoutDlg( pB, pCW, pParent, *pDialogDPObject, pObj == NULL);
 336             }
 337 #endif
 338         }
 339         break;
 340
 341         case SID_OPENDLG_EDIT_PRINTAREA:
 342         {
 343             pResult = new ScPrintAreasDlg( pB, pCW, pParent );
 344         }
 345         break;
 346
 347         case SID_OPENDLG_FUNCTION:
 348         {
 349             //  Dialog schaut selber, was in der Zelle steht
 350
 351             pResult = new ScFormulaDlg( pB, pCW, pParent, GetViewData(),ScGlobal::GetStarCalcFunctionMgr() );
 352         }
 353         break;
 354
 355         case SID_MANAGE_XML_SOURCE:
 356         {
 357             pResult = new ScXMLSourceDlg(pB, pCW, pParent, pDoc);
 358         }
 359         break;
 360
 361         case FID_CHG_SHOW:
 362         {
 363             //  Dialog schaut selber, was in der Zelle steht
 364
 365             pResult = new ScHighlightChgDlg( pB, pCW, pParent, GetViewData() );
 366         }
 367         break;
 368
 369         case WID_SIMPLE_REF:
 370         {
 371             //  Dialog schaut selber, was in der Zelle steht
 372
 373             ScViewData* pViewData = GetViewData();
 374             pViewData->SetRefTabNo( pViewData->GetTabNo() );
 375             pResult = new ScSimpleRefDlg( pB, pCW, pParent, pViewData );
 376         }
 377         break;
 378
 379
 380         default:
 381         OSL_FAIL( "ScTabViewShell::CreateRefDialog: unbekannte ID" );
 382         break;
 383     }
 384
 385     if (pResult)
 386     {
 387         //  Die Dialoge gehen immer mit eingeklapptem Zusaetze-Button auf,
 388         //  darum muss die Groesse ueber das Initialize gerettet werden
 389         //  (oder den Zusaetze-Status mit speichern !!!)
 390
 391         Size aSize = pResult->GetSizePixel();
 392         pResult->Initialize( pInfo );
 393         pResult->SetSizePixel(aSize);
 394     }
 395
 396     return pResult;
 397 }
 398
 399
 400
 401 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */