xref: /AOO41X/main/sc/source/ui/view/tabview3.cxx (revision 54628ca40d27d15cc98fe861da7fff7e60c2f7d6)
1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 
24 // MARKER(update_precomp.py): autogen include statement, do not remove
25 #include "precompiled_sc.hxx"
26 
27 // System - Includes -----------------------------------------------------
28 
29 
30 
31 // INCLUDE ---------------------------------------------------------------
32 #include <rangelst.hxx>
33 #include "scitems.hxx"
34 #include <editeng/eeitem.hxx>
35 
36 
37 #include <editeng/brshitem.hxx>
38 #include <editeng/editview.hxx>
39 #include <svx/fmshell.hxx>
40 #include <svx/svdoole2.hxx>
41 #include <sfx2/bindings.hxx>
42 #include <sfx2/viewfrm.hxx>
43 #include <vcl/cursor.hxx>
44 
45 #include "tabview.hxx"
46 #include "tabvwsh.hxx"
47 #include "docsh.hxx"
48 #include "gridwin.hxx"
49 #include "olinewin.hxx"
50 #include "colrowba.hxx"
51 #include "tabcont.hxx"
52 #include "scmod.hxx"
53 #include "uiitems.hxx"
54 #include "sc.hrc"
55 #include "viewutil.hxx"
56 #include "editutil.hxx"
57 #include "inputhdl.hxx"
58 #include "inputwin.hxx"
59 #include "validat.hxx"
60 #include "hintwin.hxx"
61 #include "inputopt.hxx"
62 #include "rfindlst.hxx"
63 #include "hiranges.hxx"
64 #include "viewuno.hxx"
65 #include "chartarr.hxx"
66 #include "anyrefdg.hxx"
67 #include "dpobject.hxx"
68 #include "patattr.hxx"
69 #include "dociter.hxx"
70 #include "seltrans.hxx"
71 #include "fillinfo.hxx"
72 #include "AccessibilityHints.hxx"
73 #include "rangeutl.hxx"
74 #include "client.hxx"
75 #include "tabprotection.hxx"
76 
77 #include <com/sun/star/chart2/data/HighlightedRange.hpp>
78 
79 namespace
80 {
81 
82 ScRange lcl_getSubRangeByIndex( const ScRange& rRange, sal_Int32 nIndex )
83 {
84     ScAddress aResult( rRange.aStart );
85 
86     SCCOL nWidth = rRange.aEnd.Col() - rRange.aStart.Col() + 1;
87     SCROW nHeight = rRange.aEnd.Row() - rRange.aStart.Row() + 1;
88     SCTAB nDepth = rRange.aEnd.Tab() - rRange.aStart.Tab() + 1;
89     if( (nWidth > 0) && (nHeight > 0) && (nDepth > 0) )
90     {
91         // row by row from first to last sheet
92         sal_Int32 nArea = nWidth * nHeight;
93         aResult.IncCol( static_cast< SCsCOL >( nIndex % nWidth ) );
94         aResult.IncRow( static_cast< SCsROW >( (nIndex % nArea) / nWidth ) );
95         aResult.IncTab( static_cast< SCsTAB >( nIndex / nArea ) );
96         if( !rRange.In( aResult ) )
97             aResult = rRange.aStart;
98     }
99 
100     return ScRange( aResult );
101 }
102 
103 } // anonymous namespace
104 
105 using namespace com::sun::star;
106 
107 // -----------------------------------------------------------------------
108 
109 //
110 // ---  Public-Funktionen
111 //
112 
113 void ScTabView::ClickCursor( SCCOL nPosX, SCROW nPosY, sal_Bool bControl )
114 {
115     ScDocument* pDoc = aViewData.GetDocument();
116     SCTAB nTab = aViewData.GetTabNo();
117     while (pDoc->IsHorOverlapped( nPosX, nPosY, nTab ))     //! ViewData !!!
118         --nPosX;
119     while (pDoc->IsVerOverlapped( nPosX, nPosY, nTab ))
120         --nPosY;
121 
122     sal_Bool bRefMode = SC_MOD()->IsFormulaMode();
123 
124     if ( bRefMode )
125     {
126         DoneRefMode( sal_False );
127 
128         if (bControl)
129             SC_MOD()->AddRefEntry();
130 
131         InitRefMode( nPosX, nPosY, nTab, SC_REFTYPE_REF );
132     }
133     else
134     {
135         DoneBlockMode( bControl );
136         aViewData.ResetOldCursor();
137         SetCursor( (SCCOL) nPosX, (SCROW) nPosY );
138     }
139 }
140 
141 void ScTabView::UpdateAutoFillMark()
142 {
143     // single selection or cursor
144     ScRange aMarkRange;
145     sal_Bool bMarked = (aViewData.GetSimpleArea( aMarkRange ) == SC_MARK_SIMPLE);
146 
147     sal_uInt16 i;
148     for (i=0; i<4; i++)
149         if (pGridWin[i] && pGridWin[i]->IsVisible())
150             pGridWin[i]->UpdateAutoFillMark( bMarked, aMarkRange );
151 
152     for (i=0; i<2; i++)
153     {
154         if (pColBar[i] && pColBar[i]->IsVisible())
155             pColBar[i]->SetMark( bMarked, aMarkRange.aStart.Col(), aMarkRange.aEnd.Col() );
156         if (pRowBar[i] && pRowBar[i]->IsVisible())
157             pRowBar[i]->SetMark( bMarked, aMarkRange.aStart.Row(), aMarkRange.aEnd.Row() );
158     }
159 
160     //  selection transfer object is checked together with AutoFill marks,
161     //  because it has the same requirement of a single continuous block.
162     CheckSelectionTransfer();   // update selection transfer object
163 }
164 
165 void ScTabView::FakeButtonUp( ScSplitPos eWhich )
166 {
167     if (pGridWin[eWhich])
168         pGridWin[eWhich]->FakeButtonUp();
169 }
170 
171 void ScTabView::HideAllCursors()
172 {
173     for (sal_uInt16 i=0; i<4; i++)
174         if (pGridWin[i])
175             if (pGridWin[i]->IsVisible())
176             {
177                 Cursor* pCur = pGridWin[i]->GetCursor();
178                 if (pCur)
179                     if (pCur->IsVisible())
180                         pCur->Hide();
181                 pGridWin[i]->HideCursor();
182             }
183 }
184 
185 void ScTabView::ShowAllCursors()
186 {
187     for (sal_uInt16 i=0; i<4; i++)
188         if (pGridWin[i])
189             if (pGridWin[i]->IsVisible())
190             {
191                 pGridWin[i]->ShowCursor();
192 
193                 // #114409#
194                 pGridWin[i]->CursorChanged();
195             }
196 }
197 
198 void ScTabView::HideCursor()
199 {
200     pGridWin[aViewData.GetActivePart()]->HideCursor();
201 }
202 
203 void ScTabView::ShowCursor()
204 {
205     pGridWin[aViewData.GetActivePart()]->ShowCursor();
206 
207     // #114409#
208     pGridWin[aViewData.GetActivePart()]->CursorChanged();
209 }
210 
211 void ScTabView::InvalidateAttribs()
212 {
213     SfxBindings& rBindings = aViewData.GetBindings();
214 
215     rBindings.Invalidate( SID_STYLE_APPLY );
216     rBindings.Invalidate( SID_STYLE_FAMILY2 );
217     // StarCalc kennt nur Absatz- bzw. Zellformat-Vorlagen
218 
219     rBindings.Invalidate( SID_ATTR_CHAR_FONT );
220     rBindings.Invalidate( SID_ATTR_CHAR_FONTHEIGHT );
221     rBindings.Invalidate( SID_ATTR_CHAR_COLOR );
222 
223     rBindings.Invalidate( SID_ATTR_CHAR_WEIGHT );
224     rBindings.Invalidate( SID_ATTR_CHAR_POSTURE );
225     rBindings.Invalidate( SID_ATTR_CHAR_UNDERLINE );
226     rBindings.Invalidate( SID_ULINE_VAL_NONE );
227     rBindings.Invalidate( SID_ULINE_VAL_SINGLE );
228     rBindings.Invalidate( SID_ULINE_VAL_DOUBLE );
229     rBindings.Invalidate( SID_ULINE_VAL_DOTTED );
230 
231     rBindings.Invalidate( SID_ATTR_CHAR_OVERLINE );
232 
233     rBindings.Invalidate( SID_ALIGNLEFT );
234     rBindings.Invalidate( SID_ALIGNRIGHT );
235     rBindings.Invalidate( SID_ALIGNBLOCK );
236     rBindings.Invalidate( SID_ALIGNCENTERHOR );
237 
238     rBindings.Invalidate( SID_ALIGNTOP );
239     rBindings.Invalidate( SID_ALIGNBOTTOM );
240     rBindings.Invalidate( SID_ALIGNCENTERVER );
241 
242     rBindings.Invalidate( SID_BACKGROUND_COLOR );
243 
244     rBindings.Invalidate( SID_ATTR_ALIGN_LINEBREAK );
245     rBindings.Invalidate( SID_NUMBER_FORMAT );
246 
247     rBindings.Invalidate( SID_TEXTDIRECTION_LEFT_TO_RIGHT );
248     rBindings.Invalidate( SID_TEXTDIRECTION_TOP_TO_BOTTOM );
249     rBindings.Invalidate( SID_ATTR_PARA_LEFT_TO_RIGHT );
250     rBindings.Invalidate( SID_ATTR_PARA_RIGHT_TO_LEFT );
251 
252     // pseudo slots for Format menu
253     rBindings.Invalidate( SID_ALIGN_ANY_HDEFAULT );
254     rBindings.Invalidate( SID_ALIGN_ANY_LEFT );
255     rBindings.Invalidate( SID_ALIGN_ANY_HCENTER );
256     rBindings.Invalidate( SID_ALIGN_ANY_RIGHT );
257     rBindings.Invalidate( SID_ALIGN_ANY_JUSTIFIED );
258     rBindings.Invalidate( SID_ALIGN_ANY_VDEFAULT );
259     rBindings.Invalidate( SID_ALIGN_ANY_TOP );
260     rBindings.Invalidate( SID_ALIGN_ANY_VCENTER );
261     rBindings.Invalidate( SID_ALIGN_ANY_BOTTOM );
262 
263 //  rBindings.Invalidate( SID_RANGE_VALUE );
264 //  rBindings.Invalidate( SID_RANGE_FORMULA );
265 }
266 
267 //      SetCursor - Cursor setzen, zeichnen, InputWin updaten
268 //                  oder Referenz verschicken
269 //      ohne Optimierung wegen BugId 29307
270 
271 #ifdef _MSC_VER
272 #pragma optimize ( "", off )
273 #endif
274 
275 void ScTabView::SetCursor( SCCOL nPosX, SCROW nPosY, sal_Bool bNew )
276 {
277     SCCOL nOldX = aViewData.GetCurX();
278     SCROW nOldY = aViewData.GetCurY();
279 
280     //  DeactivateIP nur noch bei MarkListHasChanged
281 
282     if ( nPosX != nOldX || nPosY != nOldY || bNew )
283     {
284         ScTabViewShell* pViewShell = aViewData.GetViewShell();
285         bool bRefMode = ( pViewShell ? pViewShell->IsRefInputMode() : false );
286         if ( aViewData.HasEditView( aViewData.GetActivePart() ) && !bRefMode ) // 23259 oder so
287         {
288             UpdateInputLine();
289         }
290 
291         HideAllCursors();
292 
293         aViewData.SetCurX( nPosX );
294         aViewData.SetCurY( nPosY );
295 
296         ShowAllCursors();
297 
298         CursorPosChanged();
299     }
300 }
301 
302 #ifdef _MSC_VER
303 #pragma optimize ( "", on )
304 #endif
305 
306 void ScTabView::CheckSelectionTransfer()
307 {
308     if ( aViewData.IsActive() )     // only for active view
309     {
310         ScModule* pScMod = SC_MOD();
311         ScSelectionTransferObj* pOld = pScMod->GetSelectionTransfer();
312         if ( pOld && pOld->GetView() == this && pOld->StillValid() )
313         {
314             // selection not changed - nothing to do
315         }
316         else
317         {
318             ScSelectionTransferObj* pNew = ScSelectionTransferObj::CreateFromView( this );
319             if ( pNew )
320             {
321                 //  create new selection
322 
323                 if (pOld)
324                     pOld->ForgetView();
325 
326                 uno::Reference<datatransfer::XTransferable> xRef( pNew );
327                 pScMod->SetSelectionTransfer( pNew );
328                 pNew->CopyToSelection( GetActiveWin() );                    // may delete pOld
329             }
330             else if ( pOld && pOld->GetView() == this )
331             {
332                 //  remove own selection
333 
334                 pOld->ForgetView();
335                 pScMod->SetSelectionTransfer( NULL );
336                 TransferableHelper::ClearSelection( GetActiveWin() );       // may delete pOld
337             }
338             // else: selection from outside: leave unchanged
339         }
340     }
341 }
342 
343 // Eingabezeile / Menues updaten
344 //  CursorPosChanged ruft SelectionChanged
345 //  SelectionChanged ruft CellContentChanged
346 
347 void ScTabView::CellContentChanged()
348 {
349     SfxBindings& rBindings = aViewData.GetBindings();
350 
351     rBindings.Invalidate( SID_ATTR_SIZE );      // -> Fehlermeldungen anzeigen
352     rBindings.Invalidate( SID_THESAURUS );
353     rBindings.Invalidate( SID_HYPERLINK_GETLINK );
354 
355     InvalidateAttribs();                    // Attribut-Updates
356     TestHintWindow();                       // Eingabemeldung (Gueltigkeit)
357 
358     aViewData.GetViewShell()->UpdateInputHandler();
359 }
360 
361 void ScTabView::SelectionChanged()
362 {
363     SfxViewFrame* pViewFrame = aViewData.GetViewShell()->GetViewFrame();
364     if (pViewFrame)
365     {
366         uno::Reference<frame::XController> xController = pViewFrame->GetFrame().GetController();
367         if (xController.is())
368         {
369             ScTabViewObj* pImp = ScTabViewObj::getImplementation( xController );
370             if (pImp)
371                 pImp->SelectionChanged();
372         }
373     }
374 
375     UpdateAutoFillMark();   // also calls CheckSelectionTransfer
376 
377     SfxBindings& rBindings = aViewData.GetBindings();
378 
379     rBindings.Invalidate( SID_CURRENTCELL );    // -> Navigator
380     rBindings.Invalidate( SID_AUTO_FILTER );    // -> Menue
381     rBindings.Invalidate( FID_NOTE_VISIBLE );
382     rBindings.Invalidate( SID_DELETE_NOTE );
383 
384         //  Funktionen, die evtl disabled werden muessen
385 
386     rBindings.Invalidate( FID_INS_ROWBRK );
387     rBindings.Invalidate( FID_INS_COLBRK );
388     rBindings.Invalidate( FID_DEL_ROWBRK );
389     rBindings.Invalidate( FID_DEL_COLBRK );
390     rBindings.Invalidate( FID_MERGE_ON );
391     rBindings.Invalidate( FID_MERGE_OFF );
392     rBindings.Invalidate( FID_MERGE_TOGGLE );
393     rBindings.Invalidate( SID_AUTOFILTER_HIDE );
394     rBindings.Invalidate( SID_UNFILTER );
395 //  rBindings.Invalidate( SID_IMPORT_DATA );        // jetzt wieder immer moeglich
396     rBindings.Invalidate( SID_REIMPORT_DATA );
397     rBindings.Invalidate( SID_REFRESH_DBAREA );
398     rBindings.Invalidate( SID_OUTLINE_SHOW );
399     rBindings.Invalidate( SID_OUTLINE_HIDE );
400     rBindings.Invalidate( SID_OUTLINE_REMOVE );
401     rBindings.Invalidate( FID_FILL_TO_BOTTOM );
402     rBindings.Invalidate( FID_FILL_TO_RIGHT );
403     rBindings.Invalidate( FID_FILL_TO_TOP );
404     rBindings.Invalidate( FID_FILL_TO_LEFT );
405     rBindings.Invalidate( FID_FILL_SERIES );
406     rBindings.Invalidate( SID_SCENARIOS );
407     rBindings.Invalidate( SID_AUTOFORMAT );
408     rBindings.Invalidate( SID_OPENDLG_TABOP );
409     rBindings.Invalidate( SID_DATA_SELECT );
410 
411     rBindings.Invalidate( SID_CUT );
412     rBindings.Invalidate( SID_COPY );
413     rBindings.Invalidate( SID_PASTE );
414     rBindings.Invalidate( SID_PASTE_SPECIAL );
415 
416     rBindings.Invalidate( FID_INS_ROW );
417     rBindings.Invalidate( FID_INS_COLUMN );
418     rBindings.Invalidate( FID_INS_CELL );
419     rBindings.Invalidate( FID_INS_CELLSDOWN );
420     rBindings.Invalidate( FID_INS_CELLSRIGHT );
421 
422     rBindings.Invalidate( FID_CHG_COMMENT );
423 
424         //  nur wegen Zellschutz:
425 
426     rBindings.Invalidate( SID_CELL_FORMAT_RESET );
427     rBindings.Invalidate( SID_DELETE );
428     rBindings.Invalidate( SID_DELETE_CONTENTS );
429     rBindings.Invalidate( FID_DELETE_CELL );
430     rBindings.Invalidate( FID_CELL_FORMAT );
431     rBindings.Invalidate( SID_ENABLE_HYPHENATION );
432     rBindings.Invalidate( SID_INSERT_POSTIT );
433     rBindings.Invalidate( SID_CHARMAP );
434     rBindings.Invalidate( SID_OPENDLG_FUNCTION );
435 //  rBindings.Invalidate( FID_CONDITIONAL_FORMAT );
436     rBindings.Invalidate( SID_OPENDLG_CONDFRMT );
437     rBindings.Invalidate( FID_VALIDATION );
438     rBindings.Invalidate( SID_EXTERNAL_SOURCE );
439     rBindings.Invalidate( SID_TEXT_TO_COLUMNS );
440     rBindings.Invalidate( SID_SORT_ASCENDING );
441     rBindings.Invalidate( SID_SORT_DESCENDING );
442 
443     if (aViewData.GetViewShell()->HasAccessibilityObjects())
444         aViewData.GetViewShell()->BroadcastAccessibility(SfxSimpleHint(SC_HINT_ACC_CURSORCHANGED));
445 
446     CellContentChanged();
447 }
448 
449 void ScTabView::CursorPosChanged()
450 {
451     sal_Bool bRefMode = SC_MOD()->IsFormulaMode();
452     if ( !bRefMode ) // Abfrage, damit RefMode bei Tabellenwechsel funktioniert
453         aViewData.GetDocShell()->Broadcast( SfxSimpleHint( FID_KILLEDITVIEW ) );
454 
455     //  Broadcast, damit andere Views des Dokuments auch umschalten
456 
457     ScDocument* pDoc = aViewData.GetDocument();
458     bool bDP = NULL != pDoc->GetDPAtCursor(
459         aViewData.GetCurX(), aViewData.GetCurY(), aViewData.GetTabNo() );
460     aViewData.GetViewShell()->SetPivotShell(bDP);
461 
462     //  UpdateInputHandler jetzt in CellContentChanged
463 
464     SelectionChanged();
465 
466     aViewData.SetTabStartCol( SC_TABSTART_NONE );
467 }
468 
469 void ScTabView::TestHintWindow()
470 {
471     //  show input help window and list drop-down button for validity
472 
473     sal_Bool bListValButton = sal_False;
474     ScAddress aListValPos;
475 
476     ScDocument* pDoc = aViewData.GetDocument();
477     const SfxUInt32Item* pItem = (const SfxUInt32Item*)
478                                         pDoc->GetAttr( aViewData.GetCurX(),
479                                                        aViewData.GetCurY(),
480                                                        aViewData.GetTabNo(),
481                                                        ATTR_VALIDDATA );
482     if ( pItem->GetValue() )
483     {
484         const ScValidationData* pData = pDoc->GetValidationEntry( pItem->GetValue() );
485         DBG_ASSERT(pData,"ValidationData nicht gefunden");
486         String aTitle, aMessage;
487         if ( pData && pData->GetInput( aTitle, aMessage ) && aMessage.Len() > 0 )
488         {
489             //! Abfrage, ob an gleicher Stelle !!!!
490 
491             DELETEZ(pInputHintWindow);
492 
493             ScSplitPos eWhich = aViewData.GetActivePart();
494             Window* pWin = pGridWin[eWhich];
495             SCCOL nCol = aViewData.GetCurX();
496             SCROW nRow = aViewData.GetCurY();
497             Point aPos = aViewData.GetScrPos( nCol, nRow, eWhich );
498             Size aWinSize = pWin->GetOutputSizePixel();
499             //  Cursor sichtbar?
500             if ( nCol >= aViewData.GetPosX(WhichH(eWhich)) &&
501                  nRow >= aViewData.GetPosY(WhichV(eWhich)) &&
502                  aPos.X() < aWinSize.Width() && aPos.Y() < aWinSize.Height() )
503             {
504                 aPos += pWin->GetPosPixel();                                // Position auf Frame
505                 long nSizeXPix;
506                 long nSizeYPix;
507                 aViewData.GetMergeSizePixel( nCol, nRow, nSizeXPix, nSizeYPix );
508 
509                 // HintWindow anlegen, bestimmt seine Groesse selbst
510                 pInputHintWindow = new ScHintWindow( pFrameWin, aTitle, aMessage );
511                 Size aHintSize = pInputHintWindow->GetSizePixel();
512                 Size aFrameWinSize = pFrameWin->GetOutputSizePixel();
513 
514                 // passende Position finden
515                 //  erster Versuch: unter dem Cursor
516                 Point aHintPos( aPos.X() + nSizeXPix / 2, aPos.Y() + nSizeYPix + 3 );
517                 if ( aHintPos.Y() + aHintSize.Height() > aFrameWinSize.Height() )
518                 {
519                     // zweiter Versuch: rechts vom Cursor
520                     aHintPos = Point( aPos.X() + nSizeXPix + 3, aPos.Y() + nSizeYPix / 2 );
521                     if ( aHintPos.X() + aHintSize.Width() > aFrameWinSize.Width() )
522                     {
523                         // dritter Versuch: ueber dem Cursor
524                         aHintPos = Point( aPos.X() + nSizeXPix / 2,
525                                             aPos.Y() - aHintSize.Height() - 3 );
526                         if ( aHintPos.Y() < 0 )
527                         {
528                             // oben und unten kein Platz - dann Default und abschneiden
529                             aHintPos = Point( aPos.X() + nSizeXPix / 2, aPos.Y() + nSizeYPix + 3 );
530                             aHintSize.Height() = aFrameWinSize.Height() - aHintPos.Y();
531                             pInputHintWindow->SetSizePixel( aHintSize );
532                         }
533                     }
534                 }
535 
536                 //  X anpassen
537                 if ( aHintPos.X() + aHintSize.Width() > aFrameWinSize.Width() )
538                     aHintPos.X() = aFrameWinSize.Width() - aHintSize.Width();
539                 //  Y anpassen
540                 if ( aHintPos.Y() + aHintSize.Height() > aFrameWinSize.Height() )
541                     aHintPos.Y() = aFrameWinSize.Height() - aHintSize.Height();
542 
543                 pInputHintWindow->SetPosPixel( aHintPos );
544                 pInputHintWindow->ToTop();
545                 pInputHintWindow->Show();
546             }
547         }
548         else
549             DELETEZ(pInputHintWindow);
550 
551         // list drop-down button
552         if ( pData && pData->HasSelectionList() )
553         {
554             aListValPos.Set( aViewData.GetCurX(), aViewData.GetCurY(), aViewData.GetTabNo() );
555             bListValButton = sal_True;
556         }
557     }
558     else
559         DELETEZ(pInputHintWindow);
560 
561     for ( sal_uInt16 i=0; i<4; i++ )
562         if ( pGridWin[i] && pGridWin[i]->IsVisible() )
563             pGridWin[i]->UpdateListValPos( bListValButton, aListValPos );
564 }
565 
566 void ScTabView::RemoveHintWindow()
567 {
568     DELETEZ(pInputHintWindow);
569 }
570 
571 
572 // find window that should not be over the cursor
573 Window* lcl_GetCareWin(SfxViewFrame* pViewFrm)
574 {
575     //! auch Spelling ??? (dann beim Aufruf Membervariable setzen)
576 
577     //  Suchen & Ersetzen
578     if ( pViewFrm->HasChildWindow(SID_SEARCH_DLG) )
579     {
580         SfxChildWindow* pChild = pViewFrm->GetChildWindow(SID_SEARCH_DLG);
581         if (pChild)
582         {
583             Window* pWin = pChild->GetWindow();
584             if (pWin && pWin->IsVisible())
585                 return pWin;
586         }
587     }
588 
589     //  Aenderungen uebernehmen
590     if ( pViewFrm->HasChildWindow(FID_CHG_ACCEPT) )
591     {
592         SfxChildWindow* pChild = pViewFrm->GetChildWindow(FID_CHG_ACCEPT);
593         if (pChild)
594         {
595             Window* pWin = pChild->GetWindow();
596             if (pWin && pWin->IsVisible())
597                 return pWin;
598         }
599     }
600 
601     return NULL;
602 }
603 
604     //
605     //  Bildschirm an Cursorposition anpassen
606     //
607 
608 void ScTabView::AlignToCursor( SCsCOL nCurX, SCsROW nCurY, ScFollowMode eMode,
609                                 const ScSplitPos* pWhich )
610 {
611     //
612     //  aktiven Teil umschalten jetzt hier
613     //
614 
615     ScSplitPos eActive = aViewData.GetActivePart();
616     ScHSplitPos eActiveX = WhichH(eActive);
617     ScVSplitPos eActiveY = WhichV(eActive);
618     sal_Bool bHFix = (aViewData.GetHSplitMode() == SC_SPLIT_FIX);
619     sal_Bool bVFix = (aViewData.GetVSplitMode() == SC_SPLIT_FIX);
620     if (bHFix)
621         if (eActiveX == SC_SPLIT_LEFT && nCurX >= (SCsCOL)aViewData.GetFixPosX())
622         {
623             ActivatePart( (eActiveY==SC_SPLIT_TOP) ? SC_SPLIT_TOPRIGHT : SC_SPLIT_BOTTOMRIGHT );
624             eActiveX = SC_SPLIT_RIGHT;
625         }
626     if (bVFix)
627         if (eActiveY == SC_SPLIT_TOP && nCurY >= (SCsROW)aViewData.GetFixPosY())
628         {
629             ActivatePart( (eActiveX==SC_SPLIT_LEFT) ? SC_SPLIT_BOTTOMLEFT : SC_SPLIT_BOTTOMRIGHT );
630             eActiveY = SC_SPLIT_BOTTOM;
631         }
632 
633     //
634     //  eigentliches Align
635     //
636 
637     if ( eMode != SC_FOLLOW_NONE )
638     {
639         ScSplitPos eAlign;
640         if (pWhich)
641             eAlign = *pWhich;
642         else
643             eAlign = aViewData.GetActivePart();
644         ScHSplitPos eAlignX = WhichH(eAlign);
645         ScVSplitPos eAlignY = WhichV(eAlign);
646 
647         SCsCOL nDeltaX = (SCsCOL) aViewData.GetPosX(eAlignX);
648         SCsROW nDeltaY = (SCsROW) aViewData.GetPosY(eAlignY);
649         SCsCOL nSizeX = (SCsCOL) aViewData.VisibleCellsX(eAlignX);
650         SCsROW nSizeY = (SCsROW) aViewData.VisibleCellsY(eAlignY);
651 
652         long nCellSizeX;
653         long nCellSizeY;
654         if ( nCurX >= 0 && nCurY >= 0 )
655             aViewData.GetMergeSizePixel( (SCCOL)nCurX, (SCROW)nCurY, nCellSizeX, nCellSizeY );
656         else
657             nCellSizeX = nCellSizeY = 0;
658         Size aScrSize = aViewData.GetScrSize();
659         long nSpaceX = ( aScrSize.Width()  - nCellSizeX ) / 2;
660         long nSpaceY = ( aScrSize.Height() - nCellSizeY ) / 2;
661         //  nSpaceY: desired start position of cell for FOLLOW_JUMP, modified if dialog interferes
662 
663         sal_Bool bForceNew = sal_False;     // force new calculation of JUMP position (vertical only)
664 
665         // VisibleCellsY == CellsAtY( GetPosY( eWhichY ), 1, eWhichY )
666 
667         //-------------------------------------------------------------------------------
668         //  falls z.B. Suchen-Dialog offen ist, Cursor nicht hinter den Dialog stellen
669         //  wenn moeglich, die Zeile mit dem Cursor oberhalb oder unterhalb des Dialogs
670 
671         //! nicht, wenn schon komplett sichtbar
672 
673         if ( eMode == SC_FOLLOW_JUMP )
674         {
675             Window* pCare = lcl_GetCareWin( aViewData.GetViewShell()->GetViewFrame() );
676             if (pCare)
677             {
678                 sal_Bool bLimit = sal_False;
679                 Rectangle aDlgPixel;
680                 Size aWinSize;
681                 Window* pWin = GetActiveWin();
682                 if (pWin)
683                 {
684                     aDlgPixel = pCare->GetWindowExtentsRelative( pWin );
685                     aWinSize = pWin->GetOutputSizePixel();
686                     //  ueberdeckt der Dialog das GridWin?
687                     if ( aDlgPixel.Right() >= 0 && aDlgPixel.Left() < aWinSize.Width() )
688                     {
689                         if ( nCurX < nDeltaX || nCurX >= nDeltaX+nSizeX ||
690                              nCurY < nDeltaY || nCurY >= nDeltaY+nSizeY )
691                             bLimit = sal_True;          // es wird sowieso gescrollt
692                         else
693                         {
694                             //  Cursor ist auf dem Bildschirm
695                             Point aStart = aViewData.GetScrPos( nCurX, nCurY, eAlign );
696                             long nCSX, nCSY;
697                             aViewData.GetMergeSizePixel( nCurX, nCurY, nCSX, nCSY );
698                             Rectangle aCursor( aStart, Size( nCSX, nCSY ) );
699                             if ( aCursor.IsOver( aDlgPixel ) )
700                                 bLimit = sal_True;      // Zelle vom Dialog ueberdeckt
701                         }
702                     }
703                 }
704 
705                 if (bLimit)
706                 {
707                     sal_Bool bBottom = sal_False;
708                     long nTopSpace = aDlgPixel.Top();
709                     long nBotSpace = aWinSize.Height() - aDlgPixel.Bottom();
710                     if ( nBotSpace > 0 && nBotSpace > nTopSpace )
711                     {
712                         long nDlgBot = aDlgPixel.Bottom();
713                         SCsCOL nWPosX;
714                         SCsROW nWPosY;
715                         aViewData.GetPosFromPixel( 0,nDlgBot, eAlign, nWPosX, nWPosY );
716                         ++nWPosY;   // unter der letzten betroffenen Zelle
717 
718                         SCsROW nDiff = nWPosY - nDeltaY;
719                         if ( nCurY >= nDiff )           // Pos. kann nicht negativ werden
720                         {
721                             nSpaceY = nDlgBot + ( nBotSpace - nCellSizeY ) / 2;
722                             bBottom = sal_True;
723                             bForceNew = sal_True;
724                         }
725                     }
726                     if ( !bBottom && nTopSpace > 0 )
727                     {
728                         nSpaceY = ( nTopSpace - nCellSizeY ) / 2;
729                         bForceNew = sal_True;
730                     }
731                 }
732             }
733         }
734         //-------------------------------------------------------------------------------
735 
736         SCsCOL nNewDeltaX = nDeltaX;
737         SCsROW nNewDeltaY = nDeltaY;
738         sal_Bool bDoLine = sal_False;
739 
740         switch (eMode)
741         {
742             case SC_FOLLOW_JUMP:
743                 if ( nCurX < nDeltaX || nCurX >= nDeltaX+nSizeX )
744                 {
745                     nNewDeltaX = nCurX - static_cast<SCsCOL>(aViewData.CellsAtX( nCurX, -1, eAlignX, static_cast<sal_uInt16>(nSpaceX) ));
746                     if (nNewDeltaX < 0) nNewDeltaX = 0;
747                     nSizeX = (SCsCOL) aViewData.CellsAtX( nNewDeltaX, 1, eAlignX );
748                 }
749                 if ( nCurY < nDeltaY || nCurY >= nDeltaY+nSizeY || bForceNew )
750                 {
751                     nNewDeltaY = nCurY - static_cast<SCsROW>(aViewData.CellsAtY( nCurY, -1, eAlignY, static_cast<sal_uInt16>(nSpaceY) ));
752                     if (nNewDeltaY < 0) nNewDeltaY = 0;
753                     nSizeY = (SCsROW) aViewData.CellsAtY( nNewDeltaY, 1, eAlignY );
754                 }
755                 bDoLine = sal_True;
756                 break;
757 
758             case SC_FOLLOW_LINE:
759                 bDoLine = sal_True;
760                 break;
761 
762             case SC_FOLLOW_FIX:
763                 if ( nCurX < nDeltaX || nCurX >= nDeltaX+nSizeX )
764                 {
765                     nNewDeltaX = nDeltaX + nCurX - aViewData.GetCurX();
766                     if (nNewDeltaX < 0) nNewDeltaX = 0;
767                     nSizeX = (SCsCOL) aViewData.CellsAtX( nNewDeltaX, 1, eAlignX );
768                 }
769                 if ( nCurY < nDeltaY || nCurY >= nDeltaY+nSizeY )
770                 {
771                     nNewDeltaY = nDeltaY + nCurY - aViewData.GetCurY();
772                     if (nNewDeltaY < 0) nNewDeltaY = 0;
773                     nSizeY = (SCsROW) aViewData.CellsAtY( nNewDeltaY, 1, eAlignY );
774                 }
775 
776                 //  like old version of SC_FOLLOW_JUMP:
777 
778                 if ( nCurX < nNewDeltaX || nCurX >= nNewDeltaX+nSizeX )
779                 {
780                     nNewDeltaX = nCurX - (nSizeX / 2);
781                     if (nNewDeltaX < 0) nNewDeltaX = 0;
782                     nSizeX = (SCsCOL) aViewData.CellsAtX( nNewDeltaX, 1, eAlignX );
783                 }
784                 if ( nCurY < nNewDeltaY || nCurY >= nNewDeltaY+nSizeY )
785                 {
786                     nNewDeltaY = nCurY - (nSizeY / 2);
787                     if (nNewDeltaY < 0) nNewDeltaY = 0;
788                     nSizeY = (SCsROW) aViewData.CellsAtY( nNewDeltaY, 1, eAlignY );
789                 }
790 
791                 bDoLine = sal_True;
792                 break;
793 
794             case SC_FOLLOW_NONE:
795                 break;
796             default:
797                 DBG_ERROR("Falscher Cursormodus");
798                 break;
799         }
800 
801         if (bDoLine)
802         {
803             while ( nCurX >= nNewDeltaX+nSizeX )
804             {
805                 nNewDeltaX = nCurX-nSizeX+1;
806                 ScDocument* pDoc = aViewData.GetDocument();
807                 SCTAB nTab = aViewData.GetTabNo();
808                 while ( nNewDeltaX < MAXCOL && !pDoc->GetColWidth( nNewDeltaX, nTab ) )
809                     ++nNewDeltaX;
810                 nSizeX = (SCsCOL) aViewData.CellsAtX( nNewDeltaX, 1, eAlignX );
811             }
812             while ( nCurY >= nNewDeltaY+nSizeY )
813             {
814                 nNewDeltaY = nCurY-nSizeY+1;
815                 ScDocument* pDoc = aViewData.GetDocument();
816                 SCTAB nTab = aViewData.GetTabNo();
817                 while ( nNewDeltaY < MAXROW && !pDoc->GetRowHeight( nNewDeltaY, nTab ) )
818                     ++nNewDeltaY;
819                 nSizeY = (SCsROW) aViewData.CellsAtY( nNewDeltaY, 1, eAlignY );
820             }
821             if ( nCurX < nNewDeltaX ) nNewDeltaX = nCurX;
822             if ( nCurY < nNewDeltaY ) nNewDeltaY = nCurY;
823         }
824 
825         if ( nNewDeltaX != nDeltaX )
826             nSizeX = (SCsCOL) aViewData.CellsAtX( nNewDeltaX, 1, eAlignX );
827         if (nNewDeltaX+nSizeX-1 > MAXCOL) nNewDeltaX = MAXCOL-nSizeX+1;
828         if (nNewDeltaX < 0) nNewDeltaX = 0;
829 
830         if ( nNewDeltaY != nDeltaY )
831             nSizeY = (SCsROW) aViewData.CellsAtY( nNewDeltaY, 1, eAlignY );
832         if (nNewDeltaY+nSizeY-1 > MAXROW) nNewDeltaY = MAXROW-nSizeY+1;
833         if (nNewDeltaY < 0) nNewDeltaY = 0;
834 
835         if ( nNewDeltaX != nDeltaX ) ScrollX( nNewDeltaX - nDeltaX, eAlignX );
836         if ( nNewDeltaY != nDeltaY ) ScrollY( nNewDeltaY - nDeltaY, eAlignY );
837     }
838 
839     //
840     //  nochmal aktiven Teil umschalten
841     //
842 
843     if (bHFix)
844         if (eActiveX == SC_SPLIT_RIGHT && nCurX < (SCsCOL)aViewData.GetFixPosX())
845         {
846             ActivatePart( (eActiveY==SC_SPLIT_TOP) ? SC_SPLIT_TOPLEFT : SC_SPLIT_BOTTOMLEFT );
847             eActiveX = SC_SPLIT_LEFT;
848         }
849     if (bVFix)
850         if (eActiveY == SC_SPLIT_BOTTOM && nCurY < (SCsROW)aViewData.GetFixPosY())
851         {
852             ActivatePart( (eActiveX==SC_SPLIT_LEFT) ? SC_SPLIT_TOPLEFT : SC_SPLIT_TOPRIGHT );
853             eActiveY = SC_SPLIT_TOP;
854         }
855 }
856 
857 sal_Bool ScTabView::SelMouseButtonDown( const MouseEvent& rMEvt )
858 {
859     sal_Bool bRet = sal_False;
860 
861     // #i3875# *Hack*
862     sal_Bool bMod1Locked = aViewData.GetViewShell()->GetLockedModifiers() & KEY_MOD1 ? sal_True : sal_False;
863     aViewData.SetSelCtrlMouseClick( rMEvt.IsMod1() || bMod1Locked );
864 
865     if ( pSelEngine )
866     {
867         bMoveIsShift = rMEvt.IsShift();
868         bRet = pSelEngine->SelMouseButtonDown( rMEvt );
869         bMoveIsShift = sal_False;
870     }
871 
872     aViewData.SetSelCtrlMouseClick( sal_False ); // #i3875# *Hack*
873 
874     return bRet;
875 }
876 
877     //
878     //  MoveCursor - mit Anpassung des Bildausschnitts
879     //
880 
881 void ScTabView::MoveCursorAbs( SCsCOL nCurX, SCsROW nCurY, ScFollowMode eMode,
882                                 sal_Bool bShift, sal_Bool bControl, sal_Bool bKeepOld, sal_Bool bKeepSel )
883 {
884     if (!bKeepOld)
885         aViewData.ResetOldCursor();
886 
887     if (nCurX < 0) nCurX = 0;
888     if (nCurY < 0) nCurY = 0;
889     if (nCurX > MAXCOL) nCurX = MAXCOL;
890     if (nCurY > MAXROW) nCurY = MAXROW;
891 
892     HideAllCursors();
893 
894     if ( bShift && bNewStartIfMarking && IsBlockMode() )
895     {
896         //  used for ADD selection mode: start a new block from the cursor position
897         DoneBlockMode( sal_True );
898         InitBlockMode( aViewData.GetCurX(), aViewData.GetCurY(), aViewData.GetTabNo(), sal_True );
899     }
900 
901         //  aktiven Teil umschalten jetzt in AlignToCursor
902 
903     AlignToCursor( nCurX, nCurY, eMode );
904     //!     auf OS/2: SC_FOLLOW_JUMP statt SC_FOLLOW_LINE, um Nachlaufen zu verhindern ???
905 
906     if (bKeepSel)
907         SetCursor( nCurX, nCurY );      // Markierung stehenlassen
908     else
909     {
910         sal_Bool bSame = ( nCurX == aViewData.GetCurX() && nCurY == aViewData.GetCurY() );
911         bMoveIsShift = bShift;
912         pSelEngine->CursorPosChanging( bShift, bControl );
913         bMoveIsShift = sal_False;
914         aFunctionSet.SetCursorAtCell( nCurX, nCurY, sal_False );
915 
916         //  Wenn der Cursor nicht bewegt wurde, muss das SelectionChanged fuer das
917         //  Aufheben der Selektion hier einzeln passieren:
918         if (bSame)
919             SelectionChanged();
920     }
921 
922     ShowAllCursors();
923 }
924 
925 void ScTabView::MoveCursorRel( SCsCOL nMovX, SCsROW nMovY, ScFollowMode eMode,
926                                     sal_Bool bShift, sal_Bool bKeepSel )
927 {
928     ScDocument* pDoc = aViewData.GetDocument();
929     SCTAB nTab = aViewData.GetTabNo();
930 
931     bool bSkipProtected = false, bSkipUnprotected = false;
932     ScTableProtection* pProtect = pDoc->GetTabProtection(nTab);
933     if ( pProtect && pProtect->isProtected() )
934     {
935         bSkipProtected   = !pProtect->isOptionEnabled(ScTableProtection::SELECT_LOCKED_CELLS);
936         bSkipUnprotected = !pProtect->isOptionEnabled(ScTableProtection::SELECT_UNLOCKED_CELLS);
937     }
938 
939     if ( bSkipProtected && bSkipUnprotected )
940         return;
941 
942     SCsCOL nOldX;
943     SCsROW nOldY;
944     SCsCOL nCurX;
945     SCsROW nCurY;
946     if ( aViewData.IsRefMode() )
947     {
948         nOldX = (SCsCOL) aViewData.GetRefEndX();
949         nOldY = (SCsROW) aViewData.GetRefEndY();
950         nCurX = nOldX + nMovX;
951         nCurY = nOldY + nMovY;
952     }
953     else
954     {
955         nOldX = (SCsCOL) aViewData.GetCurX();
956         nOldY = (SCsROW) aViewData.GetCurY();
957         nCurX = (nMovX != 0) ? nOldX+nMovX : (SCsCOL) aViewData.GetOldCurX();
958         nCurY = (nMovY != 0) ? nOldY+nMovY : (SCsROW) aViewData.GetOldCurY();
959     }
960 
961     sal_Bool bSkipCell = sal_False;
962     aViewData.ResetOldCursor();
963 
964     if (nMovX != 0 && VALIDCOLROW(nCurX,nCurY))
965     {
966         sal_Bool bHFlip = sal_False;
967         do
968         {
969             SCCOL nLastCol = -1;
970             bSkipCell = pDoc->ColHidden(nCurX, nTab, nLastCol) || pDoc->IsHorOverlapped( nCurX, nCurY, nTab );
971             if (bSkipProtected && !bSkipCell)
972                 bSkipCell = pDoc->HasAttrib(nCurX, nCurY, nTab, nCurX, nCurY, nTab, HASATTR_PROTECTED);
973             if (bSkipUnprotected && !bSkipCell)
974                 bSkipCell = !pDoc->HasAttrib(nCurX, nCurY, nTab, nCurX, nCurY, nTab, HASATTR_PROTECTED);
975 
976             if (bSkipCell)
977             {
978                 if ( nCurX<=0 || nCurX>=MAXCOL )
979                 {
980                     if (bHFlip)
981                     {
982                         nCurX = nOldX;
983                         bSkipCell = sal_False;
984                     }
985                     else
986                     {
987                         nMovX = -nMovX;
988                         if (nMovX > 0) ++nCurX; else --nCurX;       // zuruecknehmen
989                         bHFlip = sal_True;
990                     }
991                 }
992                 else
993                     if (nMovX > 0) ++nCurX; else --nCurX;
994             }
995         }
996         while (bSkipCell);
997 
998         if (pDoc->IsVerOverlapped( nCurX, nCurY, nTab ))
999         {
1000             aViewData.SetOldCursor( nCurX,nCurY );
1001             while (pDoc->IsVerOverlapped( nCurX, nCurY, nTab ))
1002                 --nCurY;
1003         }
1004     }
1005 
1006     if (nMovY != 0 && VALIDCOLROW(nCurX,nCurY))
1007     {
1008         sal_Bool bVFlip = sal_False;
1009         do
1010         {
1011             SCROW nLastRow = -1;
1012             bSkipCell = pDoc->RowHidden(nCurY, nTab, nLastRow) || pDoc->IsVerOverlapped( nCurX, nCurY, nTab );
1013             if (bSkipProtected && !bSkipCell)
1014                 bSkipCell = pDoc->HasAttrib(nCurX, nCurY, nTab, nCurX, nCurY, nTab, HASATTR_PROTECTED);
1015             if (bSkipUnprotected && !bSkipCell)
1016                 bSkipCell = !pDoc->HasAttrib(nCurX, nCurY, nTab, nCurX, nCurY, nTab, HASATTR_PROTECTED);
1017 
1018             if (bSkipCell)
1019             {
1020                 if ( nCurY<=0 || nCurY>=MAXROW )
1021                 {
1022                     if (bVFlip)
1023                     {
1024                         nCurY = nOldY;
1025                         bSkipCell = sal_False;
1026                     }
1027                     else
1028                     {
1029                         nMovY = -nMovY;
1030                         if (nMovY > 0) ++nCurY; else --nCurY;       // zuruecknehmen
1031                         bVFlip = sal_True;
1032                     }
1033                 }
1034                 else
1035                     if (nMovY > 0) ++nCurY; else --nCurY;
1036             }
1037         }
1038         while (bSkipCell);
1039 
1040         if (pDoc->IsHorOverlapped( nCurX, nCurY, nTab ))
1041         {
1042             aViewData.SetOldCursor( nCurX,nCurY );
1043             while (pDoc->IsHorOverlapped( nCurX, nCurY, nTab ))
1044                 --nCurX;
1045         }
1046     }
1047 
1048     MoveCursorAbs( nCurX, nCurY, eMode, bShift, sal_False, sal_True, bKeepSel );
1049 }
1050 
1051 void ScTabView::MoveCursorPage( SCsCOL nMovX, SCsROW nMovY, ScFollowMode eMode, sal_Bool bShift, sal_Bool bKeepSel )
1052 {
1053     SCCOL nCurX;
1054     SCROW nCurY;
1055     aViewData.GetMoveCursor( nCurX,nCurY );
1056 
1057     ScSplitPos eWhich = aViewData.GetActivePart();
1058     ScHSplitPos eWhichX = WhichH( eWhich );
1059     ScVSplitPos eWhichY = WhichV( eWhich );
1060 
1061     SCsCOL nPageX;
1062     SCsROW nPageY;
1063     if (nMovX >= 0)
1064         nPageX = ((SCsCOL) aViewData.CellsAtX( nCurX, 1, eWhichX )) * nMovX;
1065     else
1066         nPageX = ((SCsCOL) aViewData.CellsAtX( nCurX, -1, eWhichX )) * nMovX;
1067 
1068     if (nMovY >= 0)
1069         nPageY = ((SCsROW) aViewData.CellsAtY( nCurY, 1, eWhichY )) * nMovY;
1070     else
1071         nPageY = ((SCsROW) aViewData.CellsAtY( nCurY, -1, eWhichY )) * nMovY;
1072 
1073     if (nMovX != 0 && nPageX == 0) nPageX = (nMovX>0) ? 1 : -1;
1074     if (nMovY != 0 && nPageY == 0) nPageY = (nMovY>0) ? 1 : -1;
1075 
1076     MoveCursorRel( nPageX, nPageY, eMode, bShift, bKeepSel );
1077 }
1078 
1079 void ScTabView::MoveCursorArea( SCsCOL nMovX, SCsROW nMovY, ScFollowMode eMode, sal_Bool bShift, sal_Bool bKeepSel )
1080 {
1081     SCCOL nCurX;
1082     SCROW nCurY;
1083     aViewData.GetMoveCursor( nCurX,nCurY );
1084     SCCOL nNewX = nCurX;
1085     SCROW nNewY = nCurY;
1086 
1087     ScDocument* pDoc = aViewData.GetDocument();
1088     SCTAB nTab = aViewData.GetTabNo();
1089 
1090     //  FindAreaPos kennt nur -1 oder 1 als Richtung
1091 
1092     SCsCOLROW i;
1093     if ( nMovX > 0 )
1094         for ( i=0; i<nMovX; i++ )
1095             pDoc->FindAreaPos( nNewX, nNewY, nTab,  1,  0 );
1096     if ( nMovX < 0 )
1097         for ( i=0; i<-nMovX; i++ )
1098             pDoc->FindAreaPos( nNewX, nNewY, nTab, -1,  0 );
1099     if ( nMovY > 0 )
1100         for ( i=0; i<nMovY; i++ )
1101             pDoc->FindAreaPos( nNewX, nNewY, nTab,  0,  1 );
1102     if ( nMovY < 0 )
1103         for ( i=0; i<-nMovY; i++ )
1104             pDoc->FindAreaPos( nNewX, nNewY, nTab,  0, -1 );
1105 
1106     if (eMode==SC_FOLLOW_JUMP)                  // unten/rechts nicht zuviel grau anzeigen
1107     {
1108         if (nMovX != 0 && nNewX == MAXCOL)
1109             eMode = SC_FOLLOW_LINE;
1110         if (nMovY != 0 && nNewY == MAXROW)
1111             eMode = SC_FOLLOW_LINE;
1112     }
1113 
1114     MoveCursorRel( ((SCsCOL)nNewX)-(SCsCOL)nCurX, ((SCsROW)nNewY)-(SCsROW)nCurY, eMode, bShift, bKeepSel );
1115 }
1116 
1117 void ScTabView::MoveCursorEnd( SCsCOL nMovX, SCsROW nMovY, ScFollowMode eMode, sal_Bool bShift, sal_Bool bKeepSel )
1118 {
1119     ScDocument* pDoc = aViewData.GetDocument();
1120     SCTAB nTab = aViewData.GetTabNo();
1121 
1122     SCCOL nCurX;
1123     SCROW nCurY;
1124     aViewData.GetMoveCursor( nCurX,nCurY );
1125     SCCOL nNewX = nCurX;
1126     SCROW nNewY = nCurY;
1127 
1128     SCCOL nUsedX = 0;
1129     SCROW nUsedY = 0;
1130     if ( nMovX > 0 || nMovY > 0 )
1131         pDoc->GetPrintArea( nTab, nUsedX, nUsedY );     // Ende holen
1132 
1133     if (nMovX<0)
1134         nNewX=0;
1135     else if (nMovX>0)
1136         nNewX=nUsedX;                                   // letzter benutzter Bereich
1137 
1138     if (nMovY<0)
1139         nNewY=0;
1140     else if (nMovY>0)
1141         nNewY=nUsedY;
1142 
1143     aViewData.ResetOldCursor();
1144     MoveCursorRel( ((SCsCOL)nNewX)-(SCsCOL)nCurX, ((SCsROW)nNewY)-(SCsROW)nCurY, eMode, bShift, bKeepSel );
1145 }
1146 
1147 void ScTabView::MoveCursorScreen( SCsCOL nMovX, SCsROW nMovY, ScFollowMode eMode, sal_Bool bShift )
1148 {
1149     ScDocument* pDoc = aViewData.GetDocument();
1150     SCTAB nTab = aViewData.GetTabNo();
1151 
1152     SCCOL nCurX;
1153     SCROW nCurY;
1154     aViewData.GetMoveCursor( nCurX,nCurY );
1155     SCCOL nNewX = nCurX;
1156     SCROW nNewY = nCurY;
1157 
1158     ScSplitPos eWhich = aViewData.GetActivePart();
1159     SCCOL nPosX = aViewData.GetPosX( WhichH(eWhich) );
1160     SCROW nPosY = aViewData.GetPosY( WhichV(eWhich) );
1161 
1162     SCCOL nAddX = aViewData.VisibleCellsX( WhichH(eWhich) );
1163     if (nAddX != 0)
1164         --nAddX;
1165     SCROW nAddY = aViewData.VisibleCellsY( WhichV(eWhich) );
1166     if (nAddY != 0)
1167         --nAddY;
1168 
1169     if (nMovX<0)
1170         nNewX=nPosX;
1171     else if (nMovX>0)
1172         nNewX=nPosX+nAddX;
1173 
1174     if (nMovY<0)
1175         nNewY=nPosY;
1176     else if (nMovY>0)
1177         nNewY=nPosY+nAddY;
1178 
1179 //  aViewData.ResetOldCursor();
1180     aViewData.SetOldCursor( nNewX,nNewY );
1181 
1182     while (pDoc->IsHorOverlapped( nNewX, nNewY, nTab ))
1183         --nNewX;
1184     while (pDoc->IsVerOverlapped( nNewX, nNewY, nTab ))
1185         --nNewY;
1186 
1187     MoveCursorAbs( nNewX, nNewY, eMode, bShift, sal_False, sal_True );
1188 }
1189 
1190 void ScTabView::MoveCursorEnter( sal_Bool bShift )          // bShift -> hoch/runter
1191 {
1192     const ScInputOptions& rOpt = SC_MOD()->GetInputOptions();
1193     if (!rOpt.GetMoveSelection())
1194     {
1195         aViewData.UpdateInputHandler(sal_True);
1196         return;
1197     }
1198 
1199     SCsCOL nMoveX = 0;
1200     SCsROW nMoveY = 0;
1201     switch ((ScDirection)rOpt.GetMoveDir())
1202     {
1203         case DIR_BOTTOM:
1204             nMoveY = bShift ? -1 : 1;
1205             break;
1206         case DIR_RIGHT:
1207             nMoveX = bShift ? -1 : 1;
1208             break;
1209         case DIR_TOP:
1210             nMoveY = bShift ? 1 : -1;
1211             break;
1212         case DIR_LEFT:
1213             nMoveX = bShift ? 1 : -1;
1214             break;
1215     }
1216 
1217     ScMarkData& rMark = aViewData.GetMarkData();
1218     if (rMark.IsMarked() || rMark.IsMultiMarked())
1219     {
1220         SCCOL nCurX;
1221         SCROW nCurY;
1222         aViewData.GetMoveCursor( nCurX,nCurY );
1223         SCCOL nNewX = nCurX;
1224         SCROW nNewY = nCurY;
1225         SCTAB nTab = aViewData.GetTabNo();
1226 
1227         ScDocument* pDoc = aViewData.GetDocument();
1228         pDoc->GetNextPos( nNewX,nNewY, nTab, nMoveX,nMoveY, sal_True,sal_False, rMark );
1229 
1230         MoveCursorRel( ((SCsCOL)nNewX)-(SCsCOL)nCurX, ((SCsROW)nNewY)-(SCsROW)nCurY,
1231                             SC_FOLLOW_LINE, sal_False, sal_True );
1232 
1233         //  update input line even if cursor was not moved
1234         if ( nNewX == nCurX && nNewY == nCurY )
1235             aViewData.UpdateInputHandler(sal_True);
1236     }
1237     else
1238     {
1239         if ( nMoveY != 0 && !nMoveX )
1240         {
1241             //  nach Tab und Enter wieder zur Ausgangsspalte
1242             SCCOL nTabCol = aViewData.GetTabStartCol();
1243             if (nTabCol != SC_TABSTART_NONE)
1244             {
1245                 SCCOL nCurX;
1246                 SCROW nCurY;
1247                 aViewData.GetMoveCursor( nCurX,nCurY );
1248                 nMoveX = ((SCsCOL)nTabCol)-(SCsCOL)nCurX;
1249             }
1250         }
1251 
1252         MoveCursorRel( nMoveX,nMoveY, SC_FOLLOW_LINE, sal_False );
1253     }
1254 }
1255 
1256 
1257 sal_Bool ScTabView::MoveCursorKeyInput( const KeyEvent& rKeyEvent )
1258 {
1259     const KeyCode& rKCode = rKeyEvent.GetKeyCode();
1260 
1261     enum { MOD_NONE, MOD_CTRL, MOD_ALT, MOD_BOTH } eModifier =
1262         rKCode.IsMod1() ?
1263             (rKCode.IsMod2() ? MOD_BOTH : MOD_CTRL) :
1264             (rKCode.IsMod2() ? MOD_ALT : MOD_NONE);
1265 
1266     sal_Bool bSel = rKCode.IsShift();
1267     sal_uInt16 nCode = rKCode.GetCode();
1268 
1269     // CURSOR keys
1270     SCsCOL nDX = 0;
1271     SCsROW nDY = 0;
1272     switch( nCode )
1273     {
1274         case KEY_LEFT:  nDX = -1;   break;
1275         case KEY_RIGHT: nDX = 1;    break;
1276         case KEY_UP:    nDY = -1;   break;
1277         case KEY_DOWN:  nDY = 1;    break;
1278     }
1279     if( nDX != 0 || nDY != 0 )
1280     {
1281         switch( eModifier )
1282         {
1283             case MOD_NONE:  MoveCursorRel( nDX, nDY, SC_FOLLOW_LINE, bSel );    break;
1284             case MOD_CTRL:  MoveCursorArea( nDX, nDY, SC_FOLLOW_JUMP, bSel );   break;
1285             default:
1286             {
1287                 // added to avoid warnings
1288             }
1289         }
1290         // always sal_True to suppress changes of col/row size (ALT+CURSOR)
1291         return sal_True;
1292     }
1293 
1294     // PAGEUP/PAGEDOWN
1295     if( (nCode == KEY_PAGEUP) || (nCode == KEY_PAGEDOWN) )
1296     {
1297         nDX = (nCode == KEY_PAGEUP) ? -1 : 1;
1298         switch( eModifier )
1299         {
1300             case MOD_NONE:  MoveCursorPage( 0, static_cast<SCsCOLROW>(nDX), SC_FOLLOW_FIX, bSel );  break;
1301             case MOD_ALT:   MoveCursorPage( nDX, 0, SC_FOLLOW_FIX, bSel );  break;
1302             case MOD_CTRL:  SelectNextTab( nDX );                           break;
1303             default:
1304             {
1305                 // added to avoid warnings
1306             }
1307         }
1308         return sal_True;
1309     }
1310 
1311     // HOME/END
1312     if( (nCode == KEY_HOME) || (nCode == KEY_END) )
1313     {
1314         nDX = (nCode == KEY_HOME) ? -1 : 1;
1315         ScFollowMode eMode = (nCode == KEY_HOME) ? SC_FOLLOW_LINE : SC_FOLLOW_JUMP;
1316         switch( eModifier )
1317         {
1318             case MOD_NONE:  MoveCursorEnd( nDX, 0, eMode, bSel );   break;
1319             case MOD_CTRL:  MoveCursorEnd( nDX, static_cast<SCsCOLROW>(nDX), eMode, bSel ); break;
1320             default:
1321             {
1322                 // added to avoid warnings
1323             }
1324         }
1325         return sal_True;
1326     }
1327 
1328     return sal_False;
1329 }
1330 
1331 
1332         // naechste/vorherige nicht geschuetzte Zelle
1333 void ScTabView::FindNextUnprot( sal_Bool bShift, sal_Bool bInSelection )
1334 {
1335     short nMove = bShift ? -1 : 1;
1336 
1337     ScMarkData& rMark = aViewData.GetMarkData();
1338     sal_Bool bMarked = bInSelection && (rMark.IsMarked() || rMark.IsMultiMarked());
1339 
1340     SCCOL nCurX;
1341     SCROW nCurY;
1342     aViewData.GetMoveCursor( nCurX,nCurY );
1343     SCCOL nNewX = nCurX;
1344     SCROW nNewY = nCurY;
1345     SCTAB nTab = aViewData.GetTabNo();
1346 
1347     ScDocument* pDoc = aViewData.GetDocument();
1348     pDoc->GetNextPos( nNewX,nNewY, nTab, nMove,0, bMarked,sal_True, rMark );
1349 
1350     SCCOL nTabCol = aViewData.GetTabStartCol();
1351     if ( nTabCol == SC_TABSTART_NONE )
1352         nTabCol = nCurX;                    // auf diese Spalte zurueck bei Enter
1353 
1354     MoveCursorRel( ((SCsCOL)nNewX)-(SCsCOL)nCurX, ((SCsROW)nNewY)-(SCsROW)nCurY,
1355                         SC_FOLLOW_LINE, sal_False, sal_True );
1356 
1357     //  in MoveCursorRel wird die TabCol zurueckgesetzt...
1358     aViewData.SetTabStartCol( nTabCol );
1359 }
1360 
1361 void ScTabView::MarkColumns()
1362 {
1363     SCCOL nStartCol;
1364     SCCOL nEndCol;
1365 
1366     ScMarkData& rMark = aViewData.GetMarkData();
1367     if (rMark.IsMarked())
1368     {
1369         ScRange aMarkRange;
1370         rMark.GetMarkArea( aMarkRange );
1371         nStartCol = aMarkRange.aStart.Col();
1372         nEndCol = aMarkRange.aEnd.Col();
1373     }
1374     else
1375     {
1376         SCROW nDummy;
1377         aViewData.GetMoveCursor( nStartCol, nDummy );
1378         nEndCol=nStartCol;
1379     }
1380 
1381     SCTAB nTab = aViewData.GetTabNo();
1382     DoneBlockMode();
1383     InitBlockMode( nStartCol,0, nTab );
1384     MarkCursor( nEndCol,MAXROW, nTab );
1385     SelectionChanged();
1386 }
1387 
1388 void ScTabView::MarkRows()
1389 {
1390     SCROW nStartRow;
1391     SCROW nEndRow;
1392 
1393     ScMarkData& rMark = aViewData.GetMarkData();
1394     if (rMark.IsMarked())
1395     {
1396         ScRange aMarkRange;
1397         rMark.GetMarkArea( aMarkRange );
1398         nStartRow = aMarkRange.aStart.Row();
1399         nEndRow = aMarkRange.aEnd.Row();
1400     }
1401     else
1402     {
1403         SCCOL nDummy;
1404         aViewData.GetMoveCursor( nDummy, nStartRow );
1405         nEndRow=nStartRow;
1406     }
1407 
1408     SCTAB nTab = aViewData.GetTabNo();
1409     DoneBlockMode();
1410     InitBlockMode( 0,nStartRow, nTab );
1411     MarkCursor( MAXCOL,nEndRow, nTab );
1412     SelectionChanged();
1413 }
1414 
1415 void ScTabView::MarkDataArea( sal_Bool bIncludeCursor )
1416 {
1417     ScDocument* pDoc = aViewData.GetDocument();
1418     SCTAB nTab = aViewData.GetTabNo();
1419     SCCOL nStartCol = aViewData.GetCurX();
1420     SCROW nStartRow = aViewData.GetCurY();
1421     SCCOL nEndCol = nStartCol;
1422     SCROW nEndRow = nStartRow;
1423 
1424     pDoc->GetDataArea( nTab, nStartCol, nStartRow, nEndCol, nEndRow, bIncludeCursor, false );
1425 
1426     HideAllCursors();
1427     DoneBlockMode();
1428     InitBlockMode( nStartCol, nStartRow, nTab );
1429     MarkCursor( nEndCol, nEndRow, nTab );
1430     ShowAllCursors();
1431 
1432     SelectionChanged();
1433 }
1434 
1435 void ScTabView::MarkMatrixFormula()
1436 {
1437     ScDocument* pDoc = aViewData.GetDocument();
1438     ScAddress aCursor( aViewData.GetCurX(), aViewData.GetCurY(), aViewData.GetTabNo() );
1439     ScRange aMatrix;
1440     if ( pDoc->GetMatrixFormulaRange( aCursor, aMatrix ) )
1441     {
1442         MarkRange( aMatrix, sal_False );        // cursor is already within the range
1443     }
1444 }
1445 
1446 void ScTabView::MarkRange( const ScRange& rRange, sal_Bool bSetCursor, sal_Bool bContinue )
1447 {
1448     SCTAB nTab = rRange.aStart.Tab();
1449     SetTabNo( nTab );
1450 
1451     HideAllCursors();
1452     DoneBlockMode( bContinue ); // bContinue==sal_True -> clear old mark
1453     if (bSetCursor)             // Wenn Cursor gesetzt wird, immer auch alignen
1454     {
1455         SCCOL nAlignX = rRange.aStart.Col();
1456         SCROW nAlignY = rRange.aStart.Row();
1457         if ( rRange.aStart.Col() == 0 && rRange.aEnd.Col() == MAXCOL )
1458             nAlignX = aViewData.GetPosX(WhichH(aViewData.GetActivePart()));
1459         if ( rRange.aStart.Row() == 0 && rRange.aEnd.Row() == MAXROW )
1460             nAlignY = aViewData.GetPosY(WhichV(aViewData.GetActivePart()));
1461         AlignToCursor( nAlignX, nAlignY, SC_FOLLOW_JUMP );
1462     }
1463     InitBlockMode( rRange.aStart.Col(), rRange.aStart.Row(), nTab );
1464     MarkCursor( rRange.aEnd.Col(), rRange.aEnd.Row(), nTab );
1465     if (bSetCursor)
1466     {
1467         SCCOL nPosX = rRange.aStart.Col();
1468         SCROW nPosY = rRange.aStart.Row();
1469         ScDocument* pDoc = aViewData.GetDocument();
1470 
1471         while (pDoc->IsHorOverlapped( nPosX, nPosY, nTab ))     //! ViewData !!!
1472             --nPosX;
1473         while (pDoc->IsVerOverlapped( nPosX, nPosY, nTab ))
1474             --nPosY;
1475 
1476         aViewData.ResetOldCursor();
1477         SetCursor( nPosX, nPosY );
1478     }
1479     ShowAllCursors();
1480 
1481     SelectionChanged();
1482 }
1483 
1484 void ScTabView::Unmark()
1485 {
1486     ScMarkData& rMark = aViewData.GetMarkData();
1487     if ( rMark.IsMarked() || rMark.IsMultiMarked() )
1488     {
1489         SCCOL nCurX;
1490         SCROW nCurY;
1491         aViewData.GetMoveCursor( nCurX,nCurY );
1492         MoveCursorAbs( nCurX, nCurY, SC_FOLLOW_NONE, sal_False, sal_False );
1493 
1494         SelectionChanged();
1495     }
1496 }
1497 
1498 void ScTabView::SetMarkData( const ScMarkData& rNew )
1499 {
1500     DoneBlockMode();
1501     InitOwnBlockMode();
1502     aViewData.GetMarkData() = rNew;
1503 
1504     MarkDataChanged();
1505 }
1506 
1507 void ScTabView::MarkDataChanged()
1508 {
1509     // has to be called after making direct changes to mark data (not via MarkCursor etc)
1510 
1511     UpdateSelectionOverlay();
1512 }
1513 
1514 void ScTabView::SelectNextTab( short nDir, sal_Bool bExtendSelection )
1515 {
1516     if (!nDir) return;
1517     DBG_ASSERT( nDir==-1 || nDir==1, "SelectNextTab: falscher Wert");
1518 
1519     ScDocument* pDoc = aViewData.GetDocument();
1520     SCTAB nTab = aViewData.GetTabNo();
1521     if (nDir<0)
1522     {
1523         if (!nTab) return;
1524         --nTab;
1525         while (!pDoc->IsVisible(nTab))
1526         {
1527             if (!nTab) return;
1528             --nTab;
1529         }
1530     }
1531     else
1532     {
1533         SCTAB nCount = pDoc->GetTableCount();
1534         ++nTab;
1535         if (nTab >= nCount) return;
1536         while (!pDoc->IsVisible(nTab))
1537         {
1538             ++nTab;
1539             if (nTab >= nCount) return;
1540         }
1541     }
1542 
1543     SetTabNo( nTab, sal_False, bExtendSelection );
1544     PaintExtras();
1545 }
1546 
1547 void ScTabView::UpdateVisibleRange()
1548 {
1549     for (sal_uInt16 i=0; i<4; i++)
1550         if (pGridWin[i] && pGridWin[i]->IsVisible())
1551             pGridWin[i]->UpdateVisibleRange();
1552 }
1553 
1554 //  SetTabNo    - angezeigte Tabelle
1555 
1556 void ScTabView::SetTabNo( SCTAB nTab, sal_Bool bNew, sal_Bool bExtendSelection, bool bSameTabButMoved )
1557 {
1558     if ( !ValidTab(nTab) )
1559     {
1560         DBG_ERROR("SetTabNo: falsche Tabelle");
1561         return;
1562     }
1563 
1564     if ( nTab != aViewData.GetTabNo() || bNew )
1565     {
1566         //  #57724# Die FormShell moechte vor dem Umschalten benachrichtigt werden
1567         FmFormShell* pFormSh = aViewData.GetViewShell()->GetFormShell();
1568         if (pFormSh)
1569         {
1570             sal_Bool bAllowed = sal::static_int_cast<sal_Bool>( pFormSh->PrepareClose( sal_True ) );
1571             if (!bAllowed)
1572             {
1573                 //! Fehlermeldung? oder macht das die FormShell selber?
1574                 //! Fehler-Flag zurueckgeben und Aktionen abbrechen
1575 
1576                 return;     // Die FormShell sagt, es kann nicht umgeschaltet werden
1577             }
1578         }
1579 
1580                                         //  nicht InputEnterHandler wegen Referenzeingabe !
1581 
1582         ScDocument* pDoc = aViewData.GetDocument();
1583         pDoc->MakeTable( nTab );
1584 
1585         // Update pending row heights before switching the sheet, so Reschedule from the progress bar
1586         // doesn't paint the new sheet with old heights
1587         aViewData.GetDocShell()->UpdatePendingRowHeights( nTab );
1588 
1589         SCTAB nTabCount = pDoc->GetTableCount();
1590         SCTAB nOldPos = nTab;
1591         while (!pDoc->IsVisible(nTab))              // naechste sichtbare suchen
1592         {
1593             sal_Bool bUp = (nTab>=nOldPos);
1594             if (bUp)
1595             {
1596                 ++nTab;
1597                 if (nTab>=nTabCount)
1598                 {
1599                     nTab = nOldPos;
1600                     bUp = sal_False;
1601                 }
1602             }
1603 
1604             if (!bUp)
1605             {
1606                 if (nTab != 0)
1607                     --nTab;
1608                 else
1609                 {
1610                     DBG_ERROR("keine sichtbare Tabelle");
1611                     pDoc->SetVisible( 0, sal_True );
1612                 }
1613             }
1614         }
1615 
1616         // #i71490# Deselect drawing objects before changing the sheet number in view data,
1617         // so the handling of notes still has the sheet selected on which the notes are.
1618         DrawDeselectAll();
1619 
1620         ScModule* pScMod = SC_MOD();
1621         sal_Bool bRefMode = pScMod->IsFormulaMode();
1622         if ( !bRefMode ) // Abfrage, damit RefMode bei Tabellenwechsel funktioniert
1623         {
1624             DoneBlockMode();
1625             pSelEngine->Reset();                // reset all flags, including locked modifiers
1626             aViewData.SetRefTabNo( nTab );
1627         }
1628 
1629         ScSplitPos eOldActive = aViewData.GetActivePart();      // before switching
1630         sal_Bool bFocus = pGridWin[eOldActive]->HasFocus();
1631 
1632         aViewData.SetTabNo( nTab );
1633         //  UpdateShow noch vor SetCursor, damit UpdateAutoFillMark die richtigen
1634         //  Fenster findet (wird aus SetCursor gerufen)
1635         UpdateShow();
1636         aViewData.ResetOldCursor();
1637         SetCursor( aViewData.GetCurX(), aViewData.GetCurY(), sal_True );
1638 
1639         SfxBindings& rBindings = aViewData.GetBindings();
1640         ScMarkData& rMark = aViewData.GetMarkData();
1641 
1642         bool bAllSelected = true;
1643         for (SCTAB nSelTab = 0; nSelTab < nTabCount; ++nSelTab)
1644         {
1645             if (!pDoc->IsVisible(nSelTab) || rMark.GetTableSelect(nSelTab))
1646             {
1647                 if (nTab == nSelTab)
1648                     // This tab is already in selection.  Keep the current
1649                     // selection.
1650                     bExtendSelection = true;
1651             }
1652             else
1653             {
1654                 bAllSelected = false;
1655                 if (bExtendSelection)
1656                     // We got what we need.  No need to stay in the loop.
1657                     break;
1658             }
1659         }
1660         if (bAllSelected && !bNew)
1661             // #i6327# if all tables are selected, a selection event (#i6330#) will deselect all
1662             // (not if called with bNew to update settings)
1663             bExtendSelection = false;
1664 
1665         if (bExtendSelection)
1666             rMark.SelectTable( nTab, sal_True );
1667         else
1668         {
1669             rMark.SelectOneTable( nTab );
1670             rBindings.Invalidate( FID_FILL_TAB );
1671             rBindings.Invalidate( FID_TAB_DESELECTALL );
1672         }
1673 
1674         bool bUnoRefDialog = pScMod->IsRefDialogOpen() && pScMod->GetCurRefDlgId() == WID_SIMPLE_REF;
1675 
1676         // recalc zoom-dependent values (before TabChanged, before UpdateEditViewPos)
1677         RefreshZoom();
1678         UpdateVarZoom();
1679 
1680         if ( bRefMode )     // hide EditView if necessary (after aViewData.SetTabNo !)
1681         {
1682             for ( sal_uInt16 i=0; i<4; i++ )
1683                 if ( pGridWin[i] )
1684                     if ( pGridWin[i]->IsVisible() )
1685                         pGridWin[i]->UpdateEditViewPos();
1686         }
1687 
1688         TabChanged( bSameTabButMoved );                                     // DrawView
1689 
1690         aViewData.GetViewShell()->WindowChanged();          // falls das aktive Fenster anders ist
1691         if ( !bUnoRefDialog )
1692             aViewData.GetViewShell()->DisconnectAllClients();   // important for floating frames
1693         else
1694         {
1695             // hide / show inplace client
1696 
1697             ScClient* pClient = static_cast<ScClient*>(aViewData.GetViewShell()->GetIPClient());
1698             if ( pClient && pClient->IsObjectInPlaceActive() )
1699             {
1700                 Rectangle aObjArea = pClient->GetObjArea();
1701                 if ( nTab == aViewData.GetRefTabNo() )
1702                 {
1703                     // move to its original position
1704 
1705                     SdrOle2Obj* pDrawObj = pClient->GetDrawObj();
1706                     if ( pDrawObj )
1707                     {
1708                         Rectangle aRect = pDrawObj->GetLogicRect();
1709                         MapMode aMapMode( MAP_100TH_MM );
1710                         Size aOleSize = pDrawObj->GetOrigObjSize( &aMapMode );
1711                         aRect.SetSize( aOleSize );
1712                         aObjArea = aRect;
1713                     }
1714                 }
1715                 else
1716                 {
1717                     // move to an invisible position
1718 
1719                     aObjArea.SetPos( Point( 0, -2*aObjArea.GetHeight() ) );
1720                 }
1721                 pClient->SetObjArea( aObjArea );
1722             }
1723         }
1724 
1725         if ( bFocus && aViewData.GetActivePart() != eOldActive && !bRefMode )
1726             ActiveGrabFocus();      // grab focus to the pane that's active now
1727 
1728             //  Fixierungen
1729 
1730         sal_Bool bResize = sal_False;
1731         if ( aViewData.GetHSplitMode() == SC_SPLIT_FIX )
1732             if (aViewData.UpdateFixX())
1733                 bResize = sal_True;
1734         if ( aViewData.GetVSplitMode() == SC_SPLIT_FIX )
1735             if (aViewData.UpdateFixY())
1736                 bResize = sal_True;
1737         if (bResize)
1738             RepeatResize();
1739         InvalidateSplit();
1740 
1741         // #163911# Update the visible range in each GridWin directly, don't wait for the repaint event.
1742         UpdateVisibleRange();
1743 
1744         if ( aViewData.IsPagebreakMode() )
1745             UpdatePageBreakData();              //! asynchron ??
1746 
1747         //  #53551# Form-Layer muss den sichtbaren Ausschnitt der neuen Tabelle kennen
1748         //  dafuer muss hier schon der MapMode stimmen
1749         for (sal_uInt16 i=0; i<4; i++)
1750             if (pGridWin[i])
1751                 pGridWin[i]->SetMapMode( pGridWin[i]->GetDrawMapMode() );
1752         SetNewVisArea();
1753 
1754         PaintGrid();
1755         PaintTop();
1756         PaintLeft();
1757         PaintExtras();
1758 
1759         DoResize( aBorderPos, aFrameSize );
1760         rBindings.Invalidate( SID_DELETE_PRINTAREA );   // Menue
1761         rBindings.Invalidate( FID_DEL_MANUALBREAKS );
1762         rBindings.Invalidate( FID_RESET_PRINTZOOM );
1763         rBindings.Invalidate( SID_STATUS_DOCPOS );      // Statusbar
1764         rBindings.Invalidate( SID_STATUS_PAGESTYLE );   // Statusbar
1765         rBindings.Invalidate( SID_CURRENTTAB );         // Navigator
1766         rBindings.Invalidate( SID_STYLE_FAMILY2 );  // Gestalter
1767         rBindings.Invalidate( SID_STYLE_FAMILY4 );  // Gestalter
1768         rBindings.Invalidate( SID_TABLES_COUNT );
1769 
1770         if(pScMod->IsRefDialogOpen())
1771         {
1772             sal_uInt16 nCurRefDlgId=pScMod->GetCurRefDlgId();
1773             SfxViewFrame* pViewFrm = aViewData.GetViewShell()->GetViewFrame();
1774             SfxChildWindow* pChildWnd = pViewFrm->GetChildWindow( nCurRefDlgId );
1775             if ( pChildWnd )
1776             {
1777                 IAnyRefDialog* pRefDlg = dynamic_cast<IAnyRefDialog*>(pChildWnd->GetWindow());
1778                 pRefDlg->ViewShellChanged(NULL);
1779             }
1780         }
1781     }
1782 }
1783 
1784 //
1785 //  Paint-Funktionen - nur fuer diese View
1786 //
1787 
1788 void ScTabView::MakeEditView( ScEditEngineDefaulter* pEngine, SCCOL nCol, SCROW nRow )
1789 {
1790     DrawDeselectAll();
1791 
1792     if (pDrawView)
1793         DrawEnableAnim( sal_False );
1794 
1795     EditView* pSpellingView = aViewData.GetSpellingView();
1796 
1797     for (sal_uInt16 i=0; i<4; i++)
1798         if (pGridWin[i])
1799             if ( pGridWin[i]->IsVisible() && !aViewData.HasEditView((ScSplitPos)i) )
1800             {
1801                 ScHSplitPos eHWhich = WhichH( (ScSplitPos) i );
1802                 ScVSplitPos eVWhich = WhichV( (ScSplitPos) i );
1803                 SCCOL nScrX = aViewData.GetPosX( eHWhich );
1804                 SCROW nScrY = aViewData.GetPosY( eVWhich );
1805 
1806                 sal_Bool bPosVisible =
1807                      ( nCol >= nScrX && nCol <= nScrX + aViewData.VisibleCellsX(eHWhich) + 1 &&
1808                        nRow >= nScrY && nRow <= nScrY + aViewData.VisibleCellsY(eVWhich) + 1 );
1809 
1810                 //  #102421# for the active part, create edit view even if outside the visible area,
1811                 //  so input isn't lost (and the edit view may be scrolled into the visible area)
1812 
1813                 //  #i26433# during spelling, the spelling view must be active
1814                 if ( bPosVisible || aViewData.GetActivePart() == (ScSplitPos) i ||
1815                      ( pSpellingView && aViewData.GetEditView((ScSplitPos) i) == pSpellingView ) )
1816                 {
1817                     pGridWin[i]->HideCursor();
1818 
1819                     pGridWin[i]->DeleteCursorOverlay();
1820                     pGridWin[i]->DeleteAutoFillOverlay();
1821 
1822                     // flush OverlayManager before changing MapMode to text edit
1823                     pGridWin[i]->flushOverlayManager();
1824 
1825                     // MapMode must be set after HideCursor
1826                     pGridWin[i]->SetMapMode(aViewData.GetLogicMode());
1827 
1828                     aViewData.SetEditEngine( (ScSplitPos) i, pEngine, pGridWin[i], nCol, nRow );
1829 
1830                     if ( !bPosVisible )
1831                     {
1832                         //  move the edit view area to the real (possibly negative) position,
1833                         //  or hide if completely above or left of the window
1834                         pGridWin[i]->UpdateEditViewPos();
1835                     }
1836                 }
1837             }
1838 
1839     if (aViewData.GetViewShell()->HasAccessibilityObjects())
1840         aViewData.GetViewShell()->BroadcastAccessibility(SfxSimpleHint(SC_HINT_ACC_ENTEREDITMODE));
1841 }
1842 
1843 void ScTabView::UpdateEditView()
1844 {
1845     ScSplitPos eActive = aViewData.GetActivePart();
1846     for (sal_uInt16 i=0; i<4; i++)
1847         if (aViewData.HasEditView( (ScSplitPos) i ))
1848         {
1849             EditView* pEditView = aViewData.GetEditView( (ScSplitPos) i );
1850             aViewData.SetEditEngine( (ScSplitPos) i,
1851                 static_cast<ScEditEngineDefaulter*>(pEditView->GetEditEngine()),
1852                 pGridWin[i], GetViewData()->GetCurX(), GetViewData()->GetCurY() );
1853             if ( (ScSplitPos)i == eActive )
1854                 pEditView->ShowCursor( sal_False );
1855         }
1856 }
1857 
1858 void ScTabView::KillEditView( sal_Bool bNoPaint )
1859 {
1860     sal_uInt16 i;
1861     SCCOL nCol1 = aViewData.GetEditStartCol();
1862     SCROW nRow1 = aViewData.GetEditStartRow();
1863     SCCOL nCol2 = aViewData.GetEditEndCol();
1864     SCROW nRow2 = aViewData.GetEditEndRow();
1865     sal_Bool bPaint[4];
1866     sal_Bool bNotifyAcc(false);
1867 
1868     sal_Bool bExtended = nRow1 != nRow2;                    // Col wird sowieso bis zum Ende gezeichnet
1869     sal_Bool bAtCursor = nCol1 <= aViewData.GetCurX() &&
1870                      nCol2 >= aViewData.GetCurX() &&
1871                      nRow1 == aViewData.GetCurY();
1872     for (i=0; i<4; i++)
1873     {
1874         bPaint[i] = aViewData.HasEditView( (ScSplitPos) i );
1875         if (bPaint[i])
1876             bNotifyAcc = true;
1877     }
1878 
1879     // #108931#; notify accessibility before all things happen
1880     if ((bNotifyAcc) && (aViewData.GetViewShell()->HasAccessibilityObjects()))
1881         aViewData.GetViewShell()->BroadcastAccessibility(SfxSimpleHint(SC_HINT_ACC_LEAVEEDITMODE));
1882 
1883     aViewData.ResetEditView();
1884     for (i=0; i<4; i++)
1885         if (pGridWin[i] && bPaint[i])
1886             if (pGridWin[i]->IsVisible())
1887             {
1888                 pGridWin[i]->ShowCursor();
1889 
1890                 pGridWin[i]->SetMapMode(pGridWin[i]->GetDrawMapMode());
1891 
1892                 // #i73567# the cell still has to be repainted
1893                 if (bExtended || ( bAtCursor && !bNoPaint ))
1894                 {
1895                     pGridWin[i]->Draw( nCol1, nRow1, nCol2, nRow2 );
1896                     pGridWin[i]->UpdateSelectionOverlay();
1897                 }
1898             }
1899 
1900     if (pDrawView)
1901         DrawEnableAnim( sal_True );
1902 
1903         //  GrabFocus immer dann, wenn diese View aktiv ist und
1904         //  die Eingabezeile den Focus hat
1905 
1906     sal_Bool bGrabFocus = sal_False;
1907     if (aViewData.IsActive())
1908     {
1909         ScInputHandler* pInputHdl = SC_MOD()->GetInputHdl();
1910         if ( pInputHdl )
1911         {
1912             ScInputWindow* pInputWin = pInputHdl->GetInputWindow();
1913             if (pInputWin && pInputWin->IsInputActive())
1914                 bGrabFocus = sal_True;
1915         }
1916     }
1917 
1918     if (bGrabFocus)
1919     {
1920 //      So soll es gemacht werden, damit der Sfx es mitbekommt, klappt aber nicht:
1921 //!     aViewData.GetViewShell()->GetViewFrame()->GetWindow().GrabFocus();
1922 //      deshalb erstmal so:
1923         GetActiveWin()->GrabFocus();
1924     }
1925 
1926     //  Cursor-Abfrage erst nach GrabFocus
1927 
1928     for (i=0; i<4; i++)
1929         if (pGridWin[i] && pGridWin[i]->IsVisible())
1930         {
1931             Cursor* pCur = pGridWin[i]->GetCursor();
1932             if (pCur && pCur->IsVisible())
1933                 pCur->Hide();
1934 
1935             if(bPaint[i])
1936             {
1937                 pGridWin[i]->UpdateCursorOverlay();
1938                 pGridWin[i]->UpdateAutoFillOverlay();
1939                 // pGridWin[i]->UpdateAllOverlays();
1940             }
1941         }
1942 }
1943 
1944 void ScTabView::UpdateFormulas()
1945 {
1946     if ( aViewData.GetDocument()->IsAutoCalcShellDisabled() )
1947         return ;
1948 
1949     sal_uInt16 i;
1950     for (i=0; i<4; i++)
1951         if (pGridWin[i])
1952             if (pGridWin[i]->IsVisible())
1953                 pGridWin[i]->UpdateFormulas();
1954 
1955     if ( aViewData.IsPagebreakMode() )
1956         UpdatePageBreakData();              //! asynchron
1957 
1958     UpdateHeaderWidth();
1959 
1960     //  if in edit mode, adjust edit view area because widths/heights may have changed
1961     if ( aViewData.HasEditView( aViewData.GetActivePart() ) )
1962         UpdateEditView();
1963 }
1964 
1965 //  PaintArea -Block neu zeichnen
1966 
1967 void ScTabView::PaintArea( SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow,
1968                             ScUpdateMode eMode )
1969 {
1970     sal_uInt16 i;
1971     SCCOL nCol1;
1972     SCROW nRow1;
1973     SCCOL nCol2;
1974     SCROW nRow2;
1975 
1976     PutInOrder( nStartCol, nEndCol );
1977     PutInOrder( nStartRow, nEndRow );
1978 
1979     for (i=0; i<4; i++)
1980         if (pGridWin[i])
1981             if (pGridWin[i]->IsVisible())
1982             {
1983                 ScHSplitPos eHWhich = WhichH( (ScSplitPos) i );
1984                 ScVSplitPos eVWhich = WhichV( (ScSplitPos) i );
1985                 sal_Bool bOut = sal_False;
1986 
1987                 nCol1 = nStartCol;
1988                 nRow1 = nStartRow;
1989                 nCol2 = nEndCol;
1990                 nRow2 = nEndRow;
1991 
1992                 SCCOL nScrX = aViewData.GetPosX( eHWhich );
1993                 SCROW nScrY = aViewData.GetPosY( eVWhich );
1994                 if (nCol1 < nScrX) nCol1 = nScrX;
1995                 if (nCol2 < nScrX)
1996                 {
1997                     if ( eMode == SC_UPDATE_ALL )   // #91240# for UPDATE_ALL, paint anyway
1998                         nCol2 = nScrX;              // (because of extending strings to the right)
1999                     else
2000                         bOut = sal_True;                // completely outside the window
2001                 }
2002                 if (nRow1 < nScrY) nRow1 = nScrY;
2003                 if (nRow2 < nScrY) bOut = sal_True;
2004 
2005                 SCCOL nLastX = nScrX + aViewData.VisibleCellsX( eHWhich ) + 1;
2006                 SCROW nLastY = nScrY + aViewData.VisibleCellsY( eVWhich ) + 1;
2007                 if (nCol1 > nLastX) bOut = sal_True;
2008                 if (nCol2 > nLastX) nCol2 = nLastX;
2009                 if (nRow1 > nLastY) bOut = sal_True;
2010                 if (nRow2 > nLastY) nRow2 = nLastY;
2011 
2012                 if (!bOut)
2013                 {
2014                     if ( eMode == SC_UPDATE_CHANGED )
2015                         pGridWin[i]->Draw( nCol1, nRow1, nCol2, nRow2, eMode );
2016                     else    // ALL oder MARKS
2017                     {
2018                         sal_Bool bLayoutRTL = aViewData.GetDocument()->IsLayoutRTL( aViewData.GetTabNo() );
2019                         long nLayoutSign = bLayoutRTL ? -1 : 1;
2020 
2021                         Point aStart = aViewData.GetScrPos( nCol1, nRow1, (ScSplitPos) i );
2022                         Point aEnd   = aViewData.GetScrPos( nCol2+1, nRow2+1, (ScSplitPos) i );
2023                         if ( eMode == SC_UPDATE_ALL )
2024                             aEnd.X() = bLayoutRTL ? 0 : (pGridWin[i]->GetOutputSizePixel().Width());
2025                         aEnd.X() -= nLayoutSign;
2026                         aEnd.Y() -= 1;
2027 
2028                         // #i85232# include area below cells (could be done in GetScrPos?)
2029                         if ( eMode == SC_UPDATE_ALL && nRow2 >= MAXROW )
2030                             aEnd.Y() = pGridWin[i]->GetOutputSizePixel().Height();
2031 
2032                         sal_Bool bShowChanges = sal_True;           //! ...
2033                         if (bShowChanges)
2034                         {
2035                             aStart.X() -= nLayoutSign;      // include change marks
2036                             aStart.Y() -= 1;
2037                         }
2038 
2039                         sal_Bool bMarkClipped = aViewData.GetOptions().GetOption( VOPT_CLIPMARKS );
2040                         if (bMarkClipped)
2041                         {
2042                             //  dazu muesste ScColumn::IsEmptyBlock optimiert werden
2043                             //  (auf Search() umstellen)
2044                             //!if ( nCol1 > 0 && !aViewData.GetDocument()->IsBlockEmpty(
2045                             //!                     aViewData.GetTabNo(),
2046                             //!                     0, nRow1, nCol1-1, nRow2 ) )
2047                             {
2048                                 long nMarkPixel = (long)( SC_CLIPMARK_SIZE * aViewData.GetPPTX() );
2049                                 aStart.X() -= nMarkPixel * nLayoutSign;
2050                                 if (!bShowChanges)
2051                                     aStart.X() -= nLayoutSign;      // cell grid
2052                             }
2053                         }
2054 
2055                         pGridWin[i]->Invalidate( pGridWin[i]->PixelToLogic( Rectangle( aStart,aEnd ) ) );
2056                     }
2057                 }
2058             }
2059 
2060     // #i79909# Calling UpdateAllOverlays here isn't necessary and would lead to overlay calls from a timer,
2061     // with a wrong MapMode if editing in a cell (reference input).
2062     // #i80499# Overlays need updates in a lot of cases, e.g. changing row/column size,
2063     // or showing/hiding outlines. TODO: selections in inactive windows are vanishing.
2064     // #i84689# With relative conditional formats, PaintArea may be called often (for each changed cell),
2065     // so UpdateAllOverlays was moved to ScTabViewShell::Notify and is called only if PAINT_LEFT/PAINT_TOP
2066     // is set (width or height changed).
2067 }
2068 
2069 void ScTabView::PaintRangeFinder( long nNumber )
2070 {
2071     ScInputHandler* pHdl = SC_MOD()->GetInputHdl( aViewData.GetViewShell() );
2072     if (pHdl)
2073     {
2074         ScRangeFindList* pRangeFinder = pHdl->GetRangeFindList();
2075         if ( pRangeFinder && pRangeFinder->GetDocName() == aViewData.GetDocShell()->GetTitle() )
2076         {
2077             SCTAB nTab = aViewData.GetTabNo();
2078             sal_uInt16 nCount = (sal_uInt16)pRangeFinder->Count();
2079             for (sal_uInt16 i=0; i<nCount; i++)
2080                 if ( nNumber < 0 || nNumber == i )
2081                 {
2082                     ScRangeFindData* pData = pRangeFinder->GetObject(i);
2083                     if (pData)
2084                     {
2085                         ScRange aRef = pData->aRef;
2086                         aRef.Justify();                 // Justify fuer die Abfragen unten
2087 
2088                         if ( aRef.aStart == aRef.aEnd )     //! Tab ignorieren?
2089                             aViewData.GetDocument()->ExtendMerge(aRef);
2090 
2091                         if ( aRef.aStart.Tab() >= nTab && aRef.aEnd.Tab() <= nTab )
2092                         {
2093                             SCCOL nCol1 = aRef.aStart.Col();
2094                             SCROW nRow1 = aRef.aStart.Row();
2095                             SCCOL nCol2 = aRef.aEnd.Col();
2096                             SCROW nRow2 = aRef.aEnd.Row();
2097 
2098                             //  wegnehmen -> Repaint
2099                             //  SC_UPDATE_MARKS: Invalidate, nicht bis zum Zeilenende
2100 
2101                             sal_Bool bHiddenEdge = sal_False;
2102                             SCROW nTmp;
2103                             ScDocument* pDoc = aViewData.GetDocument();
2104                             SCCOL nLastCol = -1;
2105                             while ( nCol1 > 0 && pDoc->ColHidden(nCol1, nTab, nLastCol) )
2106                             {
2107                                 --nCol1;
2108                                 bHiddenEdge = sal_True;
2109                             }
2110                             while ( nCol2 < MAXCOL && pDoc->ColHidden(nCol2, nTab, nLastCol) )
2111                             {
2112                                 ++nCol2;
2113                                 bHiddenEdge = sal_True;
2114                             }
2115                             nTmp = pDoc->LastVisibleRow(0, nRow1, nTab);
2116                             if (!ValidRow(nTmp))
2117                                 nTmp = 0;
2118                             if (nTmp < nRow1)
2119                             {
2120                                 nRow1 = nTmp;
2121                                 bHiddenEdge = sal_True;
2122                             }
2123                             nTmp = pDoc->FirstVisibleRow(nRow2, MAXROW, nTab);
2124                             if (!ValidRow(nTmp))
2125                                 nTmp = MAXROW;
2126                             if (nTmp > nRow2)
2127                             {
2128                                 nRow2 = nTmp;
2129                                 bHiddenEdge = sal_True;
2130                             }
2131 
2132                             if ( nCol2 - nCol1 > 1 && nRow2 - nRow1 > 1 && !bHiddenEdge )
2133                             {
2134                                 //  nur an den Raendern entlang
2135                                 PaintArea( nCol1, nRow1, nCol2, nRow1, SC_UPDATE_MARKS );
2136                                 PaintArea( nCol1, nRow1+1, nCol1, nRow2-1, SC_UPDATE_MARKS );
2137                                 PaintArea( nCol2, nRow1+1, nCol2, nRow2-1, SC_UPDATE_MARKS );
2138                                 PaintArea( nCol1, nRow2, nCol2, nRow2, SC_UPDATE_MARKS );
2139                             }
2140                             else    // alles am Stueck
2141                                 PaintArea( nCol1, nRow1, nCol2, nRow2, SC_UPDATE_MARKS );
2142                         }
2143                     }
2144                 }
2145         }
2146     }
2147 }
2148 
2149 //  fuer Chart-Daten-Markierung
2150 
2151 void ScTabView::AddHighlightRange( const ScRange& rRange, const Color& rColor )
2152 {
2153     if (!pHighlightRanges)
2154         pHighlightRanges = new ScHighlightRanges;
2155     pHighlightRanges->Insert( new ScHighlightEntry( rRange, rColor ) );
2156 
2157     SCTAB nTab = aViewData.GetTabNo();
2158     if ( nTab >= rRange.aStart.Tab() && nTab <= rRange.aEnd.Tab() )
2159         PaintArea( rRange.aStart.Col(), rRange.aStart.Row(),
2160                     rRange.aEnd.Col(), rRange.aEnd.Row(), SC_UPDATE_MARKS );
2161 }
2162 
2163 void ScTabView::ClearHighlightRanges()
2164 {
2165     if (pHighlightRanges)
2166     {
2167         ScHighlightRanges* pTemp = pHighlightRanges;
2168         pHighlightRanges = NULL;    // Repaint ohne Highlight
2169 
2170         SCTAB nTab = aViewData.GetTabNo();
2171         sal_uLong nCount = pTemp->Count();
2172         for (sal_uLong i=0; i<nCount; i++)
2173         {
2174             ScHighlightEntry* pEntry = pTemp->GetObject( i );
2175             if (pEntry)
2176             {
2177                 ScRange aRange = pEntry->aRef;
2178                 if ( nTab >= aRange.aStart.Tab() && nTab <= aRange.aEnd.Tab() )
2179                     PaintArea( aRange.aStart.Col(), aRange.aStart.Row(),
2180                                aRange.aEnd.Col(), aRange.aEnd.Row(), SC_UPDATE_MARKS );
2181             }
2182         }
2183         delete pTemp;
2184     }
2185 }
2186 
2187 void ScTabView::DoChartSelection(
2188     const uno::Sequence< chart2::data::HighlightedRange > & rHilightRanges )
2189 {
2190     ClearHighlightRanges();
2191 
2192     for( sal_Int32 i=0; i<rHilightRanges.getLength(); ++i )
2193     {
2194         Color aSelColor( rHilightRanges[i].PreferredColor );
2195         ScRangeList aRangeList;
2196         ScDocument* pDoc = aViewData.GetDocShell()->GetDocument();
2197         if( ScRangeStringConverter::GetRangeListFromString(
2198                 aRangeList, rHilightRanges[i].RangeRepresentation, pDoc, pDoc->GetAddressConvention(), ';' ))
2199         {
2200             for ( ScRangePtr p = aRangeList.First(); p; p = aRangeList.Next())
2201             {
2202                 if( rHilightRanges[i].Index == - 1 )
2203                     AddHighlightRange( *p, aSelColor );
2204                 else
2205                     AddHighlightRange( lcl_getSubRangeByIndex( *p, rHilightRanges[i].Index ), aSelColor );
2206             }
2207         }
2208     }
2209 }
2210 
2211 //  DrawDragRect - Drag&Drop-Rechteck zeichnen (XOR)
2212 
2213 //UNUSED2008-05  void ScTabView::DrawDragRect( SCCOL nStartX, SCROW nStartY, SCCOL nEndX, SCROW nEndY,
2214 //UNUSED2008-05                                ScSplitPos ePos )
2215 //UNUSED2008-05  {
2216 //UNUSED2008-05      if ( aViewData.GetHSplitMode() == SC_SPLIT_FIX || aViewData.GetVSplitMode() == SC_SPLIT_FIX )
2217 //UNUSED2008-05      {
2218 //UNUSED2008-05          for (sal_uInt16  i=0; i<4; i++)
2219 //UNUSED2008-05              if (pGridWin[i])
2220 //UNUSED2008-05                  if (pGridWin[i]->IsVisible())
2221 //UNUSED2008-05                      pGridWin[i]->DrawDragRect( nStartX, nStartY, nEndX, nEndY );
2222 //UNUSED2008-05      }
2223 //UNUSED2008-05      else
2224 //UNUSED2008-05          pGridWin[ePos]->DrawDragRect( nStartX, nStartY, nEndX, nEndY );
2225 //UNUSED2008-05  }
2226 //UNUSED2008-05
2227 //UNUSED2008-05  // PaintCell - einzelne Zelle neu zeichnen
2228 //UNUSED2008-05
2229 //UNUSED2008-05  void ScTabView::PaintCell( SCCOL nCol, SCROW nRow, SCTAB nTab )
2230 //UNUSED2008-05  {
2231 //UNUSED2008-05      if ( aViewData.GetTabNo() == nTab )
2232 //UNUSED2008-05      {
2233 //UNUSED2008-05          sal_uInt16 i;
2234 //UNUSED2008-05          for (i=0; i<4; i++)
2235 //UNUSED2008-05              if (pGridWin[i])
2236 //UNUSED2008-05                  if (pGridWin[i]->IsVisible())
2237 //UNUSED2008-05                      pGridWin[i]->Draw( nCol, nRow, nCol, nRow );
2238 //UNUSED2008-05      }
2239 //UNUSED2008-05  }
2240 //UNUSED2008-05
2241 //UNUSED2008-05  void ScTabView::PaintLeftRow( SCROW nRow )
2242 //UNUSED2008-05  {
2243 //UNUSED2008-05      PaintLeftArea( nRow, nRow );
2244 //UNUSED2008-05  }
2245 //UNUSED2008-05
2246 //UNUSED2008-05  void ScTabView::PaintTopCol( SCCOL nCol )
2247 //UNUSED2008-05  {
2248 //UNUSED2008-05      PaintTopArea( nCol, nCol );
2249 //UNUSED2008-05  }
2250 
2251 //  PaintGrid - Datenbereiche neu zeichnen
2252 
2253 void ScTabView::PaintGrid()
2254 {
2255     sal_uInt16 i;
2256     for (i=0; i<4; i++)
2257         if (pGridWin[i])
2258             if (pGridWin[i]->IsVisible())
2259                 pGridWin[i]->Invalidate();
2260 }
2261 
2262 //  PaintTop - obere Kontrollelemente neu zeichnen
2263 
2264 void ScTabView::PaintTop()
2265 {
2266     sal_uInt16 i;
2267     for (i=0; i<2; i++)
2268     {
2269         if (pColBar[i])
2270             pColBar[i]->Invalidate();
2271         if (pColOutline[i])
2272             pColOutline[i]->Invalidate();
2273     }
2274 }
2275 
2276 void ScTabView::CreateAnchorHandles(SdrHdlList& rHdl, const ScAddress& rAddress)
2277 {
2278     sal_uInt16 i;
2279 
2280     for(i=0; i<4; i++)
2281     {
2282         if(pGridWin[i])
2283         {
2284             if(pGridWin[i]->IsVisible())
2285             {
2286                 pGridWin[i]->CreateAnchorHandle(rHdl, rAddress);
2287             }
2288         }
2289     }
2290 }
2291 
2292 void ScTabView::PaintTopArea( SCCOL nStartCol, SCCOL nEndCol )
2293 {
2294         //  Pixel-Position der linken Kante
2295 
2296     if ( nStartCol < aViewData.GetPosX(SC_SPLIT_LEFT) ||
2297          nStartCol < aViewData.GetPosX(SC_SPLIT_RIGHT) )
2298         aViewData.RecalcPixPos();
2299 
2300         //  Fixierung anpassen (UpdateFixX setzt HSplitPos neu)
2301 
2302     if ( aViewData.GetHSplitMode() == SC_SPLIT_FIX && nStartCol < aViewData.GetFixPosX() )
2303         if (aViewData.UpdateFixX())
2304             RepeatResize();
2305 
2306         //  zeichnen
2307 
2308     if (nStartCol>0)
2309         --nStartCol;                //! allgemeiner ?
2310 
2311     sal_Bool bLayoutRTL = aViewData.GetDocument()->IsLayoutRTL( aViewData.GetTabNo() );
2312     long nLayoutSign = bLayoutRTL ? -1 : 1;
2313 
2314     for (sal_uInt16 i=0; i<2; i++)
2315     {
2316         ScHSplitPos eWhich = (ScHSplitPos) i;
2317         if (pColBar[eWhich])
2318         {
2319             Size aWinSize = pColBar[eWhich]->GetSizePixel();
2320             long nStartX = aViewData.GetScrPos( nStartCol, 0, eWhich ).X();
2321             long nEndX;
2322             if (nEndCol >= MAXCOL)
2323                 nEndX = bLayoutRTL ? 0 : ( aWinSize.Width()-1 );
2324             else
2325                 nEndX = aViewData.GetScrPos( nEndCol+1, 0, eWhich ).X() - nLayoutSign;
2326             pColBar[eWhich]->Invalidate(
2327                     Rectangle( nStartX, 0, nEndX, aWinSize.Height()-1 ) );
2328         }
2329         if (pColOutline[eWhich])
2330             pColOutline[eWhich]->Invalidate();
2331     }
2332 }
2333 
2334 
2335 //  PaintLeft - linke Kontrollelemente neu zeichnen
2336 
2337 void ScTabView::PaintLeft()
2338 {
2339     sal_uInt16 i;
2340     for (i=0; i<2; i++)
2341     {
2342         if (pRowBar[i])
2343             pRowBar[i]->Invalidate();
2344         if (pRowOutline[i])
2345             pRowOutline[i]->Invalidate();
2346     }
2347 }
2348 
2349 void ScTabView::PaintLeftArea( SCROW nStartRow, SCROW nEndRow )
2350 {
2351         //  Pixel-Position der oberen Kante
2352 
2353     if ( nStartRow < aViewData.GetPosY(SC_SPLIT_TOP) ||
2354          nStartRow < aViewData.GetPosY(SC_SPLIT_BOTTOM) )
2355         aViewData.RecalcPixPos();
2356 
2357         //  Fixierung anpassen (UpdateFixY setzt VSplitPos neu)
2358 
2359     if ( aViewData.GetVSplitMode() == SC_SPLIT_FIX && nStartRow < aViewData.GetFixPosY() )
2360         if (aViewData.UpdateFixY())
2361             RepeatResize();
2362 
2363         //  zeichnen
2364 
2365     if (nStartRow>0)
2366         --nStartRow;
2367 
2368     for (sal_uInt16 i=0; i<2; i++)
2369     {
2370         ScVSplitPos eWhich = (ScVSplitPos) i;
2371         if (pRowBar[eWhich])
2372         {
2373             Size aWinSize = pRowBar[eWhich]->GetSizePixel();
2374             long nStartY = aViewData.GetScrPos( 0, nStartRow, eWhich ).Y();
2375             long nEndY;
2376             if (nEndRow >= MAXROW)
2377                 nEndY = aWinSize.Height()-1;
2378             else
2379                 nEndY = aViewData.GetScrPos( 0, nEndRow+1, eWhich ).Y() - 1;
2380             pRowBar[eWhich]->Invalidate(
2381                     Rectangle( 0, nStartY, aWinSize.Width()-1, nEndY ) );
2382         }
2383         if (pRowOutline[eWhich])
2384             pRowOutline[eWhich]->Invalidate();
2385     }
2386 }
2387 
2388 //  InvertBlockMark - Block invertieren
2389 
2390 void ScTabView::InvertBlockMark(SCCOL nStartX, SCROW nStartY,
2391                                 SCCOL nEndX, SCROW nEndY)
2392 {
2393     if ( !aViewData.IsActive() )
2394         return;                                 // invertiert wird nur auf aktiver View
2395 
2396     PutInOrder( nStartX, nEndX );
2397     PutInOrder( nStartY, nEndY );
2398 
2399     ScMarkData& rMark = aViewData.GetMarkData();
2400     ScDocShell* pDocSh = aViewData.GetDocShell();
2401     ScDocument* pDoc = pDocSh->GetDocument();
2402     SCTAB nTab = aViewData.GetTabNo();
2403 
2404     if ( pDocSh->GetLockCount() )
2405     {
2406         //  if paint is locked, avoid repeated inverting
2407         //  add repaint areas to paint lock data instead
2408         pDocSh->PostPaint( nStartX,nStartY,nTab, nEndX,nEndY,nTab, PAINT_GRID );
2409         return;
2410     }
2411 
2412     sal_Bool bSingle = rMark.IsMultiMarked();
2413     sal_Bool bMerge = pDoc->HasAttrib( nStartX, nStartY, nTab, nEndX, nEndY, nTab,
2414                                     HASATTR_MERGED | HASATTR_OVERLAPPED );
2415 
2416     sal_uInt16 i;
2417     if ( bMerge || bSingle )
2418     {
2419         for (i=0; i<4; i++)
2420             if (pGridWin[i])
2421                 if (pGridWin[i]->IsVisible())
2422                     pGridWin[i]->InvertSimple( nStartX, nStartY, nEndX, nEndY,
2423                                                 bMerge, bBlockNeg );
2424     }
2425     else
2426     {
2427         for (i=0; i<4; i++)
2428             if (pGridWin[i])
2429                 if (pGridWin[i]->IsVisible())
2430                 {
2431                     ScSplitPos ePos = (ScSplitPos) i;
2432                     Point aStartPoint = aViewData.GetScrPos( nStartX, nStartY, ePos );
2433                     Point aEndPoint = aViewData.GetScrPos( nEndX+1, nEndY+1, ePos );
2434                     if ( pDoc->IsLayoutRTL( nTab ) )
2435                     {
2436                         long nTemp = aStartPoint.X();
2437                         aStartPoint.X() = aEndPoint.X() + 1;    // +1 - excluding start of nEndX+1
2438                         aEndPoint.X() = nTemp;
2439                     }
2440                     else
2441                         aEndPoint.X() -= 1;
2442                     aEndPoint.Y() -= 1;
2443                     if ( aEndPoint.X() >= aStartPoint.X() && aEndPoint.Y() >= aStartPoint.Y() )
2444                     {
2445                         MapMode aOld = pGridWin[ePos]->GetMapMode();
2446                         pGridWin[ePos]->SetMapMode(MAP_PIXEL);
2447                         pGridWin[ePos]->Invert( Rectangle(aStartPoint,aEndPoint), INVERT_HIGHLIGHT );
2448                         pGridWin[ePos]->SetMapMode(aOld);
2449                         pGridWin[ePos]->CheckInverted();
2450                     }
2451                 }
2452     }
2453 
2454         //
2455         //  wenn Controls betroffen, neu malen
2456         //
2457 
2458     sal_Bool bHide = sal_True;                  // wird Teil der Markierung aufgehoben ?
2459     if (rMark.IsMarked())
2460     {
2461         ScRange aMarkRange;
2462         rMark.GetMarkArea( aMarkRange );
2463         if ( aMarkRange.aStart.Col() <= nStartX && aMarkRange.aEnd.Col() >= nEndX &&
2464              aMarkRange.aStart.Row() <= nStartY && aMarkRange.aEnd.Row() >= nEndY )
2465         {
2466             bHide = sal_False;              // der ganze Bereich ist markiert
2467         }
2468     }
2469 }
2470 
2471 sal_Bool ScTabView::PaintExtras()
2472 {
2473     sal_Bool bRet = sal_False;
2474     ScDocument* pDoc = aViewData.GetDocument();
2475     SCTAB nTab = aViewData.GetTabNo();
2476     if (!pDoc->HasTable(nTab))                  // Tabelle geloescht ?
2477     {
2478         SCTAB nCount = pDoc->GetTableCount();
2479         aViewData.SetTabNo(nCount-1);
2480         bRet = sal_True;
2481     }
2482     pTabControl->UpdateStatus();                        // sal_True = active
2483     return bRet;
2484 }
2485 
2486 void ScTabView::RecalcPPT()
2487 {
2488     //  called after changes that require the PPT values to be recalculated
2489     //  (currently from detective operations)
2490 
2491     double nOldX = aViewData.GetPPTX();
2492     double nOldY = aViewData.GetPPTY();
2493 
2494     aViewData.RefreshZoom();                            // pre-calculate new PPT values
2495 
2496     sal_Bool bChangedX = ( aViewData.GetPPTX() != nOldX );
2497     sal_Bool bChangedY = ( aViewData.GetPPTY() != nOldY );
2498     if ( bChangedX || bChangedY )
2499     {
2500         //  call view SetZoom (including draw scale, split update etc)
2501         //  and paint only if values changed
2502 
2503         Fraction aZoomX = aViewData.GetZoomX();
2504         Fraction aZoomY = aViewData.GetZoomY();
2505         SetZoom( aZoomX, aZoomY, sal_False );
2506 
2507         PaintGrid();
2508         if (bChangedX)
2509             PaintTop();
2510         if (bChangedY)
2511             PaintLeft();
2512     }
2513 }
2514 
2515 void ScTabView::ActivateView( sal_Bool bActivate, sal_Bool bFirst )
2516 {
2517     if ( bActivate == aViewData.IsActive() && !bFirst )
2518     {
2519         //  keine Assertion mehr - kommt vor, wenn vorher im Drag&Drop
2520         //  auf ein anderes Dokument umgeschaltet wurde
2521         return;
2522     }
2523 
2524     // wird nur bei MDI-(De)Activate gerufen
2525     // aViewData.Activate hinten wegen Cursor-Show bei KillEditView
2526     //  Markierung nicht mehr loeschen - wenn an der ViewData Activate(sal_False) gesetzt ist,
2527     //  wird die Markierung nicht ausgegeben
2528 
2529     if (!bActivate)
2530     {
2531         ScModule* pScMod = SC_MOD();
2532         sal_Bool bRefMode = pScMod->IsFormulaMode();
2533 
2534             //  Referenzeingabe nicht abbrechen, um Referenzen auf
2535             //  andere Dokumente zuzulassen
2536 
2537         if (!bRefMode)
2538         {
2539             //pScMod->InputEnterHandler();
2540 
2541             //  #80843# pass view to GetInputHdl, this view may not be current anymore
2542             ScInputHandler* pHdl = SC_MOD()->GetInputHdl(aViewData.GetViewShell());
2543             if (pHdl)
2544                 pHdl->EnterHandler();
2545         }
2546     }
2547     pTabControl->ActivateView(bActivate);
2548     PaintExtras();
2549 
2550     aViewData.Activate(bActivate);
2551 
2552     PaintBlock(sal_False);                  // Repaint, Markierung je nach Active-Status
2553 
2554     if (!bActivate)
2555         HideAllCursors();               // Cursor
2556     else if (!bFirst)
2557         ShowAllCursors();
2558 
2559     //HMHif (pDrawView)
2560     //HMH   DrawShowMarkHdl(bActivate);     // Drawing-Markierung
2561 
2562     if (bActivate)
2563     {
2564         if ( bFirst )
2565         {
2566             ScSplitPos eWin = aViewData.GetActivePart();
2567             DBG_ASSERT( pGridWin[eWin], "rottes Dokument, nicht alle SplitPos in GridWin" );
2568             if ( !pGridWin[eWin] )
2569             {
2570                 eWin = SC_SPLIT_BOTTOMLEFT;
2571                 if ( !pGridWin[eWin] )
2572                 {
2573                     short i;
2574                     for ( i=0; i<4; i++ )
2575                     {
2576                         if ( pGridWin[i] )
2577                         {
2578                             eWin = (ScSplitPos) i;
2579                             break;  // for
2580                         }
2581                     }
2582                     DBG_ASSERT( i<4, "und BUMM" );
2583                 }
2584                 aViewData.SetActivePart( eWin );
2585             }
2586         }
2587         //  hier nicht mehr selber GrabFocus rufen!
2588         //  Wenn das Doc bearbeitet wird, ruft der Sfx selber GrabFocus am Fenster der Shell.
2589         //  Wenn es z.B. ein Mailbody ist, darf es den Focus nicht bekommen (Bug #43638#)
2590 
2591         UpdateInputContext();
2592     }
2593     else
2594         pGridWin[aViewData.GetActivePart()]->ClickExtern();
2595 }
2596 
2597 void ScTabView::ActivatePart( ScSplitPos eWhich )
2598 {
2599     ScSplitPos eOld = aViewData.GetActivePart();
2600     if ( eOld != eWhich )
2601     {
2602         bInActivatePart = sal_True;
2603 
2604         sal_Bool bRefMode = SC_MOD()->IsFormulaMode();
2605 
2606         //  #40565# the HasEditView call during SetCursor would fail otherwise
2607         if ( aViewData.HasEditView(eOld) && !bRefMode )
2608             UpdateInputLine();
2609 
2610         ScHSplitPos eOldH = WhichH(eOld);
2611         ScVSplitPos eOldV = WhichV(eOld);
2612         ScHSplitPos eNewH = WhichH(eWhich);
2613         ScVSplitPos eNewV = WhichV(eWhich);
2614         sal_Bool bTopCap  = pColBar[eOldH] && pColBar[eOldH]->IsMouseCaptured();
2615         sal_Bool bLeftCap = pRowBar[eOldV] && pRowBar[eOldV]->IsMouseCaptured();
2616 
2617         sal_Bool bFocus = pGridWin[eOld]->HasFocus();
2618         sal_Bool bCapture = pGridWin[eOld]->IsMouseCaptured();
2619         if (bCapture)
2620             pGridWin[eOld]->ReleaseMouse();
2621         pGridWin[eOld]->ClickExtern();
2622         pGridWin[eOld]->HideCursor();
2623         pGridWin[eWhich]->HideCursor();
2624         aViewData.SetActivePart( eWhich );
2625 
2626         ScTabViewShell* pShell = aViewData.GetViewShell();
2627         pShell->WindowChanged();
2628 
2629         pSelEngine->SetWindow(pGridWin[eWhich]);
2630         pSelEngine->SetWhich(eWhich);
2631         pSelEngine->SetVisibleArea( Rectangle(Point(), pGridWin[eWhich]->GetOutputSizePixel()) );
2632 
2633         pGridWin[eOld]->MoveMouseStatus(*pGridWin[eWhich]);
2634 
2635         if ( bCapture || pGridWin[eWhich]->IsMouseCaptured() )
2636         {
2637             //  Tracking statt CaptureMouse, damit sauber abgebrochen werden kann
2638             //  (SelectionEngine ruft CaptureMouse beim SetWindow)
2639             //! Irgendwann sollte die SelectionEngine selber StartTracking rufen!?!
2640             pGridWin[eWhich]->ReleaseMouse();
2641             pGridWin[eWhich]->StartTracking();
2642         }
2643 
2644         if ( bTopCap && pColBar[eNewH] )
2645         {
2646             pColBar[eOldH]->SetIgnoreMove(sal_True);
2647             pColBar[eNewH]->SetIgnoreMove(sal_False);
2648             pHdrSelEng->SetWindow( pColBar[eNewH] );
2649             long nWidth = pColBar[eNewH]->GetOutputSizePixel().Width();
2650             pHdrSelEng->SetVisibleArea( Rectangle( 0, LONG_MIN, nWidth-1, LONG_MAX ) );
2651             pColBar[eNewH]->CaptureMouse();
2652         }
2653         if ( bLeftCap && pRowBar[eNewV] )
2654         {
2655             pRowBar[eOldV]->SetIgnoreMove(sal_True);
2656             pRowBar[eNewV]->SetIgnoreMove(sal_False);
2657             pHdrSelEng->SetWindow( pRowBar[eNewV] );
2658             long nHeight = pRowBar[eNewV]->GetOutputSizePixel().Height();
2659             pHdrSelEng->SetVisibleArea( Rectangle( LONG_MIN, 0, LONG_MAX, nHeight-1 ) );
2660             pRowBar[eNewV]->CaptureMouse();
2661         }
2662         aHdrFunc.SetWhich(eWhich);
2663 
2664         pGridWin[eOld]->ShowCursor();
2665         pGridWin[eWhich]->ShowCursor();
2666 
2667         SfxInPlaceClient* pClient = aViewData.GetViewShell()->GetIPClient();
2668         sal_Bool bOleActive = ( pClient && pClient->IsObjectInPlaceActive() );
2669 
2670         //  #103823# don't switch ViewShell's active window during RefInput, because the focus
2671         //  might change, and subsequent SetReference calls wouldn't find the right EditView
2672         if ( !bRefMode && !bOleActive )
2673             aViewData.GetViewShell()->SetWindow( pGridWin[eWhich] );
2674 
2675         if ( bFocus && !aViewData.IsAnyFillMode() && !bRefMode )
2676         {
2677             //  GrabFocus nur, wenn vorher das andere GridWindow den Focus hatte
2678             //  (z.B. wegen Suchen & Ersetzen)
2679 //!         aViewData.GetViewShell()->GetViewFrame()->GetWindow().GrabFocus();
2680             pGridWin[eWhich]->GrabFocus();
2681         }
2682 
2683         bInActivatePart = sal_False;
2684     }
2685 }
2686 
2687 void ScTabView::HideListBox()
2688 {
2689     for (sal_uInt16 i=0; i<4; i++)
2690         if (pGridWin[i])
2691             pGridWin[i]->ClickExtern();
2692 }
2693 
2694 void ScTabView::UpdateInputContext()
2695 {
2696     ScGridWindow* pWin = pGridWin[aViewData.GetActivePart()];
2697     if (pWin)
2698         pWin->UpdateInputContext();
2699 }
2700 
2701 //  GetGridWidth - Breite eines Ausgabebereichs (fuer ViewData)
2702 
2703 long ScTabView::GetGridWidth( ScHSplitPos eWhich )
2704 {
2705     ScSplitPos eGridWhich = ( eWhich == SC_SPLIT_LEFT ) ? SC_SPLIT_BOTTOMLEFT : SC_SPLIT_BOTTOMRIGHT;
2706     if (pGridWin[eGridWhich])
2707         return pGridWin[eGridWhich]->GetSizePixel().Width();
2708     else
2709         return 0;
2710 }
2711 
2712 //  GetGridHeight - Hoehe eines Ausgabebereichs (fuer ViewData)
2713 
2714 long ScTabView::GetGridHeight( ScVSplitPos eWhich )
2715 {
2716     ScSplitPos eGridWhich = ( eWhich == SC_SPLIT_TOP ) ? SC_SPLIT_TOPLEFT : SC_SPLIT_BOTTOMLEFT;
2717     if (pGridWin[eGridWhich])
2718         return pGridWin[eGridWhich]->GetSizePixel().Height();
2719     else
2720         return 0;
2721 }
2722 
2723 void ScTabView::UpdateInputLine()
2724 {
2725     SC_MOD()->InputEnterHandler();
2726 }
2727 
2728 void ScTabView::ZoomChanged()
2729 {
2730     ScInputHandler* pHdl = SC_MOD()->GetInputHdl(aViewData.GetViewShell());
2731     if (pHdl)
2732         pHdl->SetRefScale( aViewData.GetZoomX(), aViewData.GetZoomY() );
2733 
2734     UpdateFixPos();
2735 
2736     UpdateScrollBars();
2737 
2738     //  VisArea...
2739     // AW: Discussed with NN if there is a reason that new map mode was only set for one window,
2740     // but is not. Setting only on one window causes the first repaint to have the old mapMode
2741     // in three of four views, so the overlay will save the wrong content e.g. when zooming out.
2742     // Changing to setting map mode at all windows.
2743     sal_uInt32 a;
2744 
2745     for(a = 0L; a < 4L; a++)
2746     {
2747         if(pGridWin[a])
2748         {
2749             pGridWin[a]->SetMapMode(pGridWin[a]->GetDrawMapMode());
2750         }
2751     }
2752 
2753     SetNewVisArea();
2754 
2755     /* the old code
2756     ScGridWindow* pWin = pGridWin[aViewData.GetActivePart()];
2757     if (pWin)
2758     {
2759         pWin->SetMapMode( pWin->GetDrawMapMode() ); // mit neuem Zoom
2760         SetNewVisArea();                            // benutzt den gesetzten MapMode
2761     } */
2762 
2763     InterpretVisible();     // #69343# have everything calculated before painting
2764 
2765     SfxBindings& rBindings = aViewData.GetBindings();
2766     rBindings.Invalidate( SID_ATTR_ZOOM );
2767     rBindings.Invalidate( SID_ATTR_ZOOMSLIDER );
2768 
2769     HideNoteMarker();
2770 
2771     // AW: To not change too much, use pWin here
2772     ScGridWindow* pWin = pGridWin[aViewData.GetActivePart()];
2773 
2774     if ( pWin && aViewData.HasEditView( aViewData.GetActivePart() ) )
2775     {
2776         // flush OverlayManager before changing the MapMode
2777         pWin->flushOverlayManager();
2778 
2779         //  #93650# make sure the EditView's position and size are updated
2780         //  with the right (logic, not drawing) MapMode
2781         pWin->SetMapMode( aViewData.GetLogicMode() );
2782         UpdateEditView();
2783     }
2784 }
2785 
2786 void ScTabView::CheckNeedsRepaint()
2787 {
2788     sal_uInt16 i;
2789     for (i=0; i<4; i++)
2790         if ( pGridWin[i] && pGridWin[i]->IsVisible() )
2791             pGridWin[i]->CheckNeedsRepaint();
2792 }
2793 
2794 
2795 
2796 
2797 
2798