1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*/
#include <cliputil.hxx>
#include <attrib.hxx>
#include <viewdata.hxx>
#include <tabvwsh.hxx>
#include <transobj.hxx>
#include <document.hxx>
#include <dpobject.hxx>
#include <globstr.hrc>
#include <clipparam.hxx>
#include <clipoptions.hxx>
#include <rangelst.hxx>
#include <viewutil.hxx>
#include <markdata.hxx>
#include <gridwin.hxx>
#include <scitems.hxx>
#include <sfx2/classificationhelper.hxx>
#include <comphelper/lok.hxx>
namespace
{
/// Paste only if SfxClassificationHelper recommends so.
bool lcl_checkClassification(ScDocument* pSourceDoc, const ScDocument& rDestinationDoc)
{
if (!pSourceDoc)
return true;
ScClipOptions* pSourceOptions = pSourceDoc->GetClipOptions();
SfxObjectShell* pDestinationShell = rDestinationDoc.GetDocumentShell();
if (!pSourceOptions || !pDestinationShell)
return true;
SfxClassificationCheckPasteResult eResult = SfxClassificationHelper::CheckPaste(pSourceOptions->m_xDocumentProperties, pDestinationShell->getDocProperties());
return SfxClassificationHelper::ShowPasteInfo(eResult);
}
}
void ScClipUtil::PasteFromClipboard( ScViewData& rViewData, ScTabViewShell* pTabViewShell, bool bShowDialog )
{
const ScTransferObj* pOwnClip = ScTransferObj::GetOwnClipboard(ScTabViewShell::GetClipData(rViewData.GetActiveWin()));
ScDocument& rThisDoc = rViewData.GetDocument();
SCCOL nThisCol = rViewData.GetCurX();
SCROW nThisRow = rViewData.GetCurY();
SCTAB nThisTab = rViewData.GetTabNo();
ScDPObject* pDPObj = rThisDoc.GetDPAtCursor( nThisCol, nThisRow, nThisTab );
if ( pOwnClip && pDPObj )
{
// paste from Calc into DataPilot table: sort (similar to drag & drop)
ScDocument* pClipDoc = pOwnClip->GetDocument();
SCTAB nSourceTab = pOwnClip->GetVisibleTab();
SCCOL nClipStartX;
SCROW nClipStartY;
SCCOL nClipEndX;
SCROW nClipEndY;
pClipDoc->GetClipStart( nClipStartX, nClipStartY );
pClipDoc->GetClipArea( nClipEndX, nClipEndY, true );
nClipEndX = nClipEndX + nClipStartX;
nClipEndY = nClipEndY + nClipStartY; // GetClipArea returns the difference
ScRange aSource( nClipStartX, nClipStartY, nSourceTab, nClipEndX, nClipEndY, nSourceTab );
bool bDone = pTabViewShell->DataPilotMove( aSource, rViewData.GetCurPos() );
if ( !bDone )
pTabViewShell->ErrorMessage( STR_ERR_DATAPILOT_INPUT );
}
else
{
// normal paste
weld::WaitObject aWait( rViewData.GetDialogParent() );
if (!pOwnClip)
pTabViewShell->PasteFromSystem();
else
{
ScDocument* pClipDoc = pOwnClip->GetDocument();
InsertDeleteFlags nFlags = InsertDeleteFlags::ALL;
if (pClipDoc->GetClipParam().isMultiRange())
// For multi-range paste, we paste values by default.
nFlags &= ~InsertDeleteFlags::FORMULA;
if (lcl_checkClassification(pClipDoc, rThisDoc))
pTabViewShell->PasteFromClip( nFlags, pClipDoc,
ScPasteFunc::NONE, false, false, false, INS_NONE, InsertDeleteFlags::NONE,
bShowDialog ); // allow warning dialog
}
}
if (comphelper::LibreOfficeKit::isActive())
{
bool entireColumnOrRowSelected = false;
if (pOwnClip)
{
ScClipParam clipParam = pOwnClip->GetDocument()->GetClipParam();
if (clipParam.maRanges.size() > 0)
{
if (clipParam.maRanges[0].aEnd.Col() == pOwnClip->GetDocument()->MaxCol()
|| clipParam.maRanges[0].aEnd.Row() == pOwnClip->GetDocument()->MaxRow())
{
entireColumnOrRowSelected = true;
}
}
}
const SfxBoolItem* pItem = rThisDoc.GetAttr(nThisCol, nThisRow, nThisTab, ATTR_LINEBREAK);
if (pItem->GetValue() || entireColumnOrRowSelected)
{
ScTabViewShell::notifyAllViewsSheetGeomInvalidation(
pTabViewShell, true /* bColumns */, true /* bRows */, true /* bSizes*/,
true /* bHidden */, true /* bFiltered */, true /* bGroups */, nThisTab);
}
}
pTabViewShell->CellContentChanged(); // => PasteFromSystem() ???
}
bool ScClipUtil::CheckDestRanges(
const ScDocument& rDoc, SCCOL nSrcCols, SCROW nSrcRows, const ScMarkData& rMark, const ScRangeList& rDest)
{
for (size_t i = 0, n = rDest.size(); i < n; ++i)
{
ScRange aTest = rDest[i];
// Check for filtered rows in all selected sheets.
for (const auto& rTab : rMark)
{
aTest.aStart.SetTab(rTab);
aTest.aEnd.SetTab(rTab);
if (ScViewUtil::HasFiltered(aTest, rDoc))
{
// I don't know how to handle pasting into filtered rows yet.
return false;
}
}
// Destination range must be an exact multiple of the source range.
SCROW nRows = aTest.aEnd.Row() - aTest.aStart.Row() + 1;
SCCOL nCols = aTest.aEnd.Col() - aTest.aStart.Col() + 1;
SCROW nRowTest = (nRows / nSrcRows) * nSrcRows;
SCCOL nColTest = (nCols / nSrcCols) * nSrcCols;
if ( rDest.size() > 1 && ( nRows != nRowTest || nCols != nColTest ) )
{
// Destination range is not a multiple of the source range. Bail out.
return false;
}
}
return true;
}
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
