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"
  42 #include "autofmt.hxx"
  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"
  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 #include "RandomNumberGeneratorDialog.hxx"
  65 #include "SamplingDialog.hxx"
  66 #include "DescriptiveStatisticsDialog.hxx"
  67 #include "AnalysisOfVarianceDialog.hxx"
  68 #include "CorrelationDialog.hxx"
  69 #include "CovarianceDialog.hxx"
  70 #include "ExponentialSmoothingDialog.hxx"
  71 #include "MovingAverageDialog.hxx"
  72
  73 #include <config_orcus.h>
  74
  75 //------------------------------------------------------------------
  76
  77 void ScTabViewShell::SetCurRefDlgId( sal_uInt16 nNew )
  78 {
  79     //  CurRefDlgId is stored in ScModule to find if a ref dialog is open,
  80     //  and in the view to identify the view that has opened the dialog
  81     nCurRefDlgId = nNew;
  82 }
  83
  84 //ugly hack to call Define Name from Manage Names
  85 void ScTabViewShell::SwitchBetweenRefDialogs(SfxModelessDialog* pDialog)
  86 {
  87    sal_uInt16 nSlotId = SC_MOD()->GetCurRefDlgId();
  88    if (nSlotId == FID_DEFINE_NAME)
  89    {
  90         mbInSwitch = true;
  91         static_cast<ScNameDlg*>(pDialog)->GetRangeNames(maRangeMap);
  92         static_cast<ScNameDlg*>(pDialog)->Close();
  93         sal_uInt16 nId  = ScNameDefDlgWrapper::GetChildWindowId();
  94         SfxViewFrame* pViewFrm = GetViewFrame();
  95         SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
  96
  97         SC_MOD()->SetRefDialog( nId, pWnd ? false : sal_True );
  98    }
  99    else if( nSlotId == FID_ADD_NAME )
 100    {
 101         static_cast<ScNameDefDlg*>(pDialog)->GetNewData(maName, maScope);
 102         static_cast<ScNameDlg*>(pDialog)->Close();
 103         sal_uInt16 nId  = ScNameDlgWrapper::GetChildWindowId();
 104         SfxViewFrame* pViewFrm = GetViewFrame();
 105         SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
 106
 107         SC_MOD()->SetRefDialog( nId, pWnd ? false : sal_True );
 108    }
 109    else
 110    {
 111
 112    }
 113 }
 114
 115 SfxModelessDialog* ScTabViewShell::CreateRefDialog(
 116                         SfxBindings* pB, SfxChildWindow* pCW, SfxChildWinInfo* pInfo,
 117                         Window* pParent, sal_uInt16 nSlotId )
 118 {
 119     //  Dialog nur aufmachen, wenn ueber ScModule::SetRefDialog gerufen, damit
 120     //  z.B. nach einem Absturz offene Ref-Dialoge nicht wiederkommen (#42341#).
 121
 122     if ( SC_MOD()->GetCurRefDlgId() != nSlotId )
 123         return NULL;
 124
 125     if ( nCurRefDlgId != nSlotId )
 126     {
 127         //  the dialog has been opened in a different view
 128         //  -> lock the dispatcher for this view (modal mode)
 129
 130         GetViewData()->GetDispatcher().Lock( sal_True );    // lock is reset when closing dialog
 131         return NULL;
 132     }
 133
 134     SfxModelessDialog* pResult = 0;
 135
 136     if(pCW)
 137         pCW->SetHideNotDelete(sal_True);
 138
 139     ScDocument* pDoc = GetViewData()->GetDocument();
 140
 141     switch( nSlotId )
 142     {
 143         case FID_DEFINE_NAME:
 144         {
 145             if (!mbInSwitch)
 146             {
 147                 pResult = new ScNameDlg( pB, pCW, pParent, GetViewData(),
 148                                      ScAddress( GetViewData()->GetCurX(),
 149                                                 GetViewData()->GetCurY(),
 150                                                 GetViewData()->GetTabNo() ) );
 151             }
 152             else
 153             {
 154                 pResult = new ScNameDlg( pB, pCW, pParent, GetViewData(),
 155                                      ScAddress( GetViewData()->GetCurX(),
 156                                                 GetViewData()->GetCurY(),
 157                                                 GetViewData()->GetTabNo() ), &maRangeMap);
 158                 static_cast<ScNameDlg*>(pResult)->SetEntry( maName, maScope);
 159                 mbInSwitch = false;
 160             }
 161         }
 162         break;
 163
 164         case FID_ADD_NAME:
 165         {
 166             if (!mbInSwitch)
 167             {
 168                 std::map<OUString, ScRangeName*> aRangeMap;
 169                 pDoc->GetRangeNameMap(aRangeMap);
 170                 pResult = new ScNameDefDlg( pB, pCW, pParent, GetViewData(), aRangeMap,
 171                                 ScAddress( GetViewData()->GetCurX(),
 172                                             GetViewData()->GetCurY(),
 173                                             GetViewData()->GetTabNo() ), true );
 174             }
 175             else
 176             {
 177                 std::map<OUString, ScRangeName*> aRangeMap;
 178                 for (boost::ptr_map<OUString, ScRangeName>::iterator itr = maRangeMap.begin();
 179                         itr != maRangeMap.end(); ++itr)
 180                 {
 181                     aRangeMap.insert(std::pair<OUString, ScRangeName*>(itr->first, itr->second));
 182                 }
 183                 pResult = new ScNameDefDlg( pB, pCW, pParent, GetViewData(), aRangeMap,
 184                                 ScAddress( GetViewData()->GetCurX(),
 185                                             GetViewData()->GetCurY(),
 186                                             GetViewData()->GetTabNo() ), false );
 187             }
 188         }
 189         break;
 190
 191         case SID_DEFINE_COLROWNAMERANGES:
 192         {
 193             pResult = new ScColRowNameRangesDlg( pB, pCW, pParent, GetViewData() );
 194         }
 195         break;
 196
 197         case SID_OPENDLG_CONSOLIDATE:
 198         {
 199             SfxItemSet aArgSet( GetPool(),
 200                                 SCITEM_CONSOLIDATEDATA,
 201                                 SCITEM_CONSOLIDATEDATA );
 202
 203             const ScConsolidateParam* pDlgData =
 204                             pDoc->GetConsolidateDlgData();
 205
 206             if ( !pDlgData )
 207             {
 208                 ScConsolidateParam  aConsParam;
 209                 SCCOL nStartCol, nEndCol;
 210                 SCROW nStartRow, nEndRow;
 211                 SCTAB nStartTab, nEndTab;
 212
 213                 GetViewData()->GetSimpleArea( nStartCol, nStartRow, nStartTab,
 214                                               nEndCol,   nEndRow,   nEndTab );
 215
 216                 PutInOrder( nStartCol, nEndCol );
 217                 PutInOrder( nStartRow, nEndRow );
 218                 PutInOrder( nStartTab, nEndTab );
 219
 220                 aConsParam.nCol = nStartCol;
 221                 aConsParam.nRow = nStartRow;
 222                 aConsParam.nTab = nStartTab;
 223
 224                 aArgSet.Put( ScConsolidateItem( SCITEM_CONSOLIDATEDATA,
 225                                                 &aConsParam ) );
 226             }
 227             else
 228             {
 229                 aArgSet.Put( ScConsolidateItem( SCITEM_CONSOLIDATEDATA, pDlgData ) );
 230             }
 231             pResult = new ScConsolidateDlg( pB, pCW, pParent, aArgSet );
 232         }
 233         break;
 234
 235         case SID_DEFINE_DBNAME:
 236         {
 237             //  wenn auf einem bestehenden Bereich aufgerufen, den markieren
 238             GetDBData( sal_True, SC_DB_OLD );
 239             const ScMarkData& rMark = GetViewData()->GetMarkData();
 240             if ( !rMark.IsMarked() && !rMark.IsMultiMarked() )
 241                 MarkDataArea( false );
 242
 243             pResult = new ScDbNameDlg( pB, pCW, pParent, GetViewData() );
 244         }
 245         break;
 246
 247         case SID_SPECIAL_FILTER:
 248         {
 249             ScQueryParam    aQueryParam;
 250             SfxItemSet      aArgSet( GetPool(),
 251                                      SCITEM_QUERYDATA,
 252                                      SCITEM_QUERYDATA );
 253
 254             ScDBData* pDBData = GetDBData(false, SC_DB_MAKE, SC_DBSEL_ROW_DOWN);
 255             pDBData->ExtendDataArea(pDoc);
 256             pDBData->GetQueryParam( aQueryParam );
 257
 258             ScRange aArea;
 259             pDBData->GetArea(aArea);
 260             MarkRange(aArea, false);
 261
 262             ScQueryItem aItem( SCITEM_QUERYDATA, GetViewData(), &aQueryParam );
 263             ScRange aAdvSource;
 264             if (pDBData->GetAdvancedQuerySource(aAdvSource))
 265                 aItem.SetAdvancedQuerySource( &aAdvSource );
 266
 267             aArgSet.Put( aItem );
 268
 269             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 270             GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 271
 272             pResult = new ScSpecialFilterDlg( pB, pCW, pParent, aArgSet );
 273         }
 274         break;
 275
 276         case SID_FILTER:
 277         {
 278
 279             ScQueryParam    aQueryParam;
 280             SfxItemSet      aArgSet( GetPool(),
 281                                      SCITEM_QUERYDATA,
 282                                      SCITEM_QUERYDATA );
 283
 284             ScDBData* pDBData = GetDBData(false, SC_DB_MAKE, SC_DBSEL_ROW_DOWN);
 285             pDBData->ExtendDataArea(pDoc);
 286             pDBData->GetQueryParam( aQueryParam );
 287
 288             ScRange aArea;
 289             pDBData->GetArea(aArea);
 290             MarkRange(aArea, false);
 291
 292             aArgSet.Put( ScQueryItem( SCITEM_QUERYDATA,
 293                                       GetViewData(),
 294                                       &aQueryParam ) );
 295
 296             // aktuelle Tabelle merken (wg. RefInput im Dialog)
 297             GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 298
 299             pResult = new ScFilterDlg( pB, pCW, pParent, aArgSet );
 300         }
 301         break;
 302
 303         case SID_OPENDLG_TABOP:
 304         {
 305             ScViewData*  pViewData  = GetViewData();
 306             ScRefAddress  aCurPos   ( pViewData->GetCurX(),
 307                                       pViewData->GetCurY(),
 308                                       pViewData->GetTabNo(),
 309                                       false, false, false );
 310
 311             pResult = new ScTabOpDlg( pB, pCW, pParent, pViewData->GetDocument(), aCurPos );
 312         }
 313         break;
 314
 315         case SID_OPENDLG_SOLVE:
 316         {
 317             ScViewData*  pViewData  = GetViewData();
 318             ScAddress aCurPos(  pViewData->GetCurX(),
 319                                 pViewData->GetCurY(),
 320                                 pViewData->GetTabNo());
 321             pResult = new ScSolverDlg( pB, pCW, pParent, pViewData->GetDocument(), aCurPos );
 322         }
 323         break;
 324
 325         case SID_RANDOM_NUMBER_GENERATOR_DIALOG:
 326         {
 327             pResult = new ScRandomNumberGeneratorDialog( pB, pCW, pParent, GetViewData() );
 328         }
 329         break;
 330
 331         case SID_SAMPLING_DIALOG:
 332         {
 333             pResult = new ScSamplingDialog( pB, pCW, pParent, GetViewData() );
 334         }
 335         break;
 336
 337         case SID_DESCRIPTIVE_STATISTICS_DIALOG:
 338         {
 339             pResult = new ScDescriptiveStatisticsDialog( pB, pCW, pParent, GetViewData() );
 340         }
 341         break;
 342
 343         case SID_ANALYSIS_OF_VARIANCE_DIALOG:
 344         {
 345             pResult = new ScAnalysisOfVarianceDialog( pB, pCW, pParent, GetViewData() );
 346         }
 347         break;
 348
 349         case SID_CORRELATION_DIALOG:
 350         {
 351             pResult = new ScCorrelationDialog( pB, pCW, pParent, GetViewData() );
 352         }
 353         break;
 354
 355         case SID_COVARIANCE_DIALOG:
 356         {
 357             pResult = new ScCovarianceDialog( pB, pCW, pParent, GetViewData() );
 358         }
 359         break;
 360
 361         case SID_EXPONENTIAL_SMOOTHING_DIALOG:
 362         {
 363             pResult = new ScExponentialSmoothingDialog( pB, pCW, pParent, GetViewData() );
 364         }
 365         break;
 366
 367         case SID_MOVING_AVERAGE_DIALOG:
 368         {
 369             pResult = new ScMovingAverageDialog( pB, pCW, pParent, GetViewData() );
 370         }
 371         break;
 372
 373         case SID_OPENDLG_OPTSOLVER:
 374         {
 375             ScViewData* pViewData = GetViewData();
 376             ScAddress aCurPos( pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo());
 377             pResult = new ScOptSolverDlg( pB, pCW, pParent, pViewData->GetDocShell(), aCurPos );
 378         }
 379         break;
 380
 381         case SID_OPENDLG_PIVOTTABLE:
 382         {
 383 #if ! MPL_HAVE_SUBSET
 384             //  all settings must be in pDialogDPObject
 385
 386             if( pDialogDPObject )
 387             {
 388                 // Check for an existing datapilot output.
 389                 ScViewData* pViewData = GetViewData();
 390                 ScDPObject* pObj = pDoc->GetDPAtCursor(
 391                     pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo());
 392
 393                 GetViewData()->SetRefTabNo( GetViewData()->GetTabNo() );
 394                 pResult = new ScPivotLayoutDlg( pB, pCW, pParent, *pDialogDPObject, pObj == NULL);
 395             }
 396 #endif
 397         }
 398         break;
 399
 400         case SID_OPENDLG_EDIT_PRINTAREA:
 401         {
 402             pResult = new ScPrintAreasDlg( pB, pCW, pParent );
 403         }
 404         break;
 405
 406         case SID_OPENDLG_FUNCTION:
 407         {
 408             //  Dialog schaut selber, was in der Zelle steht
 409
 410             pResult = new ScFormulaDlg( pB, pCW, pParent, GetViewData(),ScGlobal::GetStarCalcFunctionMgr() );
 411         }
 412         break;
 413
 414         case SID_MANAGE_XML_SOURCE:
 415         {
 416 #if ENABLE_ORCUS
 417             pResult = new ScXMLSourceDlg(pB, pCW, pParent, pDoc);
 418 #endif
 419         }
 420         break;
 421
 422         case FID_CHG_SHOW:
 423         {
 424             //  Dialog schaut selber, was in der Zelle steht
 425
 426             pResult = new ScHighlightChgDlg( pB, pCW, pParent, GetViewData() );
 427         }
 428         break;
 429
 430         case WID_SIMPLE_REF:
 431         {
 432             //  Dialog schaut selber, was in der Zelle steht
 433
 434             ScViewData* pViewData = GetViewData();
 435             pViewData->SetRefTabNo( pViewData->GetTabNo() );
 436             pResult = new ScSimpleRefDlg( pB, pCW, pParent, pViewData );
 437         }
 438         break;
 439
 440
 441         default:
 442         OSL_FAIL( "ScTabViewShell::CreateRefDialog: unbekannte ID" );
 443         break;
 444     }
 445
 446     if (pResult)
 447     {
 448         //  Die Dialoge gehen immer mit eingeklapptem Zusaetze-Button auf,
 449         //  darum muss die Groesse ueber das Initialize gerettet werden
 450         //  (oder den Zusaetze-Status mit speichern !!!)
 451
 452         Size aSize = pResult->GetSizePixel();
 453         pResult->Initialize( pInfo );
 454         pResult->SetSizePixel(aSize);
 455     }
 456
 457     return pResult;
 458 }
 459
 460
 461
 462 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */