sc/source/ui/view/tabvwsha.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: tabvwsha.cxx,v $
  10  * $Revision: 1.28.14.1 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_sc.hxx"
  33
  34
  35
  36 // INCLUDE ---------------------------------------------------------------
  37
  38 #define _ZFORLIST_DECLARE_TABLE
  39 #include "scitems.hxx"
  40 #include <svtools/slstitm.hxx>
  41 #include <svtools/stritem.hxx>
  42 #include <svtools/whiter.hxx>
  43 #include <svtools/zformat.hxx>
  44 #include <svx/boxitem.hxx>
  45 #include <svx/numinf.hxx>
  46 #include <svx/srchitem.hxx>
  47 #include <svx/zoomslideritem.hxx>
  48 #include <sfx2/bindings.hxx>
  49 #include <sfx2/viewfrm.hxx>
  50 #include <sfx2/dispatch.hxx>
  51 #include <sfx2/request.hxx>
  52 #include <vcl/msgbox.hxx>
  53
  54 #include "global.hxx"
  55 #include "attrib.hxx"
  56 #include "patattr.hxx"
  57 #include "document.hxx"
  58 #include "cell.hxx"             // Input Status Edit-Zellen
  59 #include "globstr.hrc"
  60 #include "scmod.hxx"
  61 #include "inputhdl.hxx"
  62 #include "inputwin.hxx"
  63 #include "docsh.hxx"
  64 #include "viewdata.hxx"
  65 //CHINA001 #include "attrdlg.hxx"
  66 #include "appoptio.hxx"
  67 #include "sc.hrc"
  68 #include "stlpool.hxx"
  69 #include "tabvwsh.hxx"
  70 #include "dwfunctr.hxx"
  71 #include "scabstdlg.hxx" //CHINA001
  72 #include "compiler.hxx"
  73
  74
  75 BOOL ScTabViewShell::GetFunction( String& rFuncStr, sal_uInt16 nErrCode )
  76 {
  77     String aStr;
  78
  79     ScSubTotalFunc eFunc = (ScSubTotalFunc) SC_MOD()->GetAppOptions().GetStatusFunc();
  80
  81     if (eFunc == SUBTOTAL_FUNC_CNT || eFunc == SUBTOTAL_FUNC_CNT2)
  82         nErrCode = 0;
  83
  84     if (nErrCode)
  85     {
  86         rFuncStr = ScGlobal::GetLongErrorString(nErrCode);
  87         return true;
  88     }
  89
  90     USHORT nGlobStrId = 0;
  91     switch (eFunc)
  92     {
  93         case SUBTOTAL_FUNC_AVE:  nGlobStrId = STR_FUN_TEXT_AVG; break;
  94         case SUBTOTAL_FUNC_CNT:  nGlobStrId = STR_FUN_TEXT_COUNT; break;
  95         case SUBTOTAL_FUNC_CNT2: nGlobStrId = STR_FUN_TEXT_COUNT2; break;
  96         case SUBTOTAL_FUNC_MAX:  nGlobStrId = STR_FUN_TEXT_MAX; break;
  97         case SUBTOTAL_FUNC_MIN:  nGlobStrId = STR_FUN_TEXT_MIN; break;
  98         case SUBTOTAL_FUNC_SUM:  nGlobStrId = STR_FUN_TEXT_SUM; break;
  99         default:
 100         {
 101             // added to avoid warnings
 102         }
 103     }
 104     if (nGlobStrId)
 105     {
 106         ScViewData* pViewData   = GetViewData();
 107         ScDocument* pDoc                = pViewData->GetDocument();
 108         ScMarkData& rMark               = pViewData->GetMarkData();
 109         SCCOL           nPosX           = pViewData->GetCurX();
 110         SCROW           nPosY           = pViewData->GetCurY();
 111         SCTAB           nTab            = pViewData->GetTabNo();
 112
 113         aStr = ScGlobal::GetRscString(nGlobStrId);
 114         aStr += '=';
 115
 116         ScAddress aCursor( nPosX, nPosY, nTab );
 117         double nVal;
 118         if ( pDoc->GetSelectionFunction( eFunc, aCursor, rMark, nVal ) )
 119         {
 120             if ( nVal == 0.0 )
 121                 aStr += '0';
 122             else
 123             {
 124                 //      Anzahl im Standardformat, die anderen nach Cursorposition
 125                 SvNumberFormatter* pFormatter = pDoc->GetFormatTable();
 126                 sal_uInt32 nNumFmt = 0;
 127                 if ( eFunc != SUBTOTAL_FUNC_CNT && eFunc != SUBTOTAL_FUNC_CNT2 )
 128                 {
 129                     //  Zahlformat aus Attributen oder Formel
 130                     pDoc->GetNumberFormat( nPosX, nPosY, nTab, nNumFmt );
 131                     if ( (nNumFmt % SV_COUNTRY_LANGUAGE_OFFSET) == 0 )
 132                     {
 133                         ScBaseCell* pCell;
 134                         pDoc->GetCell( nPosX, nPosY, nTab, pCell );
 135                         if (pCell && pCell->GetCellType() == CELLTYPE_FORMULA)
 136                         {
 137
 138                             nNumFmt = ((ScFormulaCell*)pCell)->GetStandardFormat(*pFormatter, nNumFmt );
 139                         }
 140                     }
 141                 }
 142
 143                 String aValStr;
 144                 Color* pDummy;
 145                 pFormatter->GetOutputString( nVal, nNumFmt, aValStr, &pDummy );
 146                 aStr += aValStr;
 147             }
 148         }
 149
 150         rFuncStr = aStr;
 151         return TRUE;
 152     }
 153
 154     return FALSE;
 155 }
 156
 157
 158
 159 //      Funktionen, die je nach Selektion disabled sind
 160 //      Default:
 161 //              SID_DELETE,
 162 //              SID_DELETE_CONTENTS,
 163 //              FID_DELETE_CELL
 164 //              FID_VALIDATION
 165
 166
 167 void __EXPORT ScTabViewShell::GetState( SfxItemSet& rSet )
 168 {
 169     ScViewData* pViewData       = GetViewData();
 170     ScDocument* pDoc            = pViewData->GetDocument();
 171     ScDocShell* pDocShell   = pViewData->GetDocShell();
 172     ScMarkData& rMark           = pViewData->GetMarkData();
 173     SCCOL               nPosX           = pViewData->GetCurX();
 174     SCROW               nPosY           = pViewData->GetCurY();
 175     SCTAB               nTab            = pViewData->GetTabNo();
 176     USHORT              nMyId           = 0;
 177
 178     SfxViewFrame* pThisFrame = GetViewFrame();
 179     BOOL bOle = GetViewFrame()->GetFrame()->IsInPlace();
 180
 181     SCTAB nTabCount = pDoc->GetTableCount();
 182     SCTAB nTabSelCount = rMark.GetSelectCount();
 183
 184     SfxWhichIter        aIter(rSet);
 185     USHORT                      nWhich = aIter.FirstWhich();
 186
 187     while ( nWhich )
 188     {
 189         switch ( nWhich )
 190         {
 191             case FID_CHG_COMMENT:
 192                 {
 193                     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 194                     ScAddress aPos( nPosX, nPosY, nTab );
 195                     if ( pDocSh->IsReadOnly() || !pDocSh->GetChangeAction(aPos) || pDocSh->IsDocShared() )
 196                         rSet.DisableItem( nWhich );
 197                 }
 198                 break;
 199
 200             case SID_OPENDLG_EDIT_PRINTAREA:
 201             case SID_ADD_PRINTAREA:
 202             case SID_DEFINE_PRINTAREA:
 203                 {
 204                     if ( pDocShell && pDocShell->IsDocShared() )
 205                     {
 206                         rSet.DisableItem( nWhich );
 207                     }
 208                 }
 209                 break;
 210
 211             case SID_DELETE_PRINTAREA:
 212                 if ( nTabSelCount > 1 )
 213                 {
 214                     // #i22589# also take "Print Entire Sheet" into account here
 215                     BOOL bHas = FALSE;
 216                     for (SCTAB i=0; !bHas && i<nTabCount; i++)
 217                         bHas = rMark.GetTableSelect(i) && (pDoc->GetPrintRangeCount(i) || pDoc->IsPrintEntireSheet(i));
 218                     if (!bHas)
 219                         rSet.DisableItem( nWhich );
 220                 }
 221                 else if ( !pDoc->GetPrintRangeCount( nTab ) && !pDoc->IsPrintEntireSheet( nTab ) )
 222                     rSet.DisableItem( nWhich );
 223                 if ( pDocShell && pDocShell->IsDocShared() )
 224                 {
 225                     rSet.DisableItem( nWhich );
 226                 }
 227                 break;
 228
 229             case SID_STATUS_PAGESTYLE:
 230             case SID_HFEDIT:
 231                 GetViewData()->GetDocShell()->GetStatePageStyle( *this, rSet, nTab );
 232                 break;
 233
 234             case SID_SEARCH_ITEM:
 235             {
 236                 SvxSearchItem aItem(ScGlobal::GetSearchItem()); // make a copy.
 237                 // Search on current selection if a range is marked.
 238                 aItem.SetSelection(rMark.IsMarked());
 239                 rSet.Put(aItem);
 240                 break;
 241             }
 242
 243             case SID_SEARCH_OPTIONS:
 244                 {
 245                     USHORT nOptions = 0xffff;           // alles erlaubt
 246                                                     // wenn ReadOnly, kein Ersetzen:
 247                     if (GetViewData()->GetDocShell()->IsReadOnly())
 248                         nOptions &= ~( SEARCH_OPTIONS_REPLACE | SEARCH_OPTIONS_REPLACE_ALL );
 249                     rSet.Put( SfxUInt16Item( nWhich, nOptions ) );
 250                 }
 251                 break;
 252
 253             case SID_CURRENTCELL:
 254                 {
 255                     ScAddress aScAddress( GetViewData()->GetCurX(), GetViewData()->GetCurY(), 0 );
 256                     String      aAddr;
 257                     aScAddress.Format( aAddr, SCA_ABS, NULL, pDoc->GetAddressConvention() );
 258                     SfxStringItem       aPosItem( SID_CURRENTCELL, aAddr );
 259
 260                     rSet.Put( aPosItem );
 261                 }
 262                 break;
 263
 264             case SID_CURRENTTAB:
 265                 //      Tabelle fuer Basic ist 1-basiert
 266                 rSet.Put( SfxUInt16Item( nWhich, static_cast<sal_uInt16>(GetViewData()->GetTabNo()) + 1 ) );
 267                 break;
 268
 269             case SID_CURRENTDOC:
 270                 rSet.Put( SfxStringItem( nWhich, GetViewData()->GetDocShell()->GetTitle() ) );
 271                 break;
 272
 273             case FID_TOGGLEINPUTLINE:
 274                 {
 275                     USHORT nId = ScInputWindowWrapper::GetChildWindowId();
 276
 277                     if ( pThisFrame->KnowsChildWindow( nId ) )
 278                     {
 279                         SfxChildWindow* pWnd = pThisFrame->GetChildWindow( nId );
 280                         rSet.Put( SfxBoolItem( nWhich, pWnd ? TRUE : FALSE ) );
 281                     }
 282                     else
 283                         rSet.DisableItem( nWhich );
 284                 }
 285                 break;
 286
 287             case FID_DEL_MANUALBREAKS:
 288                 if (!pDoc->HasManualBreaks(nTab))
 289                     rSet.DisableItem( nWhich );
 290                 break;
 291
 292             case FID_RESET_PRINTZOOM:
 293                 {
 294                     //  disablen, wenn schon Default eingestellt
 295
 296                     String aStyleName = pDoc->GetPageStyle( nTab );
 297                     ScStyleSheetPool* pStylePool = pDoc->GetStyleSheetPool();
 298                     SfxStyleSheetBase* pStyleSheet = pStylePool->Find( aStyleName,
 299                                                     SFX_STYLE_FAMILY_PAGE );
 300                     DBG_ASSERT( pStyleSheet, "PageStyle not found" );
 301                     if ( pStyleSheet )
 302                     {
 303                         SfxItemSet& rStyleSet = pStyleSheet->GetItemSet();
 304                         USHORT nScale = ((const SfxUInt16Item&)
 305                                             rStyleSet.Get(ATTR_PAGE_SCALE)).GetValue();
 306                         USHORT nPages = ((const SfxUInt16Item&)
 307                                             rStyleSet.Get(ATTR_PAGE_SCALETOPAGES)).GetValue();
 308                         if ( nScale == 100 && nPages == 0 )
 309                             rSet.DisableItem( nWhich );
 310                     }
 311                 }
 312                 break;
 313
 314             case FID_SCALE:
 315             case SID_ATTR_ZOOM:
 316                 if ( bOle )
 317                     rSet.DisableItem( nWhich );
 318                 else
 319                 {
 320                     const Fraction& rOldY = GetViewData()->GetZoomY();
 321                     USHORT nZoom = (USHORT)(( rOldY.GetNumerator() * 100 )
 322                                                 / rOldY.GetDenominator());
 323                     rSet.Put( SvxZoomItem( SVX_ZOOM_PERCENT, nZoom, nWhich ) );
 324                 }
 325                 break;
 326
 327             case SID_ATTR_ZOOMSLIDER:
 328                 {
 329                     if ( bOle )
 330                         rSet.DisableItem( nWhich );
 331                     else
 332                     {
 333                         const Fraction& rOldY = GetViewData()->GetZoomY();
 334                         USHORT nCurrentZoom = (USHORT)(( rOldY.GetNumerator() * 100 ) / rOldY.GetDenominator());
 335
 336                         if( nCurrentZoom )
 337                         {
 338                             SvxZoomSliderItem aZoomSliderItem( nCurrentZoom, MINZOOM, MAXZOOM, SID_ATTR_ZOOMSLIDER );
 339                             aZoomSliderItem.AddSnappingPoint( 100 );
 340                             rSet.Put( aZoomSliderItem );
 341                         }
 342                     }
 343                 }
 344                 break;
 345
 346             case FID_TOGGLESYNTAX:
 347                 rSet.Put(SfxBoolItem(nWhich, GetViewData()->IsSyntaxMode()));
 348                 break;
 349
 350             case FID_TOGGLEHEADERS:
 351                 rSet.Put(SfxBoolItem(nWhich, GetViewData()->IsHeaderMode()));
 352                 break;
 353
 354             case FID_TOGGLEFORMULA:
 355                 {
 356                     const ScViewOptions& rOpts = pViewData->GetOptions();
 357                     BOOL bFormulaMode = rOpts.GetOption( VOPT_FORMULAS );
 358                     rSet.Put(SfxBoolItem(nWhich, bFormulaMode ));
 359                 }
 360                 break;
 361
 362             case FID_NORMALVIEWMODE:
 363             case FID_PAGEBREAKMODE:
 364                 // always handle both slots - they exclude each other
 365                 if ( bOle )
 366                 {
 367                     rSet.DisableItem( FID_NORMALVIEWMODE );
 368                     rSet.DisableItem( FID_PAGEBREAKMODE );
 369                 }
 370                 else
 371                 {
 372                     rSet.Put(SfxBoolItem(FID_NORMALVIEWMODE, !GetViewData()->IsPagebreakMode()));
 373                     rSet.Put(SfxBoolItem(FID_PAGEBREAKMODE, GetViewData()->IsPagebreakMode()));
 374                 }
 375                 break;
 376
 377             case FID_FUNCTION_BOX:
 378                 nMyId = ScFunctionChildWindow::GetChildWindowId();
 379                 rSet.Put(SfxBoolItem(FID_FUNCTION_BOX, pThisFrame->HasChildWindow(nMyId)));
 380                 break;
 381
 382             case FID_PROTECT_DOC:
 383                 {
 384                     if ( pDocShell && pDocShell->IsDocShared() )
 385                     {
 386                         rSet.DisableItem( nWhich );
 387                     }
 388                     else
 389                     {
 390                         rSet.Put( SfxBoolItem( nWhich, pDoc->IsDocProtected() ) );
 391                     }
 392                 }
 393                 break;
 394
 395             case FID_PROTECT_TABLE:
 396                 {
 397                     if ( pDocShell && pDocShell->IsDocShared() )
 398                     {
 399                         rSet.DisableItem( nWhich );
 400                     }
 401                     else
 402                     {
 403                         rSet.Put( SfxBoolItem( nWhich, pDoc->IsTabProtected( nTab ) ) );
 404                     }
 405                 }
 406                 break;
 407
 408             case SID_AUTO_OUTLINE:
 409                 {
 410                     if (pDoc->GetChangeTrack()!=NULL || GetViewData()->IsMultiMarked())
 411                     {
 412                         rSet.DisableItem( nWhich );
 413                     }
 414                 }
 415                 break;
 416
 417             case SID_OUTLINE_DELETEALL:
 418                 {
 419                     SCTAB nOlTab = GetViewData()->GetTabNo();
 420                     ScOutlineTable* pOlTable = pDoc->GetOutlineTable( nOlTab );
 421                     if (pOlTable == NULL)
 422                         rSet.DisableItem( nWhich );
 423                 }
 424                 break;
 425
 426             case SID_WINDOW_SPLIT:
 427                 rSet.Put(SfxBoolItem(nWhich,
 428                             pViewData->GetHSplitMode() == SC_SPLIT_NORMAL ||
 429                             pViewData->GetVSplitMode() == SC_SPLIT_NORMAL ));
 430                 break;
 431
 432             case SID_WINDOW_FIX:
 433                 rSet.Put(SfxBoolItem(nWhich,
 434                             pViewData->GetHSplitMode() == SC_SPLIT_FIX ||
 435                             pViewData->GetVSplitMode() == SC_SPLIT_FIX ));
 436                 break;
 437
 438             case FID_CHG_SHOW:
 439                 {
 440                     if ( pDoc->GetChangeTrack() == NULL || ( pDocShell && pDocShell->IsDocShared() ) )
 441                         rSet.DisableItem( nWhich );
 442                 }
 443                 break;
 444             case FID_CHG_ACCEPT:
 445                 {
 446                     rSet.Put(SfxBoolItem(FID_CHG_ACCEPT,
 447                             pThisFrame->HasChildWindow(FID_CHG_ACCEPT)));
 448                     if(pDoc->GetChangeTrack()==NULL)
 449                     {
 450                         if ( !pThisFrame->HasChildWindow(FID_CHG_ACCEPT) )
 451                         {
 452                             rSet.DisableItem( nWhich);
 453                         }
 454                     }
 455                     if ( pDocShell && pDocShell->IsDocShared() )
 456                     {
 457                         rSet.DisableItem( nWhich );
 458                     }
 459                 }
 460                 break;
 461
 462             case SID_FORMATPAGE:
 463                 //!     bei geschuetzten Tabellen ???
 464                 if ( pDocShell && ( pDocShell->IsReadOnly() || pDocShell->IsDocShared() ) )
 465                     rSet.DisableItem( nWhich );
 466                 break;
 467
 468             case SID_PRINTPREVIEW:
 469                 // #58924# Toggle-Slot braucht einen State
 470                 rSet.Put( SfxBoolItem( nWhich, FALSE ) );
 471                 break;
 472
 473             case SID_READONLY_MODE:
 474                 rSet.Put( SfxBoolItem( nWhich, GetViewData()->GetDocShell()->IsReadOnly() ) );
 475                 break;
 476
 477             case FID_TAB_DESELECTALL:
 478                 if ( nTabSelCount == 1 )
 479                     rSet.DisableItem( nWhich );     // enabled only if several sheets are selected
 480                 break;
 481
 482         } // switch ( nWitch )
 483         nWhich = aIter.NextWhich();
 484     } // while ( nWitch )
 485 }
 486
 487 //------------------------------------------------------------------
 488 void ScTabViewShell::ExecuteCellFormatDlg( SfxRequest& rReq, USHORT nTabPage )
 489 {
 490     //CHINA001 ScAttrDlg*                               pDlg    = NULL;
 491     SfxAbstractTabDialog * pDlg = NULL; //CHINA001
 492     ScDocument*                         pDoc    = GetViewData()->GetDocument();
 493
 494     SvxBoxItem                          aLineOuter( ATTR_BORDER );
 495     SvxBoxInfoItem                      aLineInner( ATTR_BORDER_INNER );
 496
 497     SvxNumberInfoItem*          pNumberInfoItem = NULL;
 498     const ScPatternAttr*        pOldAttrs               = GetSelectionPattern();
 499     SfxItemSet*                         pOldSet                 = new SfxItemSet(
 500                                                     pOldAttrs->GetItemSet() );
 501
 502
 503     // Umrandungs-Items holen und in den Set packen:
 504     GetSelectionFrame( aLineOuter, aLineInner );
 505     pOldSet->Put( aLineOuter );
 506     pOldSet->Put( aLineInner );
 507
 508     // NumberFormat Value aus Value und Language erzeugen und eintueten
 509     pOldSet->Put( SfxUInt32Item( ATTR_VALUE_FORMAT,
 510         pOldAttrs->GetNumberFormat( pDoc->GetFormatTable() ) ) );
 511
 512     MakeNumberInfoItem( pDoc, GetViewData(), &pNumberInfoItem );
 513
 514     pOldSet->MergeRange( SID_ATTR_NUMBERFORMAT_INFO, SID_ATTR_NUMBERFORMAT_INFO );
 515     pOldSet->Put(*pNumberInfoItem );
 516
 517     bInFormatDialog = TRUE;
 518     //CHINA001 pDlg = new ScAttrDlg( GetViewFrame(), GetDialogParent(), pOldSet );
 519     ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
 520     DBG_ASSERT(pFact, "ScAbstractFactory create fail!");//CHINA001
 521
 522     pDlg = pFact->CreateScAttrDlg( GetViewFrame(), GetDialogParent(), pOldSet, RID_SCDLG_ATTR);
 523     DBG_ASSERT(pDlg, "Dialog create fail!");//CHINA001
 524     if ( nTabPage != 0xffff )
 525         pDlg->SetCurPageId( nTabPage );
 526     short nResult = pDlg->Execute();
 527     bInFormatDialog = FALSE;
 528
 529     if ( nResult == RET_OK )
 530     {
 531         const SfxItemSet* pOutSet = pDlg->GetOutputItemSet();
 532
 533         const SfxPoolItem* pItem=NULL;
 534         if(pOutSet->GetItemState(SID_ATTR_NUMBERFORMAT_INFO,TRUE,&pItem)==SFX_ITEM_SET)
 535         {
 536
 537             UpdateNumberFormatter( pDoc,(const SvxNumberInfoItem&)*pItem);
 538         }
 539
 540         ApplyAttributes( pOutSet, pOldSet );
 541
 542         rReq.Done( *pOutSet );
 543     }
 544     delete pOldSet;
 545     delete pNumberInfoItem;
 546     delete pDlg;
 547 }
 548
 549 //------------------------------------------------------------------
 550
 551 bool ScTabViewShell::IsRefInputMode() const
 552 {
 553     ScModule* pScMod = SC_MOD();
 554     if ( pScMod )
 555     {
 556         if( pScMod->IsRefDialogOpen() )
 557             return pScMod->IsFormulaMode();
 558         if( pScMod->IsFormulaMode() )
 559         {
 560             ScInputHandler* pHdl = pScMod->GetInputHdl();
 561             if ( pHdl )
 562             {
 563                 String aString = pHdl->GetEditString();
 564                 if ( !pHdl->GetSelIsRef() && aString.Len() > 1 &&
 565                      ( aString.GetChar(0) == '+' || aString.GetChar(0) == '-' ) )
 566                 {
 567                     const ScViewData* pViewData = GetViewData();
 568                     if ( pViewData )
 569                     {
 570                         ScDocument* pDoc = pViewData->GetDocument();
 571                         if ( pDoc )
 572                         {
 573                             const ScAddress aPos( pViewData->GetCurPos() );
 574                             ScCompiler aComp( pDoc, aPos );
 575                             aComp.SetGrammar(pDoc->GetGrammar());
 576                             aComp.SetCloseBrackets( false );
 577                             ScTokenArray* pArr = aComp.CompileString( aString );
 578                             if ( pArr && pArr->MayReferenceFollow() )
 579                             {
 580                                 return true;
 581                             }
 582                         }
 583                     }
 584                 }
 585                 else
 586                 {
 587                     return true;
 588                 }
 589             }
 590         }
 591     }
 592
 593     return false;
 594 }
 595
 596 //------------------------------------------------------------------
 597
 598 void ScTabViewShell::ExecuteInputDirect()
 599 {
 600     if ( !IsRefInputMode() )
 601     {
 602         ScModule* pScMod = SC_MOD();
 603         if ( pScMod )
 604         {
 605             pScMod->InputEnterHandler();
 606         }
 607     }
 608 }
 609
 610 //------------------------------------------------------------------
 611
 612 void ScTabViewShell::UpdateInputHandler( BOOL bForce /* = FALSE */, BOOL bStopEditing /* = TRUE */ )
 613 {
 614     ScInputHandler* pHdl = pInputHandler ? pInputHandler : SC_MOD()->GetInputHdl();
 615
 616     if ( pHdl )
 617     {
 618         String                                  aString;
 619         const EditTextObject*   pObject         = NULL;
 620         ScViewData*                             pViewData       = GetViewData();
 621         ScDocument*                             pDoc            = pViewData->GetDocument();
 622         CellType                                eType;
 623         SCCOL                                   nPosX           = pViewData->GetCurX();
 624         SCROW                                   nPosY           = pViewData->GetCurY();
 625         SCTAB                                   nTab            = pViewData->GetTabNo();
 626         SCTAB                                   nStartTab       = 0;
 627         SCTAB                                   nEndTab         = 0;
 628         SCCOL                                   nStartCol       = 0;
 629         SCROW                                   nStartRow       = 0;
 630         SCCOL                                   nEndCol         = 0;
 631         SCROW                                   nEndRow         = 0;
 632
 633         pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab,
 634                                   nEndCol,   nEndRow,   nEndTab );
 635
 636         PutInOrder( nStartCol, nEndCol );
 637         PutInOrder( nStartRow, nEndRow );
 638         PutInOrder( nStartTab, nEndTab );
 639
 640         BOOL bHideFormula = FALSE;
 641         BOOL bHideAll     = FALSE;
 642
 643         if (pDoc->IsTabProtected(nTab))
 644         {
 645             const ScProtectionAttr* pProt = (const ScProtectionAttr*)
 646                                             pDoc->GetAttr( nPosX,nPosY,nTab,
 647                                                            ATTR_PROTECTION);
 648             bHideFormula = pProt->GetHideFormula();
 649             bHideAll     = pProt->GetHideCell();
 650         }
 651
 652         if (!bHideAll)
 653         {
 654             pDoc->GetCellType( nPosX, nPosY, nTab, eType );
 655             if (eType == CELLTYPE_FORMULA)
 656             {
 657                 if (!bHideFormula)
 658                     pDoc->GetFormula( nPosX, nPosY, nTab, aString );
 659             }
 660             else if (eType == CELLTYPE_EDIT)
 661             {
 662                 ScBaseCell* pCell;
 663                 pDoc->GetCell( nPosX, nPosY, nTab, pCell );
 664                 ((ScEditCell*)pCell)->GetData( pObject );
 665             }
 666             else
 667             {
 668                 pDoc->GetInputString( nPosX, nPosY, nTab, aString );
 669                 if (eType == CELLTYPE_STRING)
 670                 {
 671                     //  Bei Bedarf ein ' vorneweg, damit der String nicht ungewollt
 672                     //  als Zahl interpretiert wird, und um dem Benutzer zu zeigen,
 673                     //  dass es ein String ist (#35060#).
 674                     //! Auch bei Zahlformat "Text"? -> dann beim Editieren wegnehmen
 675
 676                     SvNumberFormatter* pFormatter = pDoc->GetFormatTable();
 677                     sal_uInt32 nNumFmt;
 678                     pDoc->GetNumberFormat( nPosX, nPosY, nTab, nNumFmt );
 679                     double fDummy;
 680                     if ( pFormatter->IsNumberFormat(aString, nNumFmt, fDummy) )
 681                         aString.Insert('\'',0);
 682                 }
 683             }
 684         }
 685
 686         ScInputHdlState aState( ScAddress( nPosX,         nPosY,         nTab ),
 687                                 ScAddress( nStartCol, nStartRow, nTab ),
 688                                 ScAddress( nEndCol,       nEndRow,   nTab ),
 689                                 aString,
 690                                 pObject );
 691
 692         //      if using the view's local input handler, this view can always be set
 693         //      as current view inside NotifyChange.
 694         ScTabViewShell* pSourceSh = pInputHandler ? this : NULL;
 695
 696         pHdl->NotifyChange( &aState, bForce, pSourceSh, bStopEditing );
 697     }
 698
 699     SfxBindings& rBindings = GetViewFrame()->GetBindings();
 700     rBindings.Invalidate( SID_STATUS_SUM );                     // immer zusammen mit Eingabezeile
 701     rBindings.Invalidate( SID_ATTR_SIZE );
 702     rBindings.Invalidate( SID_TABLE_CELL );
 703 }
 704
 705 void ScTabViewShell::UpdateInputHandlerCellAdjust( SvxCellHorJustify eJust )
 706 {
 707     if( ScInputHandler* pHdl = pInputHandler ? pInputHandler : SC_MOD()->GetInputHdl() )
 708         pHdl->UpdateCellAdjust( eJust );
 709 }
 710
 711 //------------------------------------------------------------------
 712
 713 void __EXPORT ScTabViewShell::ExecuteSave( SfxRequest& rReq )
 714 {
 715     //  nur SID_SAVEDOC / SID_SAVEASDOC
 716
 717     // Eingabe auf jeden Fall abschliessen, auch wenn eine Formel bearbeitet wird
 718     SC_MOD()->InputEnterHandler();
 719
 720     if ( GetViewData()->GetDocShell()->IsDocShared() )
 721     {
 722         GetViewData()->GetDocShell()->SetDocumentModified();
 723     }
 724
 725     // ansonsten normal weiter
 726     GetViewData()->GetDocShell()->ExecuteSlot( rReq );
 727 }
 728
 729 void __EXPORT ScTabViewShell::GetSaveState( SfxItemSet& rSet )
 730 {
 731     SfxShell* pDocSh = GetViewData()->GetDocShell();
 732
 733     SfxWhichIter aIter(rSet);
 734     USHORT nWhich = aIter.FirstWhich();
 735     while( nWhich )
 736     {
 737         if ( nWhich != SID_SAVEDOC || !GetViewData()->GetDocShell()->IsDocShared() )
 738         {
 739             // get state from DocShell
 740             pDocSh->GetSlotState( nWhich, NULL, &rSet );
 741         }
 742         nWhich = aIter.NextWhich();
 743     }
 744 }
 745
 746 //------------------------------------------------------------------
 747
 748 void ScTabViewShell::ExecuteUndo(SfxRequest& rReq)
 749 {
 750     SfxShell* pSh = GetViewData()->GetDispatcher().GetShell(0);
 751     SfxUndoManager* pUndoManager = pSh->GetUndoManager();
 752
 753     const SfxItemSet* pReqArgs = rReq.GetArgs();
 754     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 755
 756     USHORT nSlot = rReq.GetSlot();
 757     switch ( nSlot )
 758     {
 759         case SID_UNDO:
 760         case SID_REDO:
 761             if ( pUndoManager )
 762             {
 763                 BOOL bIsUndo = ( nSlot == SID_UNDO );
 764
 765                 USHORT nCount = 1;
 766                 const SfxPoolItem* pItem;
 767                 if ( pReqArgs && pReqArgs->GetItemState( nSlot, TRUE, &pItem ) == SFX_ITEM_SET )
 768                     nCount = ((const SfxUInt16Item*)pItem)->GetValue();
 769
 770                 // lock paint for more than one cell undo action (not for editing within a cell)
 771                 BOOL bLockPaint = ( nCount > 1 && pUndoManager == GetUndoManager() );
 772                 if ( bLockPaint )
 773                     pDocSh->LockPaint();
 774
 775                 for (USHORT i=0; i<nCount; i++)
 776                 {
 777                     if ( bIsUndo )
 778                         pUndoManager->Undo(0);
 779                     else
 780                         pUndoManager->Redo(0);
 781                 }
 782
 783                 if ( bLockPaint )
 784                     pDocSh->UnlockPaint();
 785
 786                 GetViewFrame()->GetBindings().InvalidateAll(sal_False);
 787             }
 788             break;
 789 //              default:
 790 //                      GetViewFrame()->ExecuteSlot( rReq );
 791     }
 792 }
 793
 794 void ScTabViewShell::GetUndoState(SfxItemSet &rSet)
 795 {
 796     SfxShell* pSh = GetViewData()->GetDispatcher().GetShell(0);
 797     SfxUndoManager* pUndoManager = pSh->GetUndoManager();
 798
 799     SfxWhichIter aIter(rSet);
 800     USHORT nWhich = aIter.FirstWhich();
 801     while ( nWhich )
 802     {
 803         switch (nWhich)
 804         {
 805             case SID_GETUNDOSTRINGS:
 806             case SID_GETREDOSTRINGS:
 807                 {
 808                     SfxStringListItem aStrLst( nWhich );
 809                     if ( pUndoManager )
 810                     {
 811                         List* pList = aStrLst.GetList();
 812                         BOOL bIsUndo = ( nWhich == SID_GETUNDOSTRINGS );
 813                         USHORT nCount = bIsUndo ? pUndoManager->GetUndoActionCount() : pUndoManager->GetRedoActionCount();
 814                         for (USHORT i=0; i<nCount; i++)
 815                             pList->Insert( new String( bIsUndo ? pUndoManager->GetUndoActionComment(i) :
 816                                                                  pUndoManager->GetRedoActionComment(i) ),
 817                                            LIST_APPEND );
 818                     }
 819                     rSet.Put( aStrLst );
 820                 }
 821                 break;
 822             default:
 823                 // get state from sfx view frame
 824                 GetViewFrame()->GetSlotState( nWhich, NULL, &rSet );
 825         }
 826
 827         nWhich = aIter.NextWhich();
 828     }
 829 }
 830
 831
 832 //------------------------------------------------------------------
 833
 834 void ScTabViewShell::ExecDrawOpt( SfxRequest& rReq )
 835 {
 836     ScViewOptions aViewOptions = GetViewData()->GetOptions();
 837     ScGridOptions aGridOptions = aViewOptions.GetGridOptions();
 838
 839     SfxBindings& rBindings = GetViewFrame()->GetBindings();
 840     const SfxItemSet* pArgs = rReq.GetArgs();
 841     const SfxPoolItem* pItem;
 842     USHORT nSlotId = rReq.GetSlot();
 843     switch (nSlotId)
 844     {
 845         case SID_GRID_VISIBLE:
 846             if ( pArgs && pArgs->GetItemState(nSlotId,TRUE,&pItem) == SFX_ITEM_SET )
 847             {
 848                 aGridOptions.SetGridVisible( ((const SfxBoolItem*)pItem)->GetValue() );
 849                 aViewOptions.SetGridOptions(aGridOptions);
 850                 rBindings.Invalidate(SID_GRID_VISIBLE);
 851             }
 852             break;
 853
 854         case SID_GRID_USE:
 855             if ( pArgs && pArgs->GetItemState(nSlotId,TRUE,&pItem) == SFX_ITEM_SET )
 856             {
 857                 aGridOptions.SetUseGridSnap( ((const SfxBoolItem*)pItem)->GetValue() );
 858                 aViewOptions.SetGridOptions(aGridOptions);
 859                 rBindings.Invalidate(SID_GRID_USE);
 860             }
 861             break;
 862
 863         case SID_HELPLINES_MOVE:
 864             if ( pArgs && pArgs->GetItemState(nSlotId,TRUE,&pItem) == SFX_ITEM_SET )
 865             {
 866                 aViewOptions.SetOption( VOPT_HELPLINES, ((const SfxBoolItem*)pItem)->GetValue() );
 867                 rBindings.Invalidate(SID_HELPLINES_MOVE);
 868             }
 869             break;
 870     }
 871
 872     GetViewData()->SetOptions(aViewOptions);
 873 }
 874
 875 void ScTabViewShell::GetDrawOptState( SfxItemSet& rSet )
 876 {
 877     SfxBoolItem aBool;
 878
 879     const ScViewOptions& rViewOptions = GetViewData()->GetOptions();
 880     const ScGridOptions& rGridOptions = rViewOptions.GetGridOptions();
 881
 882     aBool.SetValue(rGridOptions.GetGridVisible());
 883     aBool.SetWhich( SID_GRID_VISIBLE );
 884     rSet.Put( aBool );
 885
 886     aBool.SetValue(rGridOptions.GetUseGridSnap());
 887     aBool.SetWhich( SID_GRID_USE );
 888     rSet.Put( aBool );
 889
 890     aBool.SetValue(rViewOptions.GetOption( VOPT_HELPLINES ));
 891     aBool.SetWhich( SID_HELPLINES_MOVE );
 892     rSet.Put( aBool );
 893 }
 894
 895
 896
 897