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