sc/source/ui/view/tabvwsh3.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 <editeng/eeitem.hxx>
  22
  23 #include <sfx2/app.hxx>
  24 #include <sfx2/bindings.hxx>
  25 #include <sfx2/dispatch.hxx>
  26 #include <sfx2/passwd.hxx>
  27 #include <sfx2/request.hxx>
  28 #include <svl/ptitem.hxx>
  29 #include <svl/stritem.hxx>
  30 #include <tools/urlobj.hxx>
  31 #include <sfx2/objface.hxx>
  32 #include <vcl/msgbox.hxx>
  33 #include <vcl/vclenum.hxx>
  34
  35 #include "globstr.hrc"
  36 #include "scmod.hxx"
  37 #include "appoptio.hxx"
  38 #include "tabvwsh.hxx"
  39 #include "document.hxx"
  40 #include "sc.hrc"
  41 #include "inputwin.hxx"
  42 #include "scresid.hxx"
  43 #include "printfun.hxx"
  44 #include "docsh.hxx"
  45 #include "rangelst.hxx"
  46 #include "prevwsh.hxx"
  47 #include "rangeutl.hxx"
  48 #include "reffact.hxx"
  49 #include "uiitems.hxx"
  50 #include "formulacell.hxx"
  51 #include "inputhdl.hxx"
  52 #include "autoform.hxx"
  53 #include "autofmt.hxx"
  54 #include "dwfunctr.hxx"
  55 #include "shtabdlg.hxx"
  56 #include "tabprotection.hxx"
  57 #include "protectiondlg.hxx"
  58 #include "markdata.hxx"
  59
  60 #include <svl/ilstitem.hxx>
  61 #include <vector>
  62
  63 #include <svx/zoomslideritem.hxx>
  64 #include <svx/svxdlg.hxx>
  65 #include <svx/dialogs.hrc>
  66 #include <comphelper/string.hxx>
  67 #include "scabstdlg.hxx"
  68
  69 #include <boost/scoped_ptr.hpp>
  70
  71 /** Try to parse the given range using Calc-style syntax first, then
  72     Excel-style if that fails. */
  73 static sal_uInt16 lcl_ParseRange(ScRange& rScRange, const OUString& aAddress, ScDocument* pDoc, sal_uInt16 /* nSlot */)
  74 {
  75     sal_uInt16 nResult = rScRange.Parse(aAddress, pDoc);
  76     if ( (nResult & SCA_VALID) )
  77         return nResult;
  78
  79     return rScRange.Parse(aAddress, pDoc, ScAddress::Details(formula::FormulaGrammar::CONV_XL_A1, 0, 0));
  80 }
  81
  82 /** Try to parse the given address using Calc-style syntax first, then
  83     Excel-style if that fails. */
  84 static sal_uInt16 lcl_ParseAddress(ScAddress& rScAddress, const OUString& aAddress, ScDocument* pDoc, sal_uInt16 /* nSlot */)
  85 {
  86     sal_uInt16 nResult = rScAddress.Parse(aAddress, pDoc);
  87     if ( (nResult & SCA_VALID) )
  88         return nResult;
  89
  90     return rScAddress.Parse(aAddress, pDoc, ScAddress::Details(formula::FormulaGrammar::CONV_XL_A1, 0, 0));
  91 }
  92
  93 void ScTabViewShell::Execute( SfxRequest& rReq )
  94 {
  95     SfxViewFrame*       pThisFrame  = GetViewFrame();
  96     SfxBindings&        rBindings   = pThisFrame->GetBindings();
  97     ScModule*           pScMod      = SC_MOD();
  98     const SfxItemSet*   pReqArgs    = rReq.GetArgs();
  99     sal_uInt16              nSlot       = rReq.GetSlot();
 100
 101     if (nSlot != SID_CURRENTCELL)       // der kommt beim MouseButtonUp
 102         HideListBox();                  // Autofilter-DropDown-Listbox
 103
 104     switch ( nSlot )
 105     {
 106         case FID_INSERT_FILE:
 107             {
 108                 const SfxPoolItem* pItem;
 109                 if ( pReqArgs &&
 110                      pReqArgs->GetItemState(FID_INSERT_FILE,true,&pItem) == SFX_ITEM_SET )
 111                 {
 112                     OUString aFileName = ((const SfxStringItem*)pItem)->GetValue();
 113
 114                         // Einfuege-Position
 115
 116                     Point aInsertPos;
 117                     if ( pReqArgs->GetItemState(FN_PARAM_1,true,&pItem) == SFX_ITEM_SET )
 118                         aInsertPos = ((const SfxPointItem*)pItem)->GetValue();
 119                     else
 120                         aInsertPos = GetInsertPos();
 121
 122                         //  als Link?
 123
 124                     bool bAsLink = false;
 125                     if ( pReqArgs->GetItemState(FN_PARAM_2,true,&pItem) == SFX_ITEM_SET )
 126                         bAsLink = ((const SfxBoolItem*)pItem)->GetValue();
 127
 128                         // ausfuehren
 129
 130                     PasteFile( aInsertPos, aFileName, bAsLink );
 131                 }
 132             }
 133             break;
 134
 135         case SID_OPENDLG_EDIT_PRINTAREA:
 136             {
 137                 sal_uInt16          nId  = ScPrintAreasDlgWrapper::GetChildWindowId();
 138                 SfxChildWindow* pWnd = pThisFrame->GetChildWindow( nId );
 139
 140                 pScMod->SetRefDialog( nId, pWnd ? false : sal_True );
 141             }
 142             break;
 143
 144         case SID_CHANGE_PRINTAREA:
 145             {
 146                 if ( pReqArgs )         // OK aus Dialog
 147                 {
 148                     OUString aPrintStr;
 149                     OUString aRowStr;
 150                     OUString aColStr;
 151                     bool bEntire = false;
 152                     const SfxPoolItem* pItem;
 153                     if ( pReqArgs->GetItemState( SID_CHANGE_PRINTAREA, true, &pItem ) == SFX_ITEM_SET )
 154                         aPrintStr = static_cast<const SfxStringItem*>(pItem)->GetValue();
 155                     if ( pReqArgs->GetItemState( FN_PARAM_2, true, &pItem ) == SFX_ITEM_SET )
 156                         aRowStr = static_cast<const SfxStringItem*>(pItem)->GetValue();
 157                     if ( pReqArgs->GetItemState( FN_PARAM_3, true, &pItem ) == SFX_ITEM_SET )
 158                         aColStr = static_cast<const SfxStringItem*>(pItem)->GetValue();
 159                     if ( pReqArgs->GetItemState( FN_PARAM_4, true, &pItem ) == SFX_ITEM_SET )
 160                         bEntire = static_cast<const SfxBoolItem*>(pItem)->GetValue();
 161
 162                     SetPrintRanges( bEntire, &aPrintStr, &aColStr, &aRowStr, false );
 163
 164                     rReq.Done();
 165                 }
 166             }
 167             break;
 168
 169         case SID_ADD_PRINTAREA:
 170         case SID_DEFINE_PRINTAREA:      // Menue oder Basic
 171             {
 172                 bool bAdd = ( nSlot == SID_ADD_PRINTAREA );
 173                 if ( pReqArgs )
 174                 {
 175                     OUString aPrintStr;
 176                     const SfxPoolItem* pItem;
 177                     if ( pReqArgs->GetItemState( SID_DEFINE_PRINTAREA, true, &pItem ) == SFX_ITEM_SET )
 178                         aPrintStr = static_cast<const SfxStringItem*>(pItem)->GetValue();
 179                     SetPrintRanges( false, &aPrintStr, NULL, NULL, bAdd );
 180                 }
 181                 else
 182                 {
 183                     SetPrintRanges( false, NULL, NULL, NULL, bAdd );      // aus Selektion
 184                     rReq.Done();
 185                 }
 186             }
 187             break;
 188
 189         case SID_DELETE_PRINTAREA:
 190             {
 191                 // Clear currently defined print range if any, and reset it to
 192                 // print entire sheet which is the default.
 193                 OUString aEmpty;
 194                 SetPrintRanges(true, &aEmpty, NULL, NULL, false);
 195                 rReq.Done();
 196             }
 197             break;
 198
 199         case FID_DEL_MANUALBREAKS:
 200             RemoveManualBreaks();
 201             rReq.Done();
 202             break;
 203
 204         case FID_ADJUST_PRINTZOOM:
 205             AdjustPrintZoom();
 206             rReq.Done();
 207             break;
 208
 209         case FID_RESET_PRINTZOOM:
 210             SetPrintZoom( 100, 0 );     // 100%, nicht auf Seiten
 211             rReq.Done();
 212             break;
 213
 214         case SID_FORMATPAGE:
 215         case SID_STATUS_PAGESTYLE:
 216         case SID_HFEDIT:
 217             GetViewData()->GetDocShell()->
 218                 ExecutePageStyle( *this, rReq, GetViewData()->GetTabNo() );
 219             break;
 220
 221         case SID_JUMPTOMARK:
 222         case SID_CURRENTCELL:
 223             if ( pReqArgs )
 224             {
 225                 OUString aAddress;
 226                 const SfxPoolItem* pItem;
 227                 if ( pReqArgs->GetItemState( nSlot, true, &pItem ) == SFX_ITEM_SET )
 228                     aAddress = ((const SfxStringItem*)pItem)->GetValue();
 229                 else if ( nSlot == SID_JUMPTOMARK && pReqArgs->GetItemState(
 230                                             SID_JUMPTOMARK, true, &pItem ) == SFX_ITEM_SET )
 231                     aAddress = ((const SfxStringItem*)pItem)->GetValue();
 232
 233                 //  #i14927# SID_CURRENTCELL with a single cell must unmark if FN_PARAM_1
 234                 //  isn't set (for recorded macros, because IsAPI is no longer available).
 235                 //  ScGridWindow::MouseButtonUp no longer executes the slot for a single
 236                 //  cell if there is a multi selection.
 237                 bool bUnmark = ( nSlot == SID_CURRENTCELL );
 238                 if ( pReqArgs->GetItemState( FN_PARAM_1, true, &pItem ) == SFX_ITEM_SET )
 239                     bUnmark = ((const SfxBoolItem*)pItem)->GetValue();
 240
 241                 bool bAlignToCursor = true;
 242                 if (pReqArgs->GetItemState(FN_PARAM_2, true, &pItem) == SFX_ITEM_SET)
 243                     bAlignToCursor = static_cast<const SfxBoolItem*>(pItem)->GetValue();
 244
 245                 if ( nSlot == SID_JUMPTOMARK )
 246                 {
 247                     //  URL has to be decoded for escaped characters (%20)
 248                     aAddress = INetURLObject::decode( aAddress, '%',
 249                                                INetURLObject::DECODE_WITH_CHARSET,
 250                                             RTL_TEXTENCODING_UTF8 );
 251                 }
 252
 253                 bool bFound = false;
 254                 ScViewData* pViewData = GetViewData();
 255                 ScDocument* pDoc      = pViewData->GetDocument();
 256                 ScMarkData& rMark     = pViewData->GetMarkData();
 257                 ScRange     aScRange;
 258                 ScAddress   aScAddress;
 259                 sal_uInt16      nResult = lcl_ParseRange(aScRange, aAddress, pDoc, nSlot);
 260                 SCTAB       nTab = pViewData->GetTabNo();
 261                 bool        bMark = true;
 262
 263                 // Is this a range ?
 264                 if( nResult & SCA_VALID )
 265                 {
 266                     if ( nResult & SCA_TAB_3D )
 267                     {
 268                         if( aScRange.aStart.Tab() != nTab )
 269                             SetTabNo( nTab = aScRange.aStart.Tab() );
 270                     }
 271                     else
 272                     {
 273                         aScRange.aStart.SetTab( nTab );
 274                         aScRange.aEnd.SetTab( nTab );
 275                     }
 276                 }
 277                 // Is this a cell ?
 278                 else if ( (nResult = lcl_ParseAddress(aScAddress, aAddress, pDoc, nSlot)) & SCA_VALID )
 279                 {
 280                     if ( nResult & SCA_TAB_3D )
 281                     {
 282                         if( aScAddress.Tab() != nTab )
 283                             SetTabNo( nTab = aScAddress.Tab() );
 284                     }
 285                     else
 286                         aScAddress.SetTab( nTab );
 287
 288                     aScRange = ScRange( aScAddress, aScAddress );
 289                     // Zellen sollen nicht markiert werden
 290                     bMark = false;
 291                 }
 292                 // Ist es benahmster Bereich (erst Namen dann DBBereiche) ?
 293                 else
 294                 {
 295                     ScRangeUtil     aRangeUtil;
 296                     formula::FormulaGrammar::AddressConvention eConv = pDoc->GetAddressConvention();
 297                     if( aRangeUtil.MakeRangeFromName( aAddress, pDoc, nTab, aScRange, RUTL_NAMES, eConv ) ||
 298                         aRangeUtil.MakeRangeFromName( aAddress, pDoc, nTab, aScRange, RUTL_DBASE, eConv ) )
 299                     {
 300                         nResult |= SCA_VALID;
 301                         if( aScRange.aStart.Tab() != nTab )
 302                             SetTabNo( nTab = aScRange.aStart.Tab() );
 303                     }
 304                 }
 305
 306                 if ( !(nResult & SCA_VALID) && comphelper::string::isdigitAsciiString(aAddress) )
 307                 {
 308                     sal_Int32 nNumeric = aAddress.toInt32();
 309                     if ( nNumeric > 0 && nNumeric <= MAXROW+1 )
 310                     {
 311                         //  1-basierte Zeilennummer
 312
 313                         aScAddress.SetRow( (SCROW)(nNumeric - 1) );
 314                         aScAddress.SetCol( pViewData->GetCurX() );
 315                         aScAddress.SetTab( nTab );
 316                         aScRange = ScRange( aScAddress, aScAddress );
 317                         bMark    = false;
 318                         nResult  = SCA_VALID;
 319                     }
 320                 }
 321
 322                 if ( !ValidRow(aScRange.aStart.Row()) || !ValidRow(aScRange.aEnd.Row()) )
 323                     nResult = 0;
 324
 325                 // wir haben was gefunden
 326                 if( nResult & SCA_VALID )
 327                 {
 328                     bFound = true;
 329                     SCCOL nCol = aScRange.aStart.Col();
 330                     SCROW nRow = aScRange.aStart.Row();
 331                     bool bNothing = ( pViewData->GetCurX()==nCol && pViewData->GetCurY()==nRow );
 332
 333                     // markieren
 334                     if( bMark )
 335                     {
 336                         if (rMark.IsMarked())           // ist derselbe Bereich schon markiert?
 337                         {
 338                             ScRange aOldMark;
 339                             rMark.GetMarkArea( aOldMark );
 340                             aOldMark.Justify();
 341                             ScRange aCurrent = aScRange;
 342                             aCurrent.Justify();
 343                             bNothing = ( aCurrent == aOldMark );
 344                         }
 345                         else
 346                             bNothing = false;
 347
 348                         if (!bNothing)
 349                             MarkRange( aScRange, false );   // Cursor kommt hinterher...
 350                     }
 351                     else
 352                     {
 353                         //  remove old selection, unless bUnmark argument is sal_False (from navigator)
 354                         if( bUnmark )
 355                         {
 356                             MoveCursorAbs( nCol, nRow,
 357                                 SC_FOLLOW_NONE, false, false );
 358                         }
 359                     }
 360
 361                     // und Cursor setzen
 362
 363                     // zusammengefasste Zellen beruecksichtigen:
 364                     pDoc->SkipOverlapped(nCol, nRow, nTab);
 365
 366                     //  Navigator-Aufrufe sind nicht API!!!
 367
 368                     if( bNothing )
 369                     {
 370                         if (rReq.IsAPI())
 371                             rReq.Ignore();      // wenn Makro, dann gar nix
 372                         else
 373                             rReq.Done();        // sonst wenigstens aufzeichnen
 374                     }
 375                     else
 376                     {
 377                         pViewData->ResetOldCursor();
 378                         SetCursor( nCol, nRow );
 379                         rBindings.Invalidate( SID_CURRENTCELL );
 380                         rBindings.Update( nSlot );
 381
 382                         if (!rReq.IsAPI())
 383                             rReq.Done();
 384                     }
 385
 386                     if (bAlignToCursor)
 387                     {
 388                         // align to cursor even if the cursor position hasn't changed,
 389                         // because the cursor may be set outside the visible area.
 390                         AlignToCursor( nCol, nRow, SC_FOLLOW_JUMP );
 391                     }
 392
 393                     rReq.SetReturnValue( SfxStringItem( SID_CURRENTCELL, aAddress ) );
 394                 }
 395
 396                 if (!bFound)    // kein gueltiger Bereich
 397                 {
 398                     //  wenn es ein Tabellenname ist, umschalten (fuer Navigator/URL's)
 399
 400                     SCTAB nNameTab;
 401                     if ( pDoc->GetTable( aAddress, nNameTab ) )
 402                     {
 403                         bFound = true;
 404                         if ( nNameTab != nTab )
 405                             SetTabNo( nNameTab );
 406                     }
 407                 }
 408
 409                 if ( !bFound && nSlot == SID_JUMPTOMARK )
 410                 {
 411                     //  Grafik-Objekte probieren (nur bei URL's)
 412
 413                     bFound = SelectObject( aAddress );
 414                 }
 415
 416                 if (!bFound && !rReq.IsAPI())
 417                     ErrorMessage( STR_ERR_INVALID_AREA );
 418             }
 419             break;
 420
 421         case SID_CURRENTOBJECT:
 422             if ( pReqArgs )
 423             {
 424                 OUString aName = ((const SfxStringItem&)pReqArgs->Get(nSlot)).GetValue();
 425                 SelectObject( aName );
 426             }
 427             break;
 428
 429         case SID_CURRENTTAB:
 430             if ( pReqArgs )
 431             {
 432                 //  Tabelle fuer Basic ist 1-basiert
 433                 SCTAB nTab = ((const SfxUInt16Item&)pReqArgs->Get(nSlot)).GetValue() - 1;
 434                 ScDocument* pDoc = GetViewData()->GetDocument();
 435                 if ( nTab < pDoc->GetTableCount() )
 436                 {
 437                     SetTabNo( nTab );
 438                     rBindings.Update( nSlot );
 439
 440                     if( ! rReq.IsAPI() )
 441                         rReq.Done();
 442                 }
 443                 //! sonst Fehler ?
 444             }
 445             break;
 446
 447         case SID_CURRENTDOC:
 448             if ( pReqArgs )
 449             {
 450                 OUString aStrDocName( ((const SfxStringItem&)pReqArgs->
 451                                         Get(nSlot)).GetValue() );
 452
 453                 SfxViewFrame*   pViewFrame = NULL;
 454                 ScDocShell*     pDocSh = (ScDocShell*)SfxObjectShell::GetFirst();
 455                 bool            bFound = false;
 456
 457                 // zu aktivierenden ViewFrame suchen
 458
 459                 while ( pDocSh && !bFound )
 460                 {
 461                     if ( pDocSh->GetTitle() == aStrDocName )
 462                     {
 463                         pViewFrame = SfxViewFrame::GetFirst( pDocSh );
 464                         bFound = ( NULL != pViewFrame );
 465                     }
 466
 467                     pDocSh = (ScDocShell*)SfxObjectShell::GetNext( *pDocSh );
 468                 }
 469
 470                 if ( bFound )
 471                     pViewFrame->GetFrame().Appear();
 472
 473                 rReq.Ignore();//XXX wird von SFX erledigt
 474             }
 475
 476         case SID_ATTR_SIZE://XXX ???
 477             break;
 478
 479
 480         case SID_PRINTPREVIEW:
 481             {
 482                 if ( !pThisFrame->GetFrame().IsInPlace() )          // nicht bei OLE
 483                 {
 484                     //  print preview is now always in the same frame as the tab view
 485                     //  -> always switch this frame back to normal view
 486                     //  (ScPreviewShell ctor reads view data)
 487
 488                     // #102785#; finish input
 489                     pScMod->InputEnterHandler();
 490
 491                     pThisFrame->GetDispatcher()->Execute( SID_VIEWSHELL1, SFX_CALLMODE_ASYNCHRON );
 492                 }
 493                 //  else Fehler (z.B. Ole)
 494             }
 495             break;
 496
 497         case SID_DETECTIVE_DEL_ALL:
 498             DetectiveDelAll();
 499             rReq.Done();
 500             break;
 501
 502         //  SID_TABLE_ACTIVATE und SID_MARKAREA werden von Basic aus an der versteckten
 503         //  View aufgerufen, um auf der sichtbaren View zu markieren/umzuschalten:
 504
 505         case SID_TABLE_ACTIVATE:
 506             OSL_FAIL("old slot SID_TABLE_ACTIVATE");
 507             break;
 508
 509         case SID_REPAINT:
 510             PaintGrid();
 511             PaintTop();
 512             PaintLeft();
 513             PaintExtras();
 514             rReq.Done();
 515             break;
 516
 517         case FID_NORMALVIEWMODE:
 518         case FID_PAGEBREAKMODE:
 519             {
 520                 bool bWantPageBreak = nSlot == FID_PAGEBREAKMODE;
 521
 522                 // check whether there is an explicit argument, use it
 523                 const SfxPoolItem* pItem;
 524                 if ( pReqArgs && pReqArgs->GetItemState(nSlot, true, &pItem) == SFX_ITEM_SET )
 525                 {
 526                     bool bItemValue = ((const SfxBoolItem*)pItem)->GetValue();
 527                     bWantPageBreak = (nSlot == FID_PAGEBREAKMODE) == bItemValue;
 528                 }
 529
 530                 if( GetViewData()->IsPagebreakMode() != bWantPageBreak )
 531                 {
 532                     SetPagebreakMode( bWantPageBreak );
 533                     UpdatePageBreakData();
 534                     SetCurSubShell( GetCurObjectSelectionType(), true );
 535                     PaintGrid();
 536                     PaintTop();
 537                     PaintLeft();
 538                     rBindings.Invalidate( nSlot );
 539                     rReq.AppendItem( SfxBoolItem( nSlot, true ) );
 540                     rReq.Done();
 541                 }
 542             }
 543             break;
 544
 545         case FID_FUNCTION_BOX:
 546             {
 547                 sal_uInt16 nChildId = ScFunctionChildWindow::GetChildWindowId();
 548                 if ( rReq.GetArgs() )
 549                     pThisFrame->SetChildWindow( nChildId, ((const SfxBoolItem&) (rReq.GetArgs()->Get(FID_FUNCTION_BOX))).GetValue());
 550                 else
 551                 {
 552                     pThisFrame->ToggleChildWindow( nChildId );
 553                     rReq.AppendItem( SfxBoolItem( FID_FUNCTION_BOX , pThisFrame->HasChildWindow( nChildId ) ) );
 554                 }
 555
 556                 GetViewFrame()->GetBindings().Invalidate(FID_FUNCTION_BOX);
 557                 rReq.Done ();
 558             }
 559             break;
 560
 561
 562         case FID_TOGGLESYNTAX:
 563             {
 564                 bool bSet = !GetViewData()->IsSyntaxMode();
 565                 const SfxPoolItem* pItem;
 566                 if ( pReqArgs && pReqArgs->GetItemState(nSlot, true, &pItem) == SFX_ITEM_SET )
 567                     bSet = ((const SfxBoolItem*)pItem)->GetValue();
 568                 GetViewData()->SetSyntaxMode( bSet );
 569                 PaintGrid();
 570                 rBindings.Invalidate( FID_TOGGLESYNTAX );
 571                 rReq.AppendItem( SfxBoolItem( nSlot, bSet ) );
 572                 rReq.Done();
 573             }
 574             break;
 575         case FID_TOGGLEHEADERS:
 576             {
 577                 bool bSet = !GetViewData()->IsHeaderMode();
 578                 const SfxPoolItem* pItem;
 579                 if ( pReqArgs && pReqArgs->GetItemState(nSlot, true, &pItem) == SFX_ITEM_SET )
 580                     bSet = ((const SfxBoolItem*)pItem)->GetValue();
 581                 GetViewData()->SetHeaderMode( bSet );
 582                 RepeatResize();
 583                 rBindings.Invalidate( FID_TOGGLEHEADERS );
 584                 rReq.AppendItem( SfxBoolItem( nSlot, bSet ) );
 585                 rReq.Done();
 586             }
 587             break;
 588
 589         case FID_TOGGLEFORMULA:
 590             {
 591                 ScViewData* pViewData = GetViewData();
 592                 const ScViewOptions& rOpts = pViewData->GetOptions();
 593                 bool bFormulaMode = !rOpts.GetOption( VOPT_FORMULAS );
 594                 const SfxPoolItem *pItem;
 595                 if( pReqArgs && pReqArgs->GetItemState(nSlot, true, &pItem) == SFX_ITEM_SET )
 596                     bFormulaMode = ((const SfxBoolItem *)pItem)->GetValue();
 597
 598                 ScViewOptions rSetOpts = ScViewOptions( rOpts );
 599                 rSetOpts.SetOption( VOPT_FORMULAS, bFormulaMode );
 600                 pViewData->SetOptions( rSetOpts );
 601
 602                 pViewData->GetDocShell()->PostPaintGridAll();
 603
 604                 rBindings.Invalidate( FID_TOGGLEFORMULA );
 605                 rReq.AppendItem( SfxBoolItem( nSlot, bFormulaMode ) );
 606                 rReq.Done();
 607             }
 608             break;
 609
 610         case FID_TOGGLEINPUTLINE:
 611             {
 612                 sal_uInt16          nId  = ScInputWindowWrapper::GetChildWindowId();
 613                 SfxChildWindow* pWnd = pThisFrame->GetChildWindow( nId );
 614                 bool bSet = ( pWnd == NULL );
 615                 const SfxPoolItem* pItem;
 616                 if ( pReqArgs && pReqArgs->GetItemState(nSlot, true, &pItem) == SFX_ITEM_SET )
 617                     bSet = ((const SfxBoolItem*)pItem)->GetValue();
 618
 619                 pThisFrame->SetChildWindow( nId, bSet );
 620                 rBindings.Invalidate( FID_TOGGLEINPUTLINE );
 621                 rReq.AppendItem( SfxBoolItem( nSlot, bSet ) );
 622                 rReq.Done();
 623             }
 624             break;
 625
 626         case SID_ATTR_ZOOM: // Statuszeile
 627         case FID_SCALE:
 628             {
 629                 bool bSyncZoom = SC_MOD()->GetAppOptions().GetSynchronizeZoom();
 630                 SvxZoomType eOldZoomType = GetZoomType();
 631                 SvxZoomType eNewZoomType = eOldZoomType;
 632                 const Fraction& rOldY = GetViewData()->GetZoomY();  // Y wird angezeigt
 633                 sal_uInt16 nOldZoom = (sal_uInt16)(( rOldY.GetNumerator() * 100 )
 634                                             / rOldY.GetDenominator());
 635                 sal_uInt16 nZoom = nOldZoom;
 636                 bool bCancel = false;
 637
 638                 if ( pReqArgs )
 639                 {
 640                     const SvxZoomItem& rZoomItem = (const SvxZoomItem&)
 641                                                    pReqArgs->Get(SID_ATTR_ZOOM);
 642
 643                     eNewZoomType = rZoomItem.GetType();
 644                     nZoom     = rZoomItem.GetValue();
 645                 }
 646                 else
 647                 {
 648                     SfxItemSet      aSet     ( GetPool(), SID_ATTR_ZOOM, SID_ATTR_ZOOM );
 649                     SvxZoomItem     aZoomItem( eOldZoomType, nOldZoom, SID_ATTR_ZOOM );
 650                     boost::scoped_ptr<AbstractSvxZoomDialog> pDlg;
 651                     ScMarkData&     rMark = GetViewData()->GetMarkData();
 652                     sal_uInt16          nBtnFlags =   SVX_ZOOM_ENABLE_50
 653                                                 | SVX_ZOOM_ENABLE_75
 654                                                 | SVX_ZOOM_ENABLE_100
 655                                                 | SVX_ZOOM_ENABLE_150
 656                                                 | SVX_ZOOM_ENABLE_200
 657                                                 | SVX_ZOOM_ENABLE_WHOLEPAGE
 658                                                 | SVX_ZOOM_ENABLE_PAGEWIDTH;
 659
 660                     if ( rMark.IsMarked() || rMark.IsMultiMarked() )
 661                         nBtnFlags = nBtnFlags | SVX_ZOOM_ENABLE_OPTIMAL;
 662
 663                     aZoomItem.SetValueSet( nBtnFlags );
 664                     aSet.Put( aZoomItem );
 665                     SvxAbstractDialogFactory* pFact = SvxAbstractDialogFactory::Create();
 666                     if(pFact)
 667                     {
 668                         pDlg.reset(pFact->CreateSvxZoomDialog(GetDialogParent(), aSet ));
 669                         OSL_ENSURE(pDlg, "Dialogdiet fail!");
 670                     }
 671                     if (pDlg)
 672                     {
 673                         pDlg->SetLimits( MINZOOM, MAXZOOM );
 674
 675                         bCancel = ( RET_CANCEL == pDlg->Execute() );
 676
 677                         // bCancel is True only if we were in the previous if block,
 678                         // so no need to check again pDlg
 679                         if ( !bCancel )
 680                         {
 681                             const SvxZoomItem&  rZoomItem = (const SvxZoomItem&)
 682                                                     pDlg->GetOutputItemSet()->
 683                                                         Get( SID_ATTR_ZOOM );
 684
 685                             eNewZoomType = rZoomItem.GetType();
 686                             nZoom     = rZoomItem.GetValue();
 687                         }
 688                     }
 689                 }
 690
 691                 if ( !bCancel )
 692                 {
 693                     if ( eNewZoomType == SVX_ZOOM_PERCENT )
 694                     {
 695                         if ( nZoom < MINZOOM )  nZoom = MINZOOM;
 696                         if ( nZoom > MAXZOOM )  nZoom = MAXZOOM;
 697                     }
 698                     else
 699                     {
 700                         nZoom = CalcZoom( eNewZoomType, nOldZoom );
 701                         bCancel = nZoom == 0;
 702                     }
 703
 704                     switch ( eNewZoomType )
 705                     {
 706                         case SVX_ZOOM_WHOLEPAGE:
 707                         case SVX_ZOOM_PAGEWIDTH:
 708                             SetZoomType( eNewZoomType, bSyncZoom );
 709                             break;
 710
 711                         default:
 712                             SetZoomType( SVX_ZOOM_PERCENT, bSyncZoom );
 713                     }
 714                 }
 715
 716                 if ( nZoom != nOldZoom && !bCancel )
 717                 {
 718                     if (!GetViewData()->IsPagebreakMode())
 719                     {
 720                         ScAppOptions aNewOpt = pScMod->GetAppOptions();
 721                         aNewOpt.SetZoom( nZoom );
 722                         aNewOpt.SetZoomType( GetZoomType() );
 723                         pScMod->SetAppOptions( aNewOpt );
 724                     }
 725                     Fraction aFract( nZoom, 100 );
 726                     SetZoom( aFract, aFract, bSyncZoom );
 727                     PaintGrid();
 728                     PaintTop();
 729                     PaintLeft();
 730                     rBindings.Invalidate( SID_ATTR_ZOOM );
 731                     rReq.AppendItem( SvxZoomItem( GetZoomType(), nZoom, nSlot ) );
 732                     rReq.Done();
 733                 }
 734             }
 735             break;
 736
 737         case SID_ATTR_ZOOMSLIDER:
 738             {
 739                 const SfxPoolItem* pItem = NULL;
 740                 bool bSyncZoom = SC_MOD()->GetAppOptions().GetSynchronizeZoom();
 741                 if ( pReqArgs && pReqArgs->GetItemState(SID_ATTR_ZOOMSLIDER, true, &pItem) == SFX_ITEM_SET )
 742                 {
 743                     const sal_uInt16 nCurrentZoom = ((const SvxZoomSliderItem *)pItem)->GetValue();
 744                     if( nCurrentZoom )
 745                     {
 746                         SetZoomType( SVX_ZOOM_PERCENT, bSyncZoom );
 747                         if (!GetViewData()->IsPagebreakMode())
 748                         {
 749                             ScAppOptions aNewOpt = pScMod->GetAppOptions();
 750                             aNewOpt.SetZoom( nCurrentZoom );
 751                             aNewOpt.SetZoomType( GetZoomType() );
 752                             pScMod->SetAppOptions( aNewOpt );
 753                         }
 754                         Fraction aFract( nCurrentZoom,100 );
 755                         SetZoom( aFract, aFract, bSyncZoom );
 756                         PaintGrid();
 757                         PaintTop();
 758                         PaintLeft();
 759                         rBindings.Invalidate( SID_ATTR_ZOOMSLIDER );
 760                         rReq.Done();
 761                     }
 762                 }
 763             }
 764             break;
 765
 766         case FID_TAB_SELECTALL:
 767             SelectAllTables();
 768             rReq.Done();
 769             break;
 770
 771         case FID_TAB_DESELECTALL:
 772             DeselectAllTables();
 773             rReq.Done();
 774             break;
 775
 776         case SID_SELECT_TABLES:
 777         {
 778             ScViewData& rViewData = *GetViewData();
 779             ScDocument& rDoc = *rViewData.GetDocument();
 780             ScMarkData& rMark = rViewData.GetMarkData();
 781             SCTAB nTabCount = rDoc.GetTableCount();
 782             SCTAB nTab;
 783
 784             ::std::vector < sal_Int32 > aIndexList;
 785             SFX_REQUEST_ARG( rReq, pItem, SfxIntegerListItem, SID_SELECT_TABLES, false );
 786             if ( pItem )
 787                 pItem->GetList( aIndexList );
 788             else
 789             {
 790                 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
 791                 OSL_ENSURE(pFact, "ScAbstractFactory create fail!");
 792
 793                 boost::scoped_ptr<AbstractScShowTabDlg> pDlg(pFact->CreateScShowTabDlg(GetDialogParent()));
 794                 OSL_ENSURE(pDlg, "Dialog create fail!");
 795                 pDlg->SetDescription(
 796                     OUString( ScResId( STR_DLG_SELECTTABLES_TITLE ) ),
 797                     OUString( ScResId( STR_DLG_SELECTTABLES_LBNAME ) ),
 798                     GetStaticInterface()->GetSlot(SID_SELECT_TABLES)->GetCommand(), HID_SELECTTABLES );
 799
 800                 // fill all table names with selection state
 801                 OUString aTabName;
 802                 for( nTab = 0; nTab < nTabCount; ++nTab )
 803                 {
 804                     rDoc.GetName( nTab, aTabName );
 805                     pDlg->Insert( aTabName, rMark.GetTableSelect( nTab ) );
 806                 }
 807
 808                 if( pDlg->Execute() == RET_OK )
 809                 {
 810                     sal_uInt16 nSelCount = pDlg->GetSelectEntryCount();
 811                     sal_uInt16 nSelIx;
 812                     for( nSelIx = 0; nSelIx < nSelCount; ++nSelIx )
 813                         aIndexList.insert( aIndexList.begin()+nSelIx, pDlg->GetSelectEntryPos( nSelIx ) );
 814                     pDlg.reset();
 815                     rReq.AppendItem( SfxIntegerListItem( SID_SELECT_TABLES, aIndexList ) );
 816                 }
 817                 else
 818                     rReq.Ignore();
 819             }
 820
 821             if ( !aIndexList.empty() )
 822             {
 823                 sal_uInt16 nSelCount = aIndexList.size();
 824                 sal_uInt16 nSelIx;
 825                 SCTAB nFirstVisTab = 0;
 826
 827                 // special case: only hidden tables selected -> do nothing
 828                 bool bVisSelected = false;
 829                 for( nSelIx = 0; !bVisSelected && (nSelIx < nSelCount); ++nSelIx )
 830                     bVisSelected = rDoc.IsVisible( nFirstVisTab = static_cast<SCTAB>(aIndexList[nSelIx]) );
 831                 if( !bVisSelected )
 832                     nSelCount = 0;
 833
 834                 // select the tables
 835                 if( nSelCount )
 836                 {
 837                     for( nTab = 0; nTab < nTabCount; ++nTab )
 838                         rMark.SelectTable( nTab, false );
 839
 840                     for( nSelIx = 0; nSelIx < nSelCount; ++nSelIx )
 841                         rMark.SelectTable( static_cast<SCTAB>(aIndexList[nSelIx]), true );
 842
 843                     // activate another table, if current is deselected
 844                     if( !rMark.GetTableSelect( rViewData.GetTabNo() ) )
 845                     {
 846                         rMark.SelectTable( nFirstVisTab, true );
 847                         SetTabNo( nFirstVisTab );
 848                     }
 849
 850                     rViewData.GetDocShell()->PostPaintExtras();
 851                     SfxBindings& rBind = rViewData.GetBindings();
 852                     rBind.Invalidate( FID_FILL_TAB );
 853                     rBind.Invalidate( FID_TAB_DESELECTALL );
 854                 }
 855
 856                 rReq.Done();
 857             }
 858         }
 859         break;
 860
 861
 862         case SID_OUTLINE_DELETEALL:
 863             RemoveAllOutlines();
 864             rReq.Done();
 865             break;
 866
 867         case SID_AUTO_OUTLINE:
 868             AutoOutline();
 869             rReq.Done();
 870             break;
 871
 872
 873         case SID_WINDOW_SPLIT:
 874             {
 875                 ScSplitMode eHSplit = GetViewData()->GetHSplitMode();
 876                 ScSplitMode eVSplit = GetViewData()->GetVSplitMode();
 877                 if ( eHSplit == SC_SPLIT_NORMAL || eVSplit == SC_SPLIT_NORMAL )     // aufheben
 878                     RemoveSplit();
 879                 else if ( eHSplit == SC_SPLIT_FIX || eVSplit == SC_SPLIT_FIX )      // normal
 880                     FreezeSplitters( false );
 881                 else                                                                // erzeugen
 882                     SplitAtCursor();
 883                 rReq.Done();
 884
 885                 InvalidateSplit();
 886             }
 887             break;
 888
 889         case SID_WINDOW_FIX:
 890             {
 891                 ScSplitMode eHSplit = GetViewData()->GetHSplitMode();
 892                 ScSplitMode eVSplit = GetViewData()->GetVSplitMode();
 893                 if ( eHSplit == SC_SPLIT_FIX || eVSplit == SC_SPLIT_FIX )           // aufheben
 894                     RemoveSplit();
 895                 else
 896                     FreezeSplitters( true );        // erzeugen oder fixieren
 897                 rReq.Done();
 898
 899                 InvalidateSplit();
 900             }
 901             break;
 902
 903         case FID_CHG_SHOW:
 904             {
 905                 sal_uInt16          nId  = ScHighlightChgDlgWrapper::GetChildWindowId();
 906                 SfxChildWindow* pWnd = pThisFrame->GetChildWindow( nId );
 907
 908                 pScMod->SetRefDialog( nId, pWnd ? false : sal_True );
 909             }
 910             break;
 911
 912         case FID_CHG_ACCEPT:
 913             {
 914                 pThisFrame->ToggleChildWindow(ScAcceptChgDlgWrapper::GetChildWindowId());
 915                 GetViewFrame()->GetBindings().Invalidate(FID_CHG_ACCEPT);
 916                 rReq.Done ();
 917
 918                 /*
 919                 sal_uInt16          nId  = ScAcceptChgDlgWrapper::GetChildWindowId();
 920                 SfxChildWindow* pWnd = pThisFrame->GetChildWindow( nId );
 921
 922                 pScMod->SetRefDialog( nId, pWnd ? sal_False : sal_True );
 923                 */
 924             }
 925             break;
 926
 927         case FID_CHG_COMMENT:
 928             {
 929                 ScViewData* pData = GetViewData();
 930                 ScAddress aCursorPos( pData->GetCurX(), pData->GetCurY(), pData->GetTabNo() );
 931                 ScDocShell* pDocSh = pData->GetDocShell();
 932
 933                 ScChangeAction* pAction = pDocSh->GetChangeAction( aCursorPos );
 934                 if ( pAction )
 935                 {
 936                     const SfxPoolItem* pItem;
 937                     if ( pReqArgs &&
 938                          pReqArgs->GetItemState( nSlot, true, &pItem ) == SFX_ITEM_SET &&
 939                          pItem->ISA( SfxStringItem ) )
 940                     {
 941                         OUString aComment = ((const SfxStringItem*)pItem)->GetValue();
 942                         pDocSh->SetChangeComment( pAction, aComment );
 943                         rReq.Done();
 944                     }
 945                     else
 946                     {
 947                         pDocSh->ExecuteChangeCommentDialog( pAction, GetDialogParent() );
 948                         rReq.Done();
 949                     }
 950                 }
 951             }
 952             break;
 953
 954         case SID_CREATE_SW_DRAWVIEW:
 955             //  wird von den Forms gerufen, wenn die DrawView mit allem Zubehoer
 956             //  angelegt werden muss
 957             if (!GetScDrawView())
 958             {
 959                 GetViewData()->GetDocShell()->MakeDrawLayer();
 960                 rBindings.InvalidateAll(false);
 961             }
 962             break;
 963
 964         case FID_PROTECT_DOC:
 965             {
 966                 ScDocument*         pDoc = GetViewData()->GetDocument();
 967
 968                 if( pReqArgs )
 969                 {
 970                     const SfxPoolItem* pItem;
 971                     if( pReqArgs->HasItem( FID_PROTECT_DOC, &pItem ) &&
 972                         ((const SfxBoolItem*)pItem)->GetValue() == pDoc->IsDocProtected() )
 973                     {
 974                         rReq.Ignore();
 975                         break;
 976                     }
 977                 }
 978
 979                 ScDocProtection* pProtect = pDoc->GetDocProtection();
 980                 if (pProtect && pProtect->isProtected())
 981                 {
 982                     bool bCancel = false;
 983                     OUString aPassword;
 984
 985                     if (pProtect->isProtectedWithPass())
 986                     {
 987                         OUString aText(ScResId(SCSTR_PASSWORD));
 988
 989                         boost::scoped_ptr<SfxPasswordDialog> pDlg(new SfxPasswordDialog(GetDialogParent(), &aText));
 990                         pDlg->SetText( ScResId(SCSTR_UNPROTECTDOC) );
 991                         pDlg->SetMinLen( 0 );
 992                         pDlg->SetHelpId( GetStaticInterface()->GetSlot(FID_PROTECT_DOC)->GetCommand() );
 993                         pDlg->SetEditHelpId( HID_PASSWD_DOC );
 994
 995                         if (pDlg->Execute() == RET_OK)
 996                             aPassword = pDlg->GetPassword();
 997                         else
 998                             bCancel = true;
 999                     }
1000                     if (!bCancel)
1001                     {
1002                         Unprotect( TABLEID_DOC, aPassword );
1003                         rReq.AppendItem( SfxBoolItem( FID_PROTECT_DOC, false ) );
1004                         rReq.Done();
1005                     }
1006                 }
1007                 else
1008                 {
1009                     OUString aText(ScResId(SCSTR_PASSWORDOPT));
1010
1011                     boost::scoped_ptr<SfxPasswordDialog> pDlg(new SfxPasswordDialog(GetDialogParent(), &aText));
1012                     pDlg->SetText( ScResId(SCSTR_PROTECTDOC) );
1013                     pDlg->SetMinLen( 0 );
1014                     pDlg->SetHelpId( GetStaticInterface()->GetSlot(FID_PROTECT_DOC)->GetCommand() );
1015                     pDlg->SetEditHelpId( HID_PASSWD_DOC );
1016                     pDlg->ShowExtras( SHOWEXTRAS_CONFIRM );
1017
1018                     if (pDlg->Execute() == RET_OK)
1019                     {
1020                         OUString aPassword = pDlg->GetPassword();
1021                         Protect( TABLEID_DOC, aPassword );
1022                         rReq.AppendItem( SfxBoolItem( FID_PROTECT_DOC, true ) );
1023                         rReq.Done();
1024                     }
1025                 }
1026                 rBindings.Invalidate( FID_PROTECT_DOC );
1027             }
1028             break;
1029
1030
1031         case FID_PROTECT_TABLE:
1032         {
1033             ScDocument* pDoc = GetViewData()->GetDocument();
1034             SCTAB       nTab = GetViewData()->GetTabNo();
1035             bool        bOldProtection = pDoc->IsTabProtected(nTab);
1036
1037             if( pReqArgs )
1038             {
1039                 const SfxPoolItem* pItem;
1040                 bool bNewProtection = !bOldProtection;
1041                 if( pReqArgs->HasItem( FID_PROTECT_TABLE, &pItem ) )
1042                     bNewProtection = ((const SfxBoolItem*)pItem)->GetValue();
1043                 if( bNewProtection == bOldProtection )
1044                 {
1045                     rReq.Ignore();
1046                     break;
1047                 }
1048             }
1049
1050             if (bOldProtection)
1051             {
1052                 // Unprotect a protected sheet.
1053
1054                 ScTableProtection* pProtect = pDoc->GetTabProtection(nTab);
1055                 if (pProtect && pProtect->isProtectedWithPass())
1056                 {
1057                     OUString aText( ScResId(SCSTR_PASSWORDOPT) );
1058                     boost::scoped_ptr<SfxPasswordDialog> pDlg(new SfxPasswordDialog(GetDialogParent(), &aText));
1059                     pDlg->SetText( ScResId(SCSTR_UNPROTECTTAB) );
1060                     pDlg->SetMinLen( 0 );
1061                     pDlg->SetHelpId( GetStaticInterface()->GetSlot(FID_PROTECT_TABLE)->GetCommand() );
1062                     pDlg->SetEditHelpId( HID_PASSWD_TABLE );
1063
1064                     if (pDlg->Execute() == RET_OK)
1065                     {
1066                         OUString aPassword = pDlg->GetPassword();
1067                         Unprotect(nTab, aPassword);
1068                     }
1069                 }
1070                 else
1071                     // this sheet is not password-protected.
1072                     Unprotect(nTab, OUString());
1073
1074                 if (!pReqArgs)
1075                 {
1076                     rReq.AppendItem( SfxBoolItem(FID_PROTECT_TABLE, false) );
1077                     rReq.Done();
1078                 }
1079             }
1080             else
1081             {
1082                 // Protect a current sheet.
1083
1084                 boost::scoped_ptr<ScTableProtectionDlg> pDlg(new ScTableProtectionDlg(GetDialogParent()));
1085
1086                 ScTableProtection* pProtect = pDoc->GetTabProtection(nTab);
1087                 if (pProtect)
1088                     pDlg->SetDialogData(*pProtect);
1089
1090                 if (pDlg->Execute() == RET_OK)
1091                 {
1092                     pScMod->InputEnterHandler();
1093
1094                     ScTableProtection aNewProtect;
1095                     pDlg->WriteData(aNewProtect);
1096                     ProtectSheet(nTab, aNewProtect);
1097                     if (!pReqArgs)
1098                     {
1099                         rReq.AppendItem( SfxBoolItem(FID_PROTECT_TABLE, true) );
1100                         rReq.Done();
1101                     }
1102                 }
1103             }
1104             TabChanged();
1105             UpdateInputHandler(true);   // damit sofort wieder eingegeben werden kann
1106             SelectionChanged();
1107         }
1108         break;
1109
1110         case SID_OPT_LOCALE_CHANGED :
1111             {   // locale changed, SYSTEM number formats changed => repaint cell contents
1112                 PaintGrid();
1113                 rReq.Done();
1114             }
1115             break;
1116
1117         default:
1118             OSL_FAIL("Unbekannter Slot bei ScTabViewShell::Execute");
1119             break;
1120     }
1121 }
1122
1123 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */