Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 342 insertions, 0 deletions

diff --git a/sc/source/ui/view/tabvwshe.cxx b/sc/source/ui/view/tabvwshe.cxx
new file mode 100644
index 000000000..7089c17aa
--- /dev/null
+++ b/sc/source/ui/view/tabvwshe.cxx
@@ -0,0 +1,342 @@
+/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+#include <comphelper/string.hxx>
+#include <comphelper/lok.hxx>
+#include <editeng/eeitem.hxx>
+#include <osl/diagnose.h>
+
+#include <editeng/editview.hxx>
+#include <editeng/flditem.hxx>
+#include <svx/hlnkitem.hxx>
+#include <svl/srchitem.hxx>
+#include <sfx2/dispatch.hxx>
+#include <sfx2/request.hxx>
+#include <svl/stritem.hxx>
+
+#include <tabvwsh.hxx>
+#include <sc.hrc>
+#include <scmod.hxx>
+#include <impex.hxx>
+#include <editsh.hxx>
+#include <dociter.hxx>
+#include <inputhdl.hxx>
+#include <document.hxx>
+
+OUString ScTabViewShell::GetSelectionText( bool bWholeWord, bool bOnlyASample )
+{
+    OUString aStrSelection;
+
+    if ( pEditShell && pEditShell.get() == GetMySubShell() )
+    {
+        aStrSelection = pEditShell->GetSelectionText( bWholeWord );
+    }
+    else
+    {
+        ScRange aRange;
+
+        if ( GetViewData().GetSimpleArea( aRange ) == SC_MARK_SIMPLE )
+        {
+            ScDocument& rDoc = GetViewData().GetDocument();
+            if ( (bOnlyASample || bInFormatDialog) && aRange.aStart.Row() != aRange.aEnd.Row() )
+            {
+                // limit range to one data row
+                // (only when  the call comes from a format dialog)
+                ScHorizontalCellIterator aIter( rDoc, aRange.aStart.Tab(),
+                    aRange.aStart.Col(), aRange.aStart.Row(),
+                    aRange.aEnd.Col(), aRange.aEnd.Row() );
+                SCCOL nCol;
+                SCROW nRow;
+                if ( aIter.GetNext( nCol, nRow ) )
+                {
+                    aRange.aStart.SetCol( nCol );
+                    aRange.aStart.SetRow( nRow );
+                    aRange.aEnd.SetRow( nRow );
+                }
+                else
+                    aRange.aEnd = aRange.aStart;
+            }
+            else
+            {
+                // #i111531# with 1M rows it was necessary to limit the range
+                // to the actually used data area.
+                SCCOL nCol1, nCol2;
+                SCROW nRow1, nRow2;
+                SCTAB nTab1, nTab2;
+                aRange.GetVars( nCol1, nRow1, nTab1, nCol2, nRow2, nTab2);
+                bool bShrunk;
+                rDoc.ShrinkToUsedDataArea( bShrunk, nTab1, nCol1, nRow1, nCol2, nRow2, false);
+                if (bShrunk)
+                {
+                    aRange.aStart.SetCol( nCol1 );
+                    aRange.aStart.SetRow( nRow1 );
+                    aRange.aEnd.SetCol( nCol2 );
+                    aRange.aEnd.SetRow( nRow2 );
+                }
+            }
+
+            ScImportExport aObj( rDoc, aRange );
+            // tdf#148437 - if cell contains a formula, overwrite entire content of the cell
+            aObj.SetFormulas(true);
+            OUString aExportOUString;
+            /* TODO: STRING_TSVC under some circumstances? */
+            aObj.ExportString( aExportOUString, SotClipboardFormatId::STRING );
+            aStrSelection = convertLineEnd(aExportOUString, LINEEND_CR);
+
+            // replace Tab/CR with space, if for dialog or through Basic/SelectionTextExt,
+            // or when it is a single row.
+            // Otherwise keep Tabs in multi-row (for instance mail or Basic/SelectionText).
+            // for mail the Tabs are then later changed into (multiple) spaces.
+
+            if ( bInFormatDialog || bWholeWord || aRange.aEnd.Row() == aRange.aStart.Row() )
+            {
+                aStrSelection = aStrSelection.replaceAll("\r", " ");
+                aStrSelection = aStrSelection.replaceAll("\t", " ");
+                aStrSelection = comphelper::string::stripEnd(aStrSelection, ' ');
+            }
+        }
+    }
+
+    return aStrSelection;
+}
+
+bool ScTabViewShell::ShouldDisableEditHyperlink() const
+{
+    bool bRet = false;
+
+    if (pEditShell && pEditShell.get() == GetMySubShell())
+    {
+        bRet = pEditShell->ShouldDisableEditHyperlink();
+    }
+
+    return bRet;
+}
+
+void ScTabViewShell::EnableEditHyperlink()
+{
+    if (pEditShell && pEditShell.get() == GetMySubShell())
+    {
+        pEditShell->EnableEditHyperlink();
+    }
+}
+
+void ScTabViewShell::InsertURL( const OUString& rName, const OUString& rURL, const OUString& rTarget,
+                                sal_uInt16 nMode )
+{
+    SvxLinkInsertMode eMode = static_cast<SvxLinkInsertMode>(nMode);
+    bool bAsText = ( eMode != HLINK_BUTTON );       // default is now text
+
+    if ( bAsText )
+    {
+        if ( GetViewData().IsActive() )
+        {
+            //  if the view is active, always use InsertURLField, which starts EditMode
+            //  and selects the URL, so it can be changed from the URL bar / dialog
+
+            InsertURLField( rName, rURL, rTarget );
+        }
+        else
+        {
+            //  if the view is not active, InsertURLField doesn't work
+            //  -> use InsertBookmark to directly manipulate cell content
+            //  bTryReplace=sal_True -> if cell contains only one URL, replace it
+
+            SCCOL nPosX = GetViewData().GetCurX();
+            SCROW nPosY = GetViewData().GetCurY();
+            InsertBookmark( rName, rURL, nPosX, nPosY, &rTarget, true );
+        }
+    }
+    else
+    {
+        SC_MOD()->InputEnterHandler();
+        InsertURLButton( rName, rURL, rTarget, nullptr );
+    }
+}
+
+static void lcl_SelectFieldAfterInsert( EditView& rView )
+{
+    ESelection aSel = rView.GetSelection();
+    if ( aSel.nStartPos == aSel.nEndPos && aSel.nStartPos > 0 )
+    {
+        //  Cursor is behind the inserted field -> extend selection to the left
+
+        --aSel.nStartPos;
+        rView.SetSelection( aSel );
+    }
+}
+
+void ScTabViewShell::InsertURLField( const OUString& rName, const OUString& rURL, const OUString& rTarget )
+{
+    SvxURLField aURLField( rURL, rName, SvxURLFormat::Repr );
+    aURLField.SetTargetFrame( rTarget );
+    SvxFieldItem aURLItem( aURLField, EE_FEATURE_FIELD );
+
+    ScViewData&     rViewData   = GetViewData();
+    ScModule*       pScMod      = SC_MOD();
+    ScInputHandler* pHdl        = pScMod->GetInputHdl( rViewData.GetViewShell() );
+
+    bool bSelectFirst = false;
+    bool bIsEditMode = pScMod->IsEditMode();
+    int nSelInd = 1;
+    OUString sSeltext(GetSelectionText());
+
+    if ( !bIsEditMode )
+    {
+        if ( !SelectionEditable() )
+        {
+            // no error message (may be called from drag&drop)
+            return;
+        }
+
+        // single url in cell is shown in the dialog and replaced
+        bSelectFirst = HasBookmarkAtCursor( nullptr );
+        pScMod->SetInputMode( SC_INPUT_TABLE );
+    }
+
+    EditView*       pTopView    = pHdl->GetTopView();
+    EditView*       pTableView  = pHdl->GetTableView();
+    OSL_ENSURE( pTopView || pTableView, "No EditView" );
+
+    // Check if user selected a whole cell by single click, and cell has content.
+    // tdf#80043 - if true, replace the entire content of the selected cell instead of
+    // inserting a duplicate, or appending the url.
+    if (!bIsEditMode && !bSelectFirst && pTableView && !sSeltext.isEmpty())
+    {
+        nSelInd = sSeltext.getLength();
+        bSelectFirst = true;
+    }
+
+    if ( bSelectFirst )
+    {
+        if ( pTopView )
+            pTopView->SetSelection( ESelection(0,0,0,1) );
+        if ( pTableView )
+            pTableView->SetSelection( ESelection(0,0,0,nSelInd) );
+    }
+
+    pHdl->DataChanging();
+
+    if ( pTopView )
+    {
+        pTopView->InsertField( aURLItem );
+        lcl_SelectFieldAfterInsert( *pTopView );
+    }
+    if ( pTableView )
+    {
+        pTableView->InsertField( aURLItem );
+        lcl_SelectFieldAfterInsert( *pTableView );
+    }
+
+    pHdl->DataChanged();
+}
+
+void ScTabViewShell::ExecSearch( SfxRequest& rReq )
+{
+    const SfxItemSet*   pReqArgs    = rReq.GetArgs();
+    sal_uInt16              nSlot       = rReq.GetSlot();
+    const SfxPoolItem*  pItem;
+
+    switch ( nSlot )
+    {
+        case FID_SEARCH_NOW:
+            {
+                const SvxSearchItem* pSearchItem;
+                if ( pReqArgs &&
+                     (pSearchItem = pReqArgs->GetItemIfSet(SID_SEARCH_ITEM, false)) )
+                {
+                    ScGlobal::SetSearchItem( *pSearchItem );
+                    SearchAndReplace( pSearchItem, true, rReq.IsAPI() );
+                    rReq.Done();
+                }
+            }
+            break;
+
+        case SID_SEARCH_ITEM:
+        {
+            const SvxSearchItem* pSearchItem;
+            if (pReqArgs && (pSearchItem =
+                            pReqArgs->GetItemIfSet(SID_SEARCH_ITEM, false)))
+            {
+                // remember search item
+                ScGlobal::SetSearchItem( *pSearchItem );
+            }
+            else
+            {
+                OSL_FAIL("SID_SEARCH_ITEM without Parameter");
+            }
+            break;
+        }
+        case FID_SEARCH:
+        case FID_REPLACE:
+        case FID_REPLACE_ALL:
+        case FID_SEARCH_ALL:
+            {
+                if (pReqArgs && SfxItemState::SET == pReqArgs->GetItemState(nSlot, false, &pItem))
+                {
+                    // get search item
+
+                    SvxSearchItem aSearchItem = ScGlobal::GetSearchItem();
+
+                    // fill search item
+
+                    aSearchItem.SetSearchString(static_cast<const SfxStringItem*>(pItem)->GetValue());
+                    if(SfxItemState::SET == pReqArgs->GetItemState(FN_PARAM_1, false, &pItem))
+                        aSearchItem.SetReplaceString(static_cast<const SfxStringItem*>(pItem)->GetValue());
+
+                    if (nSlot == FID_SEARCH)
+                        aSearchItem.SetCommand(SvxSearchCmd::FIND);
+                    else if(nSlot == FID_REPLACE)
+                        aSearchItem.SetCommand(SvxSearchCmd::REPLACE);
+                    else if(nSlot == FID_REPLACE_ALL)
+                        aSearchItem.SetCommand(SvxSearchCmd::REPLACE_ALL);
+                    else
+                        aSearchItem.SetCommand(SvxSearchCmd::FIND_ALL);
+
+                    // execute request (which stores the SearchItem)
+
+                    aSearchItem.SetWhich(SID_SEARCH_ITEM);
+                    GetViewData().GetDispatcher().ExecuteList(FID_SEARCH_NOW,
+                            rReq.IsAPI() ? SfxCallMode::API|SfxCallMode::SYNCHRON :
+                                            SfxCallMode::RECORD,
+                            { &aSearchItem });
+                }
+                else
+                {
+                    GetViewData().GetDispatcher().Execute(
+                            SID_SEARCH_DLG, SfxCallMode::ASYNCHRON|SfxCallMode::RECORD );
+                }
+            }
+            break;
+        case FID_REPEAT_SEARCH:
+            {
+                // once more with ScGlobal::GetSearchItem()
+
+                SvxSearchItem aSearchItem = ScGlobal::GetSearchItem();
+                aSearchItem.SetWhich(SID_SEARCH_ITEM);
+                GetViewData().GetDispatcher().ExecuteList( FID_SEARCH_NOW,
+                        rReq.IsAPI() ? SfxCallMode::API|SfxCallMode::SYNCHRON :
+                                        SfxCallMode::RECORD,
+                        { &aSearchItem });
+            }
+            break;
+//      case FID_SEARCH_COUNT:
+    }
+}
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */