sc/source/ui/view/tabvwsh5.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include <svl/hint.hxx>
  21 #include <comphelper/lok.hxx>
  22 #include <svx/numfmtsh.hxx>
  23 #include <svx/numinf.hxx>
  24 #include <svx/svxids.hrc>
  25 #include <sfx2/dispatch.hxx>
  26 #include <sfx2/objsh.hxx>
  27 #include <sfx2/viewfrm.hxx>
  28 #include <osl/diagnose.h>
  29
  30 #include <tabvwsh.hxx>
  31 #include <global.hxx>
  32 #include <docsh.hxx>
  33 #include <document.hxx>
  34 #include <formulacell.hxx>
  35 #include <scmod.hxx>
  36 #include <uiitems.hxx>
  37 #include <hints.hxx>
  38 #include <cellvalue.hxx>
  39 #include <svl/numformat.hxx>
  40 #include <svl/sharedstring.hxx>
  41
  42 void ScTabViewShell::Notify( SfxBroadcaster& rBC, const SfxHint& rHint )
  43 {
  44     if (rHint.GetId() == SfxHintId::ScPaint) // draw new
  45     {
  46         const ScPaintHint* pPaintHint = static_cast<const ScPaintHint*>(&rHint);
  47         PaintPartFlags nParts = pPaintHint->GetParts();
  48         SCTAB nTab = GetViewData().GetTabNo();
  49         if (pPaintHint->GetStartTab() <= nTab && pPaintHint->GetEndTab() >= nTab)
  50         {
  51             if (nParts & PaintPartFlags::Extras)          // first if table vanished !!!
  52                 if (PaintExtras())
  53                     nParts = PaintPartFlags::All;
  54
  55             // if the current sheet has pending row height updates (sheet links refreshed),
  56             // execute them before invalidating the window
  57             GetViewData().GetDocShell()->UpdatePendingRowHeights( GetViewData().GetTabNo() );
  58
  59             if (nParts & PaintPartFlags::Size)
  60                 RepeatResize();                     //! InvalidateBorder ???
  61             const tools::Long nWidthAffectedHint = pPaintHint->GetMaxWidthAffectedHint();
  62             if (nParts & PaintPartFlags::Grid)
  63                 PaintArea( pPaintHint->GetStartCol(), pPaintHint->GetStartRow(),
  64                            pPaintHint->GetEndCol(), pPaintHint->GetEndRow(),
  65                            ScUpdateMode::All, nWidthAffectedHint );
  66             if (nParts & PaintPartFlags::Marks)
  67                 PaintArea( pPaintHint->GetStartCol(), pPaintHint->GetStartRow(),
  68                            pPaintHint->GetEndCol(), pPaintHint->GetEndRow(),
  69                            ScUpdateMode::Marks, nWidthAffectedHint );
  70             if (nParts & PaintPartFlags::Left)
  71                 PaintLeftArea( pPaintHint->GetStartRow(), pPaintHint->GetEndRow() );
  72             if (nParts & PaintPartFlags::Top)
  73                 PaintTopArea( pPaintHint->GetStartCol(), pPaintHint->GetEndCol() );
  74
  75             // #i84689# call UpdateAllOverlays here instead of in ScTabView::PaintArea
  76             if (nParts & ( PaintPartFlags::Left | PaintPartFlags::Top ))    // only if widths or heights changed
  77                 UpdateAllOverlays();
  78
  79             HideNoteMarker();
  80         }
  81     }
  82     else if (rHint.GetId() == SfxHintId::ScEditView) // create Edit-View
  83     {
  84         //  ScEditViewHint is only received at active view
  85         auto pEditViewHint = static_cast<const ScEditViewHint*>(&rHint);
  86
  87         SCTAB nTab = GetViewData().GetTabNo();
  88         if ( pEditViewHint->GetTab() == nTab )
  89         {
  90             SCCOL nCol = pEditViewHint->GetCol();
  91             SCROW nRow = pEditViewHint->GetRow();
  92             {
  93                 HideNoteMarker();
  94
  95                 MakeEditView( pEditViewHint->GetEngine(), nCol, nRow );
  96
  97                 StopEditShell();                    // shouldn't be set
  98
  99                 ScSplitPos eActive = GetViewData().GetActivePart();
 100                 if ( GetViewData().HasEditView(eActive) )
 101                 {
 102                     //  MakeEditView will fail, if the cursor is outside the screen.
 103                     //  Then GetEditView will return a none-active view, therefore
 104                     //  calling HasEditView.
 105
 106                     EditView* pView = GetViewData().GetEditView(eActive);  // isn't zero
 107
 108                     SetEditShell(pView, true);
 109                 }
 110             }
 111         }
 112     }
 113     else if (rHint.GetId() == SfxHintId::ScTables) // table insert / deleted
 114     {
 115         auto pTablesHint = static_cast<const ScTablesHint*>(&rHint);
 116         // first fetch current table (can be changed during DeleteTab on ViewData)
 117         SCTAB nActiveTab = GetViewData().GetTabNo();
 118
 119         SCTAB nTab1 = pTablesHint->GetTab1();
 120         SCTAB nTab2 = pTablesHint->GetTab2();
 121         sal_uInt16 nId  = pTablesHint->GetTablesHintId();
 122         switch (nId)
 123         {
 124             case SC_TAB_INSERTED:
 125                 GetViewData().InsertTab( nTab1 );
 126                 break;
 127             case SC_TAB_DELETED:
 128                 GetViewData().DeleteTab( nTab1 );
 129                 break;
 130             case SC_TAB_MOVED:
 131                 GetViewData().MoveTab( nTab1, nTab2 );
 132                 break;
 133             case SC_TAB_COPIED:
 134                 GetViewData().CopyTab( nTab1, nTab2 );
 135                 break;
 136             case SC_TAB_HIDDEN:
 137                 break;
 138             case SC_TABS_INSERTED:
 139                 GetViewData().InsertTabs( nTab1, nTab2 );
 140                 break;
 141             case SC_TABS_DELETED:
 142                 GetViewData().DeleteTabs( nTab1, nTab2 );
 143                 break;
 144             default:
 145                 OSL_FAIL("unknown ScTablesHint");
 146         }
 147
 148         //  No calling of IsActive() here, because the actions can be coming from Basic
 149         //  and then also the active view has to be switched.
 150
 151         SCTAB nNewTab = nActiveTab;
 152         bool bStayOnActiveTab = true;
 153         switch (nId)
 154         {
 155             case SC_TAB_INSERTED:
 156                 if ( nTab1 <= nNewTab )             // insert before
 157                     ++nNewTab;
 158                 break;
 159             case SC_TAB_DELETED:
 160                 if ( nTab1 < nNewTab )              // deleted before
 161                     --nNewTab;
 162                 else if ( nTab1 == nNewTab )        // deleted current
 163                     bStayOnActiveTab = false;
 164                 break;
 165             case SC_TAB_MOVED:
 166                 if ( nNewTab == nTab1 )             // moved table
 167                     nNewTab = nTab2;
 168                 else if ( nTab1 < nTab2 )           // moved back
 169                 {
 170                     if ( nNewTab > nTab1 && nNewTab <= nTab2 )      // succeeding area
 171                         --nNewTab;
 172                 }
 173                 else                                // move in front
 174                 {
 175                     if ( nNewTab >= nTab2 && nNewTab < nTab1 )      // succeeding area
 176                         ++nNewTab;
 177                 }
 178                 break;
 179             case SC_TAB_COPIED:
 180                 if ( nNewTab >= nTab2 )             // insert before
 181                     ++nNewTab;
 182                 break;
 183             case SC_TAB_HIDDEN:
 184                 if ( nTab1 == nNewTab )             // current is hidden
 185                     bStayOnActiveTab = false;
 186                 break;
 187             case SC_TABS_INSERTED:
 188                 if ( nTab1 <= nNewTab )
 189                     nNewTab += nTab2;
 190                 break;
 191             case SC_TABS_DELETED:
 192                 if ( nTab1 < nNewTab )
 193                     nNewTab -= nTab2;
 194                 break;
 195         }
 196
 197         ScDocument& rDoc = GetViewData().GetDocument();
 198         if ( nNewTab >= rDoc.GetTableCount() )
 199             nNewTab = rDoc.GetTableCount() - 1;
 200
 201         bool bForce = !bStayOnActiveTab;
 202         SetTabNo( nNewTab, bForce, false, bStayOnActiveTab );
 203     }
 204     else if (const ScIndexHint* pIndexHint = dynamic_cast<const ScIndexHint*>(&rHint))
 205     {
 206         SfxHintId nId = pIndexHint->GetId();
 207         sal_uInt16 nIndex = pIndexHint->GetIndex();
 208         switch (nId)
 209         {
 210             case SfxHintId::ScShowRangeFinder:
 211                 PaintRangeFinder( nIndex );
 212                 break;
 213             default: break;
 214         }
 215     }
 216     else                       // without parameter
 217     {
 218         const SfxHintId nSlot = rHint.GetId();
 219         switch ( nSlot )
 220         {
 221             case SfxHintId::ScDataChanged:
 222                 UpdateFormulas();
 223                 break;
 224
 225             case SfxHintId::ScRefModeChanged:
 226                 {
 227                     bool bRefMode = ScModule::get()->IsFormulaMode();
 228                     if (!bRefMode)
 229                         StopRefMode();
 230                     else
 231                         GetSelEngine()->Reset();
 232                 }
 233                 break;
 234
 235             case SfxHintId::ScKillEditView:
 236             case SfxHintId::ScKillEditViewNoPaint:
 237                 if (!comphelper::LibreOfficeKit::isActive()
 238                     || this == SfxViewShell::Current()
 239                     || bInPrepareClose
 240                     || bInDispose)
 241                 {
 242                     StopEditShell();
 243                     KillEditView( nSlot == SfxHintId::ScKillEditViewNoPaint );
 244                 }
 245                 break;
 246
 247             case SfxHintId::DocChanged:
 248                 {
 249                     ScDocument& rDoc = GetViewData().GetDocument();
 250                     if (!rDoc.HasTable( GetViewData().GetTabNo() ))
 251                     {
 252                         SetTabNo(0);
 253                     }
 254                 }
 255                 break;
 256
 257             case SfxHintId::ScDrawLayerNew:
 258                 MakeDrawView(TRISTATE_INDET);
 259                 break;
 260
 261             case SfxHintId::ScDocSaved:
 262                 {
 263                     //  "Save as" can make a write-protected document writable,
 264                     //  therefore the Layer-Locks anew (#39884#)
 265                     //  (Invalidate etc. is happening already from Sfx)
 266                     //  by SID_EDITDOC no SfxHintId::TitleChanged will occur, that
 267                     //  is why the own hint from DoSaveCompleted
 268                     //! what is with SfxHintId::SAVECOMPLETED ?
 269
 270                     UpdateLayerLocks();
 271
 272                     //  Would be too much to change Design-Mode with every save
 273                     //  (when saving under the name, it should remain unchanged)
 274                     //  Therefore only by SfxHintId::ModeChanged (from ViewFrame)
 275                 }
 276                 break;
 277
 278             case SfxHintId::ModeChanged:
 279                 //  Since you can no longer rely on it where this hint was coming
 280                 //  from, always switch the design mode when the ReadOnly state
 281                 //  really was changed:
 282
 283                 if ( GetViewData().GetSfxDocShell()->IsReadOnly() != bReadOnly )
 284                 {
 285                     bReadOnly = GetViewData().GetSfxDocShell()->IsReadOnly();
 286
 287                     SfxBoolItem aItem( SID_FM_DESIGN_MODE, !bReadOnly);
 288                     GetViewData().GetDispatcher().ExecuteList(SID_FM_DESIGN_MODE,
 289                             SfxCallMode::ASYNCHRON, { &aItem });
 290
 291                     UpdateInputContext();
 292                 }
 293                 break;
 294
 295             case SfxHintId::ScShowRangeFinder:
 296                 PaintRangeFinder(-1);
 297                 break;
 298
 299             case SfxHintId::ScForceSetTab:
 300                 SetTabNo( GetViewData().GetTabNo(), true );
 301                 break;
 302
 303             case SfxHintId::LanguageChanged:
 304             {
 305                 GetViewFrame().GetBindings().Invalidate(SID_LANGUAGE_STATUS);
 306                 if ( ScGridWindow* pWin = GetViewData().GetActiveWin() )
 307                     pWin->ResetAutoSpell();
 308             }
 309                 break;
 310
 311             default:
 312                 break;
 313         }
 314     }
 315
 316     SfxViewShell::Notify( rBC, rHint );
 317 }
 318
 319 std::unique_ptr<SvxNumberInfoItem> ScTabViewShell::MakeNumberInfoItem( ScDocument& rDoc, const ScViewData& rViewData )
 320 {
 321
 322     // construct NumberInfo item
 323
 324     SvxNumberValueType  eValType        = SvxNumberValueType::Undefined;
 325     double              nCellValue      = 0;
 326     OUString aCellString;
 327
 328     ScRefCellValue aCell(rDoc, rViewData.GetCurPos());
 329
 330     switch (aCell.getType())
 331     {
 332         case CELLTYPE_VALUE:
 333         {
 334             nCellValue = aCell.getDouble();
 335             eValType = SvxNumberValueType::Number;
 336         }
 337         break;
 338
 339         case CELLTYPE_STRING:
 340         {
 341             aCellString = aCell.getSharedString()->getString();
 342             eValType = SvxNumberValueType::String;
 343         }
 344         break;
 345
 346         case CELLTYPE_FORMULA:
 347         {
 348             if (aCell.getFormula()->IsValue())
 349             {
 350                 nCellValue = aCell.getFormula()->GetValue();
 351                 eValType = SvxNumberValueType::Number;
 352             }
 353             else
 354             {
 355                 nCellValue = 0;
 356                 eValType   = SvxNumberValueType::Undefined;
 357             }
 358         }
 359         break;
 360
 361         default:
 362             nCellValue = 0;
 363             eValType   = SvxNumberValueType::Undefined;
 364     }
 365
 366     switch ( eValType )
 367     {
 368         case SvxNumberValueType::String:
 369             return std::make_unique<SvxNumberInfoItem>(
 370                                 rDoc.GetFormatTable(),
 371                                 aCellString,
 372                                 SID_ATTR_NUMBERFORMAT_INFO );
 373
 374         case SvxNumberValueType::Number:
 375             return std::make_unique<SvxNumberInfoItem>(
 376                                 rDoc.GetFormatTable(),
 377                                 nCellValue,
 378                                 SID_ATTR_NUMBERFORMAT_INFO );
 379
 380         case SvxNumberValueType::Undefined:
 381         default:
 382             ;
 383     }
 384
 385     return std::make_unique<SvxNumberInfoItem>(
 386         rDoc.GetFormatTable(), SID_ATTR_NUMBERFORMAT_INFO);
 387 }
 388
 389 void ScTabViewShell::UpdateNumberFormatter(
 390                         const SvxNumberInfoItem& rInfoItem )
 391 {
 392     for ( sal_uInt32 key : rInfoItem.GetDelFormats() )
 393         rInfoItem.GetNumberFormatter()->DeleteEntry( key );
 394 }
 395
 396 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */