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