LibreOffice Module sc (master)  1
tabvwshe.cxx
Go to the documentation of this file.
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 <comphelper/string.hxx>
21 #include <comphelper/lok.hxx>
22 #include <editeng/eeitem.hxx>
23 
24 #include <editeng/editview.hxx>
25 #include <editeng/flditem.hxx>
26 #include <svx/hlnkitem.hxx>
27 #include <svl/srchitem.hxx>
28 #include <sfx2/dispatch.hxx>
29 #include <sfx2/viewfrm.hxx>
30 #include <sfx2/request.hxx>
31 #include <svl/stritem.hxx>
32 
33 #include <tabvwsh.hxx>
34 #include <sc.hrc>
35 #include <scmod.hxx>
36 #include <impex.hxx>
37 #include <editsh.hxx>
38 #include <dociter.hxx>
39 #include <inputhdl.hxx>
40 #include <svx/srchdlg.hxx>
41 #include <document.hxx>
42 #include <gridwin.hxx>
43 
44 OUString ScTabViewShell::GetSelectionText( bool bWholeWord )
45 {
46  OUString aStrSelection;
47 
48  if ( pEditShell && pEditShell.get() == GetMySubShell() )
49  {
50  aStrSelection = pEditShell->GetSelectionText( bWholeWord );
51  }
52  else
53  {
54  ScRange aRange;
55 
56  if ( GetViewData().GetSimpleArea( aRange ) == SC_MARK_SIMPLE )
57  {
59  if ( bInFormatDialog && aRange.aStart.Row() != aRange.aEnd.Row() )
60  {
61  // limit range to one data row
62  // (only when the call comes from a format dialog)
63  ScHorizontalCellIterator aIter( rDoc, aRange.aStart.Tab(),
64  aRange.aStart.Col(), aRange.aStart.Row(),
65  aRange.aEnd.Col(), aRange.aEnd.Row() );
66  SCCOL nCol;
67  SCROW nRow;
68  if ( aIter.GetNext( nCol, nRow ) )
69  {
70  aRange.aStart.SetCol( nCol );
71  aRange.aStart.SetRow( nRow );
72  aRange.aEnd.SetRow( nRow );
73  }
74  else
75  aRange.aEnd = aRange.aStart;
76  }
77  else
78  {
79  // #i111531# with 1M rows it was necessary to limit the range
80  // to the actually used data area.
81  SCCOL nCol1, nCol2;
82  SCROW nRow1, nRow2;
83  SCTAB nTab1, nTab2;
84  aRange.GetVars( nCol1, nRow1, nTab1, nCol2, nRow2, nTab2);
85  bool bShrunk;
86  rDoc.ShrinkToUsedDataArea( bShrunk, nTab1, nCol1, nRow1, nCol2, nRow2, false);
87  if (bShrunk)
88  {
89  aRange.aStart.SetCol( nCol1 );
90  aRange.aStart.SetRow( nRow1 );
91  aRange.aEnd.SetCol( nCol2 );
92  aRange.aEnd.SetRow( nRow2 );
93  }
94  }
95 
96  ScImportExport aObj( rDoc, aRange );
97  aObj.SetFormulas( GetViewData().GetOptions().GetOption( VOPT_FORMULAS ) );
98  OUString aExportOUString;
99  /* TODO: STRING_TSVC under some circumstances? */
100  aObj.ExportString( aExportOUString, SotClipboardFormatId::STRING );
101  aStrSelection = convertLineEnd(aExportOUString, LINEEND_CR);
102 
103  // replace Tab/CR with space, if for dialog or through Basic/SelectionTextExt,
104  // or when it is a single row.
105  // Otherwise keep Tabs in multi-row (for instance mail or Basic/SelectionText).
106  // for mail the Tabs are then later changed into (multiple) spaces.
107 
108  if ( bInFormatDialog || bWholeWord || aRange.aEnd.Row() == aRange.aStart.Row() )
109  {
110  aStrSelection = aStrSelection.replaceAll("\r", " ");
111  aStrSelection = aStrSelection.replaceAll("\t", " ");
112  aStrSelection = comphelper::string::stripEnd(aStrSelection, ' ');
113  }
114  }
115  }
116 
117  return aStrSelection;
118 }
119 
120 void ScTabViewShell::InsertURL( const OUString& rName, const OUString& rURL, const OUString& rTarget,
121  sal_uInt16 nMode )
122 {
123  SvxLinkInsertMode eMode = static_cast<SvxLinkInsertMode>(nMode);
124  bool bAsText = ( eMode != HLINK_BUTTON ); // default is now text
125 
126  if ( bAsText )
127  {
128  if ( GetViewData().IsActive() )
129  {
130  // if the view is active, always use InsertURLField, which starts EditMode
131  // and selects the URL, so it can be changed from the URL bar / dialog
132 
133  InsertURLField( rName, rURL, rTarget );
134  }
135  else
136  {
137  // if the view is not active, InsertURLField doesn't work
138  // -> use InsertBookmark to directly manipulate cell content
139  // bTryReplace=sal_True -> if cell contains only one URL, replace it
140 
141  SCCOL nPosX = GetViewData().GetCurX();
142  SCROW nPosY = GetViewData().GetCurY();
143  InsertBookmark( rName, rURL, nPosX, nPosY, &rTarget, true );
144  }
145  }
146  else
147  {
148  SC_MOD()->InputEnterHandler();
149  InsertURLButton( rName, rURL, rTarget, nullptr );
150  }
151 }
152 
154 {
155  ESelection aSel = rView.GetSelection();
156  if ( aSel.nStartPos == aSel.nEndPos && aSel.nStartPos > 0 )
157  {
158  // Cursor is behind the inserted field -> extend selection to the left
159 
160  --aSel.nStartPos;
161  rView.SetSelection( aSel );
162  }
163 }
164 
165 void ScTabViewShell::InsertURLField( const OUString& rName, const OUString& rURL, const OUString& rTarget )
166 {
167  SvxURLField aURLField( rURL, rName, SvxURLFormat::Repr );
168  aURLField.SetTargetFrame( rTarget );
169  SvxFieldItem aURLItem( aURLField, EE_FEATURE_FIELD );
170 
171  ScViewData& rViewData = GetViewData();
172  ScModule* pScMod = SC_MOD();
173  ScInputHandler* pHdl = pScMod->GetInputHdl( rViewData.GetViewShell() );
174 
175  bool bSelectFirst = false;
176  bool bIsEditMode = pScMod->IsEditMode();
177  int nSelInd = 1;
178  OUString sSeltext(GetSelectionText());
179 
180  if ( !bIsEditMode )
181  {
182  if ( !SelectionEditable() )
183  {
184  // no error message (may be called from drag&drop)
185  return;
186  }
187 
188  // single url in cell is shown in the dialog and replaced
189  bSelectFirst = HasBookmarkAtCursor( nullptr );
190  pScMod->SetInputMode( SC_INPUT_TABLE );
191  }
192 
193  EditView* pTopView = pHdl->GetTopView();
194  EditView* pTableView = pHdl->GetTableView();
195  OSL_ENSURE( pTopView || pTableView, "No EditView" );
196 
197  // Check if user selected a whole cell by single click,
198  // cell has content, and user didn't change the name/text
199  // of the link something different than the content via the hyperlink dialog.
200  // If true, assign the given hyperlink to the whole content
201  // instead of inserting a duplicate, or appending the url.
202  if (comphelper::LibreOfficeKit::isActive() && !bIsEditMode && !bSelectFirst
203  && pTableView && !sSeltext.isEmpty() && sSeltext == rName)
204  {
205  nSelInd = sSeltext.getLength();
206  bSelectFirst = true;
207  }
208 
209  if ( bSelectFirst )
210  {
211  if ( pTopView )
212  pTopView->SetSelection( ESelection(0,0,0,1) );
213  if ( pTableView )
214  pTableView->SetSelection( ESelection(0,0,0,nSelInd) );
215  }
216 
217  pHdl->DataChanging();
218 
219  if ( pTopView )
220  {
221  pTopView->InsertField( aURLItem );
222  lcl_SelectFieldAfterInsert( *pTopView );
223  }
224  if ( pTableView )
225  {
226  pTableView->InsertField( aURLItem );
227  lcl_SelectFieldAfterInsert( *pTableView );
228  }
229 
230  pHdl->DataChanged();
231 }
232 
234 {
235  const SfxItemSet* pReqArgs = rReq.GetArgs();
236  sal_uInt16 nSlot = rReq.GetSlot();
237  const SfxPoolItem* pItem;
238 
239  switch ( nSlot )
240  {
241  case FID_SEARCH_NOW:
242  {
243  if ( pReqArgs &&
244  SfxItemState::SET == pReqArgs->GetItemState(SID_SEARCH_ITEM, false, &pItem) )
245  {
246  OSL_ENSURE( dynamic_cast<const SvxSearchItem*>( pItem) != nullptr, "wrong Item" );
247  const SvxSearchItem* pSearchItem = static_cast<const SvxSearchItem*>(pItem);
248 
249  ScGlobal::SetSearchItem( *pSearchItem );
250  SearchAndReplace( pSearchItem, true, rReq.IsAPI() );
251  rReq.Done();
252  }
253  }
254  break;
255 
256  case SID_SEARCH_ITEM:
257  if (pReqArgs && SfxItemState::SET ==
258  pReqArgs->GetItemState(SID_SEARCH_ITEM, false, &pItem))
259  {
260  // remember search item
261  OSL_ENSURE( dynamic_cast<const SvxSearchItem*>( pItem) != nullptr, "wrong Item" );
262  ScGlobal::SetSearchItem( *static_cast<const SvxSearchItem*>(pItem ));
263  }
264  else
265  {
266  OSL_FAIL("SID_SEARCH_ITEM without Parameter");
267  }
268  break;
269  case FID_SEARCH:
270  case FID_REPLACE:
271  case FID_REPLACE_ALL:
272  case FID_SEARCH_ALL:
273  {
274  if (pReqArgs && SfxItemState::SET == pReqArgs->GetItemState(nSlot, false, &pItem))
275  {
276  // get search item
277 
278  SvxSearchItem aSearchItem = ScGlobal::GetSearchItem();
279 
280  // fill search item
281 
282  aSearchItem.SetSearchString(static_cast<const SfxStringItem*>(pItem)->GetValue());
283  if(SfxItemState::SET == pReqArgs->GetItemState(FN_PARAM_1, false, &pItem))
284  aSearchItem.SetReplaceString(static_cast<const SfxStringItem*>(pItem)->GetValue());
285 
286  if (nSlot == FID_SEARCH)
287  aSearchItem.SetCommand(SvxSearchCmd::FIND);
288  else if(nSlot == FID_REPLACE)
289  aSearchItem.SetCommand(SvxSearchCmd::REPLACE);
290  else if(nSlot == FID_REPLACE_ALL)
291  aSearchItem.SetCommand(SvxSearchCmd::REPLACE_ALL);
292  else
293  aSearchItem.SetCommand(SvxSearchCmd::FIND_ALL);
294 
295  // execute request (which stores the SearchItem)
296 
297  aSearchItem.SetWhich(SID_SEARCH_ITEM);
298  GetViewData().GetDispatcher().ExecuteList(FID_SEARCH_NOW,
299  rReq.IsAPI() ? SfxCallMode::API|SfxCallMode::SYNCHRON :
300  SfxCallMode::RECORD,
301  { &aSearchItem });
302  }
303  else
304  {
306  SID_SEARCH_DLG, SfxCallMode::ASYNCHRON|SfxCallMode::RECORD );
307  }
308  }
309  break;
310  case FID_REPEAT_SEARCH:
311  {
312  // once more with ScGlobal::GetSearchItem()
313 
314  SvxSearchItem aSearchItem = ScGlobal::GetSearchItem();
315  aSearchItem.SetWhich(SID_SEARCH_ITEM);
316  GetViewData().GetDispatcher().ExecuteList( FID_SEARCH_NOW,
317  rReq.IsAPI() ? SfxCallMode::API|SfxCallMode::SYNCHRON :
318  SfxCallMode::RECORD,
319  { &aSearchItem });
320  }
321  break;
322 // case FID_SEARCH_COUNT:
323  }
324 }
325 
326 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
OString stripEnd(const OString &rIn, char c)
const SfxPoolItem * ExecuteList(sal_uInt16 nSlot, SfxCallMode nCall, std::initializer_list< SfxPoolItem const * > args, std::initializer_list< SfxPoolItem const * > internalargs=std::initializer_list< SfxPoolItem const * >())
void SetTargetFrame(const OUString &rFrm)
ScAddress aStart
Definition: address.hxx:500
TOOLS_DLLPUBLIC OString convertLineEnd(const OString &rIn, LineEnd eLineEnd)
bool IsEditMode()
Definition: scmod.cxx:1341
SCROW Row() const
Definition: address.hxx:262
bool ExportString(OUString &, SotClipboardFormatId)
Definition: impex.cxx:325
std::string GetValue
bool DataChanging(sal_Unicode cTyped=0, bool bFromCommand=false)
Definition: inputhdl.cxx:2572
void SetSearchString(const OUString &rNewString)
SCROW GetCurY() const
Definition: viewdata.hxx:402
ScAddress aEnd
Definition: address.hxx:501
void Done(bool bRemove=false)
ScDocument & GetDocument() const
Definition: viewdata.hxx:380
static void lcl_SelectFieldAfterInsert(EditView &rView)
Definition: tabvwshe.cxx:153
const SfxItemSet * GetArgs() const
void SetReplaceString(const OUString &rNewString)
LINEEND_CR
EditView * GetTableView()
Definition: inputhdl.hxx:233
std::unique_ptr< ScEditShell > pEditShell
Definition: tabvwsh.hxx:101
bool SelectionEditable(bool *pOnlyNotBecauseOfMatrix=nullptr)
Definition: viewfunc.cxx:260
virtual OUString GetSelectionText(bool bWholeWord=false) override
Definition: tabvwshe.cxx:44
bool HasBookmarkAtCursor(SvxHyperlinkItem *pContent)
Definition: viewfun4.cxx:756
Mode eMode
SCTAB Tab() const
Definition: address.hxx:271
void SetRow(SCROW nRowP)
Definition: address.hxx:275
bool SearchAndReplace(const SvxSearchItem *pSearchItem, bool bAddUndo, bool bIsApi)
Definition: viewfun2.cxx:1872
static SC_DLLPUBLIC void SetSearchItem(const SvxSearchItem &rNew)
Definition: global.cxx:224
sal_Int32 nEndPos
void SetCol(SCCOL nColP)
Definition: address.hxx:279
ScViewData & GetViewData()
Definition: tabview.hxx:332
ScTabViewShell * GetViewShell() const
Definition: viewdata.hxx:357
void InsertField(const SvxFieldItem &rFld)
void InsertURL(const OUString &rName, const OUString &rURL, const OUString &rTarget, sal_uInt16 nMode)
Definition: tabvwshe.cxx:120
bool ShrinkToUsedDataArea(bool &o_bShrunk, SCTAB nTab, SCCOL &rStartCol, SCROW &rStartRow, SCCOL &rEndCol, SCROW &rEndRow, bool bColumnsOnly, bool bStickyTopRow=false, bool bStickyLeftCol=false, bool bConsiderCellNotes=false, bool bConsiderCellDrawObjects=false) const
Shrink a range to only include used data area.
Definition: document.cxx:1071
SfxItemState GetItemState(sal_uInt16 nWhich, bool bSrchInParent=true, const SfxPoolItem **ppItem=nullptr) const
void SetFormulas(bool b)
Definition: impex.hxx:118
HLINK_BUTTON
sal_Int16 SCCOL
Definition: types.hxx:22
#define SC_MOD()
Definition: scmod.hxx:253
void InsertBookmark(const OUString &rDescription, const OUString &rURL, SCCOL nPosX, SCROW nPosY, const OUString *pTarget=nullptr, bool bTryReplace=false)
Definition: viewfun4.cxx:697
SvxLinkInsertMode
void SetCommand(SvxSearchCmd nNewCommand)
bool IsActive() const
Definition: viewdata.hxx:382
bool bInFormatDialog
Definition: tabvwsh.hxx:146
void GetVars(SCCOL &nCol1, SCROW &nRow1, SCTAB &nTab1, SCCOL &nCol2, SCROW &nRow2, SCTAB &nTab2) const
Definition: address.hxx:693
void InsertURLField(const OUString &rName, const OUString &rURL, const OUString &rTarget)
Definition: tabvwshe.cxx:165
void ExecSearch(SfxRequest &rReq)
Definition: tabvwshe.cxx:233
SCCOL Col() const
Definition: address.hxx:267
void SetInputMode(ScInputMode eMode, const OUString *pInitText=nullptr)
Definition: scmod.cxx:1334
sal_Int32 SCROW
Definition: types.hxx:18
sal_uInt16 GetSlot() const
SfxShell * GetMySubShell() const
Definition: tabvwsh4.cxx:972
void SetWhich(sal_uInt16 nId)
SfxDispatcher & GetDispatcher()
Definition: viewdata.cxx:3040
void DataChanged(bool bFromTopNotify=false, bool bSetModified=true)
Definition: inputhdl.cxx:2584
void SetSelection(const ESelection &rNewSel)
ESelection GetSelection() const
constexpr sal_uInt16 EE_FEATURE_FIELD(EE_FEATURE_NOTCONV+1)
ScInputHandler * GetInputHdl(ScTabViewShell *pViewSh=nullptr, bool bUseRef=true)
Input-Handler.
Definition: scmod.cxx:1303
bool IsAPI() const
const SfxPoolItem * Execute(sal_uInt16 nSlot, SfxCallMode nCall=SfxCallMode::SLOT, const SfxPoolItem **pArgs=nullptr, sal_uInt16 nModi=0, const SfxPoolItem **pInternalArgs=nullptr)
void InsertURLButton(const OUString &rName, const OUString &rURL, const OUString &rTarget, const Point *pInsPos)
Definition: tabvwshg.cxx:41
EditView * GetTopView()
Definition: inputhdl.hxx:234
sal_Int16 SCTAB
Definition: types.hxx:23
SCCOL GetCurX() const
Definition: viewdata.hxx:401
sal_Int32 nStartPos
static SC_DLLPUBLIC const SvxSearchItem & GetSearchItem()
Definition: global.cxx:213