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