?  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 / cellsh.cxx
blobf18c6ceb30e5f5253cb5a1ccb02a30c87faf7f76
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 <scitems.hxx>
21
22 #include <svl/slstitm.hxx>
23 #include <svl/stritem.hxx>
24 #include <svl/whiter.hxx>
25 #include <svtools/cliplistener.hxx>
26 #include <svtools/insdlg.hxx>
27 #include <sot/formats.hxx>
28 #include <svx/hlnkitem.hxx>
29 #include <sfx2/bindings.hxx>
30 #include <sfx2/childwin.hxx>
31 #include <sfx2/objface.hxx>
32 #include <sfx2/request.hxx>
33 #include <sfx2/viewfrm.hxx>
34 #include <vcl/EnumContext.hxx>
35 #include <vcl/svapp.hxx>
36 #include <svx/clipfmtitem.hxx>
37 #include <svx/statusitem.hxx>
38
39 #include <cellsh.hxx>
40 #include <sc.hrc>
41 #include <docsh.hxx>
42 #include <attrib.hxx>
43 #include <tabvwsh.hxx>
44 #include <formulacell.hxx>
45 #include <scmod.hxx>
46 #include <globstr.hrc>
47 #include <scresid.hxx>
48 #include <transobj.hxx>
49 #include <drwtrans.hxx>
50 #include <scabstdlg.hxx>
51 #include <postit.hxx>
52 #include <cliputil.hxx>
53 #include <clipparam.hxx>
54 #include <markdata.hxx>
55 #include <gridwin.hxx>
56
57 #define ShellClass_ScCellShell
58 #define ShellClass_CellMovement
59 #include <scslots.hxx>
60
61
62 SFX_IMPL_INTERFACE(ScCellShell, ScFormatShell)
63
64 void ScCellShell::InitInterface_Impl()
65 {
66 GetStaticInterface()->RegisterObjectBar(SFX_OBJECTBAR_OBJECT,
67 SfxVisibilityFlags::Standard | SfxVisibilityFlags::Server,
68 ToolbarId::Objectbar_Format);
69
70 GetStaticInterface()->RegisterPopupMenu(u"cell"_ustr);
71 }
72
73 ScCellShell::ScCellShell(ScViewData& rData, const VclPtr<vcl::Window>& frameWin) :
74 ScFormatShell(rData),
75 pImpl( new CellShell_Impl() ),
76 bPastePossible(false),
77 pFrameWin(frameWin)
78 {
79 SetName(u"Cell"_ustr);
80 SfxShell::SetContextName(vcl::EnumContext::GetContextName(vcl::EnumContext::Context::Cell));
81 }
82
83 ScCellShell::~ScCellShell()
84 {
85 if ( pImpl->m_xClipEvtLstnr.is() )
86 {
87 pImpl->m_xClipEvtLstnr->RemoveListener( GetViewData().GetActiveWin() );
88
89 // The listener may just now be waiting for the SolarMutex and call the link
90 // afterwards, in spite of RemoveListener. So the link has to be reset, too.
91 pImpl->m_xClipEvtLstnr->ClearCallbackLink();
92
93 pImpl->m_xClipEvtLstnr.clear();
94 }
95
96 pImpl->m_pLinkedDlg.disposeAndClear();
97 delete pImpl->m_pRequest;
98 }
99
100 void ScCellShell::GetBlockState( SfxItemSet& rSet )
101 {
102 ScTabViewShell* pTabViewShell = GetViewData().GetViewShell();
103 ScRange aMarkRange;
104 ScMarkType eMarkType = GetViewData().GetSimpleArea( aMarkRange );
105 bool bSimpleArea = (eMarkType == SC_MARK_SIMPLE);
106 bool bOnlyNotBecauseOfMatrix;
107 bool bEditable = pTabViewShell->SelectionEditable( &bOnlyNotBecauseOfMatrix );
108 ScDocument& rDoc = GetViewData().GetDocument();
109 ScDocShell* pDocShell = GetViewData().GetDocShell();
110 ScMarkData& rMark = GetViewData().GetMarkData();
111 SCCOL nCol1, nCol2;
112 SCROW nRow1, nRow2;
113 nCol1 = aMarkRange.aStart.Col();
114 nRow1 = aMarkRange.aStart.Row();
115 nCol2 = aMarkRange.aEnd.Col();
116 nRow2 = aMarkRange.aEnd.Row();
117 SCTAB nTab = GetViewData().GetTabNo();
118
119 SfxWhichIter aIter(rSet);
120 sal_uInt16 nWhich = aIter.FirstWhich();
121 while ( nWhich )
122 {
123 bool bDisable = false;
124 bool bNeedEdit = true; // need selection be editable?
125 switch ( nWhich )
126 {
127 case FID_FILL_TO_BOTTOM: // fill to top / bottom
128 {
129 bDisable = !bSimpleArea || (nRow1 == 0 && nRow2 == 0);
130 if (!bDisable && GetViewData().SelectionForbidsCellFill())
131 bDisable = true;
132 if ( !bDisable && bEditable )
133 { // do not damage matrix
134 bDisable = rDoc.HasSelectedBlockMatrixFragment(
135 nCol1, nRow1, nCol2, nRow1, rMark ); // first row
136 }
137 }
138 break;
139 case FID_FILL_TO_TOP:
140 {
141 bDisable = (!bSimpleArea) || (nRow1 == rDoc.MaxRow() && nRow2 == rDoc.MaxRow());
142 if (!bDisable && GetViewData().SelectionForbidsCellFill())
143 bDisable = true;
144 if ( !bDisable && bEditable )
145 { // do not damage matrix
146 bDisable = rDoc.HasSelectedBlockMatrixFragment(
147 nCol1, nRow2, nCol2, nRow2, rMark ); // last row
148 }
149 }
150 break;
151 case FID_FILL_TO_RIGHT: // fill to left / right
152 {
153 bDisable = !bSimpleArea || (nCol1 == 0 && nCol2 == 0);
154 if (!bDisable && GetViewData().SelectionForbidsCellFill())
155 bDisable = true;
156 if ( !bDisable && bEditable )
157 { // do not damage matrix
158 bDisable = rDoc.HasSelectedBlockMatrixFragment(
159 nCol1, nRow1, nCol1, nRow2, rMark ); // first column
160 }
161 }
162 break;
163 case FID_FILL_TO_LEFT:
164 {
165 bDisable = (!bSimpleArea) || (nCol1 == rDoc.MaxCol() && nCol2 == rDoc.MaxCol());
166 if (!bDisable && GetViewData().SelectionForbidsCellFill())
167 bDisable = true;
168 if ( !bDisable && bEditable )
169 { // do not damage matrix
170 bDisable = rDoc.HasSelectedBlockMatrixFragment(
171 nCol2, nRow1, nCol2, nRow2, rMark ); // last column
172 }
173 }
174 break;
175
176 case SID_RANDOM_NUMBER_GENERATOR_DIALOG:
177 bDisable = !bSimpleArea || GetViewData().SelectionForbidsCellFill();
178 break;
179 case SID_SAMPLING_DIALOG:
180 case SID_DESCRIPTIVE_STATISTICS_DIALOG:
181 case SID_ANALYSIS_OF_VARIANCE_DIALOG:
182 case SID_CORRELATION_DIALOG:
183 case SID_COVARIANCE_DIALOG:
184 case SID_INSERT_SPARKLINE:
185 {
186 bDisable = !bSimpleArea;
187 }
188 break;
189 case SID_GROUP_SPARKLINES:
190 case SID_UNGROUP_SPARKLINES:
191 {
192 bDisable = !bSimpleArea;
193 }
194 break;
195
196 case SID_EDIT_SPARKLINE:
197 {
198 bDisable = !rDoc.HasSparkline(GetViewData().GetCurPos());
199 }
200 break;
201
202 case SID_DELETE_SPARKLINE:
203 case SID_EDIT_SPARKLINE_GROUP:
204 case SID_DELETE_SPARKLINE_GROUP:
205 {
206 bDisable = !rDoc.HasOneSparklineGroup(ScRange(nCol1, nRow1, nTab, nCol2, nRow2, nTab));
207 }
208 break;
209
210 case FID_FILL_SERIES: // fill block
211 case SID_OPENDLG_TABOP: // multiple-cell operations, are at least 2 cells marked?
212 if (rDoc.GetChangeTrack()!=nullptr &&nWhich ==SID_OPENDLG_TABOP)
213 bDisable = true;
214 else
215 bDisable = (!bSimpleArea) || (nCol1 == nCol2 && nRow1 == nRow2);
216
217 if (!bDisable && GetViewData().SelectionForbidsCellFill())
218 bDisable = true;
219
220 if ( !bDisable && bEditable && nWhich == FID_FILL_SERIES )
221 { // do not damage matrix
222 bDisable = rDoc.HasSelectedBlockMatrixFragment(
223 nCol1, nRow1, nCol2, nRow1, rMark ) // first row
224 || rDoc.HasSelectedBlockMatrixFragment(
225 nCol1, nRow2, nCol2, nRow2, rMark ) // last row
226 || rDoc.HasSelectedBlockMatrixFragment(
227 nCol1, nRow1, nCol1, nRow2, rMark ) // first column
228 || rDoc.HasSelectedBlockMatrixFragment(
229 nCol2, nRow1, nCol2, nRow2, rMark ); // last column
230 }
231 break;
232 case FID_FILL_SINGLE_EDIT:
233 bDisable = false;
234 break;
235 case SID_CUT: // cut
236 case SID_COPYDELETE:
237 bDisable = !bSimpleArea || GetObjectShell()->isContentExtractionLocked();
238 break;
239 case FID_INS_CELL: // insert cells, just simple selection
240 bDisable = (!bSimpleArea);
241 break;
242
243 case SID_PASTE:
244 case SID_PASTE_SPECIAL:
245 case SID_PASTE_UNFORMATTED:
246 case SID_PASTE_ONLY_VALUE:
247 case SID_PASTE_ONLY_TEXT:
248 case SID_PASTE_ONLY_FORMULA:
249 case SID_PASTE_TRANSPOSED:
250 case SID_PASTE_AS_LINK:
251 case SID_PASTE_TEXTIMPORT_DIALOG:
252 bDisable = GetViewData().SelectionForbidsPaste();
253 break;
254
255 case FID_INS_ROW:
256 case FID_INS_ROWS_BEFORE: // insert rows
257 case FID_INS_ROWS_AFTER:
258 {
259 sc::EditAction eAction = sc::EditAction::InsertRowsBefore;
260 if (nWhich == FID_INS_ROWS_AFTER)
261 eAction = sc::EditAction::InsertRowsAfter;
262
263 bDisable = (!bSimpleArea) || GetViewData().SimpleColMarked();
264 if (!bEditable && nCol1 == 0 && nCol2 == rDoc.MaxCol())
265 {
266 // See if row insertions are allowed.
267 bEditable = rDoc.IsEditActionAllowed(eAction, rMark, nCol1, nRow1, nCol2, nRow2);
268 }
269 break;
270 }
271 case FID_INS_CELLSDOWN:
272 bDisable = (!bSimpleArea) || GetViewData().SimpleColMarked();
273 break;
274
275 case FID_INS_COLUMN:
276 case FID_INS_COLUMNS_BEFORE: // insert columns
277 case FID_INS_COLUMNS_AFTER:
278 {
279 sc::EditAction eAction = sc::EditAction::InsertColumnsBefore;
280 if (nWhich == FID_INS_COLUMNS_AFTER)
281 eAction = sc::EditAction::InsertColumnsAfter;
282
283 bDisable = (!bSimpleArea && eMarkType != SC_MARK_SIMPLE_FILTERED)
284 || GetViewData().SimpleRowMarked();
285 if (!bEditable && nRow1 == 0 && nRow2 == rDoc.MaxRow())
286 {
287 // See if row insertions are allowed.
288 bEditable = rDoc.IsEditActionAllowed(eAction, rMark, nCol1, nRow1, nCol2, nRow2);
289 }
290 break;
291 }
292 case FID_INS_CELLSRIGHT:
293 bDisable = (!bSimpleArea) || GetViewData().SimpleRowMarked();
294 break;
295
296 case SID_COPY: // copy
297 case SID_COPY_HYPERLINK_LOCATION:
298 // not editable because of matrix only? Do not damage matrix
299 //! is not called, when protected AND matrix, we will have
300 //! to live with this... is caught in Copy-Routine, otherwise
301 //! work is to be done once more
302 if ( bEditable || !bOnlyNotBecauseOfMatrix )
303 bNeedEdit = false; // allowed when protected/ReadOnly
304 bDisable = GetObjectShell()->isContentExtractionLocked();
305 break;
306
307 case SID_AUTOFORMAT: // Autoformat, at least 3x3 selected
308 bDisable = (!bSimpleArea)
309 || ((nCol2 - nCol1) < 2) || ((nRow2 - nRow1) < 2);
310 break;
311
312 case SID_CELL_FORMAT_RESET :
313 case FID_CELL_FORMAT :
314 case SID_ENABLE_HYPHENATION :
315 // not editable because of matrix only? Attribute ok nonetheless
316 if ( !bEditable && bOnlyNotBecauseOfMatrix )
317 bNeedEdit = false;
318 break;
319
320 case FID_CURRENTVALIDATION:
321 case FID_VALIDATION:
322 {
323 if ( pDocShell && pDocShell->IsDocShared() )
324 {
325 bDisable = true;
326 }
327 }
328 break;
329 case SID_TRANSLITERATE_HALFWIDTH:
330 case SID_TRANSLITERATE_FULLWIDTH:
331 case SID_TRANSLITERATE_HIRAGANA:
332 case SID_TRANSLITERATE_KATAKANA:
333 ScViewUtil::HideDisabledSlot( rSet, GetViewData().GetBindings(), nWhich );
334 break;
335 case SID_CONVERT_FORMULA_TO_VALUE:
336 {
337 // Check and see if the marked range has at least one formula cell.
338 bDisable = !rDoc.HasFormulaCell(aMarkRange);
339 }
340 break;
341 }
342 if (!bDisable && bNeedEdit && !bEditable)
343 bDisable = true;
344
345 if (bDisable)
346 rSet.DisableItem(nWhich);
347 else if (nWhich == SID_ENABLE_HYPHENATION)
348 {
349 // toggle slots need a bool item
350 rSet.Put( SfxBoolItem( nWhich, false ) );
351 }
352 nWhich = aIter.NextWhich();
353 }
354 }
355
356 // functions, disabled depending on cursor position
357 // Default:
358 // SID_INSERT_POSTIT, SID_CHARMAP, SID_OPENDLG_FUNCTION
359
360 void ScCellShell::GetCellState( SfxItemSet& rSet )
361 {
362 ScDocShell* pDocShell = GetViewData().GetDocShell();
363 ScDocument& rDoc = GetViewData().GetDocShell()->GetDocument();
364 ScAddress aCursor( GetViewData().GetCurX(), GetViewData().GetCurY(),
365 GetViewData().GetTabNo() );
366 SfxWhichIter aIter(rSet);
367 sal_uInt16 nWhich = aIter.FirstWhich();
368 while ( nWhich )
369 {
370 bool bDisable = false;
371 bool bNeedEdit = true; // need cursor position be editable?
372 switch ( nWhich )
373 {
374 case SID_THESAURUS:
375 {
376 CellType eType = rDoc.GetCellType( aCursor );
377 bDisable = ( eType != CELLTYPE_STRING && eType != CELLTYPE_EDIT);
378 if (!bDisable)
379 {
380 // test for available languages
381 LanguageType nLang = ScViewUtil::GetEffLanguage( rDoc, aCursor );
382 bDisable = !ScModule::HasThesaurusLanguage( nLang );
383 }
384 }
385 break;
386 case SID_OPENDLG_FUNCTION:
387 {
388 ScMarkData aMarkData = GetViewData().GetMarkData();
389 aMarkData.MarkToSimple();
390 const ScRange& aRange = aMarkData.GetMarkArea();
391 if(aMarkData.IsMarked())
392 {
393 if (!rDoc.IsBlockEditable( aCursor.Tab(), aRange.aStart.Col(),aRange.aStart.Row(),
394 aRange.aEnd.Col(),aRange.aEnd.Row() ))
395 {
396 bDisable = true;
397 }
398 bNeedEdit=false;
399 }
400
401 }
402 break;
403 case SID_INSERT_POSTIT:
404 {
405 ScAddress aPos( GetViewData().GetCurX(), GetViewData().GetCurY(), GetViewData().GetTabNo() );
406 if( rDoc.GetNote(aPos) )
407 {
408 bDisable = true;
409 }
410 else
411 {
412 bDisable = false;
413 if ( pDocShell && pDocShell->IsDocShared() )
414 {
415 bDisable = true;
416 }
417 }
418 }
419 break;
420 case SID_EDIT_POSTIT:
421 {
422 ScAddress aPos( GetViewData().GetCurX(), GetViewData().GetCurY(), GetViewData().GetTabNo() );
423 bDisable = rDoc.GetNote(aPos) == nullptr;
424 }
425 break;
426 }
427 if (!bDisable && bNeedEdit)
428 if (!rDoc.IsBlockEditable( aCursor.Tab(), aCursor.Col(),aCursor.Row(),
429 aCursor.Col(),aCursor.Row() ))
430 bDisable = true;
431 if (bDisable)
432 rSet.DisableItem(nWhich);
433 nWhich = aIter.NextWhich();
434 }
435 }
436
437 static bool lcl_TestFormat( SvxClipboardFormatItem& rFormats, const TransferableDataHelper& rDataHelper,
438 SotClipboardFormatId nFormatId )
439 {
440 if ( rDataHelper.HasFormat( nFormatId ) )
441 {
442 // translated format name strings are no longer inserted here,
443 // handled by "paste special" dialog / toolbox controller instead.
444 // Only the object type name has to be set here:
445 OUString aStrVal;
446 if ( nFormatId == SotClipboardFormatId::EMBED_SOURCE )
447 {
448 TransferableObjectDescriptor aDesc;
449 if ( rDataHelper.GetTransferableObjectDescriptor(
450 SotClipboardFormatId::OBJECTDESCRIPTOR, aDesc ) )
451 aStrVal = aDesc.maTypeName;
452 }
453 else if ( nFormatId == SotClipboardFormatId::EMBED_SOURCE_OLE
454 || nFormatId == SotClipboardFormatId::EMBEDDED_OBJ_OLE )
455 {
456 OUString aSource;
457 SvPasteObjectHelper::GetEmbeddedName( rDataHelper, aStrVal, aSource, nFormatId );
458 }
459
460 if ( !aStrVal.isEmpty() )
461 rFormats.AddClipbrdFormat( nFormatId, aStrVal );
462 else
463 rFormats.AddClipbrdFormat( nFormatId );
464
465 return true;
466 }
467
468 return false;
469 }
470
471 void ScCellShell::GetPossibleClipboardFormats( SvxClipboardFormatItem& rFormats )
472 {
473 vcl::Window* pWin = GetViewData().GetActiveWin();
474 bool bDraw = ScDrawTransferObj::GetOwnClipboard(ScTabViewShell::GetClipData(pWin)) != nullptr;
475
476 TransferableDataHelper aDataHelper( TransferableDataHelper::CreateFromSystemClipboard( pWin ) );
477
478 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::DRAWING );
479 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::SVXB );
480 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::GDIMETAFILE );
481 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::PNG );
482 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::BITMAP );
483 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::EMBED_SOURCE );
484
485 if ( !bDraw )
486 {
487 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::LINK );
488 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::STRING );
489 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::STRING_TSVC );
490 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::DIF );
491 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::RTF );
492 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::RICHTEXT );
493 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::HTML );
494 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::HTML_SIMPLE );
495 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::BIFF_8 );
496 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::BIFF_5 );
497 }
498
499 if ( !lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::EMBED_SOURCE_OLE ) )
500 lcl_TestFormat( rFormats, aDataHelper, SotClipboardFormatId::EMBEDDED_OBJ_OLE );
501 }
502
503 // insert, insert contents
504
505 static bool lcl_IsCellPastePossible( const TransferableDataHelper& rData )
506 {
507 bool bPossible = false;
508 css::uno::Reference< css::datatransfer::XTransferable2 > xTransferable(rData.GetXTransferable(), css::uno::UNO_QUERY);
509 if ( ScTransferObj::GetOwnClipboard(xTransferable) || ScDrawTransferObj::GetOwnClipboard(xTransferable) )
510 bPossible = true;
511 else
512 {
513 if ( rData.HasFormat( SotClipboardFormatId::PNG ) ||
514 rData.HasFormat( SotClipboardFormatId::BITMAP ) ||
515 rData.HasFormat( SotClipboardFormatId::GDIMETAFILE ) ||
516 rData.HasFormat( SotClipboardFormatId::SVXB ) ||
517 rData.HasFormat( SotClipboardFormatId::PRIVATE ) ||
518 rData.HasFormat( SotClipboardFormatId::RTF ) ||
519 rData.HasFormat( SotClipboardFormatId::RICHTEXT ) ||
520 rData.HasFormat( SotClipboardFormatId::EMBED_SOURCE ) ||
521 rData.HasFormat( SotClipboardFormatId::LINK_SOURCE ) ||
522 rData.HasFormat( SotClipboardFormatId::EMBED_SOURCE_OLE ) ||
523 rData.HasFormat( SotClipboardFormatId::LINK_SOURCE_OLE ) ||
524 rData.HasFormat( SotClipboardFormatId::EMBEDDED_OBJ_OLE ) ||
525 rData.HasFormat( SotClipboardFormatId::STRING ) ||
526 rData.HasFormat( SotClipboardFormatId::STRING_TSVC ) ||
527 rData.HasFormat( SotClipboardFormatId::SYLK ) ||
528 rData.HasFormat( SotClipboardFormatId::LINK ) ||
529 rData.HasFormat( SotClipboardFormatId::HTML ) ||
530 rData.HasFormat( SotClipboardFormatId::HTML_SIMPLE ) ||
531 rData.HasFormat( SotClipboardFormatId::DIF ) )
532 {
533 bPossible = true;
534 }
535 }
536 return bPossible;
537 }
538
539 bool ScCellShell::HasClipboardFormat( SotClipboardFormatId nFormatId )
540 {
541 vcl::Window* pWin = GetViewData().GetActiveWin();
542 TransferableDataHelper aDataHelper( TransferableDataHelper::CreateFromSystemClipboard( pWin ));
543 return aDataHelper.HasFormat( nFormatId );
544 }
545
546 IMPL_LINK( ScCellShell, ClipboardChanged, TransferableDataHelper*, pDataHelper, void )
547 {
548 bPastePossible = lcl_IsCellPastePossible( *pDataHelper );
549
550 SfxBindings& rBindings = GetViewData().GetBindings();
551 rBindings.Invalidate( SID_PASTE );
552 rBindings.Invalidate( SID_PASTE_SPECIAL );
553 rBindings.Invalidate( SID_PASTE_UNFORMATTED );
554 rBindings.Invalidate( SID_PASTE_ONLY_VALUE );
555 rBindings.Invalidate( SID_PASTE_ONLY_TEXT );
556 rBindings.Invalidate( SID_PASTE_ONLY_FORMULA );
557 rBindings.Invalidate( SID_PASTE_TRANSPOSED );
558 rBindings.Invalidate( SID_PASTE_AS_LINK );
559 rBindings.Invalidate( SID_PASTE_TEXTIMPORT_DIALOG );
560 rBindings.Invalidate( SID_CLIPBOARD_FORMAT_ITEMS );
561 }
562
563 namespace {
564
565 bool checkDestRanges(ScViewData& rViewData)
566 {
567 ScRange aDummy;
568 ScMarkType eMarkType = rViewData.GetSimpleArea( aDummy);
569 if (eMarkType != SC_MARK_MULTI)
570 {
571 // Single destination range.
572 if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED)
573 return false;
574 }
575
576 // Multiple destination ranges.
577
578 // Same as ScViewData::SelectionForbidsPaste() in
579 // sc/source/ui/view/viewdata.cxx but different return details.
580
581 vcl::Window* pWin = rViewData.GetActiveWin();
582 if (!pWin)
583 return false;
584
585 const ScTransferObj* pOwnClip = ScTransferObj::GetOwnClipboard(ScTabViewShell::GetClipData(pWin));
586 if (!pOwnClip)
587 // If it's not a Calc document, we won't be picky.
588 return true;
589
590 ScDocument* pClipDoc = pOwnClip->GetDocument();
591 if (!pClipDoc)
592 return false;
593
594 ScRange aSrcRange = pClipDoc->GetClipParam().getWholeRange();
595 SCROW nRowSize = aSrcRange.aEnd.Row() - aSrcRange.aStart.Row() + 1;
596 SCCOL nColSize = aSrcRange.aEnd.Col() - aSrcRange.aStart.Col() + 1;
597
598 if (rViewData.SelectionForbidsPaste( nColSize, nRowSize))
599 return false;
600
601 ScMarkData aMark = rViewData.GetMarkData();
602 ScRangeList aRanges;
603 aMark.MarkToSimple();
604 aMark.FillRangeListWithMarks(&aRanges, false);
605
606 return ScClipUtil::CheckDestRanges(rViewData.GetDocument(), nColSize, nRowSize, aMark, aRanges);
607 }
608
609 }
610
611 void ScCellShell::GetClipState( SfxItemSet& rSet )
612 {
613 // SID_PASTE
614 // SID_PASTE_SPECIAL
615 // SID_PASTE_UNFORMATTED
616 // SID_CLIPBOARD_FORMAT_ITEMS
617
618 if ( !pImpl->m_xClipEvtLstnr.is() )
619 {
620 // create listener
621 pImpl->m_xClipEvtLstnr = new TransferableClipboardListener( LINK( this, ScCellShell, ClipboardChanged ) );
622 vcl::Window* pWin = GetViewData().GetActiveWin();
623 pImpl->m_xClipEvtLstnr->AddListener( pWin );
624
625 // get initial state
626 TransferableDataHelper aDataHelper( TransferableDataHelper::CreateFromSystemClipboard( pWin ) );
627 bPastePossible = lcl_IsCellPastePossible( aDataHelper );
628 }
629
630 bool bDisable = !bPastePossible;
631
632 // cell protection / multiple selection
633
634 if (!bDisable)
635 {
636 SCCOL nCol = GetViewData().GetCurX();
637 SCROW nRow = GetViewData().GetCurY();
638 SCTAB nTab = GetViewData().GetTabNo();
639 ScDocument& rDoc = GetViewData().GetDocShell()->GetDocument();
640 if (!rDoc.IsBlockEditable( nTab, nCol,nRow, nCol,nRow ))
641 bDisable = true;
642
643 if (!bDisable && !checkDestRanges(GetViewData()))
644 bDisable = true;
645 }
646
647 if (bDisable)
648 {
649 rSet.DisableItem( SID_PASTE );
650 rSet.DisableItem( SID_PASTE_SPECIAL );
651 rSet.DisableItem( SID_PASTE_UNFORMATTED );
652 rSet.DisableItem( SID_PASTE_ONLY_VALUE );
653 rSet.DisableItem( SID_PASTE_ONLY_TEXT );
654 rSet.DisableItem( SID_PASTE_ONLY_FORMULA );
655 rSet.DisableItem( SID_PASTE_TRANSPOSED );
656 rSet.DisableItem( SID_PASTE_AS_LINK );
657 rSet.DisableItem( SID_PASTE_TEXTIMPORT_DIALOG );
658 rSet.DisableItem( SID_CLIPBOARD_FORMAT_ITEMS );
659 }
660 else if ( rSet.GetItemState( SID_CLIPBOARD_FORMAT_ITEMS ) != SfxItemState::UNKNOWN )
661 {
662 SvxClipboardFormatItem aFormats( SID_CLIPBOARD_FORMAT_ITEMS );
663 GetPossibleClipboardFormats( aFormats );
664 rSet.Put( aFormats );
665 }
666 }
667
668 // only SID_HYPERLINK_GETLINK:
669
670 void ScCellShell::GetHLinkState( SfxItemSet& rSet )
671 {
672 // always return an item (or inserting will be disabled)
673 // if the cell at the cursor contains only a link, return that link
674
675 SvxHyperlinkItem aHLinkItem;
676 if ( !GetViewData().GetView()->HasBookmarkAtCursor( &aHLinkItem ) )
677 {
678 // tdf#80043 - put selected text into item
679 ScViewData& rData = GetViewData();
680 ScDocument& rDoc = rData.GetDocument();
681 SCCOL nPosX = rData.GetCurX();
682 SCROW nPosY = rData.GetCurY();
683 SCTAB nTab = rData.GetTabNo();
684 aHLinkItem.SetName(rDoc.GetString(nPosX, nPosY, nTab));
685 }
686
687 rSet.Put(aHLinkItem);
688 }
689
690 void ScCellShell::GetState(SfxItemSet &rSet)
691 {
692 ScTabViewShell* pTabViewShell = GetViewData().GetViewShell();
693 ScDocShell* pDocSh = GetViewData().GetDocShell();
694 ScViewData& rData = GetViewData();
695 ScDocument& rDoc = rData.GetDocument();
696 ScMarkData& rMark = rData.GetMarkData();
697 SCCOL nPosX = rData.GetCurX();
698 SCROW nPosY = rData.GetCurY();
699 SCTAB nTab = rData.GetTabNo();
700
701 SCTAB nTabCount = rDoc.GetTableCount();
702 SCTAB nTabSelCount = rMark.GetSelectCount();
703
704 SfxWhichIter aIter(rSet);
705 sal_uInt16 nWhich = aIter.FirstWhich();
706 while ( nWhich )
707 {
708 switch ( nWhich )
709 {
710 case SID_DETECTIVE_REFRESH:
711 if (!rDoc.HasDetectiveOperations())
712 rSet.DisableItem( nWhich );
713 break;
714
715 case SID_RANGE_ADDRESS:
716 {
717 ScRange aRange;
718 if ( rData.GetSimpleArea( aRange ) == SC_MARK_SIMPLE )
719 {
720 OUString aStr(aRange.Format(rDoc, ScRefFlags::VALID | ScRefFlags::TAB_3D));
721 rSet.Put( SfxStringItem( nWhich, aStr ) );
722 }
723 }
724 break;
725
726 case SID_RANGE_NOTETEXT:
727 {
728 // always take cursor position, do not use top-left cell of selection
729 OUString aNoteText;
730 if ( const ScPostIt* pNote = rDoc.GetNote(nPosX, nPosY, nTab) )
731 aNoteText = pNote->GetText();
732 rSet.Put( SfxStringItem( nWhich, aNoteText ) );
733 }
734 break;
735
736 case SID_RANGE_ROW:
737 rSet.Put( SfxInt32Item( SID_RANGE_ROW, nPosY+1 ) );
738 break;
739
740 case SID_RANGE_COL:
741 rSet.Put( SfxInt16Item( SID_RANGE_COL, nPosX+1 ) );
742 break;
743
744 case SID_RANGE_TABLE:
745 rSet.Put( SfxInt16Item( SID_RANGE_TABLE, nTab+1 ) );
746 break;
747
748 case SID_RANGE_FORMULA:
749 {
750 OUString aString = rDoc.GetFormula( nPosX, nPosY, nTab );
751 if( aString.isEmpty() )
752 {
753 aString = rDoc.GetInputString( nPosX, nPosY, nTab );
754 }
755 rSet.Put( SfxStringItem( nWhich, aString ) );
756 }
757 break;
758
759 case SID_RANGE_TEXTVALUE:
760 {
761 OUString aString = rDoc.GetString(nPosX, nPosY, nTab);
762 rSet.Put( SfxStringItem( nWhich, aString ) );
763 }
764 break;
765
766 case SID_STATUS_SELMODE:
767 {
768 /* 0: STD Click cancels Sel
769 * 1: ER Click extends selection
770 * 2: ERG Click defines further selection
771 */
772 sal_uInt16 nMode = pTabViewShell->GetLockedModifiers();
773
774 switch ( nMode )
775 {
776 case KEY_SHIFT: nMode = 1; break;
777 case KEY_MOD1: nMode = 2; break; // Control-key
778 case 0:
779 default:
780 nMode = 0;
781 }
782
783 rSet.Put( SfxUInt16Item( nWhich, nMode ) );
784 }
785 break;
786
787 case SID_STATUS_DOCPOS:
788 {
789 OUString aStr = ScResId( STR_TABLE_COUNT );
790
791 aStr = aStr.replaceFirst("%1", OUString::number( nTab + 1 ) );
792 aStr = aStr.replaceFirst("%2", OUString::number( nTabCount ) );
793
794 rSet.Put( SfxStringItem( nWhich, aStr ) ); }
795 break;
796
797 case SID_ROWCOL_SELCOUNT:
798 {
799 ScRangeListRef aMarkRanges;
800 GetViewData().GetMultiArea(aMarkRanges);
801 const SCCOL nCol1 = aMarkRanges->front().aStart.Col();
802 const SCROW nRow1 = aMarkRanges->front().aStart.Row();
803 const SCCOL nCol2 = aMarkRanges->front().aEnd.Col();
804 const SCROW nRow2 = aMarkRanges->front().aEnd.Row();
805 const size_t nRanges = aMarkRanges->size();
806
807 if ((nRanges == 1 && (nCol2 != nCol1 || nRow1 != nRow2)) || nRanges > 1)
808 {
809 bool bSameRows = true;
810 bool bSameCols = true;
811 SCROW nRowsSum = 0;
812 SCCOL nColsSum = 0;
813 for (size_t i = 0; i < nRanges; ++i)
814 {
815 const ScRange& rRange = (*aMarkRanges)[i];
816 const SCCOL nRangeCol1 = rRange.aStart.Col();
817 const SCROW nRangeRow1 = rRange.aStart.Row();
818 const SCCOL nRangeCol2 = rRange.aEnd.Col();
819 const SCROW nRangeRow2 = rRange.aEnd.Row();
820 bSameRows &= (nRow1 == nRangeRow1 && nRow2 == nRangeRow2);
821 bSameCols &= (nCol1 == nRangeCol1 && nCol2 == nRangeCol2);
822 // Sum rows if the number of cols is the same or
823 // sum columns if the number of rows is the same,
824 // otherwise do not show any count of selected cells.
825 if (bSameRows || bSameCols)
826 {
827 const auto nCols = nRangeCol2 - nRangeCol1 + 1;
828 const auto nRows = (bSameCols || nRowsSum == 0) ?
829 rDoc.CountNonFilteredRows( nRangeRow1, nRangeRow2, rRange.aStart.Tab()) :
830 nRowsSum;
831 if (bSameRows)
832 {
833 nRowsSum = nRows;
834 nColsSum += nCols;
835 }
836 else if (bSameCols)
837 {
838 nRowsSum += nRows;
839 nColsSum = nCols;
840 }
841 }
842 else
843 break;
844 }
845 // Either the rows or columns are the same among selections
846 if (bSameRows || bSameCols)
847 {
848 const LocaleDataWrapper& rLocaleData
849 = Application::GetSettings().GetUILocaleDataWrapper();
850 OUString aRowArg
851 = ScResId(STR_SELCOUNT_ROWARG, nRowsSum)
852 .replaceAll("%d", rLocaleData.getNum(nRowsSum, 0));
853 OUString aColArg
854 = ScResId(STR_SELCOUNT_COLARG, nColsSum)
855 .replaceAll("%d", rLocaleData.getNum(nColsSum, 0));
856 OUString aStr = ScResId(STR_SELCOUNT);
857 aStr = aStr.replaceAll("%1", aRowArg);
858 aStr = aStr.replaceAll("%2", aColArg);
859 rSet.Put(SfxStringItem(nWhich, aStr));
860 }
861 }
862 else
863 {
864 SCSIZE nSelected, nTotal;
865 rDoc.GetFilterSelCount( nPosX, nPosY, nTab, nSelected, nTotal );
866 if( nTotal && nSelected != SCSIZE_MAX )
867 {
868 OUString aStr = ScResId( STR_FILTER_SELCOUNT );
869 aStr = aStr.replaceAll( "%1", OUString::number( nSelected ) );
870 aStr = aStr.replaceAll( "%2", OUString::number( nTotal ) );
871 rSet.Put( SfxStringItem( nWhich, aStr ) );
872 }
873 }
874 }
875 break;
876
877 // calculations etc. with date/time/Fail/position&size together
878
879 // #i34458# The SvxStatusItem belongs only into SID_TABLE_CELL. It no longer has to be
880 // duplicated in SID_ATTR_POSITION or SID_ATTR_SIZE for SvxPosSizeStatusBarControl.
881 case SID_TABLE_CELL:
882 {
883 // Test, if error under cursor
884 // (not rDoc.GetErrCode, to avoid erasing circular references)
885
886 // In interpreter may happen via rescheduled Basic
887 if ( rDoc.IsInInterpreter() )
888 rSet.Put( SvxStatusItem( SID_TABLE_CELL, u"..."_ustr, StatusCategory::Formula ) );
889 else
890 {
891 FormulaError nErrCode = FormulaError::NONE;
892 ScFormulaCell* pCell = rDoc.GetFormulaCell(ScAddress(nPosX, nPosY, nTab));
893 if (pCell && !pCell->IsRunning())
894 nErrCode = pCell->GetErrCode();
895
896 OUString aFuncStr;
897 if ( pTabViewShell->GetFunction( aFuncStr, nErrCode ) )
898 {
899 rSet.Put( SvxStatusItem( SID_TABLE_CELL, aFuncStr, StatusCategory::Formula ) );
900 }
901 }
902 }
903 break;
904
905 case SID_DATA_SELECT:
906 // HasSelectionData includes column content and validity,
907 // page fields have to be checked separately.
908 if ( !rDoc.HasSelectionData( nPosX, nPosY, nTab ) &&
909 !pTabViewShell->HasPageFieldDataAtCursor() )
910 rSet.DisableItem( nWhich );
911 break;
912
913 case FID_CURRENTVALIDATION:
914 if ( !rDoc.HasValidationData( nPosX, nPosY, nTab ))
915 rSet.DisableItem( nWhich );
916 break;
917
918 case SID_STATUS_SUM:
919 {
920 OUString aFuncStr;
921 if ( pTabViewShell->GetFunction( aFuncStr, FormulaError::NONE ) )
922 rSet.Put( SfxStringItem( nWhich, aFuncStr ) );
923 }
924 break;
925
926 case FID_MERGE_ON:
927 if ( rDoc.GetChangeTrack() || !pTabViewShell->TestMergeCells() )
928 rSet.DisableItem( nWhich );
929 break;
930
931 case FID_MERGE_OFF:
932 if ( rDoc.GetChangeTrack() || !pTabViewShell->TestRemoveMerge() )
933 rSet.DisableItem( nWhich );
934 break;
935
936 case FID_MERGE_TOGGLE:
937 if ( rDoc.GetChangeTrack() )
938 rSet.DisableItem( nWhich );
939 else
940 {
941 bool bCanMerge = pTabViewShell->TestMergeCells();
942 bool bCanSplit = pTabViewShell->TestRemoveMerge();
943 if( !bCanMerge && !bCanSplit )
944 rSet.DisableItem( nWhich );
945 else
946 rSet.Put( SfxBoolItem( nWhich, bCanSplit ) );
947 }
948 break;
949
950 case FID_INS_ROWBRK:
951 if ( nPosY==0 || (rDoc.HasRowBreak(nPosY, nTab) & ScBreakType::Manual) || rDoc.IsTabProtected(nTab) )
952 rSet.DisableItem( nWhich );
953 break;
954
955 case FID_INS_COLBRK:
956 if ( nPosX==0 || (rDoc.HasColBreak(nPosX, nTab) & ScBreakType::Manual) || rDoc.IsTabProtected(nTab) )
957 rSet.DisableItem( nWhich );
958 break;
959
960 case FID_DEL_ROWBRK:
961 if ( nPosY==0 || !(rDoc.HasRowBreak(nPosY, nTab) & ScBreakType::Manual) || rDoc.IsTabProtected(nTab) )
962 rSet.DisableItem( nWhich );
963 break;
964
965 case FID_DEL_COLBRK:
966 if ( nPosX==0 || !(rDoc.HasColBreak(nPosX, nTab) & ScBreakType::Manual) || rDoc.IsTabProtected(nTab) )
967 rSet.DisableItem( nWhich );
968 break;
969
970 case FID_FILL_TAB:
971 if ( nTabSelCount < 2 )
972 rSet.DisableItem( nWhich );
973 break;
974
975 case SID_INSERT_CURRENT_DATE:
976 case SID_INSERT_CURRENT_TIME:
977 {
978 if ( rDoc.IsTabProtected(nTab) &&
979 rDoc.HasAttrib(nPosX, nPosY, nTab, nPosX, nPosY, nTab, HasAttrFlags::Protected))
980 rSet.DisableItem( nWhich );
981 }
982 break;
983
984 case SID_SELECT_SCENARIO:
985 {
986 std::vector<OUString> aList;
987 Color aDummyCol;
988
989 if ( !rDoc.IsScenario(nTab) )
990 {
991 OUString aStr;
992 ScScenarioFlags nFlags;
993 SCTAB nScTab = nTab + 1;
994 bool bSheetProtected = rDoc.IsTabProtected(nTab);
995
996 while ( rDoc.IsScenario(nScTab) )
997 {
998 rDoc.GetName( nScTab, aStr );
999 aList.push_back(aStr);
1000 rDoc.GetScenarioData( nScTab, aStr, aDummyCol, nFlags );
1001 aList.push_back(aStr);
1002 // Protection is sal_True if both Sheet and Scenario are protected
1003 aList.push_back((bSheetProtected && (nFlags & ScScenarioFlags::Protected)) ? u"1"_ustr : u"0"_ustr);
1004 ++nScTab;
1005 }
1006 }
1007 else
1008 {
1009 OUString aComment;
1010 ScScenarioFlags nDummyFlags;
1011 rDoc.GetScenarioData( nTab, aComment, aDummyCol, nDummyFlags );
1012 OSL_ENSURE( aList.empty(), "List not empty!" );
1013 aList.push_back(aComment);
1014 }
1015
1016 rSet.Put( SfxStringListItem( nWhich, &aList ) );
1017 }
1018 break;
1019
1020 case FID_ROW_HIDE:
1021 case FID_ROW_SHOW:
1022 case FID_COL_HIDE:
1023 case FID_COL_SHOW:
1024 case FID_COL_OPT_WIDTH:
1025 case FID_ROW_OPT_HEIGHT:
1026 case FID_DELETE_CELL:
1027 if ( rDoc.IsTabProtected(nTab) || pDocSh->IsReadOnly())
1028 rSet.DisableItem( nWhich );
1029 break;
1030
1031 case SID_OUTLINE_MAKE:
1032 {
1033 if ( GetViewData().GetDocument().GetDPAtCursor( GetViewData().GetCurX(),
1034 GetViewData().GetCurY(), GetViewData().GetTabNo() ) )
1035 {
1036 //! test for data pilot operation
1037 }
1038 else if (rDoc.GetChangeTrack()!=nullptr || GetViewData().IsMultiMarked())
1039 {
1040 rSet.DisableItem( nWhich );
1041 }
1042 }
1043 break;
1044 case SID_OUTLINE_SHOW:
1045 if ( GetViewData().GetDocument().GetDPAtCursor( GetViewData().GetCurX(),
1046 GetViewData().GetCurY(), GetViewData().GetTabNo() ) )
1047 {
1048 //! test for data pilot operation
1049 }
1050 else if (!pTabViewShell->OutlinePossible(false))
1051 rSet.DisableItem( nWhich );
1052 break;
1053
1054 case SID_OUTLINE_HIDE:
1055 if ( GetViewData().GetDocument().GetDPAtCursor( GetViewData().GetCurX(),
1056 GetViewData().GetCurY(), GetViewData().GetTabNo() ) )
1057 {
1058 //! test for data pilot operation
1059 }
1060 else if (!pTabViewShell->OutlinePossible(true))
1061 rSet.DisableItem( nWhich );
1062 break;
1063
1064 case SID_OUTLINE_REMOVE:
1065 {
1066 if ( GetViewData().GetDocument().GetDPAtCursor( GetViewData().GetCurX(),
1067 GetViewData().GetCurY(), GetViewData().GetTabNo() ) )
1068 {
1069 //! test for data pilot operation
1070 }
1071 else
1072 {
1073 bool bCol, bRow;
1074 pTabViewShell->TestRemoveOutline( bCol, bRow );
1075 if ( !bCol && !bRow )
1076 rSet.DisableItem( nWhich );
1077 }
1078 }
1079 break;
1080
1081 case FID_COL_WIDTH:
1082 {
1083 SfxUInt16Item aWidthItem( FID_COL_WIDTH, rDoc.GetColWidth( nPosX , nTab) );
1084 rSet.Put( aWidthItem );
1085 if ( pDocSh->IsReadOnly())
1086 rSet.DisableItem( nWhich );
1087
1088 //XXX disable if not conclusive
1089 }
1090 break;
1091
1092 case FID_ROW_HEIGHT:
1093 {
1094 SfxUInt16Item aHeightItem( FID_ROW_HEIGHT, rDoc.GetRowHeight( nPosY , nTab) );
1095 rSet.Put( aHeightItem );
1096 //XXX disable if not conclusive
1097 if ( pDocSh->IsReadOnly())
1098 rSet.DisableItem( nWhich );
1099 }
1100 break;
1101
1102 case SID_DETECTIVE_FILLMODE:
1103 rSet.Put(SfxBoolItem( nWhich, pTabViewShell->IsAuditShell() ));
1104 break;
1105
1106 case FID_INPUTLINE_STATUS:
1107 OSL_FAIL( "Old update method. Use ScTabViewShell::UpdateInputHandler()." );
1108 break;
1109
1110 case SID_SCENARIOS: // scenarios:
1111 if (!(rMark.IsMarked() || rMark.IsMultiMarked())) // only, if something selected
1112 rSet.DisableItem( nWhich );
1113 break;
1114
1115 case FID_NOTE_VISIBLE:
1116 {
1117 const ScPostIt* pNote = rDoc.GetNote(nPosX, nPosY, nTab);
1118 if ( pNote && rDoc.IsBlockEditable( nTab, nPosX,nPosY, nPosX,nPosY ) )
1119 rSet.Put( SfxBoolItem( nWhich, pNote->IsCaptionShown() ) );
1120 else
1121 rSet.DisableItem( nWhich );
1122 }
1123 break;
1124
1125 case FID_HIDE_NOTE:
1126 case FID_SHOW_NOTE:
1127 {
1128 bool bEnable = false;
1129 bool bSearchForHidden = nWhich == FID_SHOW_NOTE;
1130 if (!rMark.IsMarked() && !rMark.IsMultiMarked())
1131 {
1132 // Check current cell
1133 const ScPostIt* pNote = rDoc.GetNote(nPosX, nPosY, nTab);
1134 if ( pNote && rDoc.IsBlockEditable( nTab, nPosX,nPosY, nPosX,nPosY ) )
1135 if ( pNote->IsCaptionShown() != bSearchForHidden)
1136 bEnable = true;
1137 }
1138 else
1139 {
1140 // Check selection range
1141 ScRangeListRef aRangesRef;
1142 rData.GetMultiArea(aRangesRef);
1143 ScRangeList aRanges = *aRangesRef;
1144 std::vector<sc::NoteEntry> aNotes;
1145 rDoc.GetNotesInRange(aRanges, aNotes);
1146 for(const auto& rNote : aNotes)
1147 {
1148 const ScAddress& rAdr = rNote.maPos;
1149 if( rDoc.IsBlockEditable( rAdr.Tab(), rAdr.Col(), rAdr.Row(), rAdr.Col(), rAdr.Row() ))
1150 {
1151 if (rNote.mpNote->IsCaptionShown() != bSearchForHidden)
1152 {
1153 bEnable = true;
1154 break;
1155 }
1156 }
1157 }
1158
1159 }
1160 if ( !bEnable )
1161 rSet.DisableItem( nWhich );
1162 }
1163 break;
1164
1165 case FID_SHOW_ALL_NOTES:
1166 case FID_HIDE_ALL_NOTES:
1167 case FID_DELETE_ALL_NOTES:
1168 {
1169 bool bHasNotes = false;
1170
1171 for (auto const& rTab : rMark.GetSelectedTabs())
1172 {
1173 if (rDoc.HasTabNotes( rTab ))
1174 {
1175 bHasNotes = true;
1176 break;
1177 }
1178 }
1179
1180 if ( !bHasNotes )
1181 rSet.DisableItem( nWhich );
1182 }
1183 break;
1184
1185 case SID_TOGGLE_NOTES:
1186 {
1187 bool bHasNotes = false;
1188 ScRangeList aRanges;
1189
1190 for (auto const& rTab : rMark.GetSelectedTabs())
1191 {
1192 if (rDoc.HasTabNotes( rTab ))
1193 {
1194 bHasNotes = true;
1195 aRanges.push_back(ScRange(0,0,rTab,rDoc.MaxCol(),rDoc.MaxRow(),rTab));
1196 }
1197 }
1198
1199 if ( !bHasNotes )
1200 rSet.DisableItem( nWhich );
1201 else
1202 {
1203 CommentCaptionState eState = rDoc.GetAllNoteCaptionsState( aRanges );
1204 bool bAllNotesInShown = (eState != ALLHIDDEN && eState != MIXED);
1205 rSet.Put( SfxBoolItem( SID_TOGGLE_NOTES, bAllNotesInShown) );
1206 }
1207 }
1208 break;
1209
1210 case SID_DELETE_NOTE:
1211 {
1212 bool bEnable = false;
1213 if ( rMark.IsMarked() || rMark.IsMultiMarked() )
1214 {
1215 if ( rDoc.IsSelectionEditable( rMark ) )
1216 {
1217 // look for at least one note in selection
1218 ScRangeList aRanges;
1219 rMark.FillRangeListWithMarks( &aRanges, false );
1220 bEnable = rDoc.ContainsNotesInRange( aRanges );
1221 }
1222 }
1223 else
1224 {
1225 bEnable = rDoc.IsBlockEditable( nTab, nPosX,nPosY, nPosX,nPosY ) &&
1226 rDoc.GetNote(nPosX, nPosY, nTab);
1227 }
1228 if ( !bEnable )
1229 rSet.DisableItem( nWhich );
1230 }
1231 break;
1232
1233 case SID_OPENDLG_CONSOLIDATE:
1234 case SCITEM_CONSOLIDATEDATA:
1235 {
1236 if (rDoc.GetChangeTrack()!=nullptr)
1237 rSet.DisableItem( nWhich);
1238 }
1239 break;
1240
1241 case SID_CHINESE_CONVERSION:
1242 case SID_HANGUL_HANJA_CONVERSION:
1243 ScViewUtil::HideDisabledSlot( rSet, rData.GetBindings(), nWhich );
1244 break;
1245
1246 case FID_USE_NAME:
1247 {
1248 if ( pDocSh && pDocSh->IsDocShared() )
1249 rSet.DisableItem( nWhich );
1250 else
1251 {
1252 ScRange aRange;
1253 if ( rData.GetSimpleArea( aRange ) != SC_MARK_SIMPLE )
1254 rSet.DisableItem( nWhich );
1255 }
1256 }
1257 break;
1258
1259 case FID_DEFINE_NAME:
1260 case FID_INSERT_NAME:
1261 case FID_ADD_NAME:
1262 case SID_DEFINE_COLROWNAMERANGES:
1263 {
1264 if ( pDocSh && pDocSh->IsDocShared() )
1265 {
1266 rSet.DisableItem( nWhich );
1267 }
1268 }
1269 break;
1270
1271 case FID_DEFINE_CURRENT_NAME:
1272 {
1273 ScAddress aCurrentAddress( nPosX, nPosY, nTab );
1274
1275 if ( !rDoc.IsAddressInRangeName( RangeNameScope::GLOBAL, aCurrentAddress ) &&
1276 !rDoc.IsAddressInRangeName( RangeNameScope::SHEET, aCurrentAddress ))
1277 {
1278 rSet.DisableItem( nWhich );
1279 }
1280 }
1281 break;
1282
1283 case SID_SPELL_DIALOG:
1284 {
1285 if (rDoc.IsTabProtected(rData.GetTabNo()))
1286 {
1287 bool bVisible = false;
1288 SfxViewFrame* pViewFrame = ( pTabViewShell ? &pTabViewShell->GetViewFrame() : nullptr );
1289 if ( pViewFrame && pViewFrame->HasChildWindow( nWhich ) )
1290 {
1291 SfxChildWindow* pChild = pViewFrame->GetChildWindow( nWhich );
1292 std::shared_ptr<SfxDialogController> xController = pChild ? pChild->GetController() : nullptr;
1293 if (xController && xController->getDialog()->get_visible())
1294 {
1295 bVisible = true;
1296 }
1297 }
1298 if ( !bVisible )
1299 {
1300 rSet.DisableItem( nWhich );
1301 }
1302 }
1303 }
1304 break;
1305
1306 case SID_OPENDLG_CURRENTCONDFRMT:
1307 case SID_OPENDLG_CURRENTCONDFRMT_MANAGER:
1308 {
1309 const SfxPoolItem* pItem = rDoc.GetAttr( nPosX, nPosY, nTab, ATTR_CONDITIONAL );
1310 const ScCondFormatItem* pCondFormatItem = static_cast<const ScCondFormatItem*>(pItem);
1311
1312 if ( pCondFormatItem->GetCondFormatData().empty() )
1313 rSet.DisableItem( nWhich );
1314 else if ( pCondFormatItem->GetCondFormatData().size() == 1 )
1315 rSet.DisableItem( SID_OPENDLG_CURRENTCONDFRMT_MANAGER );
1316 else if ( pCondFormatItem->GetCondFormatData().size() > 1 )
1317 rSet.DisableItem( SID_OPENDLG_CURRENTCONDFRMT );
1318 }
1319 break;
1320
1321 } // switch ( nWitch )
1322 nWhich = aIter.NextWhich();
1323 } // while ( nWitch )
1324 }
1325
1326 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE