?  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 / core / data / documen8.cxx
blobca19d460c7205258cb4231a62f9d954c7abe64f7
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 #include <comphelper/fileformat.h>
22 #include <comphelper/processfactory.hxx>
23 #include <officecfg/Office/Common.hxx>
24 #include <tools/urlobj.hxx>
25 #include <editeng/frmdiritem.hxx>
26 #include <editeng/langitem.hxx>
27 #include <sfx2/linkmgr.hxx>
28 #include <sfx2/bindings.hxx>
29 #include <sfx2/printer.hxx>
30 #include <sfx2/viewfrm.hxx>
31 #include <sfx2/viewsh.hxx>
32 #include <svl/flagitem.hxx>
33 #include <svl/intitem.hxx>
34 #include <svl/numformat.hxx>
35 #include <svl/zformat.hxx>
36 #include <svl/ctloptions.hxx>
37 #include <unotools/transliterationwrapper.hxx>
38 #include <sal/log.hxx>
39 #include <osl/diagnose.h>
40
41 #include <vcl/svapp.hxx>
42 #include <vcl/virdev.hxx>
43 #include <vcl/weld.hxx>
44 #include <vcl/TaskStopwatch.hxx>
45
46 #include <inputopt.hxx>
47 #include <global.hxx>
48 #include <table.hxx>
49 #include <column.hxx>
50 #include <poolhelp.hxx>
51 #include <docpool.hxx>
52 #include <docsh.hxx>
53 #include <stlpool.hxx>
54 #include <stlsheet.hxx>
55 #include <docoptio.hxx>
56 #include <viewopti.hxx>
57 #include <scextopt.hxx>
58 #include <rechead.hxx>
59 #include <ddelink.hxx>
60 #include <scmatrix.hxx>
61 #include <arealink.hxx>
62 #include <patattr.hxx>
63 #include <editutil.hxx>
64 #include <progress.hxx>
65 #include <document.hxx>
66 #include <chartlis.hxx>
67 #include <chartlock.hxx>
68 #include <refupdat.hxx>
69 #include <markdata.hxx>
70 #include <scmod.hxx>
71 #include <externalrefmgr.hxx>
72 #include <globstr.hrc>
73 #include <strings.hrc>
74 #include <sc.hrc>
75 #include <charthelper.hxx>
76 #include <macromgr.hxx>
77 #include <docuno.hxx>
78 #include <scresid.hxx>
79 #include <columniterator.hxx>
80 #include <globalnames.hxx>
81 #include <stringutil.hxx>
82 #include <documentlinkmgr.hxx>
83 #include <tokenarray.hxx>
84 #include <recursionhelper.hxx>
85
86 #include <memory>
87 #include <utility>
88
89 using namespace com::sun::star;
90
91 namespace {
92
93 sal_uInt16 getScaleValue(SfxStyleSheetBase& rStyle, sal_uInt16 nWhich)
94 {
95 return static_cast<const SfxUInt16Item&>(rStyle.GetItemSet().Get(nWhich)).GetValue();
96 }
97
98 }
99
100 void ScDocument::ImplCreateOptions()
101 {
102 pDocOptions.reset( new ScDocOptions() );
103 pViewOptions.reset( new ScViewOptions() );
104 }
105
106 void ScDocument::ImplDeleteOptions()
107 {
108 pDocOptions.reset();
109 pViewOptions.reset();
110 pExtDocOptions.reset();
111 }
112
113 SfxPrinter* ScDocument::GetPrinter(bool bCreateIfNotExist)
114 {
115 if (!mpPrinter && bCreateIfNotExist && mxPoolHelper)
116 {
117 auto pSet =
118 std::make_unique<SfxItemSetFixed
119 <SID_PRINTER_NOTFOUND_WARN, SID_PRINTER_NOTFOUND_WARN,
120 SID_PRINTER_CHANGESTODOC, SID_PRINTER_CHANGESTODOC,
121 SID_PRINT_SELECTEDSHEET, SID_PRINT_SELECTEDSHEET,
122 SID_SCPRINTOPTIONS, SID_SCPRINTOPTIONS>>(*mxPoolHelper->GetDocPool());
123
124 SfxPrinterChangeFlags nFlags = SfxPrinterChangeFlags::NONE;
125 if (officecfg::Office::Common::Print::Warning::PaperOrientation::get())
126 nFlags |= SfxPrinterChangeFlags::CHG_ORIENTATION;
127 if (officecfg::Office::Common::Print::Warning::PaperSize::get())
128 nFlags |= SfxPrinterChangeFlags::CHG_SIZE;
129 pSet->Put( SfxFlagItem( SID_PRINTER_CHANGESTODOC, static_cast<int>(nFlags) ) );
130 pSet->Put( SfxBoolItem( SID_PRINTER_NOTFOUND_WARN, officecfg::Office::Common::Print::Warning::NotFound::get() ) );
131
132 mpPrinter = VclPtr<SfxPrinter>::Create( std::move(pSet) );
133 mpPrinter->SetMapMode(MapMode(MapUnit::Map100thMM));
134 UpdateDrawPrinter();
135 mpPrinter->SetDigitLanguage( ScModule::GetOptDigitLanguage() );
136 }
137
138 return mpPrinter;
139 }
140
141 void ScDocument::SetPrinter( VclPtr<SfxPrinter> const & pNewPrinter )
142 {
143 if ( pNewPrinter == mpPrinter.get() )
144 {
145 // #i6706# SetPrinter is called with the same printer again if
146 // the JobSetup has changed. In that case just call UpdateDrawPrinter
147 // (SetRefDevice for drawing layer) because of changed text sizes.
148 UpdateDrawPrinter();
149 }
150 else
151 {
152 ScopedVclPtr<SfxPrinter> xKeepAlive( mpPrinter );
153 mpPrinter = pNewPrinter;
154 UpdateDrawPrinter();
155 mpPrinter->SetDigitLanguage( ScModule::GetOptDigitLanguage() );
156 }
157 InvalidateTextWidth(nullptr, nullptr, false); // in both cases
158 }
159
160 void ScDocument::SetPrintOptions()
161 {
162 if ( !mpPrinter ) GetPrinter(); // this sets mpPrinter
163 OSL_ENSURE( mpPrinter, "Error in printer creation :-/" );
164
165 if ( !mpPrinter )
166 return;
167
168 SfxItemSet aOptSet( mpPrinter->GetOptions() );
169
170 SfxPrinterChangeFlags nFlags = SfxPrinterChangeFlags::NONE;
171 if (officecfg::Office::Common::Print::Warning::PaperOrientation::get())
172 nFlags |= SfxPrinterChangeFlags::CHG_ORIENTATION;
173 if (officecfg::Office::Common::Print::Warning::PaperSize::get())
174 nFlags |= SfxPrinterChangeFlags::CHG_SIZE;
175 aOptSet.Put( SfxFlagItem( SID_PRINTER_CHANGESTODOC, static_cast<int>(nFlags) ) );
176 aOptSet.Put( SfxBoolItem( SID_PRINTER_NOTFOUND_WARN, officecfg::Office::Common::Print::Warning::NotFound::get() ) );
177
178 mpPrinter->SetOptions( aOptSet );
179 }
180
181 VirtualDevice* ScDocument::GetVirtualDevice_100th_mm()
182 {
183 if (!mpVirtualDevice_100th_mm)
184 {
185 #ifdef IOS
186 mpVirtualDevice_100th_mm = VclPtr<VirtualDevice>::Create(DeviceFormat::GRAYSCALE);
187 #else
188 mpVirtualDevice_100th_mm = VclPtr<VirtualDevice>::Create(DeviceFormat::WITHOUT_ALPHA);
189 #endif
190 mpVirtualDevice_100th_mm->SetReferenceDevice(VirtualDevice::RefDevMode::MSO1);
191 MapMode aMapMode( mpVirtualDevice_100th_mm->GetMapMode() );
192 aMapMode.SetMapUnit( MapUnit::Map100thMM );
193 mpVirtualDevice_100th_mm->SetMapMode( aMapMode );
194 }
195 return mpVirtualDevice_100th_mm;
196 }
197
198 OutputDevice* ScDocument::GetRefDevice(bool bForceVirtDev)
199 {
200 // Create printer like ref device, see Writer...
201 OutputDevice* pRefDevice = nullptr;
202 if (!bForceVirtDev && ScModule::get()->GetInputOptions().GetTextWysiwyg())
203 {
204 pRefDevice = GetPrinter();
205 SAL_WARN_IF(!pRefDevice, "sc", "unable to get a printer, fallback to virdev");
206 }
207 if (!pRefDevice)
208 pRefDevice = GetVirtualDevice_100th_mm();
209 return pRefDevice;
210 }
211
212 void ScDocument::ModifyStyleSheet( SfxStyleSheetBase& rStyleSheet,
213 const SfxItemSet& rChanges )
214 {
215 SfxItemSet& rSet = rStyleSheet.GetItemSet();
216
217 switch ( rStyleSheet.GetFamily() )
218 {
219 case SfxStyleFamily::Page:
220 {
221 const sal_uInt16 nOldScale = getScaleValue(rStyleSheet, ATTR_PAGE_SCALE);
222 const sal_uInt16 nOldScaleToPages = getScaleValue(rStyleSheet, ATTR_PAGE_SCALETOPAGES);
223 rSet.Put( rChanges );
224 const sal_uInt16 nNewScale = getScaleValue(rStyleSheet, ATTR_PAGE_SCALE);
225 const sal_uInt16 nNewScaleToPages = getScaleValue(rStyleSheet, ATTR_PAGE_SCALETOPAGES);
226
227 if ( (nOldScale != nNewScale) || (nOldScaleToPages != nNewScaleToPages) )
228 InvalidateTextWidth( rStyleSheet.GetName() );
229
230 if( SvtCTLOptions::IsCTLFontEnabled() )
231 {
232 if( rChanges.GetItemState(ATTR_WRITINGDIR ) == SfxItemState::SET )
233 ScChartHelper::DoUpdateAllCharts( *this );
234 }
235 }
236 break;
237
238 case SfxStyleFamily::Para:
239 {
240 bool bNumFormatChanged;
241 if ( ScGlobal::CheckWidthInvalidate( bNumFormatChanged,
242 rSet, rChanges ) )
243 InvalidateTextWidth( nullptr, nullptr, bNumFormatChanged );
244
245 for (SCTAB nTab=0; nTab<=MAXTAB; ++nTab)
246 if (maTabs[nTab])
247 maTabs[nTab]->SetStreamValid( false );
248
249 sal_uInt32 nOldFormat =
250 rSet.Get( ATTR_VALUE_FORMAT ).GetValue();
251 sal_uInt32 nNewFormat =
252 rChanges.Get( ATTR_VALUE_FORMAT ).GetValue();
253 LanguageType eNewLang, eOldLang;
254 eNewLang = eOldLang = LANGUAGE_DONTKNOW;
255 if ( nNewFormat != nOldFormat )
256 {
257 SvNumberFormatter* pFormatter = GetFormatTable();
258 eOldLang = pFormatter->GetEntry( nOldFormat )->GetLanguage();
259 eNewLang = pFormatter->GetEntry( nNewFormat )->GetLanguage();
260 }
261
262 // Explanation to Items in rChanges:
263 // Set Item - take over change
264 // Dontcare - Set Default
265 // Default - No change
266 // ("no change" is not possible with PutExtended, thus the loop)
267 for (sal_uInt16 nWhich = ATTR_PATTERN_START; nWhich <= ATTR_PATTERN_END; nWhich++)
268 {
269 const SfxPoolItem* pItem;
270 SfxItemState eState = rChanges.GetItemState( nWhich, false, &pItem );
271 if ( eState == SfxItemState::SET )
272 rSet.Put( *pItem );
273 else if ( eState == SfxItemState::INVALID )
274 rSet.ClearItem( nWhich );
275 // when Default nothing
276 }
277
278 if ( eNewLang != eOldLang )
279 rSet.Put(
280 SvxLanguageItem( eNewLang, ATTR_LANGUAGE_FORMAT ) );
281 }
282 break;
283 default:
284 {
285 // added to avoid warnings
286 }
287 }
288 }
289
290 void ScDocument::CopyStdStylesFrom( const ScDocument& rSrcDoc )
291 {
292 // number format exchange list has to be handled here, too
293 NumFmtMergeHandler aNumFmtMergeHdl(*this, rSrcDoc);
294 mxPoolHelper->GetStylePool()->CopyStdStylesFrom( rSrcDoc.mxPoolHelper->GetStylePool() );
295 }
296
297 void ScDocument::InvalidateTextWidth( std::u16string_view rStyleName )
298 {
299 const SCTAB nCount = GetTableCount();
300 for ( SCTAB i=0; i<nCount && maTabs[i]; i++ )
301 if ( maTabs[i]->GetPageStyle() == rStyleName )
302 InvalidateTextWidth( i );
303 }
304
305 void ScDocument::InvalidateTextWidth( SCTAB nTab )
306 {
307 ScAddress aAdrFrom( 0, 0, nTab );
308 ScAddress aAdrTo ( MaxCol(), MaxRow(), nTab );
309 InvalidateTextWidth( &aAdrFrom, &aAdrTo, false );
310 }
311
312 bool ScDocument::IsPageStyleInUse( std::u16string_view rStrPageStyle, SCTAB* pInTab )
313 {
314 bool bInUse = false;
315 const SCTAB nCount = GetTableCount();
316 SCTAB i;
317
318 for ( i = 0; !bInUse && i < nCount && maTabs[i]; i++ )
319 bInUse = ( maTabs[i]->GetPageStyle() == rStrPageStyle );
320
321 if ( pInTab )
322 *pInTab = i-1;
323
324 return bInUse;
325 }
326
327 bool ScDocument::RemovePageStyleInUse( std::u16string_view rStyle )
328 {
329 bool bWasInUse = false;
330 const SCTAB nCount = GetTableCount();
331
332 for ( SCTAB i=0; i<nCount && maTabs[i]; i++ )
333 if ( maTabs[i]->GetPageStyle() == rStyle )
334 {
335 bWasInUse = true;
336 maTabs[i]->SetPageStyle( ScResId(STR_STYLENAME_STANDARD) );
337 }
338
339 return bWasInUse;
340 }
341
342 bool ScDocument::RenamePageStyleInUse( std::u16string_view rOld, const OUString& rNew )
343 {
344 bool bWasInUse = false;
345 const SCTAB nCount = GetTableCount();
346
347 for ( SCTAB i=0; i<nCount && maTabs[i]; i++ )
348 if ( maTabs[i]->GetPageStyle() == rOld )
349 {
350 bWasInUse = true;
351 maTabs[i]->SetPageStyle( rNew );
352 }
353
354 return bWasInUse;
355 }
356
357 EEHorizontalTextDirection ScDocument::GetEditTextDirection(SCTAB nTab) const
358 {
359 EEHorizontalTextDirection eRet = EEHorizontalTextDirection::Default;
360
361 OUString aStyleName = GetPageStyle( nTab );
362 SfxStyleSheetBase* pStyle = mxPoolHelper->GetStylePool()->Find( aStyleName, SfxStyleFamily::Page );
363 if ( pStyle )
364 {
365 SfxItemSet& rStyleSet = pStyle->GetItemSet();
366 SvxFrameDirection eDirection =
367 rStyleSet.Get( ATTR_WRITINGDIR ).GetValue();
368
369 if ( eDirection == SvxFrameDirection::Horizontal_LR_TB )
370 eRet = EEHorizontalTextDirection::L2R;
371 else if ( eDirection == SvxFrameDirection::Horizontal_RL_TB )
372 eRet = EEHorizontalTextDirection::R2L;
373 // else (invalid for EditEngine): keep "default"
374 }
375
376 return eRet;
377 }
378
379 ScMacroManager* ScDocument::GetMacroManager()
380 {
381 if (!mpMacroMgr)
382 mpMacroMgr.reset(new ScMacroManager(*this));
383 return mpMacroMgr.get();
384 }
385
386 void ScDocument::FillMatrix(
387 ScMatrix& rMat, SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, svl::SharedStringPool* pPool ) const
388 {
389 const ScTable* pTab = FetchTable(nTab);
390 if (!pTab)
391 return;
392
393 if (nCol1 > nCol2 || nRow1 > nRow2)
394 return;
395
396 SCSIZE nC, nR;
397 rMat.GetDimensions(nC, nR);
398 if (static_cast<SCROW>(nR) != nRow2 - nRow1 + 1 || static_cast<SCCOL>(nC) != nCol2 - nCol1 + 1)
399 return;
400
401 pTab->FillMatrix(rMat, nCol1, nRow1, nCol2, nRow2, pPool);
402 }
403
404 void ScDocument::SetFormulaResults( const ScAddress& rTopPos, const double* pResults, size_t nLen )
405 {
406 ScTable* pTab = FetchTable(rTopPos.Tab());
407 if (!pTab)
408 return;
409
410 pTab->SetFormulaResults(rTopPos.Col(), rTopPos.Row(), pResults, nLen);
411 }
412
413 void ScDocument::CalculateInColumnInThread( ScInterpreterContext& rContext, const ScRange& rCalcRange, unsigned nThisThread, unsigned nThreadsTotal)
414 {
415 ScTable* pTab = FetchTable(rCalcRange.aStart.Tab());
416 if (!pTab)
417 return;
418
419 assert(IsThreadedGroupCalcInProgress());
420
421 maThreadSpecific.pContext = &rContext;
422 pTab->CalculateInColumnInThread(rContext, rCalcRange.aStart.Col(), rCalcRange.aEnd.Col(), rCalcRange.aStart.Row(), rCalcRange.aEnd.Row(), nThisThread, nThreadsTotal);
423
424 assert(IsThreadedGroupCalcInProgress());
425 maThreadSpecific.pContext = nullptr;
426 // If any of the thread_local data would cause problems if they stay around for too long
427 // (and e.g. outlive the ScDocument), clean them up here, they cannot be cleaned up
428 // later from the main thread.
429 if(maThreadSpecific.xRecursionHelper)
430 maThreadSpecific.xRecursionHelper->Clear();
431 }
432
433 void ScDocument::HandleStuffAfterParallelCalculation( SCCOL nColStart, SCCOL nColEnd, SCROW nRow, size_t nLen, SCTAB nTab, ScInterpreter* pInterpreter )
434 {
435 assert(!IsThreadedGroupCalcInProgress());
436 for( const DelayedSetNumberFormat& data : GetNonThreadedContext().maDelayedSetNumberFormat)
437 SetNumberFormat( ScAddress( data.mCol, data.mRow, nTab ), data.mnNumberFormat );
438 GetNonThreadedContext().maDelayedSetNumberFormat.clear();
439
440 ScTable* pTab = FetchTable(nTab);
441 if (!pTab)
442 return;
443
444 pTab->HandleStuffAfterParallelCalculation(nColStart, nColEnd, nRow, nLen, pInterpreter);
445 }
446
447 void ScDocument::InvalidateTextWidth( const ScAddress* pAdrFrom, const ScAddress* pAdrTo,
448 bool bNumFormatChanged )
449 {
450 bool bBroadcast = (bNumFormatChanged && GetDocOptions().IsCalcAsShown() && !IsImportingXML() && !IsClipboard());
451 if ( pAdrFrom && !pAdrTo )
452 {
453 const SCTAB nTab = pAdrFrom->Tab();
454
455 if (nTab < static_cast<SCTAB>(maTabs.size()) && maTabs[nTab] )
456 maTabs[nTab]->InvalidateTextWidth( pAdrFrom, nullptr, bNumFormatChanged, bBroadcast );
457 }
458 else
459 {
460 const SCTAB nTabStart = pAdrFrom ? pAdrFrom->Tab() : 0;
461 const SCTAB nTabEnd = pAdrTo ? pAdrTo->Tab() : MAXTAB;
462
463 for ( SCTAB nTab=nTabStart; nTab<=nTabEnd && nTab < static_cast<SCTAB>(maTabs.size()); nTab++ )
464 if ( maTabs[nTab] )
465 maTabs[nTab]->InvalidateTextWidth( pAdrFrom, pAdrTo, bNumFormatChanged, bBroadcast );
466 }
467 }
468
469 #define CALCMAX 1000 // Calculations
470
471 namespace {
472
473 class IdleCalcTextWidthScope : public TaskStopwatch
474 {
475 ScDocument& mrDoc;
476 ScAddress& mrCalcPos;
477 MapMode maOldMapMode;
478 ScStyleSheetPool* mpStylePool;
479 bool mbNeedMore;
480 bool mbProgress;
481
482 public:
483 IdleCalcTextWidthScope(ScDocument& rDoc, ScAddress& rCalcPos) :
484 mrDoc(rDoc),
485 mrCalcPos(rCalcPos),
486 mpStylePool(rDoc.GetStyleSheetPool()),
487 mbNeedMore(false),
488 mbProgress(false)
489 {
490 mrDoc.EnableIdle(false);
491 }
492
493 ~IdleCalcTextWidthScope() COVERITY_NOEXCEPT_FALSE
494 {
495 SfxPrinter* pDev = mrDoc.GetPrinter();
496 if (pDev)
497 pDev->SetMapMode(maOldMapMode);
498
499 if (mbProgress)
500 ScProgress::DeleteInterpretProgress();
501
502 mrDoc.EnableIdle(true);
503 }
504
505 SCTAB Tab() const { return mrCalcPos.Tab(); }
506 SCCOL Col() const { return mrCalcPos.Col(); }
507 SCROW Row() const { return mrCalcPos.Row(); }
508
509 void setTab(SCTAB nTab) { mrCalcPos.SetTab(nTab); }
510 void setCol(SCCOL nCol) { mrCalcPos.SetCol(nCol); }
511 void setRow(SCROW nRow) { mrCalcPos.SetRow(nRow); }
512
513 void incTab() { mrCalcPos.IncTab(); }
514 void incCol(SCCOL nInc) { mrCalcPos.IncCol(nInc); }
515
516 void setOldMapMode(const MapMode& rOldMapMode) { maOldMapMode = rOldMapMode; }
517
518 void setNeedMore(bool b) { mbNeedMore = b; }
519 bool getNeedMore() const { return mbNeedMore; }
520
521 void createProgressBar()
522 {
523 ScProgress::CreateInterpretProgress(&mrDoc, false);
524 mbProgress = true;
525 }
526
527 bool hasProgressBar() const { return mbProgress; }
528
529 ScStyleSheetPool* getStylePool() { return mpStylePool; }
530 };
531
532 }
533
534 bool ScDocument::IdleCalcTextWidth() // true = try next again
535 {
536 // #i75610# if a printer hasn't been set or created yet, don't create one for this
537 if (!mbIdleEnabled || IsInLinkUpdate() || GetPrinter(false) == nullptr)
538 return false;
539
540 IdleCalcTextWidthScope aScope(*this, aCurTextWidthCalcPos);
541
542 if (!ValidRow(aScope.Row()))
543 {
544 aScope.setRow(0);
545 aScope.incCol(-1);
546 }
547
548 if (aScope.Col() < 0)
549 {
550 aScope.setCol(MaxCol());
551 aScope.incTab();
552 }
553
554 if (!HasTable(aScope.Tab()))
555 aScope.setTab(0);
556
557 ScTable* pTab = maTabs[aScope.Tab()].get();
558 ScStyleSheet* pStyle = static_cast<ScStyleSheet*>(aScope.getStylePool()->Find(pTab->aPageStyle, SfxStyleFamily::Page));
559 OSL_ENSURE( pStyle, "Missing StyleSheet :-/" );
560
561 if (!pStyle || getScaleValue(*pStyle, ATTR_PAGE_SCALETOPAGES) == 0)
562 {
563 // Move to the next sheet as the current one has scale-to-pages set,
564 // and bail out.
565 aScope.incTab();
566 return false;
567 }
568
569 sal_uInt16 nZoom = getScaleValue(*pStyle, ATTR_PAGE_SCALE);
570 Fraction aZoomFract(nZoom, 100);
571
572 aScope.setCol(pTab->ClampToAllocatedColumns(aScope.Col()));
573 // Start at specified cell position (nCol, nRow, nTab).
574 ScColumn* pCol = &pTab->aCol[aScope.Col()];
575 std::optional<ScColumnTextWidthIterator> pColIter(std::in_place, *this, *pCol, aScope.Row(), MaxRow());
576
577 OutputDevice* pDev = nullptr;
578 sal_uInt16 nRestart = 0;
579 sal_uInt16 nCount = 0;
580 while ( (nZoom > 0) && (nCount < CALCMAX) && (nRestart < 2) )
581 {
582 if (pColIter->hasCell())
583 {
584 // More cell in this column.
585 SCROW nRow = pColIter->getPos();
586 aScope.setRow(nRow);
587
588 if (pColIter->getValue() == TEXTWIDTH_DIRTY)
589 {
590 // Calculate text width for this cell.
591 double nPPTX = 0.0;
592 double nPPTY = 0.0;
593 if (!pDev)
594 {
595 pDev = GetPrinter();
596 assert(pDev);
597 aScope.setOldMapMode(pDev->GetMapMode());
598 pDev->SetMapMode(MapMode(MapUnit::MapPixel)); // Important for GetNeededSize
599
600 Point aPix1000 = pDev->LogicToPixel(Point(1000,1000), MapMode(MapUnit::MapTwip));
601 nPPTX = aPix1000.X() / 1000.0;
602 nPPTY = aPix1000.Y() / 1000.0;
603 }
604
605 if (!aScope.hasProgressBar() && pCol->IsFormulaDirty(nRow))
606 aScope.createProgressBar();
607
608 sal_uInt16 nNewWidth = static_cast<sal_uInt16>(GetNeededSize(
609 aScope.Col(), aScope.Row(), aScope.Tab(),
610 pDev, nPPTX, nPPTY, aZoomFract,aZoomFract, true, true)); // bTotalSize
611
612 pColIter->setValue(nNewWidth);
613 aScope.setNeedMore(true);
614 }
615 pColIter->next();
616 }
617 else
618 {
619 // No more cell in this column. Move to the left column and start at row 0.
620
621 bool bNewTab = false;
622
623 aScope.setRow(0);
624 aScope.incCol(-1);
625
626 if (aScope.Col() < 0)
627 {
628 // No more column to the left. Move to the right-most column of the next sheet.
629 aScope.setCol(MaxCol());
630 aScope.incTab();
631 bNewTab = true;
632 }
633
634 if (!HasTable(aScope.Tab()))
635 {
636 // Sheet doesn't exist at specified sheet position. Restart at sheet 0.
637 aScope.setTab(0);
638 nRestart++;
639 bNewTab = true;
640 }
641
642 if ( nRestart < 2 )
643 {
644 if ( bNewTab )
645 {
646 pTab = maTabs[aScope.Tab()].get();
647 aScope.setCol(pTab->ClampToAllocatedColumns(aScope.Col()));
648 pStyle = static_cast<ScStyleSheet*>(aScope.getStylePool()->Find(
649 pTab->aPageStyle, SfxStyleFamily::Page));
650
651 if ( pStyle )
652 {
653 // Check if the scale-to-pages setting is set. If
654 // set, we exit the loop. If not, get the page
655 // scale factor of the new sheet.
656 if (getScaleValue(*pStyle, ATTR_PAGE_SCALETOPAGES) == 0)
657 {
658 nZoom = getScaleValue(*pStyle, ATTR_PAGE_SCALE);
659 aZoomFract = Fraction(nZoom, 100);
660 }
661 else
662 nZoom = 0;
663 }
664 else
665 {
666 OSL_FAIL( "Missing StyleSheet :-/" );
667 }
668 }
669
670 if ( nZoom > 0 )
671 {
672 pCol = &pTab->aCol[aScope.Col()];
673 pColIter.emplace(*this, *pCol, aScope.Row(), MaxRow());
674 }
675 else
676 {
677 aScope.incTab(); // Move to the next sheet as the current one has scale-to-pages set.
678 return false;
679 }
680 }
681 }
682
683 ++nCount;
684
685 if (!aScope.continueIter())
686 break;
687 }
688
689 return aScope.getNeedMore();
690 }
691
692 void ScDocument::RepaintRange( const ScRange& rRange )
693 {
694 if ( bIsVisible && mpShell )
695 {
696 ScModelObj* pModel = mpShell->GetModel();
697 if ( pModel )
698 pModel->RepaintRange( rRange ); // locked repaints are checked there
699 }
700 }
701
702 void ScDocument::RepaintRange( const ScRangeList& rRange )
703 {
704 if ( bIsVisible && mpShell )
705 {
706 ScModelObj* pModel = mpShell->GetModel();
707 if ( pModel )
708 pModel->RepaintRange( rRange ); // locked repaints are checked there
709 }
710 }
711
712 void ScDocument::SaveDdeLinks(SvStream& rStream) const
713 {
714 // when 4.0-Export, remove all with mode != DEFAULT
715 bool bExport40 = ( rStream.GetVersion() <= SOFFICE_FILEFORMAT_40 );
716
717 const ::sfx2::SvBaseLinks& rLinks = GetLinkManager()->GetLinks();
718 sal_uInt16 nCount = rLinks.size();
719
720 // Count them first
721
722 sal_uInt16 nDdeCount = 0;
723 sal_uInt16 i;
724 for (i=0; i<nCount; i++)
725 {
726 ::sfx2::SvBaseLink* pBase = rLinks[i].get();
727 if (ScDdeLink* pLink = dynamic_cast<ScDdeLink*>(pBase))
728 if ( !bExport40 || pLink->GetMode() == SC_DDE_DEFAULT )
729 ++nDdeCount;
730 }
731
732 // Header
733
734 ScMultipleWriteHeader aHdr( rStream );
735 rStream.WriteUInt16( nDdeCount );
736
737 // Save links
738
739 for (i=0; i<nCount; i++)
740 {
741 ::sfx2::SvBaseLink* pBase = rLinks[i].get();
742 if (ScDdeLink* pLink = dynamic_cast<ScDdeLink*>(pBase))
743 {
744 if ( !bExport40 || pLink->GetMode() == SC_DDE_DEFAULT )
745 pLink->Store( rStream, aHdr );
746 }
747 }
748 }
749
750 void ScDocument::LoadDdeLinks(SvStream& rStream)
751 {
752 sfx2::LinkManager* pMgr = GetDocLinkManager().getLinkManager(bAutoCalc);
753 if (!pMgr)
754 return;
755
756 ScMultipleReadHeader aHdr( rStream );
757
758 sal_uInt16 nCount(0);
759 rStream.ReadUInt16( nCount );
760
761 const rtl_TextEncoding eCharSet = rStream.GetStreamCharSet();
762 const size_t nMinStringSize = eCharSet == RTL_TEXTENCODING_UNICODE ? sizeof(sal_uInt32) : sizeof(sal_uInt16);
763 const size_t nMinRecordSize = 1 + nMinStringSize*3;
764 const size_t nMaxRecords = rStream.remainingSize() / nMinRecordSize;
765 if (nCount > nMaxRecords)
766 {
767 SAL_WARN("sc", "Parsing error: " << nMaxRecords <<
768 " max possible entries, but " << nCount << " claimed, truncating");
769 nCount = nMaxRecords;
770 }
771
772 for (sal_uInt16 i=0; i<nCount; ++i)
773 {
774 ScDdeLink* pLink = new ScDdeLink( *this, rStream, aHdr );
775 pMgr->InsertDDELink(pLink, pLink->GetAppl(), pLink->GetTopic(), pLink->GetItem());
776 }
777 }
778
779 void ScDocument::SetInLinkUpdate(bool bSet)
780 {
781 // called from TableLink and AreaLink
782
783 OSL_ENSURE( bInLinkUpdate != bSet, "SetInLinkUpdate twice" );
784 bInLinkUpdate = bSet;
785 }
786
787 bool ScDocument::IsInLinkUpdate() const
788 {
789 return bInLinkUpdate || IsInDdeLinkUpdate();
790 }
791
792 void ScDocument::UpdateExternalRefLinks(weld::Window* pWin)
793 {
794 if (!pExternalRefMgr)
795 return;
796
797 sfx2::LinkManager* pMgr = GetDocLinkManager().getLinkManager(bAutoCalc);
798 if (!pMgr)
799 return;
800
801 const ::sfx2::SvBaseLinks& rLinks = pMgr->GetLinks();
802 sal_uInt16 nCount = rLinks.size();
803
804 bool bAny = false;
805
806 // Collect all the external ref links first.
807 std::vector<ScExternalRefLink*> aRefLinks;
808 for (sal_uInt16 i = 0; i < nCount; ++i)
809 {
810 ::sfx2::SvBaseLink* pBase = rLinks[i].get();
811 ScExternalRefLink* pRefLink = dynamic_cast<ScExternalRefLink*>(pBase);
812 if (pRefLink)
813 aRefLinks.push_back(pRefLink);
814 }
815
816 weld::WaitObject aWaitSwitch(pWin);
817
818 pExternalRefMgr->enableDocTimer(false);
819 ScProgress aProgress(GetDocumentShell(), ScResId(SCSTR_UPDATE_EXTDOCS), aRefLinks.size(), true);
820 for (size_t i = 0, n = aRefLinks.size(); i < n; ++i)
821 {
822 aProgress.SetState(i+1);
823
824 ScExternalRefLink* pRefLink = aRefLinks[i];
825 if (pRefLink->Update())
826 {
827 bAny = true;
828 continue;
829 }
830
831 // Update failed. Notify the user.
832
833 OUString aFile;
834 sfx2::LinkManager::GetDisplayNames(pRefLink, nullptr, &aFile);
835 // Decode encoded URL for display friendliness.
836 INetURLObject aUrl(aFile,INetURLObject::EncodeMechanism::WasEncoded);
837 aFile = aUrl.GetMainURL(INetURLObject::DecodeMechanism::Unambiguous);
838
839 OUString sMessage = ScResId(SCSTR_EXTDOC_NOT_LOADED) +
840 "\n\n" +
841 aFile;
842 std::unique_ptr<weld::MessageDialog> xBox(Application::CreateMessageDialog(pWin,
843 VclMessageType::Warning, VclButtonsType::Ok,
844 sMessage));
845 xBox->run();
846 }
847
848 pExternalRefMgr->enableDocTimer(true);
849
850 if (!bAny)
851 return;
852
853 TrackFormulas();
854 mpShell->Broadcast( SfxHint(SfxHintId::ScDataChanged) );
855
856 // #i101960# set document modified, as in TrackTimeHdl for DDE links
857 if (!mpShell->IsModified())
858 {
859 mpShell->SetModified();
860 SfxBindings* pBindings = GetViewBindings();
861 if (pBindings)
862 {
863 pBindings->Invalidate( SID_SAVEDOC );
864 pBindings->Invalidate( SID_DOC_MODIFIED );
865 }
866 }
867 }
868
869 void ScDocument::CopyDdeLinks( ScDocument& rDestDoc ) const
870 {
871 if (bIsClip) // Create from Stream
872 {
873 if (pClipData)
874 {
875 pClipData->Seek(0);
876 rDestDoc.LoadDdeLinks(*pClipData);
877 }
878
879 return;
880 }
881
882 const sfx2::LinkManager* pMgr = GetDocLinkManager().getExistingLinkManager();
883 if (!pMgr)
884 return;
885
886 sfx2::LinkManager* pDestMgr = rDestDoc.GetDocLinkManager().getLinkManager(rDestDoc.bAutoCalc);
887 if (!pDestMgr)
888 return;
889
890 const sfx2::SvBaseLinks& rLinks = pMgr->GetLinks();
891 for (const auto & rLink : rLinks)
892 {
893 const sfx2::SvBaseLink* pBase = rLink.get();
894 if (const ScDdeLink* p = dynamic_cast<const ScDdeLink*>(pBase))
895 {
896 ScDdeLink* pNew = new ScDdeLink(rDestDoc, *p);
897 pDestMgr->InsertDDELink(
898 pNew, pNew->GetAppl(), pNew->GetTopic(), pNew->GetItem());
899 }
900 }
901 }
902
903 namespace {
904
905 /** Tries to find the specified DDE link.
906 @param pnDdePos (out-param) if not 0, the index of the DDE link is returned here
907 (does not include other links from link manager).
908 @return The DDE link, if it exists, otherwise 0. */
909 ScDdeLink* lclGetDdeLink(
910 const sfx2::LinkManager* pLinkManager,
911 std::u16string_view rAppl, std::u16string_view rTopic, std::u16string_view rItem, sal_uInt8 nMode,
912 size_t* pnDdePos = nullptr )
913 {
914 if( pLinkManager )
915 {
916 const ::sfx2::SvBaseLinks& rLinks = pLinkManager->GetLinks();
917 if( pnDdePos ) *pnDdePos = 0;
918 for( const auto& nLinks : rLinks )
919 {
920 if( ScDdeLink* pDdeLink = dynamic_cast<ScDdeLink*>( nLinks.get() ) )
921 {
922 if( (pDdeLink->GetAppl() == rAppl) &&
923 (pDdeLink->GetTopic() == rTopic) &&
924 (pDdeLink->GetItem() == rItem) &&
925 ((nMode == SC_DDE_IGNOREMODE) || (nMode == pDdeLink->GetMode())) )
926 return pDdeLink;
927 if( pnDdePos ) ++*pnDdePos;
928 }
929 }
930 }
931 return nullptr;
932 }
933
934 /** Returns a pointer to the specified DDE link.
935 @param nDdePos Index of the DDE link (does not include other links from link manager).
936 @return The DDE link, if it exists, otherwise 0. */
937 ScDdeLink* lclGetDdeLink( const sfx2::LinkManager* pLinkManager, size_t nDdePos )
938 {
939 if( pLinkManager )
940 {
941 size_t nDdeIndex = 0; // counts only the DDE links
942 for( const auto& pLink : pLinkManager->GetLinks() )
943 {
944 if( ScDdeLink* pDdeLink = dynamic_cast<ScDdeLink*>( pLink.get() ) )
945 {
946 if( nDdeIndex == nDdePos )
947 return pDdeLink;
948 ++nDdeIndex;
949 }
950 }
951 }
952 return nullptr;
953 }
954
955 } // namespace
956
957 bool ScDocument::FindDdeLink( std::u16string_view rAppl, std::u16string_view rTopic, std::u16string_view rItem,
958 sal_uInt8 nMode, size_t& rnDdePos )
959 {
960 return lclGetDdeLink( GetLinkManager(), rAppl, rTopic, rItem, nMode, &rnDdePos ) != nullptr;
961 }
962
963 bool ScDocument::GetDdeLinkData( size_t nDdePos, OUString& rAppl, OUString& rTopic, OUString& rItem ) const
964 {
965 if( const ScDdeLink* pDdeLink = lclGetDdeLink( GetLinkManager(), nDdePos ) )
966 {
967 rAppl = pDdeLink->GetAppl();
968 rTopic = pDdeLink->GetTopic();
969 rItem = pDdeLink->GetItem();
970 return true;
971 }
972 return false;
973 }
974
975 bool ScDocument::GetDdeLinkMode( size_t nDdePos, sal_uInt8& rnMode ) const
976 {
977 if( const ScDdeLink* pDdeLink = lclGetDdeLink( GetLinkManager(), nDdePos ) )
978 {
979 rnMode = pDdeLink->GetMode();
980 return true;
981 }
982 return false;
983 }
984
985 const ScMatrix* ScDocument::GetDdeLinkResultMatrix( size_t nDdePos ) const
986 {
987 const ScDdeLink* pDdeLink = lclGetDdeLink( GetLinkManager(), nDdePos );
988 return pDdeLink ? pDdeLink->GetResult() : nullptr;
989 }
990
991 bool ScDocument::CreateDdeLink( const OUString& rAppl, const OUString& rTopic, const OUString& rItem, sal_uInt8 nMode, const ScMatrixRef& pResults )
992 {
993 /* Create a DDE link without updating it (i.e. for Excel import), to prevent
994 unwanted connections. First try to find existing link. Set result array
995 on existing and new links. */
996 //TODO: store DDE links additionally at document (for efficiency)?
997 OSL_ENSURE( nMode != SC_DDE_IGNOREMODE, "ScDocument::CreateDdeLink - SC_DDE_IGNOREMODE not allowed here" );
998
999 sfx2::LinkManager* pMgr = GetDocLinkManager().getLinkManager(bAutoCalc);
1000 if (!pMgr)
1001 return false;
1002
1003 if (nMode != SC_DDE_IGNOREMODE)
1004 {
1005 ScDdeLink* pDdeLink = lclGetDdeLink(pMgr, rAppl, rTopic, rItem, nMode);
1006 if( !pDdeLink )
1007 {
1008 // create a new DDE link, but without TryUpdate
1009 pDdeLink = new ScDdeLink( *this, rAppl, rTopic, rItem, nMode );
1010 pMgr->InsertDDELink(pDdeLink, rAppl, rTopic, rItem);
1011 }
1012
1013 // insert link results
1014 if( pResults )
1015 pDdeLink->SetResult( pResults );
1016
1017 return true;
1018 }
1019 return false;
1020 }
1021
1022 bool ScDocument::SetDdeLinkResultMatrix( size_t nDdePos, const ScMatrixRef& pResults )
1023 {
1024 if( ScDdeLink* pDdeLink = lclGetDdeLink( GetLinkManager(), nDdePos ) )
1025 {
1026 pDdeLink->SetResult( pResults );
1027 return true;
1028 }
1029 return false;
1030 }
1031
1032 bool ScDocument::HasAreaLinks() const
1033 {
1034 const sfx2::LinkManager* pMgr = GetDocLinkManager().getExistingLinkManager();
1035 if (!pMgr)
1036 return false;
1037
1038 const ::sfx2::SvBaseLinks& rLinks = pMgr->GetLinks();
1039 sal_uInt16 nCount = rLinks.size();
1040 for (sal_uInt16 i=0; i<nCount; i++)
1041 if (nullptr != dynamic_cast<const ScAreaLink* >(rLinks[i].get()))
1042 return true;
1043
1044 return false;
1045 }
1046
1047 void ScDocument::UpdateAreaLinks()
1048 {
1049 sfx2::LinkManager* pMgr = GetDocLinkManager().getLinkManager(false);
1050 if (!pMgr)
1051 return;
1052
1053 const ::sfx2::SvBaseLinks& rLinks = pMgr->GetLinks();
1054 for (const auto & rLink : rLinks)
1055 {
1056 ::sfx2::SvBaseLink* pBase = rLink.get();
1057 if (dynamic_cast<const ScAreaLink*>( pBase) != nullptr)
1058 pBase->Update();
1059 }
1060 }
1061
1062 void ScDocument::DeleteAreaLinksOnTab( SCTAB nTab )
1063 {
1064 sfx2::LinkManager* pMgr = GetDocLinkManager().getLinkManager(false);
1065 if (!pMgr)
1066 return;
1067
1068 const ::sfx2::SvBaseLinks& rLinks = pMgr->GetLinks();
1069 sfx2::SvBaseLinks::size_type nPos = 0;
1070 while ( nPos < rLinks.size() )
1071 {
1072 const ::sfx2::SvBaseLink* pBase = rLinks[nPos].get();
1073 const ScAreaLink* pLink = dynamic_cast<const ScAreaLink*>(pBase);
1074 if (pLink && pLink->GetDestArea().aStart.Tab() == nTab)
1075 pMgr->Remove(nPos);
1076 else
1077 ++nPos;
1078 }
1079 }
1080
1081 void ScDocument::UpdateRefAreaLinks( UpdateRefMode eUpdateRefMode,
1082 const ScRange& rRange, SCCOL nDx, SCROW nDy, SCTAB nDz )
1083 {
1084 sfx2::LinkManager* pMgr = GetDocLinkManager().getLinkManager(false);
1085 if (!pMgr)
1086 return;
1087
1088 bool bAnyUpdate = false;
1089
1090 const ::sfx2::SvBaseLinks& rLinks = pMgr->GetLinks();
1091 sal_uInt16 nCount = rLinks.size();
1092 for (sal_uInt16 i=0; i<nCount; i++)
1093 {
1094 ::sfx2::SvBaseLink* pBase = rLinks[i].get();
1095 if (ScAreaLink* pLink = dynamic_cast<ScAreaLink*>(pBase))
1096 {
1097 ScRange aOutRange = pLink->GetDestArea();
1098
1099 SCCOL nCol1 = aOutRange.aStart.Col();
1100 SCROW nRow1 = aOutRange.aStart.Row();
1101 SCTAB nTab1 = aOutRange.aStart.Tab();
1102 SCCOL nCol2 = aOutRange.aEnd.Col();
1103 SCROW nRow2 = aOutRange.aEnd.Row();
1104 SCTAB nTab2 = aOutRange.aEnd.Tab();
1105
1106 ScRefUpdateRes eRes =
1107 ScRefUpdate::Update( this, eUpdateRefMode,
1108 rRange.aStart.Col(), rRange.aStart.Row(), rRange.aStart.Tab(),
1109 rRange.aEnd.Col(), rRange.aEnd.Row(), rRange.aEnd.Tab(), nDx, nDy, nDz,
1110 nCol1, nRow1, nTab1, nCol2, nRow2, nTab2 );
1111 if ( eRes != UR_NOTHING )
1112 {
1113 pLink->SetDestArea( ScRange( nCol1, nRow1, nTab1, nCol2, nRow2, nTab2 ) );
1114 bAnyUpdate = true;
1115 }
1116 }
1117 }
1118
1119 if ( !bAnyUpdate )
1120 return;
1121
1122 // #i52120# Look for duplicates (after updating all positions).
1123 // If several links start at the same cell, the one with the lower index is removed
1124 // (file format specifies only one link definition for a cell).
1125
1126 sal_uInt16 nFirstIndex = 0;
1127 while ( nFirstIndex < nCount )
1128 {
1129 bool bFound = false;
1130 ::sfx2::SvBaseLink* pFirst = rLinks[nFirstIndex].get();
1131 if (ScAreaLink* pFirstLink = dynamic_cast<ScAreaLink*>(pFirst))
1132 {
1133 ScAddress aFirstPos = pFirstLink->GetDestArea().aStart;
1134 for ( sal_uInt16 nSecondIndex = nFirstIndex + 1; nSecondIndex < nCount && !bFound; ++nSecondIndex )
1135 {
1136 ::sfx2::SvBaseLink* pSecond = rLinks[nSecondIndex].get();
1137 ScAreaLink* pSecondLink = dynamic_cast<ScAreaLink*>(pSecond);
1138 if (pSecondLink && pSecondLink->GetDestArea().aStart == aFirstPos)
1139 {
1140 // remove the first link, exit the inner loop, don't increment nFirstIndex
1141 pMgr->Remove(pFirst);
1142 nCount = rLinks.size();
1143 bFound = true;
1144 }
1145 }
1146 }
1147 if (!bFound)
1148 ++nFirstIndex;
1149 }
1150 }
1151
1152 void ScDocument::CheckLinkFormulaNeedingCheck( const ScTokenArray& rCode )
1153 {
1154 if (HasLinkFormulaNeedingCheck())
1155 return;
1156
1157 // Prefer RPN over tokenized formula if available.
1158 if (rCode.GetCodeLen())
1159 {
1160 if (rCode.HasOpCodeRPN(ocDde) || rCode.HasOpCodeRPN(ocWebservice))
1161 SetLinkFormulaNeedingCheck(true);
1162 }
1163 else if (rCode.GetLen())
1164 {
1165 if (rCode.HasOpCode(ocDde) || rCode.HasOpCode(ocWebservice))
1166 SetLinkFormulaNeedingCheck(true);
1167 }
1168 else
1169 {
1170 // Possible with named expression without expression like Excel
1171 // internal print ranges, obscure user define names, ... formula error
1172 // cells without formula ...
1173 SAL_WARN("sc.core","ScDocument::CheckLinkFormulaNeedingCheck - called with empty ScTokenArray");
1174 }
1175 }
1176
1177 // TimerDelays etc.
1178 void ScDocument::KeyInput()
1179 {
1180 if ( pChartListenerCollection->hasListeners() )
1181 pChartListenerCollection->StartTimer();
1182 if (apTemporaryChartLock)
1183 apTemporaryChartLock->StartOrContinueLocking();
1184 }
1185
1186 SfxBindings* ScDocument::GetViewBindings()
1187 {
1188 // used to invalidate slots after changes to this document
1189
1190 if ( !mpShell )
1191 return nullptr; // no ObjShell -> no view
1192
1193 // first check current view
1194 SfxViewFrame* pViewFrame = SfxViewFrame::Current();
1195 if ( pViewFrame && pViewFrame->GetObjectShell() != mpShell ) // wrong document?
1196 pViewFrame = nullptr;
1197
1198 // otherwise use first view for this doc
1199 if ( !pViewFrame )
1200 pViewFrame = SfxViewFrame::GetFirst( mpShell );
1201
1202 if (pViewFrame)
1203 return &pViewFrame->GetBindings();
1204 else
1205 return nullptr;
1206 }
1207
1208 void ScDocument::TransliterateText( const ScMarkData& rMultiMark, TransliterationFlags nType )
1209 {
1210 OSL_ENSURE( rMultiMark.IsMultiMarked(), "TransliterateText: no selection" );
1211
1212 utl::TransliterationWrapper aTransliterationWrapper( comphelper::getProcessComponentContext(), nType );
1213 bool bConsiderLanguage = aTransliterationWrapper.needLanguageForTheMode();
1214 LanguageType nLanguage = LANGUAGE_SYSTEM;
1215
1216 std::unique_ptr<ScEditEngineDefaulter> pEngine; // not using mpEditEngine member because of defaults
1217
1218 SCTAB nCount = GetTableCount();
1219 for (const SCTAB& nTab : rMultiMark)
1220 {
1221 if (nTab >= nCount)
1222 break;
1223
1224 if ( maTabs[nTab] )
1225 {
1226 SCCOL nCol = 0;
1227 SCROW nRow = 0;
1228
1229 bool bFound = rMultiMark.IsCellMarked( nCol, nRow );
1230 if (!bFound)
1231 bFound = GetNextMarkedCell( nCol, nRow, nTab, rMultiMark );
1232
1233 while (bFound)
1234 {
1235 ScRefCellValue aCell(*this, ScAddress(nCol, nRow, nTab));
1236
1237 // fdo#32786 TITLE_CASE/SENTENCE_CASE need the extra handling in EditEngine (loop over words/sentences).
1238 // Still use TransliterationWrapper directly for text cells with other transliteration types,
1239 // for performance reasons.
1240 if (aCell.getType() == CELLTYPE_EDIT ||
1241 (aCell.getType() == CELLTYPE_STRING &&
1242 ( nType == TransliterationFlags::SENTENCE_CASE || nType == TransliterationFlags::TITLE_CASE)))
1243 {
1244 if (!pEngine)
1245 pEngine.reset(new ScFieldEditEngine(this, GetEnginePool(), GetEditPool()));
1246
1247 // defaults from cell attributes must be set so right language is used
1248 const ScPatternAttr* pPattern = GetPattern( nCol, nRow, nTab );
1249 auto pDefaults = std::make_unique<SfxItemSet>( pEngine->GetEmptyItemSet() );
1250 if ( ScStyleSheet* pPreviewStyle = GetPreviewCellStyle( nCol, nRow, nTab ) )
1251 {
1252 ScPatternAttr aPreviewPattern( *pPattern );
1253 aPreviewPattern.SetStyleSheet(pPreviewStyle);
1254 aPreviewPattern.FillEditItemSet(pDefaults.get());
1255 }
1256 else
1257 {
1258 SfxItemSet* pFontSet = GetPreviewFont( nCol, nRow, nTab );
1259 pPattern->FillEditItemSet(pDefaults.get(), pFontSet);
1260 }
1261 pEngine->SetDefaults(std::move(pDefaults));
1262 if (aCell.getType() == CELLTYPE_STRING)
1263 pEngine->SetTextCurrentDefaults(aCell.getSharedString()->getString());
1264 else if (aCell.getEditText())
1265 pEngine->SetTextCurrentDefaults(*aCell.getEditText());
1266
1267 pEngine->ClearModifyFlag();
1268
1269 sal_Int32 nLastPar = pEngine->GetParagraphCount();
1270 if (nLastPar)
1271 --nLastPar;
1272 sal_Int32 nTxtLen = pEngine->GetTextLen(nLastPar);
1273 ESelection aSelAll( 0, 0, nLastPar, nTxtLen );
1274
1275 pEngine->TransliterateText( aSelAll, nType );
1276
1277 if ( pEngine->IsModified() )
1278 {
1279 ScEditAttrTester aTester( pEngine.get() );
1280 if ( aTester.NeedsObject() )
1281 {
1282 // remove defaults (paragraph attributes) before creating text object
1283 pEngine->SetDefaults(pEngine->GetEmptyItemSet());
1284
1285 // The cell will take ownership of the text object instance.
1286 SetEditText(ScAddress(nCol,nRow,nTab), pEngine->CreateTextObject());
1287 }
1288 else
1289 {
1290 ScSetStringParam aParam;
1291 aParam.setTextInput();
1292 SetString(ScAddress(nCol,nRow,nTab), pEngine->GetText(), &aParam);
1293 }
1294 }
1295 }
1296
1297 else if (aCell.getType() == CELLTYPE_STRING)
1298 {
1299 OUString aOldStr = aCell.getSharedString()->getString();
1300 sal_Int32 nOldLen = aOldStr.getLength();
1301
1302 if ( bConsiderLanguage )
1303 {
1304 SvtScriptType nScript = GetStringScriptType( aOldStr ); //TODO: cell script type?
1305 sal_uInt16 nWhich = ( nScript == SvtScriptType::ASIAN ) ? ATTR_CJK_FONT_LANGUAGE :
1306 ( ( nScript == SvtScriptType::COMPLEX ) ? ATTR_CTL_FONT_LANGUAGE :
1307 ATTR_FONT_LANGUAGE );
1308 nLanguage = static_cast<const SvxLanguageItem*>(GetAttr( nCol, nRow, nTab, nWhich ))->GetValue();
1309 }
1310
1311 uno::Sequence<sal_Int32> aOffsets;
1312 OUString aNewStr = aTransliterationWrapper.transliterate( aOldStr, nLanguage, 0, nOldLen, &aOffsets );
1313
1314 if ( aNewStr != aOldStr )
1315 {
1316 ScSetStringParam aParam;
1317 aParam.setTextInput();
1318 SetString(ScAddress(nCol,nRow,nTab), aNewStr, &aParam);
1319 }
1320 }
1321 bFound = GetNextMarkedCell( nCol, nRow, nTab, rMultiMark );
1322 }
1323 }
1324 }
1325 }
1326
1327 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE