?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
problem pasting to calc an image copied from firefox (windows)
[LibreOffice.git] / sc / source / ui / view / cellsh2.cxx
blob8ff829326597e5795b64ad3c14e90f1b846f8124
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 <config_features.h>
21
22 #include <basic/sberrors.hxx>
23 #include <scitems.hxx>
24 #include <comphelper/lok.hxx>
25 #include <sfx2/viewfrm.hxx>
26 #include <sfx2/request.hxx>
27 #include <basic/sbxcore.hxx>
28 #include <svl/whiter.hxx>
29 #include <svl/numformat.hxx>
30 #include <svl/zforlist.hxx>
31 #include <svl/stritem.hxx>
32 #include <svl/visitem.hxx>
33 #include <unotools/moduleoptions.hxx>
34
35 #include <com/sun/star/frame/FrameSearchFlag.hpp>
36 #include <com/sun/star/sheet/TableValidationVisibility.hpp>
37
38 #include <cellsh.hxx>
39 #include <dbdata.hxx>
40 #include <queryparam.hxx>
41 #include <tabvwsh.hxx>
42 #include <sc.hrc>
43 #include <globstr.hrc>
44 #include <scresid.hxx>
45 #include <global.hxx>
46 #include <scmod.hxx>
47 #include <docsh.hxx>
48 #include <document.hxx>
49 #include <uiitems.hxx>
50 #include <dbdocfun.hxx>
51 #include <reffact.hxx>
52 #include <validat.hxx>
53 #include <validate.hxx>
54 #include <datamapper.hxx>
55
56 #include <scui_def.hxx>
57 #include <scabstdlg.hxx>
58 #include <impex.hxx>
59 #include <asciiopt.hxx>
60 #include <datastream.hxx>
61 #include <datastreamdlg.hxx>
62 #include <dataproviderdlg.hxx>
63 #include <queryentry.hxx>
64 #include <markdata.hxx>
65 #include <documentlinkmgr.hxx>
66 #include <officecfg/Office/Common.hxx>
67
68 #include <o3tl/make_shared.hxx>
69 #include <memory>
70
71 using namespace com::sun::star;
72
73 static bool lcl_GetTextToColumnsRange( const ScViewData& rData, ScRange& rRange, bool bDoEmptyCheckOnly )
74 {
75 bool bRet = false;
76 const ScMarkData& rMark = rData.GetMarkData();
77
78 if ( rMark.IsMarked() )
79 {
80 if ( !rMark.IsMultiMarked() )
81 {
82 rMark.GetMarkArea( rRange );
83 if ( rRange.aStart.Col() == rRange.aEnd.Col() )
84 {
85 bRet = true;
86 }
87 }
88 }
89 else
90 {
91 const SCCOL nCol = rData.GetCurX();
92 const SCROW nRow = rData.GetCurY();
93 const SCTAB nTab = rData.GetTabNo();
94 rRange = ScRange( nCol, nRow, nTab, nCol, nRow, nTab );
95 bRet = true;
96 }
97
98 const ScDocument& rDoc = rData.GetDocument();
99
100 if ( bDoEmptyCheckOnly )
101 {
102 if ( bRet && rDoc.IsBlockEmpty( rRange.aStart.Tab(), rRange.aStart.Col(),
103 rRange.aStart.Row(), rRange.aEnd.Col(),
104 rRange.aEnd.Row() ) )
105 {
106 bRet = false;
107 }
108 }
109 else if ( bRet )
110 {
111 rRange.PutInOrder();
112 SCCOL nStartCol = rRange.aStart.Col(), nEndCol = rRange.aEnd.Col();
113 SCROW nStartRow = rRange.aStart.Row(), nEndRow = rRange.aEnd.Row();
114 bool bShrunk = false;
115 rDoc.ShrinkToUsedDataArea( bShrunk, rRange.aStart.Tab(), nStartCol, nStartRow,
116 nEndCol, nEndRow, false, false, true );
117 if ( bShrunk )
118 {
119 rRange.aStart.SetRow( nStartRow );
120 rRange.aEnd.SetRow( nEndRow );
121 }
122 }
123
124 return bRet;
125 }
126
127 static bool lcl_GetSortParam( const ScViewData& rData, const ScSortParam& rSortParam )
128 {
129 ScTabViewShell* pTabViewShell = rData.GetViewShell();
130 ScDBData* pDBData = pTabViewShell->GetDBData();
131 ScDocument& rDoc = rData.GetDocument();
132 SCTAB nTab = rData.GetTabNo();
133 ScDirection eFillDir = DIR_TOP;
134 bool bSort = true;
135 ScRange aExternalRange;
136
137 if( rSortParam.nCol1 != rSortParam.nCol2 )
138 eFillDir = DIR_LEFT;
139 if( rSortParam.nRow1 != rSortParam.nRow2 )
140 eFillDir = DIR_TOP;
141
142 if( rSortParam.nRow2 == rDoc.MaxRow() )
143 {
144 // Assume that user selected entire column(s), but cater for the
145 // possibility that the start row is not the first row.
146 SCSIZE nCount = rDoc.GetEmptyLinesInBlock( rSortParam.nCol1, rSortParam.nRow1, nTab,
147 rSortParam.nCol2, rSortParam.nRow2, nTab, eFillDir );
148 aExternalRange = ScRange( rSortParam.nCol1,
149 ::std::min( rSortParam.nRow1 + sal::static_int_cast<SCROW>( nCount ), rDoc.MaxRow()), nTab,
150 rSortParam.nCol2, rSortParam.nRow2, nTab);
151 aExternalRange.PutInOrder();
152 }
153 else if (rSortParam.nCol1 != rSortParam.nCol2 || rSortParam.nRow1 != rSortParam.nRow2)
154 {
155 // Preserve a preselected area.
156 aExternalRange = ScRange( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab);
157 aExternalRange.PutInOrder();
158 }
159 else
160 aExternalRange = ScRange( rData.GetCurX(), rData.GetCurY(), nTab );
161
162 SCROW nStartRow = aExternalRange.aStart.Row();
163 SCCOL nStartCol = aExternalRange.aStart.Col();
164 SCROW nEndRow = aExternalRange.aEnd.Row();
165 SCCOL nEndCol = aExternalRange.aEnd.Col();
166 rDoc.GetDataArea( aExternalRange.aStart.Tab(), nStartCol, nStartRow, nEndCol, nEndRow, false, false );
167 aExternalRange.aStart.SetRow( nStartRow );
168 aExternalRange.aStart.SetCol( nStartCol );
169 aExternalRange.aEnd.SetRow( nEndRow );
170 aExternalRange.aEnd.SetCol( nEndCol );
171
172 // with LibreOfficeKit, don't try to interact with the user
173 if (!comphelper::LibreOfficeKit::isActive() &&
174 ((rSortParam.nCol1 == rSortParam.nCol2 && aExternalRange.aStart.Col() != aExternalRange.aEnd.Col()) ||
175 (rSortParam.nRow1 == rSortParam.nRow2 && aExternalRange.aStart.Row() != aExternalRange.aEnd.Row())))
176 {
177 pTabViewShell->AddHighlightRange( aExternalRange,COL_LIGHTBLUE );
178 OUString aExtendStr( aExternalRange.Format(rDoc, ScRefFlags::VALID));
179
180 ScRange aCurrentRange( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab );
181 OUString aCurrentStr(aCurrentRange.Format(rDoc, ScRefFlags::VALID));
182
183 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
184
185 ScopedVclPtr<AbstractScSortWarningDlg> pWarningDlg(pFact->CreateScSortWarningDlg(pTabViewShell->GetFrameWeld(), aExtendStr, aCurrentStr));
186 short bResult = pWarningDlg->Execute();
187 if( bResult == BTN_EXTEND_RANGE || bResult == BTN_CURRENT_SELECTION )
188 {
189 if( bResult == BTN_EXTEND_RANGE )
190 {
191 pTabViewShell->MarkRange( aExternalRange, false );
192 pDBData->SetArea( nTab, aExternalRange.aStart.Col(), aExternalRange.aStart.Row(), aExternalRange.aEnd.Col(), aExternalRange.aEnd.Row() );
193 }
194 }
195 else
196 {
197 bSort = false;
198 rData.GetDocShell()->CancelAutoDBRange();
199 }
200
201 pTabViewShell->ClearHighlightRanges();
202 }
203 return bSort;
204 }
205
206 namespace
207 {
208 // this registers the dialog which Find1RefWindow search for
209 class ScValidationRegisteredDlg
210 {
211 std::shared_ptr<SfxDialogController> m_xDlg;
212 public:
213 ScValidationRegisteredDlg(weld::Window* pParent, const std::shared_ptr<SfxDialogController>& rDlg)
214 : m_xDlg(rDlg)
215 {
216 SC_MOD()->RegisterRefController(static_cast<sal_uInt16>(ScValidationDlg::SLOTID), m_xDlg, pParent);
217 }
218 ~ScValidationRegisteredDlg()
219 {
220 m_xDlg->Close();
221 SC_MOD()->UnregisterRefController(static_cast<sal_uInt16>(ScValidationDlg::SLOTID), m_xDlg);
222 }
223 };
224 }
225
226 void ScCellShell::ExecuteDB( SfxRequest& rReq )
227 {
228 ScTabViewShell* pTabViewShell = GetViewData().GetViewShell();
229 sal_uInt16 nSlotId = rReq.GetSlot();
230 const SfxItemSet* pReqArgs = rReq.GetArgs();
231 ScModule* pScMod = SC_MOD();
232
233 pTabViewShell->HideListBox(); // Autofilter-DropDown-Listbox
234
235 if ( GetViewData().HasEditView( GetViewData().GetActivePart() ) )
236 {
237 pScMod->InputEnterHandler();
238 pTabViewShell->UpdateInputHandler();
239 }
240
241 switch ( nSlotId )
242 {
243 case SID_VIEW_DATA_SOURCE_BROWSER:
244 {
245 // check if database beamer is open
246
247 SfxViewFrame* pViewFrame = pTabViewShell->GetViewFrame();
248 bool bWasOpen = false;
249 {
250 uno::Reference<frame::XFrame> xFrame = pViewFrame->GetFrame().GetFrameInterface();
251 uno::Reference<frame::XFrame> xBeamerFrame = xFrame->findFrame(
252 "_beamer",
253 frame::FrameSearchFlag::CHILDREN);
254 if ( xBeamerFrame.is() )
255 bWasOpen = true;
256 }
257
258 if ( bWasOpen )
259 {
260 // close database beamer: just forward to SfxViewFrame
261
262 pViewFrame->ExecuteSlot( rReq );
263 }
264 else
265 {
266 // show database beamer: SfxViewFrame call must be synchronous
267
268 pViewFrame->ExecuteSlot( rReq, false ); // false = synchronous
269
270 // select current database in database beamer
271
272 ScImportParam aImportParam;
273 ScDBData* pDBData = pTabViewShell->GetDBData(true,SC_DB_OLD); // don't create if none found
274 if (pDBData)
275 pDBData->GetImportParam( aImportParam );
276
277 ScDBDocFunc::ShowInBeamer( aImportParam, pTabViewShell->GetViewFrame() );
278 }
279 rReq.Done(); // needed because it's a toggle slot
280 }
281 break;
282
283 case SID_REIMPORT_DATA:
284 {
285 bool bOk = false;
286 ScDBData* pDBData = pTabViewShell->GetDBData(true,SC_DB_OLD);
287 if (pDBData)
288 {
289 ScImportParam aImportParam;
290 pDBData->GetImportParam( aImportParam );
291 if (aImportParam.bImport && !pDBData->HasImportSelection())
292 {
293 pTabViewShell->ImportData( aImportParam );
294 pDBData->SetImportParam( aImportParam ); //! Undo ??
295 bOk = true;
296 }
297 }
298
299 if (!bOk && ! rReq.IsAPI() )
300 pTabViewShell->ErrorMessage(STR_REIMPORT_EMPTY);
301
302 if( bOk )
303 rReq.Done();
304 }
305 break;
306
307 case SID_REFRESH_DBAREA:
308 {
309 ScDBData* pDBData = pTabViewShell->GetDBData(true,SC_DB_OLD);
310 if (pDBData)
311 {
312 // repeat import like SID_REIMPORT_DATA
313
314 bool bContinue = true;
315 ScImportParam aImportParam;
316 pDBData->GetImportParam( aImportParam );
317 if (aImportParam.bImport && !pDBData->HasImportSelection())
318 {
319 bContinue = pTabViewShell->ImportData( aImportParam );
320 pDBData->SetImportParam( aImportParam ); //! Undo ??
321
322 // mark (size may have been changed)
323 ScRange aNewRange;
324 pDBData->GetArea(aNewRange);
325 pTabViewShell->MarkRange(aNewRange);
326 }
327
328 if ( bContinue ) // fail at import -> break
329 {
330 // internal operations, when any stored
331
332 if ( pDBData->HasQueryParam() || pDBData->HasSortParam() ||
333 pDBData->HasSubTotalParam() )
334 pTabViewShell->RepeatDB();
335
336 // pivot tables that have the range as data source
337
338 ScRange aRange;
339 pDBData->GetArea(aRange);
340 GetViewData().GetDocShell()->RefreshPivotTables(aRange);
341 }
342 }
343 rReq.Done();
344 }
345 break;
346
347 case SID_SBA_BRW_INSERT:
348 {
349 OSL_FAIL( "Deprecated Slot" );
350 }
351 break;
352
353 case SID_DATA_FORM:
354 {
355 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
356
357 ScopedVclPtr<AbstractScDataFormDlg> pDlg(pFact->CreateScDataFormDlg(
358 pTabViewShell->GetFrameWeld(), pTabViewShell));
359
360 pDlg->Execute();
361
362 rReq.Done();
363 }
364 break;
365
366 case SID_SUBTOTALS:
367 ExecuteSubtotals(rReq);
368 break;
369
370 case SID_SORT_DESCENDING:
371 case SID_SORT_ASCENDING:
372 {
373 //#i60401 ux-ctest: Calc does not support all users' strategies regarding sorting data
374 //the patch comes from maoyg
375 ScSortParam aSortParam;
376 ScDBData* pDBData = pTabViewShell->GetDBData();
377 ScViewData& rData = GetViewData();
378
379 pDBData->GetSortParam( aSortParam );
380
381 if( lcl_GetSortParam( rData, aSortParam ) )
382 {
383 SCCOL nCol = GetViewData().GetCurX();
384 SCCOL nTab = GetViewData().GetTabNo();
385 ScDocument& rDoc = GetViewData().GetDocument();
386
387 pDBData->GetSortParam( aSortParam );
388 bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, nTab );
389
390 if( nCol < aSortParam.nCol1 )
391 nCol = aSortParam.nCol1;
392 else if( nCol > aSortParam.nCol2 )
393 nCol = aSortParam.nCol2;
394
395 aSortParam.bHasHeader = bHasHeader;
396 aSortParam.bByRow = true;
397 aSortParam.bCaseSens = false;
398 aSortParam.bNaturalSort = false;
399 aSortParam.aDataAreaExtras.mbCellNotes = false;
400 aSortParam.aDataAreaExtras.mbCellDrawObjects = true;
401 aSortParam.aDataAreaExtras.mbCellFormats = true;
402 aSortParam.bInplace = true;
403 aSortParam.maKeyState[0].bDoSort = true;
404 aSortParam.maKeyState[0].nField = nCol;
405 aSortParam.maKeyState[0].bAscending = ( nSlotId == SID_SORT_ASCENDING );
406
407 for ( sal_uInt16 i=1; i<aSortParam.GetSortKeyCount(); i++ )
408 aSortParam.maKeyState[i].bDoSort = false;
409
410 pTabViewShell->UISort( aSortParam ); // subtotal when needed new
411
412 rReq.Done();
413 }
414 }
415 break;
416
417 case SID_SORT:
418 {
419 const SfxItemSet* pArgs = rReq.GetArgs();
420
421 //#i60401 ux-ctest: Calc does not support all users' strategies regarding sorting data
422 //the patch comes from maoyg
423
424 if ( pArgs ) // Basic
425 {
426 ScSortParam aSortParam;
427 ScDBData* pDBData = pTabViewShell->GetDBData();
428 ScViewData& rData = GetViewData();
429
430 pDBData->GetSortParam( aSortParam );
431
432 if( lcl_GetSortParam( rData, aSortParam ) )
433 {
434 ScDocument& rDoc = GetViewData().GetDocument();
435
436 pDBData->GetSortParam( aSortParam );
437 bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, rData.GetTabNo() );
438 if( bHasHeader )
439 aSortParam.bHasHeader = bHasHeader;
440
441 aSortParam.bInplace = true; // from Basic always
442
443 const SfxPoolItem* pItem;
444 if ( pArgs->GetItemState( SID_SORT_BYROW, true, &pItem ) == SfxItemState::SET )
445 aSortParam.bByRow = static_cast<const SfxBoolItem*>(pItem)->GetValue();
446 if ( pArgs->GetItemState( SID_SORT_HASHEADER, true, &pItem ) == SfxItemState::SET )
447 aSortParam.bHasHeader = static_cast<const SfxBoolItem*>(pItem)->GetValue();
448 if ( pArgs->GetItemState( SID_SORT_CASESENS, true, &pItem ) == SfxItemState::SET )
449 aSortParam.bCaseSens = static_cast<const SfxBoolItem*>(pItem)->GetValue();
450 if ( pArgs->GetItemState( SID_SORT_NATURALSORT, true, &pItem ) == SfxItemState::SET )
451 aSortParam.bNaturalSort = static_cast<const SfxBoolItem*>(pItem)->GetValue();
452 if ( pArgs->GetItemState( SID_SORT_INCCOMMENTS, true, &pItem ) == SfxItemState::SET )
453 aSortParam.aDataAreaExtras.mbCellNotes = static_cast<const SfxBoolItem*>(pItem)->GetValue();
454 if ( pArgs->GetItemState( SID_SORT_INCIMAGES, true, &pItem ) == SfxItemState::SET )
455 aSortParam.aDataAreaExtras.mbCellDrawObjects = static_cast<const SfxBoolItem*>(pItem)->GetValue();
456 if ( pArgs->GetItemState( SID_SORT_ATTRIBS, true, &pItem ) == SfxItemState::SET )
457 aSortParam.aDataAreaExtras.mbCellFormats = static_cast<const SfxBoolItem*>(pItem)->GetValue();
458 if ( pArgs->GetItemState( SID_SORT_USERDEF, true, &pItem ) == SfxItemState::SET )
459 {
460 sal_uInt16 nUserIndex = static_cast<const SfxUInt16Item*>(pItem)->GetValue();
461 aSortParam.bUserDef = ( nUserIndex != 0 );
462 if ( nUserIndex )
463 aSortParam.nUserIndex = nUserIndex - 1; // Basic: 1-based
464 }
465
466 SCCOLROW nField0 = 0;
467 if ( pArgs->GetItemState( FN_PARAM_1, true, &pItem ) == SfxItemState::SET )
468 nField0 = static_cast<const SfxInt32Item*>(pItem)->GetValue();
469 aSortParam.maKeyState[0].bDoSort = ( nField0 != 0 );
470 aSortParam.maKeyState[0].nField = nField0 > 0 ? (nField0-1) : 0;
471 if ( pArgs->GetItemState( FN_PARAM_2, true, &pItem ) == SfxItemState::SET )
472 aSortParam.maKeyState[0].bAscending = static_cast<const SfxBoolItem*>(pItem)->GetValue();
473 SCCOLROW nField1 = 0;
474 if ( pArgs->GetItemState( FN_PARAM_3, true, &pItem ) == SfxItemState::SET )
475 nField1 = static_cast<const SfxInt32Item*>(pItem)->GetValue();
476 aSortParam.maKeyState[1].bDoSort = ( nField1 != 0 );
477 aSortParam.maKeyState[1].nField = nField1 > 0 ? (nField1-1) : 0;
478 if ( pArgs->GetItemState( FN_PARAM_4, true, &pItem ) == SfxItemState::SET )
479 aSortParam.maKeyState[1].bAscending = static_cast<const SfxBoolItem*>(pItem)->GetValue();
480 SCCOLROW nField2 = 0;
481 if ( pArgs->GetItemState( FN_PARAM_5, true, &pItem ) == SfxItemState::SET )
482 nField2 = static_cast<const SfxInt32Item*>(pItem)->GetValue();
483 aSortParam.maKeyState[2].bDoSort = ( nField2 != 0 );
484 aSortParam.maKeyState[2].nField = nField2 > 0 ? (nField2-1) : 0;
485 if ( pArgs->GetItemState( FN_PARAM_6, true, &pItem ) == SfxItemState::SET )
486 aSortParam.maKeyState[2].bAscending = static_cast<const SfxBoolItem*>(pItem)->GetValue();
487
488 // subtotal when needed new
489 pTabViewShell->UISort( aSortParam );
490 rReq.Done();
491 }
492 }
493 else
494 {
495 ScSortParam aSortParam;
496 ScDBData* pDBData = pTabViewShell->GetDBData();
497 ScViewData& rData = GetViewData();
498
499 pDBData->GetSortParam( aSortParam );
500
501 if( lcl_GetSortParam( rData, aSortParam ) )
502 {
503 ScDocument& rDoc = GetViewData().GetDocument();
504 SfxItemSetFixed<SCITEM_SORTDATA, SCITEM_SORTDATA> aArgSet( GetPool() );
505
506 pDBData->GetSortParam( aSortParam );
507 bool bHasHeader = rDoc.HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, rData.GetTabNo() );
508 if( bHasHeader )
509 aSortParam.bHasHeader = bHasHeader;
510
511 aArgSet.Put( ScSortItem( SCITEM_SORTDATA, &GetViewData(), &aSortParam ) );
512
513 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
514 std::shared_ptr<ScAsyncTabController> pDlg(pFact->CreateScSortDlg(pTabViewShell->GetFrameWeld(), &aArgSet));
515 pDlg->SetCurPageId("criteria"); // 1=sort field tab 2=sort options tab
516
517 VclAbstractDialog::AsyncContext aContext;
518 aContext.maEndDialogFn = [pDlg, &rData, pTabViewShell](sal_Int32 nResult)
519 {
520 if ( nResult == RET_OK )
521 {
522 const SfxItemSet* pOutSet = pDlg->GetOutputItemSet();
523 const ScSortParam& rOutParam = static_cast<const ScSortItem&>(
524 pOutSet->Get( SCITEM_SORTDATA )).GetSortData();
525
526 // subtotal when needed new
527
528 pTabViewShell->UISort( rOutParam );
529
530 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
531 if (pViewFrm)
532 {
533 SfxRequest aRequest(pViewFrm, SID_SORT);
534
535 if ( rOutParam.bInplace )
536 {
537 aRequest.AppendItem( SfxBoolItem( SID_SORT_BYROW,
538 rOutParam.bByRow ) );
539 aRequest.AppendItem( SfxBoolItem( SID_SORT_HASHEADER,
540 rOutParam.bHasHeader ) );
541 aRequest.AppendItem( SfxBoolItem( SID_SORT_CASESENS,
542 rOutParam.bCaseSens ) );
543 aRequest.AppendItem( SfxBoolItem( SID_SORT_NATURALSORT,
544 rOutParam.bNaturalSort ) );
545 aRequest.AppendItem( SfxBoolItem( SID_SORT_INCCOMMENTS,
546 rOutParam.aDataAreaExtras.mbCellNotes ) );
547 aRequest.AppendItem( SfxBoolItem( SID_SORT_INCIMAGES,
548 rOutParam.aDataAreaExtras.mbCellDrawObjects ) );
549 aRequest.AppendItem( SfxBoolItem( SID_SORT_ATTRIBS,
550 rOutParam.aDataAreaExtras.mbCellFormats ) );
551 sal_uInt16 nUser = rOutParam.bUserDef ? ( rOutParam.nUserIndex + 1 ) : 0;
552 aRequest.AppendItem( SfxUInt16Item( SID_SORT_USERDEF, nUser ) );
553 if ( rOutParam.maKeyState[0].bDoSort )
554 {
555 aRequest.AppendItem( SfxInt32Item( FN_PARAM_1,
556 rOutParam.maKeyState[0].nField + 1 ) );
557 aRequest.AppendItem( SfxBoolItem( FN_PARAM_2,
558 rOutParam.maKeyState[0].bAscending ) );
559 }
560 if ( rOutParam.maKeyState[1].bDoSort )
561 {
562 aRequest.AppendItem( SfxInt32Item( FN_PARAM_3,
563 rOutParam.maKeyState[1].nField + 1 ) );
564 aRequest.AppendItem( SfxBoolItem( FN_PARAM_4,
565 rOutParam.maKeyState[1].bAscending ) );
566 }
567 if ( rOutParam.maKeyState[2].bDoSort )
568 {
569 aRequest.AppendItem( SfxInt32Item( FN_PARAM_5,
570 rOutParam.maKeyState[2].nField + 1 ) );
571 aRequest.AppendItem( SfxBoolItem( FN_PARAM_6,
572 rOutParam.maKeyState[2].bAscending ) );
573 }
574 }
575
576 aRequest.Done();
577 }
578 }
579 else
580 {
581 rData.GetDocShell()->CancelAutoDBRange();
582 }
583 };
584
585 pDlg->StartExecuteAsync(aContext);
586 }
587 }
588 }
589 break;
590
591 case SID_FILTER:
592 {
593 const SfxItemSet* pArgs = rReq.GetArgs();
594 if ( pArgs )
595 {
596 OSL_FAIL("SID_FILTER with arguments?");
597 pTabViewShell->Query( static_cast<const ScQueryItem&>(
598 pArgs->Get( SCITEM_QUERYDATA )).GetQueryData(), nullptr, true );
599 rReq.Done();
600 }
601 else
602 {
603 sal_uInt16 nId = ScFilterDlgWrapper::GetChildWindowId();
604 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
605 SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
606
607 pScMod->SetRefDialog( nId, pWnd == nullptr );
608 }
609 }
610 break;
611
612 case SID_SPECIAL_FILTER:
613 {
614 const SfxItemSet* pArgs = rReq.GetArgs();
615 if ( pArgs )
616 {
617 OSL_FAIL("SID_SPECIAL_FILTER with arguments?");
618 pTabViewShell->Query( static_cast<const ScQueryItem&>(
619 pArgs->Get( SCITEM_QUERYDATA )).GetQueryData(), nullptr, true );
620 rReq.Done();
621 }
622 else
623 {
624 sal_uInt16 nId = ScSpecialFilterDlgWrapper::GetChildWindowId();
625 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
626 SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
627
628 pScMod->SetRefDialog( nId, pWnd == nullptr );
629 }
630 }
631 break;
632
633 case FID_FILTER_OK:
634 {
635 const SfxPoolItem* pItem;
636 if ( pReqArgs && SfxItemState::SET ==
637 pReqArgs->GetItemState( SCITEM_QUERYDATA, true, &pItem ) )
638 {
639 const ScQueryItem& rQueryItem = static_cast<const ScQueryItem&>(*pItem);
640
641 SCTAB nCurTab = GetViewData().GetTabNo();
642 SCTAB nRefTab = GetViewData().GetRefTabNo();
643
644 // If RefInput switched to a different sheet from the data sheet,
645 // switch back:
646
647 if ( nCurTab != nRefTab )
648 {
649 pTabViewShell->SetTabNo( nRefTab );
650 pTabViewShell->PaintExtras();
651 }
652
653 ScRange aAdvSource;
654 if (rQueryItem.GetAdvancedQuerySource(aAdvSource))
655 pTabViewShell->Query( rQueryItem.GetQueryData(), &aAdvSource, true );
656 else
657 pTabViewShell->Query( rQueryItem.GetQueryData(), nullptr, true );
658 rReq.Done( *pReqArgs );
659 }
660 }
661 break;
662
663 case SID_UNFILTER:
664 {
665 ScQueryParam aParam;
666 ScDBData* pDBData = pTabViewShell->GetDBData();
667
668 pDBData->GetQueryParam( aParam );
669 SCSIZE nEC = aParam.GetEntryCount();
670 for (SCSIZE i=0; i<nEC; i++)
671 aParam.GetEntry(i).bDoQuery = false;
672 aParam.bDuplicate = true;
673 pTabViewShell->Query( aParam, nullptr, true );
674 rReq.Done();
675 }
676 break;
677
678 case SID_AUTO_FILTER:
679 pTabViewShell->ToggleAutoFilter();
680 rReq.Done();
681 break;
682
683 case SID_AUTOFILTER_HIDE:
684 pTabViewShell->HideAutoFilter();
685 rReq.Done();
686 break;
687
688 case SID_PIVOT_TABLE:
689 {
690 const SfxPoolItem* pItem;
691 if ( pReqArgs && SfxItemState::SET ==
692 pReqArgs->GetItemState( SCITEM_PIVOTDATA, true, &pItem ) )
693 {
694 SCTAB nCurTab = GetViewData().GetTabNo();
695 SCTAB nRefTab = GetViewData().GetRefTabNo();
696
697 // If RefInput switched to a different sheet from the data sheet,
698 // switch back:
699
700 if ( nCurTab != nRefTab )
701 {
702 pTabViewShell->SetTabNo( nRefTab );
703 pTabViewShell->PaintExtras();
704 }
705
706 const ScDPObject* pDPObject = pTabViewShell->GetDialogDPObject();
707 if ( pDPObject )
708 {
709 const ScPivotItem* pPItem = static_cast<const ScPivotItem*>(pItem);
710 bool bSuccess = pTabViewShell->MakePivotTable(
711 pPItem->GetData(), pPItem->GetDestRange(), pPItem->IsNewSheet(), *pDPObject );
712 SfxBoolItem aRet(0, bSuccess);
713 rReq.SetReturnValue(aRet);
714 }
715 rReq.Done();
716 }
717 #if HAVE_FEATURE_SCRIPTING
718 else if (rReq.IsAPI())
719 SbxBase::SetError(ERRCODE_BASIC_BAD_PARAMETER);
720 #endif
721 }
722 break;
723
724 case SID_OPENDLG_PIVOTTABLE:
725 ExecuteDataPilotDialog();
726 break;
727 case SID_DEFINE_DBNAME:
728 {
729
730 sal_uInt16 nId = ScDbNameDlgWrapper::GetChildWindowId();
731 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
732 SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
733
734 pScMod->SetRefDialog( nId, pWnd == nullptr );
735
736 }
737 break;
738
739 case SID_SELECT_DB:
740 {
741 if ( pReqArgs )
742 {
743 const SfxStringItem& rItem
744 = static_cast<const SfxStringItem&>(pReqArgs->Get(SID_SELECT_DB));
745 pTabViewShell->GotoDBArea(rItem.GetValue());
746 rReq.Done();
747 }
748 else
749 {
750 ScDocument& rDoc = GetViewData().GetDocument();
751 ScDBCollection* pDBCol = rDoc.GetDBCollection();
752
753 if ( pDBCol )
754 {
755 std::vector<OUString> aList;
756 const ScDBCollection::NamedDBs& rDBs = pDBCol->getNamedDBs();
757 for (const auto& rxDB : rDBs)
758 aList.push_back(rxDB->GetName());
759
760 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
761
762 ScopedVclPtr<AbstractScSelEntryDlg> pDlg(pFact->CreateScSelEntryDlg(pTabViewShell->GetFrameWeld(), aList));
763 if ( pDlg->Execute() == RET_OK )
764 {
765 OUString aName = pDlg->GetSelectedEntry();
766 pTabViewShell->GotoDBArea( aName );
767 rReq.AppendItem( SfxStringItem( SID_SELECT_DB, aName ) );
768 rReq.Done();
769 }
770 }
771 }
772 }
773 break;
774 case SID_DATA_STREAMS:
775 {
776 sc::DataStreamDlg aDialog(GetViewData().GetDocShell(), pTabViewShell->GetFrameWeld());
777 ScDocument& rDoc = GetViewData().GetDocument();
778 sc::DocumentLinkManager& rMgr = rDoc.GetDocLinkManager();
779 sc::DataStream* pStrm = rMgr.getDataStream();
780 if (pStrm)
781 aDialog.Init(*pStrm);
782
783 if (aDialog.run() == RET_OK)
784 aDialog.StartStream();
785 }
786 break;
787 case SID_DATA_STREAMS_PLAY:
788 {
789 ScDocument& rDoc = GetViewData().GetDocument();
790 sc::DocumentLinkManager& rMgr = rDoc.GetDocLinkManager();
791 sc::DataStream* pStrm = rMgr.getDataStream();
792 if (pStrm)
793 pStrm->StartImport();
794 }
795 break;
796 case SID_DATA_STREAMS_STOP:
797 {
798 ScDocument& rDoc = GetViewData().GetDocument();
799 sc::DocumentLinkManager& rMgr = rDoc.GetDocLinkManager();
800 sc::DataStream* pStrm = rMgr.getDataStream();
801 if (pStrm)
802 pStrm->StopImport();
803 }
804 break;
805 case SID_DATA_PROVIDER:
806 {
807 auto xDoc = o3tl::make_shared<ScDocument>();
808 xDoc->InsertTab(0, "test");
809 ScDocument& rDoc = GetViewData().GetDocument();
810 ScDataProviderDlg aDialog(pTabViewShell->GetDialogParent(), xDoc, &rDoc);
811 if (aDialog.run() == RET_OK)
812 {
813 aDialog.import(rDoc);
814 }
815 }
816 break;
817 case SID_DATA_PROVIDER_REFRESH:
818 {
819 ScDocument& rDoc = GetViewData().GetDocument();
820 auto& rDataMapper = rDoc.GetExternalDataMapper();
821 for (auto& rDataSource : rDataMapper.getDataSources())
822 {
823 rDataSource.refresh(&rDoc, false);
824 }
825 }
826 break;
827 case SID_MANAGE_XML_SOURCE:
828 ExecuteXMLSourceDialog();
829 break;
830 case FID_VALIDATION:
831 case FID_CURRENTVALIDATION:
832 {
833 const SfxPoolItem* pItem;
834 const SfxItemSet* pArgs = rReq.GetArgs();
835 if ( pArgs )
836 {
837 OSL_FAIL("later...");
838 }
839 else
840 {
841 SfxItemSet aArgSet( GetPool(), ScTPValidationValue::GetRanges() );
842 ScValidationMode eMode = SC_VALID_ANY;
843 ScConditionMode eOper = ScConditionMode::Equal;
844 OUString aExpr1, aExpr2;
845 bool bBlank = true;
846 sal_Int16 nListType = css::sheet::TableValidationVisibility::UNSORTED;
847 bool bShowHelp = false;
848 OUString aHelpTitle, aHelpText;
849 bool bShowError = false;
850 ScValidErrorStyle eErrStyle = SC_VALERR_STOP;
851 OUString aErrTitle, aErrText;
852
853 ScDocument& rDoc = GetViewData().GetDocument();
854 SCCOL nCurX = GetViewData().GetCurX();
855 SCROW nCurY = GetViewData().GetCurY();
856 SCTAB nTab = GetViewData().GetTabNo();
857 ScAddress aCursorPos( nCurX, nCurY, nTab );
858 sal_uLong nIndex = rDoc.GetAttr(
859 nCurX, nCurY, nTab, ATTR_VALIDDATA )->GetValue();
860 if ( nIndex )
861 {
862 const ScValidationData* pOldData = rDoc.GetValidationEntry( nIndex );
863 if ( pOldData )
864 {
865 eMode = pOldData->GetDataMode();
866 eOper = pOldData->GetOperation();
867 sal_uInt32 nNumFmt = 0;
868 if ( eMode == SC_VALID_DATE || eMode == SC_VALID_TIME )
869 {
870 SvNumFormatType nType = ( eMode == SC_VALID_DATE ) ? SvNumFormatType::DATE
871 : SvNumFormatType::TIME;
872 nNumFmt = rDoc.GetFormatTable()->GetStandardFormat(
873 nType, ScGlobal::eLnge );
874 }
875 aExpr1 = pOldData->GetExpression( aCursorPos, 0, nNumFmt );
876 aExpr2 = pOldData->GetExpression( aCursorPos, 1, nNumFmt );
877 bBlank = pOldData->IsIgnoreBlank();
878 nListType = pOldData->GetListType();
879
880 bShowHelp = pOldData->GetInput( aHelpTitle, aHelpText );
881 bShowError = pOldData->GetErrMsg( aErrTitle, aErrText, eErrStyle );
882
883 aArgSet.Put( SfxUInt16Item( FID_VALID_MODE, sal::static_int_cast<sal_uInt16>(eMode) ) );
884 aArgSet.Put( SfxUInt16Item( FID_VALID_CONDMODE, sal::static_int_cast<sal_uInt16>(eOper) ) );
885 aArgSet.Put( SfxStringItem( FID_VALID_VALUE1, aExpr1 ) );
886 aArgSet.Put( SfxStringItem( FID_VALID_VALUE2, aExpr2 ) );
887 aArgSet.Put( SfxBoolItem( FID_VALID_BLANK, bBlank ) );
888 aArgSet.Put( SfxInt16Item( FID_VALID_LISTTYPE, nListType ) );
889 aArgSet.Put( SfxBoolItem( FID_VALID_SHOWHELP, bShowHelp ) );
890 aArgSet.Put( SfxStringItem( FID_VALID_HELPTITLE, aHelpTitle ) );
891 aArgSet.Put( SfxStringItem( FID_VALID_HELPTEXT, aHelpText ) );
892 aArgSet.Put( SfxBoolItem( FID_VALID_SHOWERR, bShowError ) );
893 aArgSet.Put( SfxUInt16Item( FID_VALID_ERRSTYLE, sal::static_int_cast<sal_uInt16>(eErrStyle) ) );
894 aArgSet.Put( SfxStringItem( FID_VALID_ERRTITLE, aErrTitle ) );
895 aArgSet.Put( SfxStringItem( FID_VALID_ERRTEXT, aErrText ) );
896 }
897 }
898
899 // cell range picker
900 vcl::Window* pWin = GetViewData().GetActiveWin();
901 weld::Window* pParentWin = pWin ? pWin->GetFrameWeld() : nullptr;
902 auto xDlg = std::make_shared<ScValidationDlg>(pParentWin, &aArgSet, pTabViewShell);
903 ScValidationRegisteredDlg aRegisterThatDlgExists(pParentWin, xDlg);
904
905 short nResult = xDlg->run();
906 if ( nResult == RET_OK )
907 {
908 const SfxItemSet* pOutSet = xDlg->GetOutputItemSet();
909
910 if ( pOutSet->GetItemState( FID_VALID_MODE, true, &pItem ) == SfxItemState::SET )
911 eMode = static_cast<ScValidationMode>(static_cast<const SfxUInt16Item*>(pItem)->GetValue());
912 if ( pOutSet->GetItemState( FID_VALID_CONDMODE, true, &pItem ) == SfxItemState::SET )
913 eOper = static_cast<ScConditionMode>(static_cast<const SfxUInt16Item*>(pItem)->GetValue());
914 if ( pOutSet->GetItemState( FID_VALID_VALUE1, true, &pItem ) == SfxItemState::SET )
915 {
916 OUString aTemp1 = static_cast<const SfxStringItem*>(pItem)->GetValue();
917 if (eMode == SC_VALID_DATE || eMode == SC_VALID_TIME)
918 {
919 sal_uInt32 nNumIndex = 0;
920 double nVal;
921 if (rDoc.GetFormatTable()->IsNumberFormat(aTemp1, nNumIndex, nVal))
922 aExpr1 = ::rtl::math::doubleToUString( nVal,
923 rtl_math_StringFormat_Automatic, rtl_math_DecimalPlaces_Max,
924 ScGlobal::getLocaleData().getNumDecimalSep()[0], true);
925 else
926 aExpr1 = aTemp1;
927 }
928 else
929 aExpr1 = aTemp1;
930 }
931 if ( pOutSet->GetItemState( FID_VALID_VALUE2, true, &pItem ) == SfxItemState::SET )
932 {
933 OUString aTemp2 = static_cast<const SfxStringItem*>(pItem)->GetValue();
934 if (eMode == SC_VALID_DATE || eMode == SC_VALID_TIME)
935 {
936 sal_uInt32 nNumIndex = 0;
937 double nVal;
938 if (rDoc.GetFormatTable()->IsNumberFormat(aTemp2, nNumIndex, nVal))
939 aExpr2 = ::rtl::math::doubleToUString( nVal,
940 rtl_math_StringFormat_Automatic, rtl_math_DecimalPlaces_Max,
941 ScGlobal::getLocaleData().getNumDecimalSep()[0], true);
942 else
943 aExpr2 = aTemp2;
944 if ( eMode == SC_VALID_TIME ) {
945 sal_Int32 wraparound = aExpr1.compareTo(aExpr2);
946 if (wraparound > 0) {
947 if (eOper == ScConditionMode::Between) {
948 eOper = ScConditionMode::NotBetween;
949 OUString tmp = aExpr1;
950 aExpr1 = aExpr2;
951 aExpr2 = tmp;
952 }
953 else if (eOper == ScConditionMode::NotBetween) {
954 eOper = ScConditionMode::Between;
955 OUString tmp = aExpr1;
956 aExpr1 = aExpr2;
957 aExpr2 = tmp;
958 }
959 }
960 }
961 }
962 else
963 aExpr2 = aTemp2;
964 }
965 if ( pOutSet->GetItemState( FID_VALID_BLANK, true, &pItem ) == SfxItemState::SET )
966 bBlank = static_cast<const SfxBoolItem*>(pItem)->GetValue();
967 if ( pOutSet->GetItemState( FID_VALID_LISTTYPE, true, &pItem ) == SfxItemState::SET )
968 nListType = static_cast<const SfxInt16Item*>(pItem)->GetValue();
969
970 if ( pOutSet->GetItemState( FID_VALID_SHOWHELP, true, &pItem ) == SfxItemState::SET )
971 bShowHelp = static_cast<const SfxBoolItem*>(pItem)->GetValue();
972 if ( pOutSet->GetItemState( FID_VALID_HELPTITLE, true, &pItem ) == SfxItemState::SET )
973 aHelpTitle = static_cast<const SfxStringItem*>(pItem)->GetValue();
974 if ( pOutSet->GetItemState( FID_VALID_HELPTEXT, true, &pItem ) == SfxItemState::SET )
975 aHelpText = static_cast<const SfxStringItem*>(pItem)->GetValue();
976
977 if ( pOutSet->GetItemState( FID_VALID_SHOWERR, true, &pItem ) == SfxItemState::SET )
978 bShowError = static_cast<const SfxBoolItem*>(pItem)->GetValue();
979 if ( pOutSet->GetItemState( FID_VALID_ERRSTYLE, true, &pItem ) == SfxItemState::SET )
980 eErrStyle = static_cast<ScValidErrorStyle>(static_cast<const SfxUInt16Item*>(pItem)->GetValue());
981 if ( pOutSet->GetItemState( FID_VALID_ERRTITLE, true, &pItem ) == SfxItemState::SET )
982 aErrTitle = static_cast<const SfxStringItem*>(pItem)->GetValue();
983 if ( pOutSet->GetItemState( FID_VALID_ERRTEXT, true, &pItem ) == SfxItemState::SET )
984 aErrText = static_cast<const SfxStringItem*>(pItem)->GetValue();
985
986 ScValidationData aData( eMode, eOper, aExpr1, aExpr2, rDoc, aCursorPos );
987 aData.SetIgnoreBlank( bBlank );
988 aData.SetListType( nListType );
989
990 aData.SetInput(aHelpTitle, aHelpText); // sets bShowInput to TRUE
991 if (!bShowHelp)
992 aData.ResetInput(); // reset only bShowInput
993
994 aData.SetError(aErrTitle, aErrText, eErrStyle); // sets bShowError to TRUE
995 if (!bShowError)
996 aData.ResetError(); // reset only bShowError
997
998 pTabViewShell->SetValidation( aData );
999 pTabViewShell->TestHintWindow();
1000 rReq.Done( *pOutSet );
1001 }
1002 }
1003 }
1004 break;
1005
1006 case SID_TEXT_TO_COLUMNS:
1007 {
1008 ScViewData& rData = GetViewData();
1009 ScRange aRange;
1010
1011 if ( lcl_GetTextToColumnsRange( rData, aRange, false ) )
1012 {
1013 ScDocument& rDoc = rData.GetDocument();
1014
1015 ScImportExport aExport( rDoc, aRange );
1016 aExport.SetExportTextOptions( ScExportTextOptions( ScExportTextOptions::None, 0, false ) );
1017
1018 // #i87703# text to columns fails with tab separator
1019 aExport.SetDelimiter( u'\0' );
1020
1021 SvMemoryStream aStream;
1022 aStream.SetStreamCharSet( RTL_TEXTENCODING_UNICODE );
1023 ScImportExport::SetNoEndianSwap( aStream );
1024 aExport.ExportStream( aStream, OUString(), SotClipboardFormatId::STRING );
1025
1026 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
1027 ScopedVclPtr<AbstractScImportAsciiDlg> pDlg(pFact->CreateScImportAsciiDlg(
1028 pTabViewShell->GetFrameWeld(), OUString(), &aStream, SC_TEXTTOCOLUMNS));
1029
1030 if ( pDlg->Execute() == RET_OK )
1031 {
1032 ScDocShell* pDocSh = rData.GetDocShell();
1033 OSL_ENSURE( pDocSh, "ScCellShell::ExecuteDB: SID_TEXT_TO_COLUMNS - pDocSh is null!" );
1034
1035 OUString aUndo = ScResId( STR_UNDO_TEXTTOCOLUMNS );
1036 pDocSh->GetUndoManager()->EnterListAction( aUndo, aUndo, 0, rData.GetViewShell()->GetViewShellId() );
1037
1038 ScImportExport aImport( rDoc, aRange.aStart );
1039 ScAsciiOptions aOptions;
1040 pDlg->GetOptions( aOptions );
1041 pDlg->SaveParameters();
1042 aImport.SetExtOptions( aOptions );
1043 aImport.SetApi( false );
1044 aImport.SetImportBroadcast( true );
1045 aImport.SetOverwriting( true );
1046 aStream.Seek( 0 );
1047 aImport.ImportStream( aStream, OUString(), SotClipboardFormatId::STRING );
1048
1049 pDocSh->GetUndoManager()->LeaveListAction();
1050 }
1051 }
1052 }
1053 break;
1054 }
1055 }
1056
1057 void ScCellShell::GetDBState( SfxItemSet& rSet )
1058 {
1059 ScTabViewShell* pTabViewShell = GetViewData().GetViewShell();
1060 ScViewData& rData = GetViewData();
1061 ScDocShell* pDocSh = rData.GetDocShell();
1062 ScDocument& rDoc = pDocSh->GetDocument();
1063 SCCOL nPosX = rData.GetCurX();
1064 SCROW nPosY = rData.GetCurY();
1065 SCTAB nTab = rData.GetTabNo();
1066
1067 bool bAutoFilter = false;
1068 bool bAutoFilterTested = false;
1069
1070 SfxWhichIter aIter(rSet);
1071 sal_uInt16 nWhich = aIter.FirstWhich();
1072 while (nWhich)
1073 {
1074 switch (nWhich)
1075 {
1076 case SID_REFRESH_DBAREA:
1077 {
1078 // imported data without selection
1079 // or filter,sort,subtotal (also without import)
1080 bool bOk = false;
1081 ScDBData* pDBData = pTabViewShell->GetDBData(false,SC_DB_OLD);
1082 if (pDBData && rDoc.GetChangeTrack() == nullptr)
1083 {
1084 if ( pDBData->HasImportParam() )
1085 bOk = !pDBData->HasImportSelection();
1086 else
1087 {
1088 bOk = pDBData->HasQueryParam() ||
1089 pDBData->HasSortParam() ||
1090 pDBData->HasSubTotalParam();
1091 }
1092 }
1093 if (!bOk)
1094 rSet.DisableItem( nWhich );
1095 }
1096 break;
1097
1098 case SID_FILTER:
1099 case SID_SPECIAL_FILTER:
1100 {
1101 ScRange aDummy;
1102 ScMarkType eMarkType = GetViewData().GetSimpleArea( aDummy);
1103 if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED)
1104 {
1105 rSet.DisableItem( nWhich );
1106 }
1107 }
1108 break;
1109
1110 //in case of Redlining and multiselection disable
1111 case SID_SORT_ASCENDING:
1112 case SID_SORT_DESCENDING:
1113 case SCITEM_SORTDATA:
1114 case SCITEM_SUBTDATA:
1115 case SID_OPENDLG_PIVOTTABLE:
1116 {
1117 //! move ReadOnly check to idl flags
1118
1119 if ( pDocSh->IsReadOnly() || rDoc.GetChangeTrack()!=nullptr ||
1120 GetViewData().IsMultiMarked() )
1121 {
1122 rSet.DisableItem( nWhich );
1123 }
1124 }
1125 break;
1126
1127 case SID_REIMPORT_DATA:
1128 {
1129 // only imported data without selection
1130 ScDBData* pDBData = pTabViewShell->GetDBData(false,SC_DB_OLD);
1131 if (!pDBData || !pDBData->HasImportParam() || pDBData->HasImportSelection() ||
1132 rDoc.GetChangeTrack()!=nullptr)
1133 {
1134 rSet.DisableItem( nWhich );
1135 }
1136 }
1137 break;
1138
1139 case SID_VIEW_DATA_SOURCE_BROWSER:
1140 {
1141 if (!SvtModuleOptions().IsModuleInstalled(SvtModuleOptions::EModule::DATABASE))
1142 rSet.Put(SfxVisibilityItem(nWhich, false));
1143 else
1144 // get state (BoolItem) from SfxViewFrame
1145 pTabViewShell->GetViewFrame()->GetSlotState( nWhich, nullptr, &rSet );
1146 }
1147 break;
1148 case SID_SBA_BRW_INSERT:
1149 {
1150 // SBA wants a sal_Bool-item, enabled
1151
1152 rSet.Put(SfxBoolItem(nWhich, true));
1153 }
1154 break;
1155
1156 case SID_AUTO_FILTER:
1157 case SID_AUTOFILTER_HIDE:
1158 {
1159 if (!bAutoFilterTested)
1160 {
1161 bAutoFilter = rDoc.HasAutoFilter( nPosX, nPosY, nTab );
1162 bAutoFilterTested = true;
1163 }
1164 if ( nWhich == SID_AUTO_FILTER )
1165 {
1166 ScRange aDummy;
1167 ScMarkType eMarkType = GetViewData().GetSimpleArea( aDummy);
1168 if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED)
1169 {
1170 rSet.DisableItem( nWhich );
1171 }
1172 else if (rDoc.GetDPAtBlock(aDummy))
1173 {
1174 rSet.DisableItem( nWhich );
1175 }
1176 else
1177 rSet.Put( SfxBoolItem( nWhich, bAutoFilter ) );
1178 }
1179 else
1180 if (!bAutoFilter)
1181 rSet.DisableItem( nWhich );
1182 }
1183 break;
1184
1185 case SID_UNFILTER:
1186 {
1187 SCCOL nStartCol, nEndCol;
1188 SCROW nStartRow, nEndRow;
1189 SCTAB nStartTab, nEndTab;
1190 bool bAnyQuery = false;
1191
1192 bool bSelected = (GetViewData().GetSimpleArea(
1193 nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nEndTab )
1194 == SC_MARK_SIMPLE);
1195
1196 if ( bSelected )
1197 {
1198 if (nStartCol==nEndCol && nStartRow==nEndRow)
1199 bSelected = false;
1200 }
1201 else
1202 {
1203 nStartCol = GetViewData().GetCurX();
1204 nStartRow = GetViewData().GetCurY();
1205 nStartTab = GetViewData().GetTabNo();
1206 }
1207
1208 ScDBData* pDBData = bSelected
1209 ? rDoc.GetDBAtArea( nStartTab, nStartCol, nStartRow, nEndCol, nEndRow )
1210 : rDoc.GetDBAtCursor( nStartCol, nStartRow, nStartTab, ScDBDataPortion::AREA );
1211
1212 if ( pDBData )
1213 {
1214 ScQueryParam aParam;
1215 pDBData->GetQueryParam( aParam );
1216 if ( aParam.GetEntry(0).bDoQuery )
1217 bAnyQuery = true;
1218 }
1219
1220 if ( !bAnyQuery )
1221 rSet.DisableItem( nWhich );
1222 }
1223 break;
1224
1225 case SID_DEFINE_DBNAME:
1226 {
1227 if ( pDocSh->IsDocShared() )
1228 {
1229 rSet.DisableItem( nWhich );
1230 }
1231 }
1232 break;
1233 case SID_DATA_PROVIDER:
1234 break;
1235 case SID_DATA_PROVIDER_REFRESH:
1236 {
1237 ScDocument& rViewDoc = GetViewData().GetDocument();
1238 auto& rDataMapper = rViewDoc.GetExternalDataMapper();
1239 if (rDataMapper.getDataSources().empty())
1240 rSet.DisableItem(nWhich);
1241 }
1242 break;
1243 case SID_DATA_STREAMS:
1244 case SID_DATA_STREAMS_PLAY:
1245 case SID_DATA_STREAMS_STOP:
1246 {
1247 if ( !officecfg::Office::Common::Misc::ExperimentalMode::get() )
1248 rSet.DisableItem( nWhich );
1249 }
1250 break;
1251 case SID_TEXT_TO_COLUMNS:
1252 {
1253 ScRange aRange;
1254 if ( !lcl_GetTextToColumnsRange( rData, aRange, true ) )
1255 {
1256 rSet.DisableItem( nWhich );
1257 }
1258 }
1259 break;
1260 case SID_MANAGE_XML_SOURCE:
1261 break;
1262 }
1263 nWhich = aIter.NextWhich();
1264 }
1265 }
1266
1267 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE