sc/qa/unit/ucalc.hxx

   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 #ifndef INCLUDED_SC_QA_UNIT_UCALC_HXX
  11 #define INCLUDED_SC_QA_UNIT_UCALC_HXX
  12
  13 #include "helper/qahelper.hxx"
  14 #include "document.hxx"
  15 #include <stringutil.hxx>
  16
  17 struct TestImpl;
  18 class ScUndoPaste;
  19
  20 /**
  21  * Temporarily set formula grammar.
  22  */
  23 class FormulaGrammarSwitch
  24 {
  25     ScDocument* mpDoc;
  26     formula::FormulaGrammar::Grammar meOldGrammar;
  27 public:
  28     FormulaGrammarSwitch(ScDocument* pDoc, formula::FormulaGrammar::Grammar eGrammar);
  29     ~FormulaGrammarSwitch();
  30 };
  31
  32 class Test : public test::BootstrapFixture
  33 {
  34 public:
  35     struct RangeNameDef
  36     {
  37         const char* mpName;
  38         const char* mpExpr;
  39         sal_uInt16 mnIndex;
  40     };
  41
  42     static ScDocShell* findLoadedDocShellByName(const OUString& rName);
  43     static bool insertRangeNames(ScDocument* pDoc, ScRangeName* pNames, const RangeNameDef* p, const RangeNameDef* pEnd);
  44     static void printRange(ScDocument* pDoc, const ScRange& rRange, const char* pCaption);
  45     static void clearRange(ScDocument* pDoc, const ScRange& rRange);
  46     static void clearSheet(ScDocument* pDoc, SCTAB nTab);
  47     static void copyToClip(ScDocument* pSrcDoc, const ScRange& rRange, ScDocument* pClipDoc);
  48     static void pasteFromClip(ScDocument* pDestDoc, const ScRange& rDestRange, ScDocument* pClipDoc);
  49     static ScUndoPaste* createUndoPaste(ScDocShell& rDocSh, const ScRange& rRange, ScDocument* pUndoDoc);
  50
  51     /**
  52      * Enable or disable expand reference options which controls how
  53      * references in formula are expanded when inserting rows or columns.
  54      */
  55     static void setExpandRefs(bool bExpand);
  56
  57     static void setCalcAsShown(ScDocument* pDoc, bool bCalcAsShown);
  58
  59
  60     template<size_t _Size>
  61     static ScRange insertRangeData(
  62         ScDocument* pDoc, const ScAddress& rPos, const char* aData[][_Size], size_t nRowCount )
  63     {
  64         ScRange aRange(rPos);
  65         aRange.aEnd.SetCol(rPos.Col()+_Size-1);
  66         aRange.aEnd.SetRow(rPos.Row()+nRowCount-1);
  67
  68         clearRange(pDoc, aRange);
  69
  70         for (size_t i = 0; i < _Size; ++i)
  71         {
  72             for (size_t j = 0; j < nRowCount; ++j)
  73             {
  74                 if (!aData[j][i])
  75                     continue;
  76
  77                 SCCOL nCol = i + rPos.Col();
  78                 SCROW nRow = j + rPos.Row();
  79                 OUString aStr(aData[j][i], strlen(aData[j][i]), RTL_TEXTENCODING_UTF8);
  80
  81                 ScSetStringParam aParam; // Leave default.
  82                 aParam.meStartListening = sc::NoListening;
  83                 pDoc->SetString(nCol, nRow, rPos.Tab(), aStr, &aParam);
  84             }
  85         }
  86
  87         pDoc->StartAllListeners(aRange);
  88
  89         printRange(pDoc, aRange, "Range data content");
  90         return aRange;
  91     }
  92
  93     Test();
  94     virtual ~Test();
  95
  96     ScDocShell& getDocShell();
  97
  98     virtual void setUp() SAL_OVERRIDE;
  99     virtual void tearDown() SAL_OVERRIDE;
 100
 101     /**
 102      * Basic performance regression test. Pick some actions that *should* take
 103      * only a fraction of a second to complete, and make sure they stay that
 104      * way. We set the threshold to 1 second for each action which should be
 105      * large enough to accommodate slower machines or machines with high load.
 106      */
 107     void testPerf();
 108     void testCollator();
 109     void testSharedStringPool();
 110     void testSharedStringPoolUndoDoc();
 111     void testRangeList();
 112     void testMarkData();
 113     void testInput();
 114     void testDocStatistics();
 115
 116     /**
 117      * The 'data entries' data is a list of strings used for suggestions as
 118      * the user types in new cell value.
 119      */
 120     void testDataEntries();
 121
 122     /**
 123      * Selection function is responsible for displaying quick calculation
 124      * results in the status bar.
 125      */
 126     void testSelectionFunction();
 127
 128     void testFormulaCreateStringFromTokens();
 129     void testFormulaParseReference();
 130     void testFetchVectorRefArray();
 131     void testFormulaHashAndTag();
 132     void testFormulaTokenEquality();
 133     void testFormulaRefData();
 134     void testFormulaCompiler();
 135     void testFormulaCompilerJumpReordering();
 136     void testFormulaRefUpdate();
 137     void testFormulaRefUpdateRange();
 138     void testFormulaRefUpdateSheets();
 139     void testFormulaRefUpdateSheetsDelete();
 140     void testFormulaRefUpdateInsertRows();
 141     void testFormulaRefUpdateInsertColumns();
 142     void testFormulaRefUpdateMove();
 143     void testFormulaRefUpdateMoveUndo();
 144     void testFormulaRefUpdateMoveToSheet();
 145     void testFormulaRefUpdateDeleteContent();
 146     void testFormulaRefUpdateDeleteAndShiftLeft();
 147     void testFormulaRefUpdateDeleteAndShiftUp();
 148     void testFormulaRefUpdateName();
 149     void testFormulaRefUpdateNameMove();
 150     void testFormulaRefUpdateNameExpandRef();
 151     void testFormulaRefUpdateNameDeleteRow();
 152     void testFormulaRefUpdateNameCopySheet();
 153     void testFormulaRefUpdateNameDelete();
 154     void testFormulaRefUpdateValidity();
 155     void testMultipleOperations();
 156     void testFuncCOLUMN();
 157     void testFuncCOUNT();
 158     void testFuncCOUNTBLANK();
 159     void testFuncROW();
 160     void testFuncSUM();
 161     void testFuncPRODUCT();
 162     void testFuncSUMPRODUCT();
 163     void testFuncMIN();
 164     void testFuncN();
 165     void testFuncCOUNTIF();
 166     void testFuncNUMBERVALUE();
 167     void testFuncLEN();
 168     void testFuncLOOKUP();
 169     void testFuncVLOOKUP();
 170     void testFuncMATCH();
 171     void testFuncCELL();
 172     void testFuncDATEDIF();
 173     void testFuncINDIRECT();
 174     void testFuncIF();
 175     void testFuncCHOOSE();
 176     void testFuncIFERROR();
 177     void testFuncSHEET();
 178     void testFuncNOW();
 179     void testFuncGETPIVOTDATA();
 180     void testFuncGETPIVOTDATALeafAccess();
 181     void testMatrixOp();
 182     void testFuncRangeOp();
 183
 184     void testExternalRef();
 185     void testExternalRefFunctions();
 186
 187     void testCopyToDocument();
 188
 189     void testHorizontalIterator();
 190     void testValueIterator();
 191     void testHorizontalAttrIterator();
 192
 193     /**
 194      * Basic test for formula dependency tracking.
 195      */
 196     void testFormulaDepTracking();
 197
 198     /**
 199      * Another test for formula dependency tracking, inspired by fdo#56278.
 200      */
 201     void testFormulaDepTracking2();
 202
 203     void testFormulaDepTracking3();
 204
 205     void testFormulaDepTrackingDeleteRow();
 206
 207     void testFormulaDepTrackingDeleteCol();
 208
 209     void testFormulaMatrixResultUpdate();
 210
 211     /**
 212      * More direct test for cell broadcaster management, used to track formula
 213      * dependencies.
 214      */
 215     void testCellBroadcaster();
 216
 217     void testFuncParam();
 218     void testNamedRange();
 219     void testInsertNameList();
 220     void testCSV();
 221     void testMatrix();
 222     void testMatrixComparisonWithErrors();
 223     void testEnterMixedMatrix();
 224     void testMatrixEditable();
 225
 226     /**
 227      * Basic test for pivot tables.
 228      */
 229     void testPivotTable();
 230
 231     /**
 232      * Test against unwanted automatic format detection on field names and
 233      * field members in pivot tables.
 234      */
 235     void testPivotTableLabels();
 236
 237     /**
 238      * Make sure that we set cells displaying date values numeric cells,
 239      * rather than text cells.  Grouping by date or number functionality
 240      * depends on this.
 241      */
 242     void testPivotTableDateLabels();
 243
 244     /**
 245      * Test for pivot table's filtering functionality by page fields.
 246      */
 247     void testPivotTableFilters();
 248
 249     /**
 250      * Test for pivot table's named source range.
 251      */
 252     void testPivotTableNamedSource();
 253
 254     /**
 255      * Test for pivot table cache.  Each dimension in the pivot cache stores
 256      * only unique values that are sorted in ascending order.
 257      */
 258     void testPivotTableCache();
 259
 260     /**
 261      * Test for pivot table containing data fields that reference the same
 262      * source field but different functions.
 263      */
 264     void testPivotTableDuplicateDataFields();
 265
 266     void testPivotTableNormalGrouping();
 267     void testPivotTableNumberGrouping();
 268     void testPivotTableDateGrouping();
 269     void testPivotTableEmptyRows();
 270     void testPivotTableTextNumber();
 271
 272     /**
 273      * Test for checking that pivot table treats strings in a case insensitive
 274      * manner.
 275      */
 276     void testPivotTableCaseInsensitiveStrings();
 277
 278     /**
 279      * Test for pivot table's handling of double-precision numbers that are
 280      * very close together.
 281      */
 282     void testPivotTableNumStability();
 283
 284     /**
 285      * Test for pivot table that include field with various non-default field
 286      * references.
 287      */
 288     void testPivotTableFieldReference();
 289
 290     /**
 291      * Test pivot table functionality performed via ScDBDocFunc.
 292      */
 293     void testPivotTableDocFunc();
 294
 295     /**
 296      * Test pivot table per-field repeat item labels functionality
 297      */
 298     void testPivotTableRepeatItemLabels();
 299
 300     void testCellCopy();
 301     void testSheetCopy();
 302     void testSheetMove();
 303     void testDataArea();
 304     void testAutofilter();
 305     void testCopyPaste();
 306     void testCopyPasteAsLink();
 307     void testCopyPasteTranspose();
 308     void testCopyPasteMultiRange();
 309     void testCopyPasteSkipEmpty();
 310     void testCopyPasteSkipEmpty2();
 311     void testCopyPasteSkipEmptyConditionalFormatting();
 312     void testCutPasteRefUndo();
 313     void testMoveRefBetweenSheets();
 314     void testUndoCut();
 315     void testMoveBlock();
 316     void testCopyPasteRelativeFormula();
 317     void testCopyPasteRepeatOneFormula();
 318     void testMergedCells();
 319     void testUpdateReference();
 320     void testSearchCells();
 321     void testSharedFormulas();
 322     void testSharedFormulasRefUpdate();
 323     void testSharedFormulasRefUpdateMove();
 324     void testSharedFormulasRefUpdateMove2();
 325     void testSharedFormulasRefUpdateRange();
 326     void testSharedFormulasRefUpdateRangeDeleteRow();
 327     void testSharedFormulasRefUpdateExternal();
 328     void testSharedFormulasInsertRow();
 329     void testSharedFormulasDeleteRows();
 330     void testSharedFormulasDeleteColumns();
 331     void testSharedFormulasRefUpdateMoveSheets();
 332     void testSharedFormulasRefUpdateCopySheets();
 333     void testSharedFormulasRefUpdateDeleteSheets();
 334     void testSharedFormulasCopyPaste();
 335     void testSharedFormulaInsertColumn();
 336     void testSharedFormulaMoveBlock();
 337     void testSharedFormulaUpdateOnNamedRangeChange();
 338     void testSharedFormulaUpdateOnDBChange();
 339     void testSharedFormulaAbsCellListener();
 340     void testSharedFormulaUnshareAreaListeners();
 341     void testFormulaPosition();
 342
 343     void testMixData();
 344
 345     /**
 346      * Make sure the sheet streams are invalidated properly.
 347      */
 348     void testStreamValid();
 349
 350     /**
 351      * Test built-in cell functions to make sure their categories and order
 352      * are correct.
 353      */
 354     void testFunctionLists();
 355
 356     void testGraphicsInGroup();
 357     void testGraphicsOnSheetMove();
 358
 359     /**
 360      * Test toggling relative/absolute flag of cell and cell range references.
 361      * This corresponds with hitting Shift-F4 while the cursor is on a formula
 362      * cell.
 363      */
 364     void testToggleRefFlag();
 365
 366     /**
 367      * Test to make sure correct precedent / dependent cells are obtained when
 368      * preparing to jump to them.
 369      */
 370     void testJumpToPrecedentsDependents();
 371
 372     void testSetBackgroundColor();
 373     void testRenameTable();
 374
 375     void testAutoFill();
 376     void testAutoFillSimple();
 377     void testCopyPasteFormulas();
 378     void testCopyPasteFormulasExternalDoc();
 379
 380     void testFindAreaPosVertical();
 381     void testFindAreaPosColRight();
 382     void testShiftCells();
 383
 384     void testSort();
 385     void testSortHorizontal();
 386     void testSortHorizontalWholeColumn();
 387     void testSortSingleRow();
 388     void testSortWithFormulaRefs();
 389     void testSortWithStrings();
 390     void testSortInFormulaGroup();
 391     void testSortWithCellFormats();
 392     void testSortRefUpdate();
 393     void testSortRefUpdate2();
 394     void testSortRefUpdate3();
 395     void testSortRefUpdate4();
 396     void testSortRefUpdate4_Impl();
 397     void testSortRefUpdate5();
 398     void testSortRefUpdate6();
 399     void testSortBroadcaster();
 400     void testSortOutOfPlaceResult();
 401     void testSortPartialFormulaGroup();
 402
 403     void testNoteBasic();
 404     void testNoteDeleteRow();
 405     void testNoteDeleteCol();
 406     void testNoteLifeCycle();
 407     void testNoteCopyPaste();
 408     void testAreasWithNotes();
 409     void testAnchoredRotatedShape();
 410     void testCellTextWidth();
 411     void testEditTextIterator();
 412
 413     void testCondFormatINSDEL();
 414     void testCondFormatInsertRow();
 415     void testCondFormatInsertCol();
 416     void testCondFormatInsertDeleteSheets();
 417     void testCondCopyPaste();
 418     void testCondCopyPasteSingleCell(); //e.g. fdo#82503
 419     void testCondCopyPasteSingleCellToRange(); //e.g. fdo#82503
 420     void testCondCopyPasteSheetBetweenDoc();
 421     void testCondCopyPasteSheet();
 422     void testIconSet();
 423     void testDataBarLengthAutomaticAxis();
 424     void testDataBarLengthMiddleAxis();
 425
 426     void testImportStream();
 427     void testDeleteContents();
 428     void testTransliterateText();
 429
 430     void testFormulaToValue();
 431     void testFormulaToValue2();
 432
 433     void testColumnFindEditCells();
 434     void testSetStringAndNote();
 435
 436     // tdf#80137
 437     void testCopyPasteMatrixFormula();
 438     void testUndoDataAnchor();
 439
 440     CPPUNIT_TEST_SUITE(Test);
 441 #if CALC_TEST_PERF
 442     CPPUNIT_TEST(testPerf);
 443 #endif
 444     CPPUNIT_TEST(testCollator);
 445     CPPUNIT_TEST(testSharedStringPool);
 446     CPPUNIT_TEST(testSharedStringPoolUndoDoc);
 447     CPPUNIT_TEST(testRangeList);
 448     CPPUNIT_TEST(testMarkData);
 449     CPPUNIT_TEST(testInput);
 450     CPPUNIT_TEST(testDocStatistics);
 451     CPPUNIT_TEST(testDataEntries);
 452     CPPUNIT_TEST(testSelectionFunction);
 453     CPPUNIT_TEST(testFormulaCreateStringFromTokens);
 454     CPPUNIT_TEST(testFormulaParseReference);
 455     CPPUNIT_TEST(testFetchVectorRefArray);
 456     CPPUNIT_TEST(testFormulaHashAndTag);
 457     CPPUNIT_TEST(testFormulaTokenEquality);
 458     CPPUNIT_TEST(testFormulaRefData);
 459     CPPUNIT_TEST(testFormulaCompiler);
 460     CPPUNIT_TEST(testFormulaCompilerJumpReordering);
 461     CPPUNIT_TEST(testFormulaRefUpdate);
 462     CPPUNIT_TEST(testFormulaRefUpdateRange);
 463     CPPUNIT_TEST(testFormulaRefUpdateSheets);
 464     CPPUNIT_TEST(testFormulaRefUpdateSheetsDelete);
 465     CPPUNIT_TEST(testFormulaRefUpdateInsertRows);
 466     CPPUNIT_TEST(testFormulaRefUpdateInsertColumns);
 467     CPPUNIT_TEST(testFormulaRefUpdateMove);
 468     CPPUNIT_TEST(testFormulaRefUpdateMoveUndo);
 469     CPPUNIT_TEST(testFormulaRefUpdateMoveToSheet);
 470     CPPUNIT_TEST(testFormulaRefUpdateDeleteContent);
 471     CPPUNIT_TEST(testFormulaRefUpdateDeleteAndShiftLeft);
 472     CPPUNIT_TEST(testFormulaRefUpdateDeleteAndShiftUp);
 473     CPPUNIT_TEST(testFormulaRefUpdateName);
 474     CPPUNIT_TEST(testFormulaRefUpdateNameMove);
 475     CPPUNIT_TEST(testFormulaRefUpdateNameExpandRef);
 476     CPPUNIT_TEST(testFormulaRefUpdateNameDeleteRow);
 477     CPPUNIT_TEST(testFormulaRefUpdateNameCopySheet);
 478     CPPUNIT_TEST(testFormulaRefUpdateNameDelete);
 479     CPPUNIT_TEST(testFormulaRefUpdateValidity);
 480     CPPUNIT_TEST(testMultipleOperations);
 481     CPPUNIT_TEST(testFuncCOLUMN);
 482     CPPUNIT_TEST(testFuncCOUNT);
 483     CPPUNIT_TEST(testFuncCOUNTBLANK);
 484     CPPUNIT_TEST(testFuncROW);
 485     CPPUNIT_TEST(testFuncSUM);
 486     CPPUNIT_TEST(testFuncPRODUCT);
 487     CPPUNIT_TEST(testFuncSUMPRODUCT);
 488     CPPUNIT_TEST(testFuncMIN);
 489     CPPUNIT_TEST(testFuncN);
 490     CPPUNIT_TEST(testFuncCOUNTIF);
 491     CPPUNIT_TEST(testFuncNUMBERVALUE);
 492     CPPUNIT_TEST(testFuncLEN);
 493     CPPUNIT_TEST(testFuncLOOKUP);
 494     CPPUNIT_TEST(testFuncVLOOKUP);
 495     CPPUNIT_TEST(testFuncMATCH);
 496     CPPUNIT_TEST(testFuncCELL);
 497     CPPUNIT_TEST(testFuncDATEDIF);
 498     CPPUNIT_TEST(testFuncINDIRECT);
 499     CPPUNIT_TEST(testFuncIF);
 500     CPPUNIT_TEST(testFuncCHOOSE);
 501     CPPUNIT_TEST(testFuncIFERROR);
 502     CPPUNIT_TEST(testFuncGETPIVOTDATA);
 503     CPPUNIT_TEST(testFuncGETPIVOTDATALeafAccess);
 504     CPPUNIT_TEST(testMatrixOp);
 505     CPPUNIT_TEST(testFuncRangeOp);
 506     CPPUNIT_TEST(testExternalRef);
 507     CPPUNIT_TEST(testExternalRefFunctions);
 508     CPPUNIT_TEST(testCopyToDocument);
 509     CPPUNIT_TEST(testFuncSHEET);
 510     CPPUNIT_TEST(testFuncNOW);
 511     CPPUNIT_TEST(testHorizontalIterator);
 512     CPPUNIT_TEST(testValueIterator);
 513     CPPUNIT_TEST(testHorizontalAttrIterator);
 514     CPPUNIT_TEST(testFormulaDepTracking);
 515     CPPUNIT_TEST(testFormulaDepTracking2);
 516     CPPUNIT_TEST(testFormulaDepTracking3);
 517     CPPUNIT_TEST(testFormulaDepTrackingDeleteRow);
 518     CPPUNIT_TEST(testFormulaDepTrackingDeleteCol);
 519     CPPUNIT_TEST(testFormulaMatrixResultUpdate);
 520     CPPUNIT_TEST(testCellBroadcaster);
 521     CPPUNIT_TEST(testFuncParam);
 522     CPPUNIT_TEST(testNamedRange);
 523     CPPUNIT_TEST(testInsertNameList);
 524     CPPUNIT_TEST(testCSV);
 525     CPPUNIT_TEST(testMatrix);
 526     CPPUNIT_TEST(testMatrixComparisonWithErrors);
 527     CPPUNIT_TEST(testEnterMixedMatrix);
 528     CPPUNIT_TEST(testMatrixEditable);
 529     CPPUNIT_TEST(testPivotTable);
 530     CPPUNIT_TEST(testPivotTableLabels);
 531     CPPUNIT_TEST(testPivotTableDateLabels);
 532     CPPUNIT_TEST(testPivotTableFilters);
 533     CPPUNIT_TEST(testPivotTableNamedSource);
 534     CPPUNIT_TEST(testPivotTableCache);
 535     CPPUNIT_TEST(testPivotTableDuplicateDataFields);
 536     CPPUNIT_TEST(testPivotTableNormalGrouping);
 537     CPPUNIT_TEST(testPivotTableNumberGrouping);
 538     CPPUNIT_TEST(testPivotTableDateGrouping);
 539     CPPUNIT_TEST(testPivotTableEmptyRows);
 540     CPPUNIT_TEST(testPivotTableTextNumber);
 541     CPPUNIT_TEST(testPivotTableCaseInsensitiveStrings);
 542     CPPUNIT_TEST(testPivotTableNumStability);
 543     CPPUNIT_TEST(testPivotTableFieldReference);
 544     CPPUNIT_TEST(testPivotTableDocFunc);
 545     CPPUNIT_TEST(testPivotTableRepeatItemLabels);
 546     CPPUNIT_TEST(testCellCopy);
 547     CPPUNIT_TEST(testSheetCopy);
 548     CPPUNIT_TEST(testSheetMove);
 549     CPPUNIT_TEST(testDataArea);
 550     CPPUNIT_TEST(testGraphicsInGroup);
 551     CPPUNIT_TEST(testGraphicsOnSheetMove);
 552     CPPUNIT_TEST(testStreamValid);
 553     CPPUNIT_TEST(testFunctionLists);
 554     CPPUNIT_TEST(testToggleRefFlag);
 555     CPPUNIT_TEST(testAutofilter);
 556     CPPUNIT_TEST(testCopyPaste);
 557     CPPUNIT_TEST(testCopyPasteAsLink);
 558     CPPUNIT_TEST(testCopyPasteTranspose);
 559     CPPUNIT_TEST(testCopyPasteMultiRange);
 560     CPPUNIT_TEST(testCopyPasteSkipEmpty);
 561     CPPUNIT_TEST(testCopyPasteSkipEmpty2);
 562     //CPPUNIT_TEST(testCopyPasteSkipEmptyConditionalFormatting);
 563     CPPUNIT_TEST(testCutPasteRefUndo);
 564     CPPUNIT_TEST(testMoveRefBetweenSheets);
 565     CPPUNIT_TEST(testUndoCut);
 566     CPPUNIT_TEST(testMoveBlock);
 567     CPPUNIT_TEST(testCopyPasteRelativeFormula);
 568     CPPUNIT_TEST(testCopyPasteRepeatOneFormula);
 569     CPPUNIT_TEST(testMergedCells);
 570     CPPUNIT_TEST(testUpdateReference);
 571     CPPUNIT_TEST(testSearchCells);
 572     CPPUNIT_TEST(testSharedFormulas);
 573     CPPUNIT_TEST(testSharedFormulasRefUpdate);
 574     CPPUNIT_TEST(testSharedFormulasRefUpdateMove);
 575     CPPUNIT_TEST(testSharedFormulasRefUpdateMove2);
 576     CPPUNIT_TEST(testSharedFormulasRefUpdateRange);
 577     CPPUNIT_TEST(testSharedFormulasRefUpdateRangeDeleteRow);
 578     CPPUNIT_TEST(testSharedFormulasRefUpdateExternal);
 579     CPPUNIT_TEST(testSharedFormulasInsertRow);
 580     CPPUNIT_TEST(testSharedFormulasDeleteRows);
 581     CPPUNIT_TEST(testSharedFormulasDeleteColumns);
 582     CPPUNIT_TEST(testSharedFormulasRefUpdateMoveSheets);
 583     CPPUNIT_TEST(testSharedFormulasRefUpdateCopySheets);
 584     CPPUNIT_TEST(testSharedFormulasRefUpdateDeleteSheets);
 585     CPPUNIT_TEST(testSharedFormulasCopyPaste);
 586     CPPUNIT_TEST(testSharedFormulaInsertColumn);
 587     CPPUNIT_TEST(testSharedFormulaUpdateOnNamedRangeChange);
 588     CPPUNIT_TEST(testSharedFormulaUpdateOnDBChange);
 589     CPPUNIT_TEST(testSharedFormulaAbsCellListener);
 590     CPPUNIT_TEST(testSharedFormulaUnshareAreaListeners);
 591     CPPUNIT_TEST(testFormulaPosition);
 592     CPPUNIT_TEST(testMixData);
 593     CPPUNIT_TEST(testJumpToPrecedentsDependents);
 594     CPPUNIT_TEST(testSetBackgroundColor);
 595     CPPUNIT_TEST(testRenameTable);
 596     CPPUNIT_TEST(testAutoFill);
 597     CPPUNIT_TEST(testAutoFillSimple);
 598     CPPUNIT_TEST(testCopyPasteFormulas);
 599     CPPUNIT_TEST(testCopyPasteFormulasExternalDoc);
 600     CPPUNIT_TEST(testFindAreaPosVertical);
 601     CPPUNIT_TEST(testFindAreaPosColRight);
 602     CPPUNIT_TEST(testSort);
 603     CPPUNIT_TEST(testSortHorizontal);
 604     CPPUNIT_TEST(testSortHorizontalWholeColumn);
 605     CPPUNIT_TEST(testSortSingleRow);
 606     CPPUNIT_TEST(testSortWithFormulaRefs);
 607     CPPUNIT_TEST(testSortWithStrings);
 608     CPPUNIT_TEST(testSortInFormulaGroup);
 609     CPPUNIT_TEST(testSortWithCellFormats);
 610     CPPUNIT_TEST(testSortRefUpdate);
 611     CPPUNIT_TEST(testSortRefUpdate2);
 612     CPPUNIT_TEST(testSortRefUpdate3);
 613     CPPUNIT_TEST(testSortRefUpdate4);
 614     CPPUNIT_TEST(testSortRefUpdate5);
 615     CPPUNIT_TEST(testSortRefUpdate6);
 616     CPPUNIT_TEST(testSortBroadcaster);
 617     CPPUNIT_TEST(testSortOutOfPlaceResult);
 618     CPPUNIT_TEST(testSortPartialFormulaGroup);
 619     CPPUNIT_TEST(testShiftCells);
 620     CPPUNIT_TEST(testNoteBasic);
 621     CPPUNIT_TEST(testNoteDeleteRow);
 622     CPPUNIT_TEST(testNoteDeleteCol);
 623     CPPUNIT_TEST(testNoteLifeCycle);
 624     CPPUNIT_TEST(testNoteCopyPaste);
 625     CPPUNIT_TEST(testAreasWithNotes);
 626     CPPUNIT_TEST(testAnchoredRotatedShape);
 627     CPPUNIT_TEST(testCellTextWidth);
 628     CPPUNIT_TEST(testEditTextIterator);
 629     CPPUNIT_TEST(testCondFormatINSDEL);
 630     CPPUNIT_TEST(testCondFormatInsertRow);
 631     CPPUNIT_TEST(testCondFormatInsertCol);
 632     CPPUNIT_TEST(testCondFormatInsertDeleteSheets);
 633     CPPUNIT_TEST(testCondCopyPaste);
 634     CPPUNIT_TEST(testCondCopyPasteSingleCell);
 635     CPPUNIT_TEST(testCondCopyPasteSingleCellToRange);
 636     CPPUNIT_TEST(testCondCopyPasteSheetBetweenDoc);
 637     CPPUNIT_TEST(testCondCopyPasteSheet);
 638     CPPUNIT_TEST(testIconSet);
 639     CPPUNIT_TEST(testDataBarLengthAutomaticAxis);
 640     CPPUNIT_TEST(testDataBarLengthMiddleAxis);
 641     CPPUNIT_TEST(testImportStream);
 642     CPPUNIT_TEST(testDeleteContents);
 643     CPPUNIT_TEST(testTransliterateText);
 644     CPPUNIT_TEST(testFormulaToValue);
 645     CPPUNIT_TEST(testFormulaToValue2);
 646     CPPUNIT_TEST(testColumnFindEditCells);
 647     CPPUNIT_TEST(testSetStringAndNote);
 648     CPPUNIT_TEST(testCopyPasteMatrixFormula);
 649     CPPUNIT_TEST(testUndoDataAnchor);
 650     CPPUNIT_TEST_SUITE_END();
 651
 652 private:
 653     TestImpl* m_pImpl;
 654     ScDocument *m_pDoc;
 655 };
 656
 657 #endif
 658
 659 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */