sc/source/ui/view/viewfun6.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: viewfun6.cxx,v $
  10  * $Revision: 1.11.128.4 $
  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 #include <svx/svdundo.hxx>
  35 #include <svx/svdocapt.hxx>
  36 #include <sfx2/bindings.hxx>
  37 #include <sfx2/dispatch.hxx>
  38 #include <vcl/msgbox.hxx>
  39 #include <vcl/sound.hxx>
  40
  41 #include "viewfunc.hxx"
  42 #include "detfunc.hxx"
  43 #include "detdata.hxx"
  44 #include "viewdata.hxx"
  45 #include "drwlayer.hxx"
  46 #include "docsh.hxx"
  47 #include "undocell.hxx"
  48 #include "futext.hxx"
  49 #include "docfunc.hxx"
  50 #include "globstr.hrc"
  51 #include "sc.hrc"
  52 #include "fusel.hxx"
  53 #include "reftokenhelper.hxx"
  54 #include "externalrefmgr.hxx"
  55
  56 #include <vector>
  57
  58 using ::rtl::OUStringBuffer;
  59 using ::std::vector;
  60
  61 //==================================================================
  62
  63 void ScViewFunc::DetectiveAddPred()
  64 {
  65     ScDocShell* pDocSh = GetViewData()->GetDocShell();
  66     BOOL bDone = pDocSh->GetDocFunc().
  67                     DetectiveAddPred( GetViewData()->GetCurPos() );
  68     if (!bDone)
  69         Sound::Beep();
  70
  71     RecalcPPT();        //! use broadcast in DocFunc instead?
  72 }
  73
  74 void ScViewFunc::DetectiveDelPred()
  75 {
  76     ScDocShell* pDocSh = GetViewData()->GetDocShell();
  77     BOOL bDone = pDocSh->GetDocFunc().
  78                     DetectiveDelPred( GetViewData()->GetCurPos() );
  79     if (!bDone)
  80         Sound::Beep();
  81
  82     RecalcPPT();
  83 }
  84
  85 void ScViewFunc::DetectiveAddSucc()
  86 {
  87     ScDocShell* pDocSh = GetViewData()->GetDocShell();
  88     BOOL bDone = pDocSh->GetDocFunc().
  89                     DetectiveAddSucc( GetViewData()->GetCurPos() );
  90     if (!bDone)
  91         Sound::Beep();
  92
  93     RecalcPPT();
  94 }
  95
  96 void ScViewFunc::DetectiveDelSucc()
  97 {
  98     ScDocShell* pDocSh = GetViewData()->GetDocShell();
  99     BOOL bDone = pDocSh->GetDocFunc().
 100                     DetectiveDelSucc( GetViewData()->GetCurPos() );
 101     if (!bDone)
 102         Sound::Beep();
 103
 104     RecalcPPT();
 105 }
 106
 107 void ScViewFunc::DetectiveAddError()
 108 {
 109     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 110     BOOL bDone = pDocSh->GetDocFunc().
 111                     DetectiveAddError( GetViewData()->GetCurPos() );
 112     if (!bDone)
 113         Sound::Beep();
 114
 115     RecalcPPT();
 116 }
 117
 118 void ScViewFunc::DetectiveDelAll()
 119 {
 120     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 121     BOOL bDone = pDocSh->GetDocFunc().
 122                     DetectiveDelAll( GetViewData()->GetTabNo() );
 123     if (!bDone)
 124         Sound::Beep();
 125
 126     RecalcPPT();
 127 }
 128
 129 void ScViewFunc::DetectiveMarkInvalid()
 130 {
 131     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 132     BOOL bDone = pDocSh->GetDocFunc().
 133                     DetectiveMarkInvalid( GetViewData()->GetTabNo() );
 134     if (!bDone)
 135         Sound::Beep();
 136
 137     RecalcPPT();
 138 }
 139
 140 void ScViewFunc::DetectiveRefresh()
 141 {
 142     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 143     BOOL bDone = pDocSh->GetDocFunc().DetectiveRefresh();
 144     if (!bDone)
 145         Sound::Beep();
 146
 147     RecalcPPT();
 148 }
 149
 150 static void lcl_jumpToRange(const ScRange& rRange, ScViewData* pView, ScDocument* pDoc)
 151 {
 152     String aAddrText;
 153     rRange.Format(aAddrText, SCR_ABS_3D, pDoc);
 154     SfxStringItem aPosItem(SID_CURRENTCELL, aAddrText);
 155     SfxBoolItem aUnmarkItem(FN_PARAM_1, TRUE);        // remove existing selection
 156     pView->GetDispatcher().Execute(
 157         SID_CURRENTCELL, SFX_CALLMODE_SYNCHRON | SFX_CALLMODE_RECORD,
 158         &aPosItem, &aUnmarkItem, 0L);
 159 }
 160
 161 void ScViewFunc::MarkAndJumpToRanges(const ScRangeList& rRanges)
 162 {
 163     ScViewData* pView = GetViewData();
 164     ScDocShell* pDocSh = pView->GetDocShell();
 165
 166     ScRangeList aRanges(rRanges);
 167     ScRange* p = aRanges.First();
 168     ScRangeList aRangesToMark;
 169     ScAddress aCurPos = pView->GetCurPos();
 170     for (; p; p = aRanges.Next())
 171     {
 172         // Collect only those ranges that are on the same sheet as the current
 173         // cursor.
 174
 175         if (p->aStart.Tab() == aCurPos.Tab())
 176             aRangesToMark.Append(*p);
 177     }
 178
 179     if (!aRangesToMark.Count())
 180         return;
 181
 182     // Jump to the first range of all precedent ranges.
 183     p = aRangesToMark.First();
 184     lcl_jumpToRange(*p, pView, pDocSh->GetDocument());
 185
 186     for (; p; p = aRangesToMark.Next())
 187         MarkRange(*p, false, true);
 188 }
 189
 190 void ScViewFunc::DetectiveMarkPred()
 191 {
 192     ScViewData* pView = GetViewData();
 193     ScDocShell* pDocSh = pView->GetDocShell();
 194     ScDocument* pDoc = pDocSh->GetDocument();
 195     ScMarkData& rMarkData = pView->GetMarkData();
 196     ScAddress aCurPos = pView->GetCurPos();
 197     ScRangeList aRanges;
 198     if (rMarkData.IsMarked() || rMarkData.IsMultiMarked())
 199         rMarkData.FillRangeListWithMarks(&aRanges, false);
 200     else
 201         aRanges.Append(aCurPos);
 202
 203     vector<ScSharedTokenRef> aRefTokens;
 204     pDocSh->GetDocFunc().DetectiveCollectAllPreds(aRanges, aRefTokens);
 205
 206     if (aRefTokens.empty())
 207         // No precedents found.  Nothing to do.
 208         return;
 209
 210     ScSharedTokenRef p = aRefTokens.front();
 211     if (ScRefTokenHelper::isExternalRef(p))
 212     {
 213         // This is external.  Open the external document if available, and
 214         // jump to the destination.
 215
 216         sal_uInt16 nFileId = p->GetIndex();
 217         ScExternalRefManager* pRefMgr = pDoc->GetExternalRefManager();
 218         const String* pPath = pRefMgr->getExternalFileName(nFileId);
 219
 220         ScRange aRange;
 221         if (pPath && ScRefTokenHelper::getRangeFromToken(aRange, p, true))
 222         {
 223             const String& rTabName = p->GetString();
 224             OUStringBuffer aBuf;
 225             aBuf.append(*pPath);
 226             aBuf.append(sal_Unicode('#'));
 227             aBuf.append(rTabName);
 228             aBuf.append(sal_Unicode('.'));
 229
 230             String aRangeStr;
 231             aRange.Format(aRangeStr, SCA_VALID);
 232             aBuf.append(aRangeStr);
 233
 234             ScGlobal::OpenURL(aBuf.makeStringAndClear(), String());
 235         }
 236         return;
 237     }
 238     else
 239     {
 240         ScRange aRange;
 241         ScRefTokenHelper::getRangeFromToken(aRange, p, false);
 242         if (aRange.aStart.Tab() != aCurPos.Tab())
 243         {
 244             // The first precedent range is on a different sheet.  Jump to it
 245             // immediately and forget the rest.
 246             lcl_jumpToRange(aRange, pView, pDoc);
 247             return;
 248         }
 249     }
 250
 251     ScRangeList aDestRanges;
 252     ScRefTokenHelper::getRangeListFromTokens(aDestRanges, aRefTokens);
 253     MarkAndJumpToRanges(aDestRanges);
 254 }
 255
 256 void ScViewFunc::DetectiveMarkSucc()
 257 {
 258     ScViewData* pView = GetViewData();
 259     ScDocShell* pDocSh = pView->GetDocShell();
 260     ScMarkData& rMarkData = pView->GetMarkData();
 261     ScAddress aCurPos = pView->GetCurPos();
 262     ScRangeList aRanges;
 263     if (rMarkData.IsMarked() || rMarkData.IsMultiMarked())
 264         rMarkData.FillRangeListWithMarks(&aRanges, false);
 265     else
 266         aRanges.Append(aCurPos);
 267
 268     vector<ScSharedTokenRef> aRefTokens;
 269     pDocSh->GetDocFunc().DetectiveCollectAllSuccs(aRanges, aRefTokens);
 270
 271     if (aRefTokens.empty())
 272         // No dependants found.  Nothing to do.
 273         return;
 274
 275     ScRangeList aDestRanges;
 276     ScRefTokenHelper::getRangeListFromTokens(aDestRanges, aRefTokens);
 277     MarkAndJumpToRanges(aDestRanges);
 278 }
 279
 280 //---------------------------------------------------------------------------
 281
 282 void ScViewFunc::ShowNote( bool bShow )
 283 {
 284     if( bShow )
 285         HideNoteMarker();
 286     const ScViewData& rViewData = *GetViewData();
 287     ScAddress aPos( rViewData.GetCurX(), rViewData.GetCurY(), rViewData.GetTabNo() );
 288     // show note moved to ScDocFunc, to be able to use it in notesuno.cxx
 289     rViewData.GetDocShell()->GetDocFunc().ShowNote( aPos, bShow );
 290 }
 291
 292 void ScViewFunc::EditNote()
 293 {
 294     //  zum Editieren einblenden und aktivieren
 295
 296     ScDocShell* pDocSh = GetViewData()->GetDocShell();
 297     ScDocument* pDoc = pDocSh->GetDocument();
 298     SCCOL nCol = GetViewData()->GetCurX();
 299     SCROW nRow = GetViewData()->GetCurY();
 300     SCTAB nTab = GetViewData()->GetTabNo();
 301     ScAddress aPos( nCol, nRow, nTab );
 302
 303     // start drawing undo to catch undo action for insertion of the caption object
 304     pDocSh->MakeDrawLayer();
 305     ScDrawLayer* pDrawLayer = pDoc->GetDrawLayer();
 306     pDrawLayer->BeginCalcUndo();
 307     // generated undo action is processed in FuText::StopEditMode
 308
 309     // get existing note or create a new note (including caption drawing object)
 310     if( ScPostIt* pNote = pDoc->GetOrCreateNote( aPos ) )
 311     {
 312         // hide temporary note caption
 313         HideNoteMarker();
 314         // show caption object without changing internal visibility state
 315         pNote->ShowCaptionTemp( aPos );
 316
 317         /*  Drawing object has been created in ScDocument::GetOrCreateNote() or
 318             in ScPostIt::ShowCaptionTemp(), so ScPostIt::GetCaption() should
 319             return a caption object. */
 320         if( SdrCaptionObj* pCaption = pNote->GetCaption() )
 321         {
 322             // #i33764# enable the resize handles before starting edit mode
 323             if( FuPoor* pDraw = GetDrawFuncPtr() )
 324                 static_cast< FuSelection* >( pDraw )->ActivateNoteHandles( pCaption );
 325
 326             // activate object (as in FuSelection::TestComment)
 327             GetViewData()->GetDispatcher().Execute( SID_DRAW_NOTEEDIT, SFX_CALLMODE_SYNCHRON | SFX_CALLMODE_RECORD );
 328             // jetzt den erzeugten FuText holen und in den EditModus setzen
 329             FuPoor* pPoor = GetDrawFuncPtr();
 330             if ( pPoor && (pPoor->GetSlotID() == SID_DRAW_NOTEEDIT) )    //     hat keine RTTI
 331             {
 332                 ScrollToObject( pCaption );         // Objekt komplett sichtbar machen
 333                 static_cast< FuText* >( pPoor )->SetInEditMode( pCaption );
 334             }
 335         }
 336     }
 337 }