sc/qa/unit/rangelst_test.cxx

   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 <docsh.hxx>
  13 #include <scdll.hxx>
  14
  15 #include <rangelst.hxx>
  16
  17 class Test : public test::BootstrapFixture
  18 {
  19 public:
  20     Test()
  21         : m_pDoc(nullptr)
  22     {
  23     }
  24
  25     virtual void setUp() override;
  26     virtual void tearDown() override;
  27
  28     void testDeleteArea_4Ranges();
  29     void testDeleteArea_3Ranges();
  30     void testDeleteArea_3Ranges_Case2();
  31     void testDeleteArea_3Ranges_Case3();
  32     void testDeleteArea_3Ranges_Case4();
  33     void testDeleteArea_3Ranges_Case5();
  34     void testDeleteArea_2Ranges();
  35     void testDeleteArea_2Ranges_Case2();
  36     void testDeleteArea_2Ranges_Case3();
  37     void testDeleteArea_2Ranges_Case4();
  38     void testDeleteArea_2Ranges_Case5();
  39     void testDeleteArea_2Ranges_Case6();
  40     void testDeleteArea_2Ranges_Case7();
  41     void testDeleteArea_2Ranges_Case8();
  42     void testDeleteArea_1Range();
  43     void testDeleteArea_0Ranges();
  44     void testJoin_Case1();
  45     void testJoin_Case2();
  46     void testJoin_Case3();
  47     void testJoin_Case4();
  48     void testJoin_Case5();
  49     void testGetIntersectedRange();
  50
  51     void testUpdateReference_DeleteRow();
  52     void testUpdateReference_DeleteLastRow();
  53     void testUpdateReference_DeleteCol();
  54
  55     void testInsertRow();
  56     void testInsertCol();
  57
  58     CPPUNIT_TEST_SUITE(Test);
  59     CPPUNIT_TEST(testDeleteArea_4Ranges);
  60     CPPUNIT_TEST(testDeleteArea_3Ranges);
  61     CPPUNIT_TEST(testDeleteArea_3Ranges_Case2);
  62     CPPUNIT_TEST(testDeleteArea_3Ranges_Case3);
  63     CPPUNIT_TEST(testDeleteArea_3Ranges_Case4);
  64     CPPUNIT_TEST(testDeleteArea_3Ranges_Case5);
  65     CPPUNIT_TEST(testDeleteArea_2Ranges);
  66     CPPUNIT_TEST(testDeleteArea_2Ranges_Case2);
  67     CPPUNIT_TEST(testDeleteArea_2Ranges_Case3);
  68     CPPUNIT_TEST(testDeleteArea_2Ranges_Case4);
  69     CPPUNIT_TEST(testDeleteArea_2Ranges_Case5);
  70     CPPUNIT_TEST(testDeleteArea_2Ranges_Case6);
  71     CPPUNIT_TEST(testDeleteArea_2Ranges_Case7);
  72     CPPUNIT_TEST(testDeleteArea_2Ranges_Case8);
  73     CPPUNIT_TEST(testDeleteArea_1Range);
  74     CPPUNIT_TEST(testDeleteArea_0Ranges);
  75     CPPUNIT_TEST(testJoin_Case1);
  76     CPPUNIT_TEST(testJoin_Case2);
  77     CPPUNIT_TEST(testJoin_Case3);
  78     CPPUNIT_TEST(testJoin_Case4);
  79     CPPUNIT_TEST(testJoin_Case5);
  80     CPPUNIT_TEST(testUpdateReference_DeleteRow);
  81     CPPUNIT_TEST(testUpdateReference_DeleteLastRow);
  82     CPPUNIT_TEST(testUpdateReference_DeleteCol);
  83     CPPUNIT_TEST(testGetIntersectedRange);
  84     CPPUNIT_TEST(testInsertRow);
  85     CPPUNIT_TEST(testInsertCol);
  86     CPPUNIT_TEST_SUITE_END();
  87
  88 private:
  89     ScDocument *m_pDoc;
  90     ScDocShellRef m_xDocShRef;
  91 };
  92
  93 void Test::setUp()
  94 {
  95     BootstrapFixture::setUp();
  96
  97     ScDLL::Init();
  98     m_xDocShRef = new ScDocShell(
  99         SfxModelFlags::EMBEDDED_OBJECT |
 100         SfxModelFlags::DISABLE_EMBEDDED_SCRIPTS |
 101         SfxModelFlags::DISABLE_DOCUMENT_RECOVERY);
 102
 103     m_pDoc = &m_xDocShRef->GetDocument();
 104 }
 105
 106 void Test::tearDown()
 107 {
 108     m_xDocShRef.clear();
 109     BootstrapFixture::tearDown();
 110 }
 111
 112 void Test::testDeleteArea_4Ranges()
 113 {
 114     ScRangeList aList(ScRange(0,0,0,5,5,0));
 115     aList.DeleteArea(2,2,0,3,3,0);
 116
 117     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(4), aList.size());
 118     for(SCCOL nCol = 0; nCol <= 5; ++nCol)
 119     {
 120         for(SCROW nRow = 0; nRow <= 5; ++nRow)
 121         {
 122             if((nCol == 2 || nCol == 3) && ( nRow == 2 || nRow == 3))
 123                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 124             else
 125                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 126         }
 127     }
 128 }
 129
 130 void Test::testDeleteArea_3Ranges()
 131 {
 132     ScRangeList aList(ScRange(1,1,0,6,6,0));
 133     aList.DeleteArea(3,3,0,8,4,0);
 134
 135     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(3), aList.size());
 136     for(SCCOL nCol = 1; nCol <= 6; ++nCol)
 137     {
 138         for(SCROW nRow = 1; nRow <= 6; ++nRow)
 139         {
 140             if((nRow == 3 || nRow == 4) && (nCol >= 3))
 141                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 142             else
 143                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 144         }
 145     }
 146
 147     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(28), aList.GetCellCount());
 148 }
 149
 150 void Test::testDeleteArea_3Ranges_Case2()
 151 {
 152     ScRangeList aList(ScRange(1,1,0,6,6,0));
 153     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 154     aList.DeleteArea(0,2,0,2,4,0);
 155     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(3), aList.size());
 156
 157     // Column 1-2 && Row 2-4 should not be in the range list. The rest should
 158     // be in the list.
 159     for (SCCOL nCol = 1; nCol <= 6; ++nCol)
 160     {
 161         for (SCROW nRow = 1; nRow <= 6; ++nRow)
 162         {
 163             if ((1 <= nCol && nCol <= 2) && (2 <= nRow && nRow <= 4))
 164                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 165             else
 166                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 167         }
 168     }
 169 }
 170
 171 void Test::testDeleteArea_3Ranges_Case3()
 172 {
 173     ScRangeList aList(ScRange(1,5,0,6,11,0));
 174     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 175     aList.DeleteArea(3,2,0,4,8,0);
 176     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(3), aList.size());
 177
 178     // Column 3-4 && Row 5-8 should not be in the range list.
 179     for (SCCOL nCol = 1; nCol <= 6; ++nCol)
 180     {
 181         for (SCROW nRow = 5; nRow <= 11; ++nRow)
 182         {
 183             if ((3 <= nCol && nCol <= 4) && (5 <= nRow && nRow <= 8))
 184                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 185             else
 186                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 187         }
 188     }
 189 }
 190
 191 void Test::testDeleteArea_3Ranges_Case4()
 192 {
 193     ScRangeList aList(ScRange(1,5,0,6,11,0));
 194     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 195     aList.DeleteArea(3,5,0,4,5,0);
 196     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(3), aList.size());
 197
 198     // Column 3-4 && Row 5 should not be in the range list.
 199     for (SCCOL nCol = 1; nCol <= 6; ++nCol)
 200     {
 201         for (SCROW nRow = 5; nRow <= 11; ++nRow)
 202         {
 203             if ((3 <= nCol && nCol <= 4) && 5 == nRow )
 204                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 205             else
 206                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 207         }
 208     }
 209 }
 210
 211 void Test::testDeleteArea_3Ranges_Case5()
 212 {
 213     ScRangeList aList(ScRange(1,5,0,6,11,0));
 214     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 215     aList.DeleteArea(6,7,0,6,9,0);
 216     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(3), aList.size());
 217
 218     // Column 6 && Row 7-9 should not be in the range list.
 219     for (SCCOL nCol = 1; nCol <= 6; ++nCol)
 220     {
 221         for (SCROW nRow = 5; nRow <= 11; ++nRow)
 222         {
 223             if ( nCol == 6 && (7 <= nRow && nRow <= 9))
 224                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 225             else
 226                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 227         }
 228     }
 229 }
 230
 231 void Test::testDeleteArea_2Ranges()
 232 {
 233     ScRangeList aList(ScRange(0,0,0,5,5,5));
 234     ScRangeList aList2(aList);
 235
 236     aList.DeleteArea(4,4,0,6,7,0);
 237     aList2.DeleteArea(4,4,0,6,7,0);
 238     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 239     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList2.size());
 240
 241     for(SCCOL nCol = 0; nCol <= 5; ++nCol)
 242     {
 243         for(SCROW nRow = 0; nRow <= 5; ++nRow)
 244         {
 245             if(nCol>=4 && nRow >= 4)
 246                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 247             else
 248                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 249         }
 250     }
 251 }
 252
 253 void Test::testDeleteArea_2Ranges_Case2()
 254 {
 255     ScRangeList aList(ScRange(1,1,0,1,5,0));
 256     aList.DeleteArea(0,3,0,MAXCOL,3,0);
 257
 258     for(SCROW nRow = 1; nRow <= 5; ++nRow)
 259     {
 260         if(nRow == 3)
 261             CPPUNIT_ASSERT(!aList.In(ScRange(1,3,0)));
 262         else
 263             CPPUNIT_ASSERT(aList.In(ScRange(1,nRow,0)));
 264     }
 265     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(4), aList.GetCellCount());
 266 }
 267
 268 void Test::testDeleteArea_2Ranges_Case3()
 269 {
 270     ScRangeList aList(ScRange(0,5,0,2,10,0));
 271     aList.DeleteArea(2,3,0,3,7,0);
 272     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 273
 274     // Column 2 Row 5-7 shouldn't be in the list.
 275     for (SCCOL nCol = 0; nCol <= 2; ++nCol)
 276     {
 277         for (SCROW nRow = 5; nRow <= 10; ++nRow)
 278         {
 279             if (nCol == 2 && (5 <= nRow && nRow <= 7))
 280                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol,nRow,0)));
 281             else
 282                 CPPUNIT_ASSERT(aList.In(ScRange(nCol,nRow,0)));
 283         }
 284     }
 285 }
 286
 287 void Test::testDeleteArea_2Ranges_Case4()
 288 {
 289     ScRangeList aList(ScRange(2,3,0,4,7,0));
 290     aList.DeleteArea(0,1,0,2,5,0);
 291     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 292
 293     // Column 2 Row 3-5 shouldn't be in the list.
 294     for (SCCOL nCol = 2; nCol <= 4; ++nCol)
 295     {
 296         for (SCROW nRow = 3; nRow <= 7; ++nRow)
 297         {
 298             if (nCol == 2 && (3 <= nRow && nRow <= 5))
 299                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol,nRow,0)));
 300             else
 301                 CPPUNIT_ASSERT(aList.In(ScRange(nCol,nRow,0)));
 302         }
 303     }
 304 }
 305
 306 void Test::testDeleteArea_2Ranges_Case5()
 307 {
 308     ScRangeList aList(ScRange(2,2,0,5,5,0));
 309     aList.DeleteArea(4,5,0,5,5,0);
 310     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 311
 312     // Column 4 and 5 Row 5 shouldn't be in the list.
 313     for(SCCOL nCol = 2; nCol <= 5; ++nCol)
 314     {
 315         for(SCROW nRow = 2; nRow <= 5; ++nRow)
 316         {
 317             if(nRow == 5 && 4 <= nCol)
 318                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 319             else
 320                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 321         }
 322     }
 323 }
 324
 325 void Test::testDeleteArea_2Ranges_Case6()
 326 {
 327     ScRangeList aList(ScRange(2,2,0,5,5,0));
 328     aList.DeleteArea(4,2,0,5,2,0);
 329     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 330
 331     // Column 4 and 5 Row 2 shouldn't be in the list.
 332     for(SCCOL nCol = 2; nCol <= 5; ++nCol)
 333     {
 334         for(SCROW nRow = 2; nRow <= 5; ++nRow)
 335         {
 336             if(nRow == 2 && 4 <= nCol)
 337                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 338             else
 339                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 340         }
 341     }
 342 }
 343
 344 void Test::testDeleteArea_2Ranges_Case7()
 345 {
 346     ScRangeList aList(ScRange(2,2,0,5,5,0));
 347     aList.DeleteArea(2,5,0,2,5,0);
 348     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 349
 350     // Column 2 Row 5 shouldn't be in the list.
 351     for(SCCOL nCol = 2; nCol <= 5; ++nCol)
 352     {
 353         for(SCROW nRow = 2; nRow <= 5; ++nRow)
 354         {
 355             if(nRow == 5 && nCol == 2)
 356                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 357             else
 358                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 359         }
 360     }
 361 }
 362
 363 void Test::testDeleteArea_2Ranges_Case8()
 364 {
 365     ScRangeList aList(ScRange(2,2,0,5,5,0));
 366     aList.DeleteArea(2,2,0,3,2,0);
 367     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 368
 369     // Column 2 & 3 Row 2 shouldn't be in the list.
 370     for(SCCOL nCol = 2; nCol <= 5; ++nCol)
 371     {
 372         for(SCROW nRow = 2; nRow <= 5; ++nRow)
 373         {
 374             if(nRow == 2 && nCol <= 3)
 375                 CPPUNIT_ASSERT(!aList.In(ScRange(nCol, nRow, 0)));
 376             else
 377                 CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 378         }
 379     }
 380 }
 381
 382 void Test::testDeleteArea_1Range()
 383 {
 384     ScRangeList aList(ScRange(1,1,0,3,3,0));
 385     aList.DeleteArea(1,1,0,2,3,0);
 386
 387     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 388
 389     for(SCROW nRow = 1; nRow <= 3; ++nRow)
 390     {
 391         CPPUNIT_ASSERT(aList.In(ScRange(3,nRow,0)));
 392     }
 393     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(3), aList.GetCellCount());
 394 }
 395
 396 void Test::testDeleteArea_0Ranges()
 397 {
 398     ScRangeList aList(ScRange(1,1,0,3,3,0));
 399     aList.DeleteArea(1,1,0,3,3,0);
 400
 401     CPPUNIT_ASSERT(aList.empty());
 402
 403     ScRangeList aList2(ScRange(1,1,0,3,3,0));
 404     aList2.DeleteArea(0,0,0,4,4,0);
 405
 406     CPPUNIT_ASSERT(aList.empty());
 407 }
 408
 409 void Test::testJoin_Case1()
 410 {
 411     ScRangeList aList;
 412     aList.push_back(ScRange(1,1,0,3,3,0));
 413     aList.Join(ScRange(4,1,0,6,3,0));
 414
 415     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 416     CPPUNIT_ASSERT_EQUAL( ScRange(1,1,0,6,3,0), aList[0]);
 417 }
 418
 419 void Test::testJoin_Case2()
 420 {
 421     ScRangeList aList;
 422     aList.push_back(ScRange(1,1,0,3,3,0));
 423     aList.push_back(ScRange(4,1,0,6,3,0));
 424     aList.push_back(ScRange(7,1,0,9,3,0));
 425
 426     aList.Join(aList[2], true);
 427
 428     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 429     CPPUNIT_ASSERT_EQUAL(ScRange(1,1,0,9,3,0), aList[0]);
 430 }
 431
 432 void Test::testJoin_Case3()
 433 {
 434     ScRangeList aList;
 435     aList.Join(ScRange(1,1,0,6,6,0));
 436     aList.Join(ScRange(3,3,0,4,4,0));
 437
 438     // The second one should have been swallowed by the first one
 439     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 440     CPPUNIT_ASSERT_EQUAL(ScRange(1,1,0,6,6,0), aList[0]);
 441
 442     // Add a disjoint one
 443     aList.Join(ScRange(8,8,0,9,9,0));
 444
 445     // Should be two ones now
 446     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 447     // The first one should still be as is
 448     CPPUNIT_ASSERT_EQUAL(ScRange(1,1,0,6,6,0), aList[0]);
 449     // Ditto for the second one
 450     CPPUNIT_ASSERT_EQUAL(ScRange(8,8,0,9,9,0), aList[1]);
 451 }
 452
 453 void Test::testJoin_Case4()
 454 {
 455     ScRangeList aList;
 456     aList.Join(ScRange(1,1,0,2,6,0));
 457     // Join a range that overlaps it and extends it vertically
 458     aList.Join(ScRange(1,4,0,2,8,0));
 459
 460     // The one range in the list should have been extended
 461     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 462     CPPUNIT_ASSERT_EQUAL(ScRange(1,1,0,2,8,0), aList[0]);
 463
 464     // Join a range that overlaps it and extends it horizontally
 465     aList.Join(ScRange(2,1,0,4,8,0));
 466
 467     // Again, should have just been extended
 468     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 469     CPPUNIT_ASSERT_EQUAL(ScRange(1,1,0,4,8,0), aList[0]);
 470
 471     // And then the same but on top / to the left of existing range
 472     ScRangeList aList2;
 473     aList2.Join(ScRange(4,4,0,8,8,0));
 474     aList2.Join(ScRange(4,1,0,8,6,0));
 475
 476     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList2.size());
 477     CPPUNIT_ASSERT_EQUAL(ScRange(4,1,0,8,8,0), aList2[0]);
 478
 479     aList2.Join(ScRange(1,1,0,6,8,0));
 480
 481     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList2.size());
 482     CPPUNIT_ASSERT_EQUAL(ScRange(1,1,0,8,8,0), aList2[0]);
 483 }
 484
 485 void Test::testJoin_Case5()
 486 {
 487     ScRangeList aList;
 488     aList.Join(ScRange(0,0,0,4,4,0));
 489     aList.Join(ScRange(8,0,0,10,4,0));
 490
 491     // Nothing special so far, two disjoint ranges
 492     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(2), aList.size());
 493     CPPUNIT_ASSERT_EQUAL(ScRange(0,0,0,4,4,0), aList[0]);
 494     CPPUNIT_ASSERT_EQUAL(ScRange(8,0,0,10,4,0), aList[1]);
 495
 496     // This should join the two ranges into one
 497     aList.Join(ScRange(5,0,0,9,4,0));
 498
 499     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), aList.size());
 500     CPPUNIT_ASSERT_EQUAL(ScRange(0,0,0,10,4,0), aList[0]);
 501 }
 502
 503 void Test::testUpdateReference_DeleteRow()
 504 {
 505     ScRangeList aList(ScRange(1,1,0,4,4,0));
 506     bool bUpdated = aList.UpdateReference(URM_INSDEL, m_pDoc, ScRange(0,3,0,MAXCOL,MAXROW,0), 0, -1, 0);
 507     CPPUNIT_ASSERT(bUpdated);
 508
 509     for(SCCOL nCol = 1; nCol <= 4; ++nCol)
 510     {
 511         for(SCROW nRow = 1; nRow <= 3; ++nRow)
 512         {
 513             CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 514         }
 515         CPPUNIT_ASSERT(!aList.In(ScRange(nCol, 4, 0)));
 516     }
 517     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(12), aList.GetCellCount());
 518
 519     ScRangeList aList2(ScRange(2,2,0,2,2,0));
 520     aList2.UpdateReference(URM_INSDEL, m_pDoc, ScRange(0,3,0,MAXCOL,MAXROW,0), 0, -1, 0);
 521     CPPUNIT_ASSERT(aList2.empty());
 522 }
 523
 524 void Test::testUpdateReference_DeleteLastRow()
 525 {
 526     ScRangeList aList(ScRange(1,1,0,4,4,0));
 527     bool bUpdated = aList.UpdateReference(URM_INSDEL, m_pDoc, ScRange(0,4,0,MAXCOL,4,0), 0, -1, 0);
 528     CPPUNIT_ASSERT(bUpdated);
 529 }
 530
 531 void Test::testUpdateReference_DeleteCol()
 532 {
 533     ScRangeList aList(ScRange(1,1,0,4,4,0));
 534     bool bUpdated = aList.UpdateReference(URM_INSDEL, m_pDoc, ScRange(3,0,0,MAXCOL,MAXROW,0), -1, 0, 0);
 535     CPPUNIT_ASSERT(bUpdated);
 536
 537     for(SCROW nRow = 1; nRow <= 4; ++nRow)
 538     {
 539         for(SCCOL nCol = 1; nCol <= 3; ++nCol)
 540         {
 541             CPPUNIT_ASSERT(aList.In(ScRange(nCol, nRow, 0)));
 542         }
 543         CPPUNIT_ASSERT(!aList.In(ScRange(4, nRow, 0)));
 544     }
 545     CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(12), aList.GetCellCount());
 546 }
 547
 548 void Test::testGetIntersectedRange()
 549 {
 550     ScRangeList aList(ScRange(2, 2, 0, 5, 5, 0));
 551     ScRangeList aIntersecting = aList.GetIntersectedRange(ScRange(0, 0, 0, 3, 3, 0));
 552     CPPUNIT_ASSERT_EQUAL(ScRangeList(ScRange(2,2,0,3,3,0)), aIntersecting);
 553 }
 554
 555 void Test::testInsertRow()
 556 {
 557     ScRangeList aList(ScRange(1,1,0,4,4,0));
 558     aList.InsertRow(0, 0, MAXCOL, 5, 2);
 559     CPPUNIT_ASSERT_EQUAL(ScRangeList(ScRange(1,1,0,4,6,0)), aList);
 560 }
 561
 562 void Test::testInsertCol()
 563 {
 564     ScRangeList aList(ScRange(1,1,0,4,4,0));
 565     aList.InsertCol(0, 0, MAXROW, 5, 2);
 566     CPPUNIT_ASSERT_EQUAL(ScRangeList(ScRange(1,1,0,6,4,0)), aList);
 567 }
 568
 569 CPPUNIT_TEST_SUITE_REGISTRATION(Test);
 570
 571 CPPUNIT_PLUGIN_IMPLEMENT();
 572 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */