?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
nss: upgrade to release 3.73
[LibreOffice.git] / sc / qa / unit / copy_paste_test.cxx
blob6c91afad30ea8cdd6a8ceff55d1baa6b2d955e8b
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
10 #include <sal/config.h>
11 #include <test/bootstrapfixture.hxx>
12 #include <comphelper/processfactory.hxx>
13
14 #include <docsh.hxx>
15 #include <docfunc.hxx>
16 #include <cellmergeoption.hxx>
17 #include <tabvwsh.hxx>
18 #include <impex.hxx>
19 #include <viewfunc.hxx>
20 #include <scitems.hxx>
21 #include <attrib.hxx>
22 #include <userlist.hxx>
23
24 #include <com/sun/star/frame/Desktop.hpp>
25 #include <com/sun/star/frame/XModel2.hpp>
26
27 #include "helper/qahelper.hxx"
28
29 using namespace ::com::sun::star;
30 using namespace ::com::sun::star::uno;
31
32 class ScCopyPasteTest : public ScBootstrapFixture
33 {
34 public:
35 ScCopyPasteTest();
36
37 virtual void setUp() override;
38 virtual void tearDown() override;
39
40 void testCopyPasteXLS();
41 void testTdf84411();
42 void testTdf124565();
43 void testTdf126421();
44 void testTdf107394();
45 void testTdf53431_fillOnAutofilter();
46 void testTdf40993_fillMergedCells();
47 void testTdf43958_clickSelectOnMergedCells();
48 void testTdf88782_autofillLinearNumbersInMergedCells();
49 void tdf137621_autofillMergedBool();
50 void tdf137205_autofillDatesInMergedCells();
51 void tdf137653_137654_autofillUserlist();
52 void tdf113500_autofillMixed();
53 void tdf137625_autofillMergedUserlist();
54 void tdf137624_autofillMergedMixed();
55
56 CPPUNIT_TEST_SUITE(ScCopyPasteTest);
57 CPPUNIT_TEST(testCopyPasteXLS);
58 CPPUNIT_TEST(testTdf84411);
59 CPPUNIT_TEST(testTdf124565);
60 CPPUNIT_TEST(testTdf126421);
61 CPPUNIT_TEST(testTdf107394);
62 CPPUNIT_TEST(testTdf53431_fillOnAutofilter);
63 CPPUNIT_TEST(testTdf40993_fillMergedCells);
64 CPPUNIT_TEST(testTdf43958_clickSelectOnMergedCells);
65 CPPUNIT_TEST(testTdf88782_autofillLinearNumbersInMergedCells);
66 CPPUNIT_TEST(tdf137621_autofillMergedBool);
67 CPPUNIT_TEST(tdf137205_autofillDatesInMergedCells);
68 CPPUNIT_TEST(tdf137653_137654_autofillUserlist);
69 CPPUNIT_TEST(tdf113500_autofillMixed);
70 CPPUNIT_TEST(tdf137625_autofillMergedUserlist);
71 CPPUNIT_TEST(tdf137624_autofillMergedMixed);
72 CPPUNIT_TEST_SUITE_END();
73
74 private:
75
76 ScDocShellRef loadDocAndSetupModelViewController(const OUString& rFileName, sal_Int32 nFormat, bool bReadWrite);
77 void addToUserList(const OUString& rStr);
78 uno::Reference<uno::XInterface> m_xCalcComponent;
79 };
80
81 // tdf#83366
82 void ScCopyPasteTest::testCopyPasteXLS()
83 {
84 uno::Reference< frame::XDesktop2 > xDesktop = frame::Desktop::create(::comphelper::getProcessComponentContext());
85 CPPUNIT_ASSERT( xDesktop.is() );
86
87 // create a frame
88 Reference< frame::XFrame > xTargetFrame = xDesktop->findFrame( "_blank", 0 );
89 CPPUNIT_ASSERT( xTargetFrame.is() );
90
91 // 1. Open the document
92 ScDocShellRef xDocSh = loadDoc("chartx2.", FORMAT_XLS);
93 CPPUNIT_ASSERT_MESSAGE("Failed to load chartx2.xls.", xDocSh.is());
94
95 uno::Reference< frame::XModel2 > xModel2 ( xDocSh->GetModel(), UNO_QUERY );
96 CPPUNIT_ASSERT( xModel2.is() );
97
98 Reference< frame::XController2 > xController = xModel2->createDefaultViewController( xTargetFrame );
99 CPPUNIT_ASSERT( xController.is() );
100
101 // introduce model/view/controller to each other
102 xController->attachModel( xModel2.get() );
103 xModel2->connectController( xController.get() );
104 xTargetFrame->setComponent( xController->getComponentWindow(), xController.get() );
105 xController->attachFrame( xTargetFrame );
106 xModel2->setCurrentController( xController.get() );
107
108 ScDocument& rDoc = xDocSh->GetDocument();
109
110 // Get the document controller
111 ScTabViewShell* pViewShell = xDocSh->GetBestViewShell(false);
112 CPPUNIT_ASSERT(pViewShell != nullptr);
113
114 // 2. Highlight B2:C5
115 ScRange aSrcRange;
116 ScRefFlags nRes = aSrcRange.Parse("B2:C5", rDoc, rDoc.GetAddressConvention());
117 CPPUNIT_ASSERT_MESSAGE("Failed to parse.", (nRes & ScRefFlags::VALID));
118
119 ScMarkData aMark(rDoc.GetSheetLimits());
120 aMark.SetMarkArea(aSrcRange);
121
122 pViewShell->GetViewData().GetMarkData().SetMarkArea(aSrcRange);
123
124 // 3. Copy
125 ScDocument aClipDoc(SCDOCMODE_CLIP);
126 pViewShell->GetViewData().GetView()->CopyToClip(&aClipDoc, false, false, false, false);
127
128 // 4. Close the document (Ctrl-W)
129 xDocSh->DoClose();
130
131 // 5. Create a new Spreadsheet
132 Sequence < beans::PropertyValue > args(1);
133 args[0].Name = "Hidden";
134 args[0].Value <<= true;
135
136 uno::Reference< lang::XComponent > xComponent = xDesktop->loadComponentFromURL(
137 "private:factory/scalc",
138 "_blank",
139 0,
140 args );
141 CPPUNIT_ASSERT( xComponent.is() );
142
143 // Get the document model
144 SfxObjectShell* pFoundShell = SfxObjectShell::GetShellFromComponent(xComponent);
145 CPPUNIT_ASSERT_MESSAGE("Failed to access document shell", pFoundShell);
146
147 xDocSh = dynamic_cast<ScDocShell*>(pFoundShell);
148 CPPUNIT_ASSERT(xDocSh);
149
150 // Get the document controller
151 pViewShell = xDocSh->GetBestViewShell(false);
152 CPPUNIT_ASSERT(pViewShell != nullptr);
153
154 // 6. Paste
155 pViewShell->GetViewData().GetView()->PasteFromClip(InsertDeleteFlags::ALL, &aClipDoc);
156
157 xComponent->dispose();
158 }
159
160 namespace {
161
162 ScMarkData::MarkedTabsType TabsInRange(const ScRange& r)
163 {
164 ScMarkData::MarkedTabsType aResult;
165 for (SCTAB i = r.aStart.Tab(); i <= r.aEnd.Tab(); ++i)
166 aResult.insert(i);
167 return aResult;
168 }
169
170 void lcl_copy( const OUString& rSrcRange, const OUString& rDstRange, ScDocument& rDoc, ScTabViewShell* pViewShell )
171 {
172 ScDocument aClipDoc(SCDOCMODE_CLIP);
173
174 // 1. Copy
175 ScRange aSrcRange;
176 ScRefFlags nRes = aSrcRange.Parse(rSrcRange, rDoc, rDoc.GetAddressConvention());
177 CPPUNIT_ASSERT_MESSAGE("Failed to parse.", (nRes & ScRefFlags::VALID));
178 pViewShell->GetViewData().GetMarkData().SetMarkArea(aSrcRange);
179 pViewShell->GetViewData().GetMarkData().SetSelectedTabs(TabsInRange(aSrcRange));
180 pViewShell->GetViewData().GetView()->CopyToClip(&aClipDoc, false, false, false, false);
181
182 // 2. Paste
183 ScRange aDstRange;
184 nRes = aDstRange.Parse(rDstRange, rDoc, rDoc.GetAddressConvention());
185 CPPUNIT_ASSERT_MESSAGE("Failed to parse.", (nRes & ScRefFlags::VALID));
186 pViewShell->GetViewData().GetMarkData().SetMarkArea(aDstRange);
187 pViewShell->GetViewData().GetMarkData().SetSelectedTabs(TabsInRange(aDstRange));
188 pViewShell->GetViewData().GetView()->PasteFromClip(InsertDeleteFlags::ALL, &aClipDoc);
189 }
190
191 } // anonymous namespace
192
193 void ScCopyPasteTest::testTdf84411()
194 {
195 uno::Reference< frame::XDesktop2 > xDesktop = frame::Desktop::create(::comphelper::getProcessComponentContext());
196 CPPUNIT_ASSERT( xDesktop.is() );
197
198 // create a frame
199 Reference< frame::XFrame > xTargetFrame = xDesktop->findFrame( "_blank", 0 );
200 CPPUNIT_ASSERT( xTargetFrame.is() );
201
202 // 1. Create spreadsheet
203 uno::Sequence< beans::PropertyValue > aEmptyArgList;
204 uno::Reference< lang::XComponent > xComponent = xDesktop->loadComponentFromURL(
205 "private:factory/scalc",
206 "_blank",
207 0,
208 aEmptyArgList );
209 CPPUNIT_ASSERT( xComponent.is() );
210
211 // Get the document model
212 SfxObjectShell* pFoundShell = SfxObjectShell::GetShellFromComponent(xComponent);
213 CPPUNIT_ASSERT_MESSAGE("Failed to access document shell", pFoundShell);
214
215 ScDocShellRef xDocSh = dynamic_cast<ScDocShell*>(pFoundShell);
216 CPPUNIT_ASSERT(xDocSh);
217
218 uno::Reference< frame::XModel2 > xModel2 ( xDocSh->GetModel(), UNO_QUERY );
219 CPPUNIT_ASSERT( xModel2.is() );
220
221 Reference< frame::XController2 > xController = xModel2->createDefaultViewController( xTargetFrame );
222 CPPUNIT_ASSERT( xController.is() );
223
224 // introduce model/view/controller to each other
225 xController->attachModel( xModel2.get() );
226 xModel2->connectController( xController.get() );
227 xTargetFrame->setComponent( xController->getComponentWindow(), xController.get() );
228 xController->attachFrame( xTargetFrame );
229 xModel2->setCurrentController( xController.get() );
230
231 ScDocument& rDoc = xDocSh->GetDocument();
232
233 // Get the document controller
234 ScTabViewShell* pViewShell = xDocSh->GetBestViewShell(false);
235 CPPUNIT_ASSERT(pViewShell != nullptr);
236
237
238 // 2. Setup data and formulas
239 for (unsigned int r = 0; r <= 4991; ++r)
240 for (unsigned int c = 0; c <= 14; ++c)
241 rDoc.SetValue( ScAddress(c,r,0), (r+1)*(c+1) );
242
243 rDoc.SetString(ScAddress(15,10000,0), "=AVERAGE(A10001:O10001)");
244 rDoc.SetString(ScAddress(16,10000,0), "=MIN(A10001:O10001)");
245 rDoc.SetString(ScAddress(17,10000,0), "=MAX(A10001:O10001)");
246
247 lcl_copy("P10001:R10001", "P10002:R12500", rDoc, pViewShell);
248
249
250 // 3. Disable OpenCL
251 ScModelObj* pModel = comphelper::getUnoTunnelImplementation<ScModelObj>(pFoundShell->GetModel());
252 CPPUNIT_ASSERT(pModel != nullptr);
253 bool bOpenCLState = ScCalcConfig::isOpenCLEnabled();
254 pModel->enableOpenCL(false);
255 CPPUNIT_ASSERT(!ScCalcConfig::isOpenCLEnabled() || ScCalcConfig::getForceCalculationType() == ForceCalculationOpenCL);
256 pModel->enableAutomaticCalculation(true);
257
258
259 // 4. Copy and Paste
260 lcl_copy("A1:O2500", "A10001:O12500", rDoc, pViewShell);
261
262 lcl_copy("A2501:O5000", "A12501:O15000", rDoc, pViewShell);
263
264 lcl_copy("P10001:R10001", "P12501:R15000", rDoc, pViewShell);
265
266
267 // 5. Close the document (Ctrl-W)
268 pModel->enableOpenCL(bOpenCLState);
269 xComponent->dispose();
270 }
271
272 void ScCopyPasteTest::testTdf124565()
273 {
274 // Create new document
275 ScDocShell* xDocSh = new ScDocShell(
276 SfxModelFlags::EMBEDDED_OBJECT |
277 SfxModelFlags::DISABLE_EMBEDDED_SCRIPTS |
278 SfxModelFlags::DISABLE_DOCUMENT_RECOVERY);
279 xDocSh->DoInitNew();
280
281 uno::Reference< frame::XDesktop2 > xDesktop = frame::Desktop::create(::comphelper::getProcessComponentContext());
282 CPPUNIT_ASSERT( xDesktop.is() );
283
284 Reference< frame::XFrame > xTargetFrame = xDesktop->findFrame( "_blank", 0 );
285 CPPUNIT_ASSERT( xTargetFrame.is() );
286
287 uno::Reference< frame::XModel2 > xModel2 ( xDocSh->GetModel(), UNO_QUERY );
288 CPPUNIT_ASSERT( xModel2.is() );
289
290 Reference< frame::XController2 > xController = xModel2->createDefaultViewController( xTargetFrame );
291 CPPUNIT_ASSERT( xController.is() );
292
293 // introduce model/view/controller to each other
294 xController->attachModel( xModel2.get() );
295 xModel2->connectController( xController.get() );
296 xTargetFrame->setComponent( xController->getComponentWindow(), xController.get() );
297 xController->attachFrame( xTargetFrame );
298 xModel2->setCurrentController( xController.get() );
299
300 ScDocument& rDoc = xDocSh->GetDocument();
301 ScTabViewShell* pViewShell = xDocSh->GetBestViewShell(false);
302 CPPUNIT_ASSERT(pViewShell != nullptr);
303
304 // Set content and height of first row
305 rDoc.SetString(ScAddress(0, 0, 0), "Test");
306 rDoc.SetRowHeight(0, 0, 500);
307 rDoc.SetManualHeight(0, 0, 0, true);
308
309 // Copy first row
310 ScDocument aClipDoc(SCDOCMODE_CLIP);
311 ScRange aCopyRange(0, 0, 0, aClipDoc.MaxCol(), 0, 0);
312 pViewShell->GetViewData().GetMarkData().SetMarkArea(aCopyRange);
313 pViewShell->GetViewData().GetView()->CopyToClip(&aClipDoc, false, false, false, false);
314
315 // Paste to second row
316 SCTAB nTab = 0;
317 SCCOL nCol = 0;
318 SCROW nRow = 1;
319
320 ScRange aPasteRange(nCol, nRow, nTab, aClipDoc.MaxCol(), nRow, nTab);
321 pViewShell->GetViewData().GetMarkData().SetMarkArea(aPasteRange);
322 pViewShell->GetViewData().GetView()->PasteFromClip(InsertDeleteFlags::ALL, &aClipDoc);
323
324 // Copy-pasted?
325 CPPUNIT_ASSERT_EQUAL_MESSAGE("String was not pasted!", OUString("Test"), rDoc.GetString(nCol, nRow, nTab));
326
327 // And height same as in source?
328 CPPUNIT_ASSERT_EQUAL_MESSAGE("Row#2 height is invalid!", sal_uInt16(500), rDoc.GetRowHeight(nRow, nTab));
329
330 CPPUNIT_ASSERT_MESSAGE("Row#2 must be manual height!", rDoc.IsManualRowHeight(nRow, nTab));
331
332 xDocSh->DoClose();
333 }
334
335 void ScCopyPasteTest::testTdf126421()
336 {
337 uno::Reference<frame::XDesktop2> xDesktop
338 = frame::Desktop::create(::comphelper::getProcessComponentContext());
339 CPPUNIT_ASSERT(xDesktop.is());
340
341 // create a frame
342 Reference<frame::XFrame> xTargetFrame = xDesktop->findFrame("_blank", 0);
343 CPPUNIT_ASSERT(xTargetFrame.is());
344
345 // 1. Create spreadsheet
346 uno::Sequence<beans::PropertyValue> aEmptyArgList;
347 uno::Reference<lang::XComponent> xComponent
348 = xDesktop->loadComponentFromURL("private:factory/scalc", "_blank", 0, aEmptyArgList);
349 CPPUNIT_ASSERT(xComponent.is());
350
351 // Get the document model
352 SfxObjectShell* pFoundShell = SfxObjectShell::GetShellFromComponent(xComponent);
353 CPPUNIT_ASSERT_MESSAGE("Failed to access document shell", pFoundShell);
354
355 ScDocShellRef xDocSh = dynamic_cast<ScDocShell*>(pFoundShell);
356 CPPUNIT_ASSERT(xDocSh);
357
358 uno::Reference<frame::XModel2> xModel2(xDocSh->GetModel(), UNO_QUERY);
359 CPPUNIT_ASSERT(xModel2.is());
360
361 Reference<frame::XController2> xController = xModel2->createDefaultViewController(xTargetFrame);
362 CPPUNIT_ASSERT(xController.is());
363
364 // introduce model/view/controller to each other
365 xController->attachModel(xModel2.get());
366 xModel2->connectController(xController.get());
367 xTargetFrame->setComponent(xController->getComponentWindow(), xController.get());
368 xController->attachFrame(xTargetFrame);
369 xModel2->setCurrentController(xController.get());
370
371 ScDocument& rDoc = xDocSh->GetDocument();
372
373 // Get the document controller
374 ScTabViewShell* pViewShell = xDocSh->GetBestViewShell(false);
375 CPPUNIT_ASSERT(pViewShell != nullptr);
376
377 // 2. Setup data
378 for (int r = 0; r < 2; ++r)
379 for (int c = 0; c < 1024; ++c)
380 rDoc.SetValue(c, r, 0, (c + 1) * 100 + (r + 1));
381
382 const SCTAB n2ndTab = rDoc.GetMaxTableNumber() + 1;
383 rDoc.MakeTable(n2ndTab);
384 const auto aTabNames = rDoc.GetAllTableNames();
385
386 lcl_copy(aTabNames[0] + ".A1:AMJ2", aTabNames[n2ndTab] + ".A1:AMJ2", rDoc, pViewShell);
387
388 // 3. Check all cells in destination table
389 for (int r = 0; r < 2; ++r)
390 for (int c = 0; c < 1024; ++c)
391 CPPUNIT_ASSERT_EQUAL(double((c + 1) * 100 + (r + 1)), rDoc.GetValue(c, r, n2ndTab));
392
393 xDocSh->DoClose();
394 }
395
396 void ScCopyPasteTest::testTdf107394()
397 {
398 uno::Reference<frame::XDesktop2> xDesktop
399 = frame::Desktop::create(::comphelper::getProcessComponentContext());
400 CPPUNIT_ASSERT(xDesktop.is());
401
402 uno::Reference<lang::XComponent> xComponent
403 = xDesktop->loadComponentFromURL("private:factory/scalc", "_blank", 0, {});
404 CPPUNIT_ASSERT(xComponent.is());
405
406 auto pModelObj = dynamic_cast<ScModelObj*>(xComponent.get());
407 CPPUNIT_ASSERT(pModelObj);
408 CPPUNIT_ASSERT(pModelObj->GetDocument());
409
410 ScDocument& rDoc = *pModelObj->GetDocument();
411
412 sal_uInt16 nFirstRowHeight = rDoc.GetRowHeight(0, 0);
413 sal_uInt16 nSecondRowHeight = rDoc.GetRowHeight(1, 0);
414 CPPUNIT_ASSERT_EQUAL(nFirstRowHeight, nSecondRowHeight);
415
416 // Import values to A1:A2.
417 ScImportExport aObj(rDoc, ScAddress(0,0,0));
418 aObj.SetImportBroadcast(true);
419
420 SvMemoryStream aStream;
421 aStream.WriteOString("<pre>First\nVery long sentence.</pre>");
422 aStream.Seek(0);
423 CPPUNIT_ASSERT(aObj.ImportStream(aStream, OUString(), SotClipboardFormatId::HTML));
424
425 CPPUNIT_ASSERT_EQUAL(OUString("First"), rDoc.GetString(ScAddress(0,0,0)));
426 CPPUNIT_ASSERT_EQUAL(OUString("Very long sentence."), rDoc.GetString(ScAddress(0,1,0)));
427
428 nFirstRowHeight = rDoc.GetRowHeight(0, 0);
429 nSecondRowHeight = rDoc.GetRowHeight(1, 0);
430 CPPUNIT_ASSERT_GREATER(nFirstRowHeight, nSecondRowHeight);
431
432 // Undo, and check the result.
433 SfxUndoManager* pUndoMgr = rDoc.GetUndoManager();
434 CPPUNIT_ASSERT_MESSAGE("Failed to get the undo manager.", pUndoMgr);
435 pUndoMgr->Undo();
436
437 CPPUNIT_ASSERT(rDoc.GetString(ScAddress(0,0,0)).isEmpty());
438 CPPUNIT_ASSERT(rDoc.GetString(ScAddress(0,1,0)).isEmpty());
439
440 nFirstRowHeight = rDoc.GetRowHeight(0, 0);
441 nSecondRowHeight = rDoc.GetRowHeight(1, 0);
442 // Without the accompanying fix in place, this test would have failed:
443 // - Expected: 256
444 // - Actual : 477
445 // i.e. the increased height of the second row remained after undo.
446 CPPUNIT_ASSERT_EQUAL(nFirstRowHeight, nSecondRowHeight);
447
448 xComponent->dispose();
449 }
450
451 static ScMF lcl_getMergeFlagOfCell(const ScDocument& rDoc, SCCOL nCol, SCROW nRow, SCTAB nTab)
452 {
453 const SfxPoolItem& rPoolItem = rDoc.GetPattern(nCol, nRow, nTab)->GetItem(ATTR_MERGE_FLAG);
454 const ScMergeFlagAttr& rMergeFlag = static_cast<const ScMergeFlagAttr&>(rPoolItem);
455 return rMergeFlag.GetValue();
456 }
457
458 static ScAddress lcl_getMergeSizeOfCell(const ScDocument& rDoc, SCCOL nCol, SCROW nRow, SCTAB nTab)
459 {
460 const SfxPoolItem& rPoolItem = rDoc.GetPattern(nCol, nRow, nTab)->GetItem(ATTR_MERGE);
461 const ScMergeAttr& rMerge = static_cast<const ScMergeAttr&>(rPoolItem);
462 return ScAddress(rMerge.GetColMerge(), rMerge.GetRowMerge(), nTab);
463 }
464
465 ScDocShellRef ScCopyPasteTest::loadDocAndSetupModelViewController(const OUString& rFileName, sal_Int32 nFormat, bool bReadWrite)
466 {
467 uno::Reference< frame::XDesktop2 > xDesktop = frame::Desktop::create(::comphelper::getProcessComponentContext());
468 CPPUNIT_ASSERT(xDesktop.is());
469
470 // create a frame
471 Reference< frame::XFrame > xTargetFrame = xDesktop->findFrame("_blank", 0);
472 CPPUNIT_ASSERT(xTargetFrame.is());
473
474 // 1. Open the document
475 ScDocShellRef xDocSh = loadDoc(rFileName, nFormat, bReadWrite);
476 CPPUNIT_ASSERT_MESSAGE(OString("Failed to load " + OUStringToOString(rFileName, RTL_TEXTENCODING_UTF8)).getStr(), xDocSh.is());
477
478 uno::Reference< frame::XModel2 > xModel2(xDocSh->GetModel(), UNO_QUERY);
479 CPPUNIT_ASSERT(xModel2.is());
480
481 Reference< frame::XController2 > xController = xModel2->createDefaultViewController(xTargetFrame);
482 CPPUNIT_ASSERT(xController.is());
483
484 // introduce model/view/controller to each other
485 xController->attachModel(xModel2.get());
486 xModel2->connectController(xController.get());
487 xTargetFrame->setComponent(xController->getComponentWindow(), xController.get());
488 xController->attachFrame(xTargetFrame);
489 xModel2->setCurrentController(xController.get());
490
491 return xDocSh;
492 }
493
494 void ScCopyPasteTest::testTdf53431_fillOnAutofilter()
495 {
496 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf53431_autofilterFilldown.", FORMAT_ODS, true);
497 ScDocument& rDoc = xDocSh->GetDocument();
498
499 // Get the document controller
500 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
501 CPPUNIT_ASSERT(pView != nullptr);
502
503 //Fill should not clone Autofilter button
504 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(1, 1, 0, 2, 4, 0));
505 pView->FillSimple(FILL_TO_BOTTOM);
506 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 1, 1, 0) & ScMF::Auto));
507 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 2, 1, 0) & ScMF::Auto));
508 CPPUNIT_ASSERT(!(lcl_getMergeFlagOfCell(rDoc, 1, 4, 0) & ScMF::Auto));
509
510 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(1, 1, 0, 4, 4, 0));
511 pView->FillSimple(FILL_TO_RIGHT);
512 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 1, 1, 0) & ScMF::Auto));
513 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 2, 1, 0) & ScMF::Auto));
514 CPPUNIT_ASSERT(!(lcl_getMergeFlagOfCell(rDoc, 4, 1, 0) & ScMF::Auto));
515 CPPUNIT_ASSERT(!(lcl_getMergeFlagOfCell(rDoc, 1, 4, 0) & ScMF::Auto));
516 CPPUNIT_ASSERT(!(lcl_getMergeFlagOfCell(rDoc, 4, 4, 0) & ScMF::Auto));
517
518 //Fill should not delete Autofilter buttons
519 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(0, 0, 0, 2, 4, 0));
520 pView->FillSimple(FILL_TO_TOP);
521 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 1, 1, 0) & ScMF::Auto));
522 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 2, 1, 0) & ScMF::Auto));
523 CPPUNIT_ASSERT(!(lcl_getMergeFlagOfCell(rDoc, 1, 0, 0) & ScMF::Auto));
524
525 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(0, 0, 0, 4, 4, 0));
526 pView->FillSimple(FILL_TO_LEFT);
527 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 1, 1, 0) & ScMF::Auto));
528 CPPUNIT_ASSERT((lcl_getMergeFlagOfCell(rDoc, 2, 1, 0) & ScMF::Auto));
529 CPPUNIT_ASSERT(!(lcl_getMergeFlagOfCell(rDoc, 0, 1, 0) & ScMF::Auto));
530 }
531
532 void ScCopyPasteTest::testTdf40993_fillMergedCells()
533 {
534 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf40993_fillMergedCells.", FORMAT_ODS, true);
535 ScDocument& rDoc = xDocSh->GetDocument();
536
537 // Get the document controller
538 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
539 CPPUNIT_ASSERT(pView != nullptr);
540
541 // check content of the merged cell H11:I11
542 CPPUNIT_ASSERT_EQUAL(OUString("1.5"), rDoc.GetString(ScAddress(7, 10, 0)));
543
544 // fill operation on the merged cell should clone ATTR_MERGE and ATTR_MERGE_FLAG
545 // (as long as ATTR_MERGE_FLAG has only ScMF::Hor or ScMF::Ver)
546 //
547 // select merged cell
548 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(7, 10, 0, 8, 10, 0));
549 // copy its content in the next ten rows
550 pView->FillAuto(FILL_TO_BOTTOM, 7, 10, 8, 10, 10);
551 for (int i = 7; i < 9; i++)
552 {
553 ScMF nOriginFlag = lcl_getMergeFlagOfCell(rDoc, i, 10, 0);
554 ScAddress aOriginMerge = lcl_getMergeSizeOfCell(rDoc, i, 10, 0);
555
556 // ATTR_MERGE_FLAG: top left cell is NONE, the other cell shows horizontal overlapping
557 CPPUNIT_ASSERT_EQUAL(i == 7 ? ScMF::NONE : ScMF::Hor, nOriginFlag);
558
559 // ATTR_MERGE: top left cell contains the size of the
560 // merged area (2:1), the other cell doesn't
561 CPPUNIT_ASSERT_EQUAL(i == 7 ? ScAddress(2, 1, 0): ScAddress(0, 0, 0), aOriginMerge);
562
563 for (int j = 11; j < 21; j++)
564 {
565 // check copying of ATTR_MERGE and ATTR_MERGE_FLAG
566 CPPUNIT_ASSERT_EQUAL(lcl_getMergeFlagOfCell(rDoc, i, j, 0), nOriginFlag);
567 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, i, j, 0), aOriginMerge);
568 }
569 }
570
571 CPPUNIT_ASSERT_EQUAL(lcl_getMergeFlagOfCell(rDoc, 7, 21, 0),
572 lcl_getMergeFlagOfCell(rDoc, 7, 10, 0));
573 CPPUNIT_ASSERT(lcl_getMergeSizeOfCell(rDoc, 7, 21, 0) !=
574 lcl_getMergeSizeOfCell(rDoc, 7, 10, 0));
575 CPPUNIT_ASSERT(lcl_getMergeFlagOfCell(rDoc, 8, 21, 0) !=
576 lcl_getMergeFlagOfCell(rDoc, 8, 10, 0));
577 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, 8, 21, 0),
578 lcl_getMergeSizeOfCell(rDoc, 8, 10, 0));
579
580 // area A6:E9 with various merged cells copied vertically and horizontally
581 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(0, 5, 0, 4, 8, 0));
582 pView->FillAuto(FILL_TO_BOTTOM, 0, 5, 4, 8, 12);
583 ScDocShell::GetViewData()->GetMarkData().SetMarkArea(ScRange(0, 5, 0, 4, 8, 0));
584 pView->FillAuto(FILL_TO_RIGHT, 0, 5, 4, 8, 10);
585 for (int i = 0; i < 5; i++)
586 {
587 for (int j = 5; j < 9; j++)
588 {
589 ScMF nOriginFlag = lcl_getMergeFlagOfCell(rDoc, i, j, 0);
590 ScAddress aOriginMerge = lcl_getMergeSizeOfCell(rDoc, i, j, 0);
591 // copies contain the same ATTR_MERGE and ATTR_MERGE_FLAG
592 for (int k = 0; k < 12; k += 4)
593 {
594 CPPUNIT_ASSERT_EQUAL(lcl_getMergeFlagOfCell(rDoc, i, j + k, 0), nOriginFlag);
595 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, i, j + k, 0), aOriginMerge);
596 }
597 for (int k = 0; k < 10; k += 5)
598 {
599 CPPUNIT_ASSERT_EQUAL(lcl_getMergeFlagOfCell(rDoc, i + k, j, 0), nOriginFlag);
600 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, i + k, j, 0), aOriginMerge);
601 }
602 }
603 }
604 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, 1, 5, 0), ScAddress(2, 4, 0));
605 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, 0, 5, 0), ScAddress(1, 2, 0));
606 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, 4, 6, 0), ScAddress(1, 2, 0));
607 CPPUNIT_ASSERT_EQUAL(lcl_getMergeSizeOfCell(rDoc, 3, 5, 0), ScAddress(2, 1, 0));
608 }
609
610 static void lcl_clickAndCheckCurrentArea(SCCOL nCol, SCROW nRow, SCCOL nCol2, SCROW nRow2)
611 {
612 ScRange aRange;
613 ScDocShell::GetViewData()->SetCurX(nCol);
614 ScDocShell::GetViewData()->SetCurY(nRow);
615 ScDocShell::GetViewData()->GetSimpleArea(aRange);
616 CPPUNIT_ASSERT_EQUAL(aRange, ScRange(nCol, nRow, 0, nCol2, nRow2, 0));
617 }
618
619 void ScCopyPasteTest::testTdf43958_clickSelectOnMergedCells()
620 {
621 loadDocAndSetupModelViewController("tdf40993_fillMergedCells.", FORMAT_ODS, true);
622
623 // select cell (e.g. by clicking on it) and check what is selected [but not marked]:
624 // if it is the top left cell of a merged area, the selection is enlarged to the area
625 lcl_clickAndCheckCurrentArea(1, 5, 2, 8); // B6 -> B6:C9
626 lcl_clickAndCheckCurrentArea(0, 5, 0, 6); // A6 -> A6:A7
627 lcl_clickAndCheckCurrentArea(3, 5, 4, 5); // D6 -> D6:E6
628 lcl_clickAndCheckCurrentArea(4, 6, 4, 7); // D7 -> D6:D7
629 lcl_clickAndCheckCurrentArea(7, 10, 8, 10); // H11 -> H11:I11
630 lcl_clickAndCheckCurrentArea(7, 13, 8, 13); // H14 -> H14:I14
631
632 // otherwise it remains the same
633 lcl_clickAndCheckCurrentArea(0, 7, 0, 7); // A8
634 lcl_clickAndCheckCurrentArea(0, 8, 0, 8); // A9
635 lcl_clickAndCheckCurrentArea(2, 6, 2, 6); // C7
636 lcl_clickAndCheckCurrentArea(2, 7, 2, 7); // C8
637 lcl_clickAndCheckCurrentArea(2, 8, 2, 8); // C9
638 }
639
640 void ScCopyPasteTest::testTdf88782_autofillLinearNumbersInMergedCells()
641 {
642 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf88782_AutofillLinearNumbersInMergedCells.", FORMAT_ODS, true);
643 ScDocument& rDoc = xDocSh->GetDocument();
644
645 // Get the document controller
646 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
647 CPPUNIT_ASSERT(pView != nullptr);
648
649 // merge the yellow cells
650 ScCellMergeOption aMergeOptions(9, 11, 10, 13); //J12:K14
651 aMergeOptions.maTabs.insert(0);
652 xDocSh->GetDocFunc().MergeCells(aMergeOptions, false, true, true, false);
653
654 // fillauto numbers, these areas contain mostly merged cells
655 pView->FillAuto(FILL_TO_BOTTOM, 1, 8, 3, 14, 7); // B9:D15 -> B9:D22
656 pView->FillAuto(FILL_TO_BOTTOM, 5, 8, 7, 17, 10); // F9:H18 -> F9:H28
657 pView->FillAuto(FILL_TO_BOTTOM, 9, 8, 10, 13, 6); // J9:K14 -> J9:K20
658 pView->FillAuto(FILL_TO_RIGHT, 9, 30, 16, 35, 8); //J31:Q36 -> J31:Y36
659 pView->FillAuto(FILL_TO_LEFT, 9, 30, 16, 35, 8); //J31:Q36 -> B31:Q36
660
661 // compare the results of fill-down with the reference stored in the test file
662 // this compares the whole area blindly, for specific test cases, check the test file
663 // the test file have instructions / explanations, so that is easy to understand
664 for (int nCol = 1; nCol <= 10; nCol++)
665 {
666 for (int nRow = 8; nRow <= 27; nRow++)
667 {
668 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
669 CellType nType2 = rDoc.GetCellType(ScAddress(nCol + 22, nRow, 0));
670 double* pValue1 = rDoc.GetValueCell(ScAddress(nCol, nRow, 0));
671 double* pValue2 = rDoc.GetValueCell(ScAddress(nCol + 22, nRow, 0));
672
673 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
674 if (pValue2 != nullptr)
675 CPPUNIT_ASSERT_EQUAL(*pValue1, *pValue2); //cells with number value
676 else
677 CPPUNIT_ASSERT_EQUAL(pValue1, pValue2); //empty cells
678 }
679 }
680
681 // compare the results of fill-right and left with the reference stored in the test file
682 for (int nCol = 1; nCol <= 24; nCol++)
683 {
684 for (int nRow = 30; nRow <= 35; nRow++)
685 {
686 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
687 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 16, 0));
688 double* pValue1 = rDoc.GetValueCell(ScAddress(nCol, nRow, 0));
689 double* pValue2 = rDoc.GetValueCell(ScAddress(nCol, nRow + 16, 0));
690
691 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
692 if (pValue2 != nullptr)
693 CPPUNIT_ASSERT_EQUAL(*pValue1, *pValue2);
694 else
695 CPPUNIT_ASSERT_EQUAL(pValue1, pValue2);
696 }
697 }
698 }
699
700 void ScCopyPasteTest::tdf137621_autofillMergedBool()
701 {
702 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf137621_autofillMergedBool.", FORMAT_ODS, true);
703 ScDocument& rDoc = xDocSh->GetDocument();
704
705 // Get the document controller
706 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
707 CPPUNIT_ASSERT(pView != nullptr);
708
709 // fillauto booleans, these areas contain only merged cells
710 pView->FillAuto(FILL_TO_RIGHT, 0, 4, 3, 5, 8); //A5:D6
711
712 // compare the results of fill-right with the reference stored in the test file
713 // this compares the whole area blindly, for specific test cases, check the test file
714 for (int nCol = 4; nCol <= 11; nCol++)
715 {
716 for (int nRow = 4; nRow <= 5; nRow++)
717 {
718 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
719 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 3, 0));
720 double* pValue1 = rDoc.GetValueCell(ScAddress(nCol, nRow, 0));
721 double* pValue2 = rDoc.GetValueCell(ScAddress(nCol, nRow + 3, 0));
722
723 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
724 if (pValue2 != nullptr)
725 CPPUNIT_ASSERT_EQUAL(*pValue1, *pValue2); //cells with boolean value
726 else
727 CPPUNIT_ASSERT_EQUAL(pValue1, pValue2); //empty cells
728 }
729 }
730 }
731
732 void ScCopyPasteTest::tdf137205_autofillDatesInMergedCells()
733 {
734 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf137205_AutofillDatesInMergedCells.", FORMAT_ODS, true);
735 ScDocument& rDoc = xDocSh->GetDocument();
736
737 // Get the document controller
738 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
739 CPPUNIT_ASSERT(pView != nullptr);
740
741 // fillauto dates, this areas contain only merged cells
742 pView->FillAuto(FILL_TO_RIGHT, 1, 5, 4, 7, 8); //B6:E8
743
744 // compare the results of fill-right with the reference stored in the test file
745 // this compares the whole area blindly, for specific test cases, check the test file
746 for (int nCol = 5; nCol <= 12; nCol++)
747 {
748 for (int nRow = 5; nRow <= 7; nRow++)
749 {
750 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
751 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 5, 0));
752 double* pValue1 = rDoc.GetValueCell(ScAddress(nCol, nRow, 0));
753 double* pValue2 = rDoc.GetValueCell(ScAddress(nCol, nRow + 5, 0));
754
755 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
756 if (pValue2 != nullptr)
757 CPPUNIT_ASSERT_EQUAL(*pValue1, *pValue2); //cells with number value
758 else
759 CPPUNIT_ASSERT_EQUAL(pValue1, pValue2); //empty cells
760 }
761 }
762 }
763
764 void ScCopyPasteTest::addToUserList(const OUString& rStr)
765 {
766 ScUserListData* aListData = new ScUserListData(rStr);
767 ScGlobal::GetUserList()->push_back(aListData);
768 }
769
770 void ScCopyPasteTest::tdf137653_137654_autofillUserlist()
771 {
772 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf137653_137654_autofillUserlist.", FORMAT_ODS, true);
773 ScDocument& rDoc = xDocSh->GetDocument();
774
775 // Get the document controller
776 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
777 CPPUNIT_ASSERT(pView != nullptr);
778
779 // delete every userlist to make sure there won't be any string that is in 2 different userlist
780 ScGlobal::GetUserList()->clear();
781 addToUserList({ "January,February,March,April,May,June,July,August,September,October,November,December" });
782 const ScUserListData* pListData = ScGlobal::GetUserList()->GetData("January");
783 sal_uInt16 nIdx1 = 0, nIdx2 = 0;
784 bool bHasIdx1, bHasIdx2;
785 bool bMatchCase = false;
786
787 // fillauto userlist, these areas contain only merged cells
788 pView->FillAuto(FILL_TO_RIGHT, 4, 5, 6, 7, 3); //E6:G8
789 pView->FillAuto(FILL_TO_LEFT, 4, 5, 6, 7, 3); //E6:G8
790 pView->FillAuto(FILL_TO_BOTTOM, 1, 18, 3, 19, 2); //B19:D20
791 pView->FillAuto(FILL_TO_TOP, 1, 18, 3, 19, 2); //B19:D20
792
793 // compare the results of fill-right / -left with the reference stored in the test file
794 // this compares the whole area blindly, for specific test cases, check the test file
795 for (int nCol = 1; nCol <= 9; nCol++)
796 {
797 for (int nRow = 5; nRow <= 7; nRow++)
798 {
799 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
800 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 4, 0));
801 bHasIdx1 = pListData->GetSubIndex(rDoc.GetString(nCol, nRow, 0), nIdx1, bMatchCase);
802 bHasIdx2 = pListData->GetSubIndex(rDoc.GetString(nCol, nRow + 4, 0), nIdx2, bMatchCase);
803
804 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
805 CPPUNIT_ASSERT(bHasIdx1 && bHasIdx2);
806 CPPUNIT_ASSERT_EQUAL(nIdx1, nIdx2); // userlist index value of cells
807 }
808 }
809
810 // compare the results of fill-up / -down
811 for (int nCol = 1; nCol <= 3; nCol++)
812 {
813 for (int nRow = 16; nRow <= 21; nRow++)
814 {
815 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
816 CellType nType2 = rDoc.GetCellType(ScAddress(nCol + 4, nRow, 0));
817 bHasIdx1 = pListData->GetSubIndex(rDoc.GetString(nCol, nRow, 0), nIdx1, bMatchCase);
818 bHasIdx2 = pListData->GetSubIndex(rDoc.GetString(nCol + 4, nRow, 0), nIdx2, bMatchCase);
819
820 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
821 CPPUNIT_ASSERT(bHasIdx1 && bHasIdx2);
822 CPPUNIT_ASSERT_EQUAL(nIdx1, nIdx2); // userlist index value of cells
823 }
824 }
825 }
826
827 void ScCopyPasteTest::tdf113500_autofillMixed()
828 {
829 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf113500_autofillMixed.", FORMAT_ODS, true);
830 ScDocument& rDoc = xDocSh->GetDocument();
831
832 // Get the document controller
833 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
834 CPPUNIT_ASSERT(pView != nullptr);
835
836 // fillauto userlist, these areas contain only merged cells
837 pView->FillAuto(FILL_TO_RIGHT, 4, 5, 6, 7, 3); //E6:G8
838 pView->FillAuto(FILL_TO_LEFT, 4, 5, 6, 7, 3); //E6:G8
839 pView->FillAuto(FILL_TO_BOTTOM, 1, 18, 3, 19, 2); //B19:D20
840 pView->FillAuto(FILL_TO_TOP, 1, 18, 3, 19, 2); //B19:D20
841
842 // compare the results of fill-right / -left with the reference stored in the test file
843 // this compares the whole area blindly, for specific test cases, check the test file
844 // do not check the 3. row: a1,b2,a3. It is another bug to fix
845 for (int nCol = 1; nCol <= 9; nCol++)
846 {
847 for (int nRow = 5; nRow <= 6; nRow++)
848 {
849 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
850 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 4, 0));
851 OUString aStr1 = rDoc.GetString(nCol, nRow, 0);
852 OUString aStr2 = rDoc.GetString(nCol, nRow + 4, 0);
853
854 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
855 CPPUNIT_ASSERT_EQUAL(aStr1, aStr2);
856 }
857 }
858
859 // compare the results of fill-up / -down
860 // do not check the 2. column: 1st,3st. It is another bug to fix
861 for (int nCol = 1; nCol <= 3; nCol+=2)
862 {
863 for (int nRow = 16; nRow <= 21; nRow++)
864 {
865 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
866 CellType nType2 = rDoc.GetCellType(ScAddress(nCol + 4, nRow, 0));
867 OUString aStr1 = rDoc.GetString(nCol, nRow, 0);
868 OUString aStr2 = rDoc.GetString(nCol + 4, nRow, 0);
869
870 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
871 CPPUNIT_ASSERT_EQUAL(aStr1, aStr2);
872 }
873 }
874 }
875
876 void ScCopyPasteTest::tdf137625_autofillMergedUserlist()
877 {
878 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf137625_autofillMergedUserlist.", FORMAT_ODS, true);
879 ScDocument& rDoc = xDocSh->GetDocument();
880
881 // Get the document controller
882 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
883 CPPUNIT_ASSERT(pView != nullptr);
884
885 // delete every userlist to make sure there won't be any string that is in 2 different userlist
886 ScGlobal::GetUserList()->clear();
887 addToUserList({ "January,February,March,April,May,June,July,August,September,October,November,December" });
888 const ScUserListData* pListData = ScGlobal::GetUserList()->GetData("January");
889 sal_uInt16 nIdx1 = 0, nIdx2 = 0;
890 bool bHasIdx1, bHasIdx2;
891 bool bMatchCase = false;
892
893 // fillauto userlist, these areas contain only merged cells
894 pView->FillAuto(FILL_TO_RIGHT, 7, 5, 12, 7, 6); //H6:M8
895 pView->FillAuto(FILL_TO_LEFT, 7, 5, 12, 7, 6); //H6:M8
896 pView->FillAuto(FILL_TO_BOTTOM, 1, 20, 3, 23, 4); //B21:D24
897 pView->FillAuto(FILL_TO_TOP, 1, 20, 3, 23, 4); //B21:D24
898
899 // compare the results of fill-right / -left with the reference stored in the test file
900 // this compares the whole area blindly, for specific test cases, check the test file
901 for (int nCol = 1; nCol <= 18; nCol++)
902 {
903 for (int nRow = 5; nRow <= 7; nRow++)
904 {
905 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
906 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 4, 0));
907 bHasIdx1 = pListData->GetSubIndex(rDoc.GetString(nCol, nRow, 0), nIdx1, bMatchCase);
908 bHasIdx2 = pListData->GetSubIndex(rDoc.GetString(nCol, nRow + 4, 0), nIdx2, bMatchCase);
909
910 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
911 CPPUNIT_ASSERT_EQUAL(bHasIdx1, bHasIdx2);
912 if (bHasIdx1)
913 CPPUNIT_ASSERT_EQUAL(nIdx1, nIdx2); //cells with userlist value
914 }
915 }
916
917 // compare the results of fill-up / -down
918 for (int nCol = 1; nCol <= 3; nCol++)
919 {
920 for (int nRow = 16; nRow <= 27; nRow++)
921 {
922 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
923 CellType nType2 = rDoc.GetCellType(ScAddress(nCol + 4, nRow, 0));
924 bHasIdx1 = pListData->GetSubIndex(rDoc.GetString(nCol, nRow, 0), nIdx1, bMatchCase);
925 bHasIdx2 = pListData->GetSubIndex(rDoc.GetString(nCol + 4, nRow, 0), nIdx2, bMatchCase);
926
927 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
928 CPPUNIT_ASSERT_EQUAL(bHasIdx1, bHasIdx2);
929 if (bHasIdx1)
930 CPPUNIT_ASSERT_EQUAL(nIdx1, nIdx2); //cells with userlist value
931 }
932 }
933 }
934
935 void ScCopyPasteTest::tdf137624_autofillMergedMixed()
936 {
937 ScDocShellRef xDocSh = loadDocAndSetupModelViewController("tdf137624_autofillMergedMixed.", FORMAT_ODS, true);
938 ScDocument& rDoc = xDocSh->GetDocument();
939
940 // Get the document controller
941 ScTabViewShell* pView = xDocSh->GetBestViewShell(false);
942 CPPUNIT_ASSERT(pView != nullptr);
943
944 // add 1aa,2bb,3cc,4dd,5ee,6ff to userlist, to test that autofill won't confuse it with 1aa,3aa
945 // delete every userlist to make sure there won't be any string that is in 2 different userlist
946 ScGlobal::GetUserList()->clear();
947 addToUserList({ "1aa,2bb,3cc,4dd,5ee,6ff" });
948
949 // fillauto mixed (string + number), these areas contain only merged cells
950 pView->FillAuto(FILL_TO_RIGHT, 7, 5, 12, 7, 6); //H6:M8
951 pView->FillAuto(FILL_TO_LEFT, 7, 5, 12, 7, 6); //H6:M8
952 pView->FillAuto(FILL_TO_BOTTOM, 1, 20, 3, 23, 4); //B21:D24
953 pView->FillAuto(FILL_TO_TOP, 1, 20, 3, 23, 4); //B21:D24
954
955 // compare the results of fill-right / -left with the reference stored in the test file
956 // this compares the whole area blindly, for specific test cases, check the test file
957 for (int nCol = 1; nCol <= 18; nCol++)
958 {
959 for (int nRow = 5; nRow <= 7; nRow++)
960 {
961 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
962 CellType nType2 = rDoc.GetCellType(ScAddress(nCol, nRow + 4, 0));
963 OUString aStr1 = rDoc.GetString(nCol, nRow, 0);
964 OUString aStr2 = rDoc.GetString(nCol, nRow + 4, 0);
965
966 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
967 CPPUNIT_ASSERT_EQUAL(aStr1, aStr2);
968 }
969 }
970
971 // compare the results of fill-up / -down
972 for (int nCol = 1; nCol <= 3; nCol++)
973 {
974 for (int nRow = 16; nRow <= 27; nRow++)
975 {
976 CellType nType1 = rDoc.GetCellType(ScAddress(nCol, nRow, 0));
977 CellType nType2 = rDoc.GetCellType(ScAddress(nCol + 4, nRow, 0));
978 OUString aStr1 = rDoc.GetString(nCol, nRow, 0);
979 OUString aStr2 = rDoc.GetString(nCol + 4, nRow, 0);
980
981 CPPUNIT_ASSERT_EQUAL(nType1, nType2);
982 CPPUNIT_ASSERT_EQUAL(aStr1, aStr2);
983 }
984 }
985 }
986
987 ScCopyPasteTest::ScCopyPasteTest()
988 : ScBootstrapFixture( "sc/qa/unit/data" )
989 {
990 }
991
992 void ScCopyPasteTest::setUp()
993 {
994 test::BootstrapFixture::setUp();
995
996 // This is a bit of a fudge, we do this to ensure that ScGlobals::ensure,
997 // which is a private symbol to us, gets called
998 m_xCalcComponent =
999 getMultiServiceFactory()->createInstance("com.sun.star.comp.Calc.SpreadsheetDocument");
1000 CPPUNIT_ASSERT_MESSAGE("no calc component!", m_xCalcComponent.is());
1001 }
1002
1003 void ScCopyPasteTest::tearDown()
1004 {
1005 uno::Reference< lang::XComponent >( m_xCalcComponent, UNO_QUERY_THROW )->dispose();
1006 test::BootstrapFixture::tearDown();
1007 }
1008
1009 CPPUNIT_TEST_SUITE_REGISTRATION(ScCopyPasteTest);
1010
1011 CPPUNIT_PLUGIN_IMPLEMENT();
1012
1013 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE