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