sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.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
  11 #include <sfx2/dispatch.hxx>
  12 #include <svl/zforlist.hxx>
  13 #include <svl/undo.hxx>
  14
  15 #include "formulacell.hxx"
  16 #include "rangelst.hxx"
  17 #include "scitems.hxx"
  18 #include "docsh.hxx"
  19 #include "document.hxx"
  20 #include "uiitems.hxx"
  21 #include "reffact.hxx"
  22 #include "strload.hxx"
  23 #include "docfunc.hxx"
  24 #include "StatisticsDialogs.hrc"
  25 #include "TableFillingAndNavigationTools.hxx"
  26
  27 #include "AnalysisOfVarianceDialog.hxx"
  28
  29 namespace
  30 {
  31
  32 struct StatisticCalculation {
  33     sal_Int16   aLabelId;
  34     const char* aFormula;
  35     const char* aResultRangeName;
  36 };
  37
  38 static StatisticCalculation lclBasicStatistics[] =
  39 {
  40     { STR_ANOVA_LABEL_GROUPS, NULL,                NULL          },
  41     { STRID_CALC_COUNT,       "=COUNT(%RANGE%)",   "COUNT_RANGE" },
  42     { STRID_CALC_SUM,         "=SUM(%RANGE%)",     "SUM_RANGE"   },
  43     { STRID_CALC_MEAN,        "=AVERAGE(%RANGE%)", "MEAN_RANGE"  },
  44     { STRID_CALC_VARIANCE,    "=VAR(%RANGE%)",     "VAR_RANGE"   },
  45     { 0,                      NULL,                NULL          }
  46 };
  47
  48 static sal_Int16 lclAnovaLabels[] =
  49 {
  50     STR_ANOVA_LABEL_SOURCE_OF_VARIATION,
  51     STR_ANOVA_LABEL_SS,
  52     STR_ANOVA_LABEL_DF,
  53     STR_ANOVA_LABEL_MS,
  54     STR_ANOVA_LABEL_F,
  55     STR_ANOVA_LABEL_P_VALUE,
  56     STR_ANOVA_LABEL_F_CRITICAL,
  57     0
  58 };
  59
  60 static const char strWildcardRange[] = "%RANGE%";
  61 static const char strWildcardNumber[] = "%NUMBER%";
  62
  63 OUString lclCreateMultiParameterFormula(
  64             ScRangeList&        aRangeList, const OUString& aFormulaTemplate,
  65             const OUString&     aWildcard,  ScDocument*     pDocument,
  66             ScAddress::Details& aAddressDetails)
  67 {
  68     OUString aResult;
  69     for (size_t i = 0; i < aRangeList.size(); i++)
  70     {
  71         OUString aRangeString(aRangeList[i]->Format(SCR_ABS, pDocument, aAddressDetails));
  72         OUString aFormulaString = aFormulaTemplate.replaceAll(aWildcard, aRangeString);
  73         aResult += aFormulaString;
  74         if(i != aRangeList.size() - 1) // Not Last
  75             aResult+= ";";
  76     }
  77     return aResult;
  78 }
  79
  80 void lclMakeSubRangesList(ScRangeList& rRangeList, ScRange& rInputRange, ScStatisticsInputOutputDialog::GroupedBy aGroupedBy)
  81 {
  82     boost::scoped_ptr<DataRangeIterator> pIterator;
  83     if (aGroupedBy == ScStatisticsInputOutputDialog::BY_COLUMN)
  84         pIterator.reset(new DataRangeByColumnIterator(rInputRange));
  85     else
  86         pIterator.reset(new DataRangeByRowIterator(rInputRange));
  87
  88     for( ; pIterator->hasNext(); pIterator->next() )
  89     {
  90         ScRange aRange = pIterator->get();
  91         rRangeList.Append(aRange);
  92     }
  93 }
  94
  95 }
  96
  97 ScAnalysisOfVarianceDialog::ScAnalysisOfVarianceDialog(
  98                     SfxBindings* pSfxBindings, SfxChildWindow* pChildWindow,
  99                     vcl::Window* pParent, ScViewData* pViewData ) :
 100     ScStatisticsInputOutputDialog(
 101             pSfxBindings, pChildWindow, pParent, pViewData,
 102             "AnalysisOfVarianceDialog", "modules/scalc/ui/analysisofvariancedialog.ui" ),
 103     meFactor(SINGLE_FACTOR)
 104 {
 105     get(mpAlphaField,         "alpha-spin");
 106     get(mpSingleFactorRadio,  "radio-single-factor");
 107     get(mpTwoFactorRadio,     "radio-two-factor");
 108     get(mpRowsPerSampleField, "rows-per-sample-spin");
 109
 110     mpSingleFactorRadio->SetToggleHdl( LINK( this, ScAnalysisOfVarianceDialog, FactorChanged ) );
 111     mpTwoFactorRadio->SetToggleHdl( LINK( this, ScAnalysisOfVarianceDialog, FactorChanged ) );
 112
 113     mpSingleFactorRadio->Check(true);
 114     mpTwoFactorRadio->Check(false);
 115
 116     FactorChanged(NULL);
 117 }
 118
 119 ScAnalysisOfVarianceDialog::~ScAnalysisOfVarianceDialog()
 120 {
 121     disposeOnce();
 122 }
 123
 124 void ScAnalysisOfVarianceDialog::dispose()
 125 {
 126     mpAlphaField.clear();
 127     mpSingleFactorRadio.clear();
 128     mpTwoFactorRadio.clear();
 129     mpRowsPerSampleField.clear();
 130     ScStatisticsInputOutputDialog::dispose();
 131 }
 132
 133 bool ScAnalysisOfVarianceDialog::Close()
 134 {
 135     return DoClose( ScAnalysisOfVarianceDialogWrapper::GetChildWindowId() );
 136 }
 137
 138 sal_Int16 ScAnalysisOfVarianceDialog::GetUndoNameId()
 139 {
 140     return STR_ANALYSIS_OF_VARIANCE_UNDO_NAME;
 141 }
 142
 143 IMPL_LINK_NOARG( ScAnalysisOfVarianceDialog, FactorChanged )
 144 {
 145     if (mpSingleFactorRadio->IsChecked())
 146     {
 147         mpGroupByRowsRadio->Enable(true);
 148         mpGroupByColumnsRadio->Enable(true);
 149         mpRowsPerSampleField->Enable(false);
 150         meFactor = SINGLE_FACTOR;
 151     }
 152     else if (mpTwoFactorRadio->IsChecked())
 153     {
 154         mpGroupByRowsRadio->Enable(false);
 155         mpGroupByColumnsRadio->Enable(false);
 156         mpRowsPerSampleField->Enable(false); // Rows per sample not yet implemented
 157         meFactor = TWO_FACTOR;
 158     }
 159
 160     return 0;
 161 }
 162
 163 void ScAnalysisOfVarianceDialog::RowColumn(ScRangeList& rRangeList, AddressWalkerWriter& aOutput, FormulaTemplate& aTemplate,
 164                                            OUString& sFormula, GroupedBy aGroupedBy, ScRange* pResultRange)
 165 {
 166     if (pResultRange != NULL)
 167         pResultRange->aStart = aOutput.current();
 168     if (!sFormula.isEmpty())
 169     {
 170         for (size_t i = 0; i < rRangeList.size(); i++)
 171         {
 172             ScRange* pRange = rRangeList[i];
 173             aTemplate.setTemplate(sFormula);
 174             aTemplate.applyRange(strWildcardRange, *pRange);
 175             aOutput.writeFormula(aTemplate.getTemplate());
 176             if (pResultRange != NULL)
 177                 pResultRange->aEnd = aOutput.current();
 178             aOutput.nextRow();
 179         }
 180     }
 181     else
 182     {
 183         sal_Int16 aLabelId = (aGroupedBy == BY_COLUMN) ? STR_COLUMN_LABEL_TEMPLATE : STR_ROW_LABEL_TEMPLATE;
 184         OUString aLabelTemplate(SC_STRLOAD(RID_STATISTICS_DLGS, aLabelId));
 185
 186         for (size_t i = 0; i < rRangeList.size(); i++)
 187         {
 188             aTemplate.setTemplate(aLabelTemplate);
 189             aTemplate.applyNumber(strWildcardNumber, i + 1);
 190             aOutput.writeString(aTemplate.getTemplate());
 191             if (pResultRange != NULL)
 192                 pResultRange->aEnd = aOutput.current();
 193             aOutput.nextRow();
 194         }
 195     }
 196 }
 197
 198 void ScAnalysisOfVarianceDialog::AnovaSingleFactor(AddressWalkerWriter& output, FormulaTemplate& aTemplate)
 199 {
 200     output.writeBoldString(SC_STRLOAD(RID_STATISTICS_DLGS, STR_ANOVA_SINGLE_FACTOR_LABEL));
 201     output.newLine();
 202
 203     double aAlphaValue = mpAlphaField->GetValue() / 100.0;
 204     output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, STR_LABEL_ALPHA));
 205     output.nextColumn();
 206     output.writeValue(aAlphaValue);
 207     aTemplate.autoReplaceAddress("%ALPHA%", output.current());
 208     output.newLine();
 209     output.newLine();
 210
 211     // Write labels
 212     for(sal_Int32 i = 0; lclBasicStatistics[i].aLabelId != 0; i++)
 213     {
 214         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, lclBasicStatistics[i].aLabelId));
 215         output.nextColumn();
 216     }
 217     output.newLine();
 218
 219     // Collect aRangeList
 220     ScRangeList aRangeList;
 221     lclMakeSubRangesList(aRangeList, mInputRange, mGroupedBy);
 222
 223     output.push();
 224
 225     // Write values
 226     for(sal_Int32 i = 0; lclBasicStatistics[i].aLabelId != 0; i++)
 227     {
 228         output.resetRow();
 229         ScRange aResultRange;
 230         OUString sFormula = OUString::createFromAscii(lclBasicStatistics[i].aFormula);
 231         RowColumn(aRangeList, output, aTemplate, sFormula, mGroupedBy, &aResultRange);
 232         output.nextColumn();
 233         if (lclBasicStatistics[i].aResultRangeName != NULL)
 234         {
 235             OUString sResultRangeName = OUString::createFromAscii(lclBasicStatistics[i].aResultRangeName);
 236             aTemplate.autoReplaceRange("%" + sResultRangeName + "%", aResultRange);
 237         }
 238     }
 239
 240     output.nextRow(); // Blank row
 241
 242     // Write ANOVA labels
 243     output.resetColumn();
 244     for(sal_Int32 i = 0; lclAnovaLabels[i] != 0; i++)
 245     {
 246         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, lclAnovaLabels[i]));
 247         output.nextColumn();
 248     }
 249     output.nextRow();
 250
 251     aTemplate.autoReplaceRange("%FIRST_COLUMN%", *aRangeList[0]);
 252
 253     // Between Groups
 254     {
 255         // Label
 256         output.resetColumn();
 257         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, STR_ANOVA_LABEL_BETWEEN_GROUPS));
 258         output.nextColumn();
 259
 260         // Sum of Squares
 261
 262         aTemplate.setTemplate("=SUMPRODUCT(%SUM_RANGE%;%MEAN_RANGE%)-SUM(%SUM_RANGE%)^2/SUM(%COUNT_RANGE%)");
 263         aTemplate.autoReplaceAddress("%BETWEEN_SS%", output.current());
 264         output.writeFormula(aTemplate.getTemplate());
 265         output.nextColumn();
 266
 267         // Degree of freedom
 268         aTemplate.setTemplate("=COUNT(%SUM_RANGE%)-1");
 269         aTemplate.autoReplaceAddress("%BETWEEN_DF%", output.current());
 270         output.writeFormula(aTemplate.getTemplate());
 271         output.nextColumn();
 272
 273         // MS
 274         aTemplate.setTemplate("=%BETWEEN_SS% / %BETWEEN_DF%");
 275         aTemplate.autoReplaceAddress("%BETWEEN_MS%", output.current());
 276         output.writeFormula(aTemplate.getTemplate());
 277         output.nextColumn();
 278
 279         // F
 280         aTemplate.setTemplate("=%BETWEEN_MS% / %WITHIN_MS%");
 281         aTemplate.applyAddress("%WITHIN_MS%",  output.current(-1, 1));
 282         aTemplate.autoReplaceAddress("%F_VAL%", output.current());
 283         output.writeFormula(aTemplate.getTemplate());
 284         output.nextColumn();
 285
 286         // P-value
 287         aTemplate.setTemplate("=FDIST(%F_VAL%; %BETWEEN_DF%; %WITHIN_DF%");
 288         aTemplate.applyAddress("%WITHIN_DF%",   output.current(-3, 1));
 289         output.writeFormula(aTemplate.getTemplate());
 290         output.nextColumn();
 291
 292         // F critical
 293         aTemplate.setTemplate("=FINV(%ALPHA%; %BETWEEN_DF%; %WITHIN_DF%");
 294         aTemplate.applyAddress("%WITHIN_DF%",  output.current(-4, 1));
 295         output.writeFormula(aTemplate.getTemplate());
 296     }
 297     output.nextRow();
 298
 299     // Within Groups
 300     {
 301         // Label
 302         output.resetColumn();
 303         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, STR_ANOVA_LABEL_WITHIN_GROUPS));
 304         output.nextColumn();
 305
 306         // Sum of Squares
 307         OUString aSSPart = lclCreateMultiParameterFormula(aRangeList, OUString("DEVSQ(%RANGE%)"), strWildcardRange, mDocument, mAddressDetails);
 308         aTemplate.setTemplate("=SUM(%RANGE%)");
 309         aTemplate.applyString(strWildcardRange, aSSPart);
 310         aTemplate.autoReplaceAddress("%WITHIN_SS%", output.current());
 311         output.writeFormula(aTemplate.getTemplate());
 312         output.nextColumn();
 313
 314         // Degree of freedom
 315         aTemplate.setTemplate("=SUM(%COUNT_RANGE%)-COUNT(%COUNT_RANGE%)");
 316         aTemplate.autoReplaceAddress("%WITHIN_DF%", output.current());
 317         output.writeFormula(aTemplate.getTemplate());
 318         output.nextColumn();
 319
 320         // MS
 321         aTemplate.setTemplate("=%WITHIN_SS% / %WITHIN_DF%");
 322         output.writeFormula(aTemplate.getTemplate());
 323     }
 324     output.nextRow();
 325
 326     // Total
 327     {
 328         // Label
 329         output.resetColumn();
 330         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, STR_ANOVA_LABEL_TOTAL));
 331         output.nextColumn();
 332
 333         // Sum of Squares
 334         aTemplate.setTemplate("=DEVSQ(%RANGE_LIST%)");
 335         aTemplate.applyRangeList("%RANGE_LIST%", aRangeList);
 336         output.writeFormula(aTemplate.getTemplate());
 337         output.nextColumn();
 338
 339         // Degree of freedom
 340         aTemplate.setTemplate("=SUM(%COUNT_RANGE%) - 1");
 341         output.writeFormula(aTemplate.getTemplate());
 342     }
 343     output.nextRow();
 344 }
 345
 346 void ScAnalysisOfVarianceDialog::AnovaTwoFactor(AddressWalkerWriter& output, FormulaTemplate& aTemplate)
 347 {
 348     output.writeBoldString(SC_STRLOAD(RID_STATISTICS_DLGS, STR_ANOVA_TWO_FACTOR_LABEL));
 349     output.newLine();
 350
 351     double aAlphaValue = mpAlphaField->GetValue() / 100.0;
 352     output.writeString("Alpha");
 353     output.nextColumn();
 354     output.writeValue(aAlphaValue);
 355     aTemplate.autoReplaceAddress("%ALPHA%", output.current());
 356     output.newLine();
 357     output.newLine();
 358
 359     // Write labels
 360     for(sal_Int32 i = 0; lclBasicStatistics[i].aLabelId != 0; i++)
 361     {
 362         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, lclBasicStatistics[i].aLabelId));
 363         output.nextColumn();
 364     }
 365     output.newLine();
 366
 367     ScRangeList aColumnRangeList;
 368     ScRangeList aRowRangeList;
 369
 370     lclMakeSubRangesList(aColumnRangeList, mInputRange, BY_COLUMN);
 371     lclMakeSubRangesList(aRowRangeList, mInputRange, BY_ROW);
 372
 373     // Write ColumnX values
 374     output.push();
 375     for(sal_Int32 i = 0; lclBasicStatistics[i].aLabelId != 0; i++)
 376     {
 377         output.resetRow();
 378         ScRange aResultRange;
 379         OUString sFormula = OUString::createFromAscii(lclBasicStatistics[i].aFormula);
 380         RowColumn(aColumnRangeList, output, aTemplate, sFormula, BY_COLUMN, &aResultRange);
 381         if (lclBasicStatistics[i].aResultRangeName != NULL)
 382         {
 383             OUString sResultRangeName = OUString::createFromAscii(lclBasicStatistics[i].aResultRangeName);
 384             aTemplate.autoReplaceRange("%" + sResultRangeName + "_COLUMN%", aResultRange);
 385         }
 386         output.nextColumn();
 387     }
 388     output.newLine();
 389
 390     // Write RowX values
 391     output.push();
 392     for(sal_Int32 i = 0; lclBasicStatistics[i].aLabelId != 0; i++)
 393     {
 394         output.resetRow();
 395         ScRange aResultRange;
 396         OUString sFormula = OUString::createFromAscii(lclBasicStatistics[i].aFormula);
 397         RowColumn(aRowRangeList, output, aTemplate, sFormula, BY_ROW, &aResultRange);
 398
 399         if (lclBasicStatistics[i].aResultRangeName != NULL)
 400         {
 401             OUString sResultRangeName = OUString::createFromAscii(lclBasicStatistics[i].aResultRangeName);
 402             aTemplate.autoReplaceRange("%" + sResultRangeName + "_ROW%", aResultRange);
 403         }
 404         output.nextColumn();
 405     }
 406     output.newLine();
 407
 408     // Write ANOVA labels
 409     for(sal_Int32 i = 0; lclAnovaLabels[i] != 0; i++)
 410     {
 411         output.writeString(SC_STRLOAD(RID_STATISTICS_DLGS, lclAnovaLabels[i]));
 412         output.nextColumn();
 413     }
 414     output.nextRow();
 415
 416     // Setup auto-replace strings
 417     aTemplate.autoReplaceRange(strWildcardRange, mInputRange);
 418     aTemplate.autoReplaceRange("%FIRST_COLUMN%", *aColumnRangeList[0]);
 419     aTemplate.autoReplaceRange("%FIRST_ROW%",    *aRowRangeList[0]);
 420
 421     // Rows
 422     {
 423         // Label
 424         output.resetColumn();
 425         output.writeString("Rows");
 426         output.nextColumn();
 427
 428         // Sum of Squares
 429         aTemplate.setTemplate("=SUMPRODUCT(%SUM_RANGE_ROW%;%MEAN_RANGE_ROW%) - SUM(%RANGE%)^2 / COUNT(%RANGE%)");
 430         aTemplate.autoReplaceAddress("%ROW_SS%", output.current());
 431         output.writeFormula(aTemplate.getTemplate());
 432         output.nextColumn();
 433
 434         // Degree of freedom
 435         aTemplate.setTemplate("=MAX(%COUNT_RANGE_COLUMN%) - 1");
 436         aTemplate.autoReplaceAddress("%ROW_DF%", output.current());
 437         output.writeFormula(aTemplate.getTemplate());
 438         output.nextColumn();
 439
 440         // MS
 441         aTemplate.setTemplate("=%ROW_SS% / %ROW_DF%");
 442         aTemplate.autoReplaceAddress("%MS_ROW%", output.current());
 443         output.writeFormula(aTemplate.getTemplate());
 444         output.nextColumn();
 445
 446         // F
 447         aTemplate.setTemplate("=%MS_ROW% / %MS_ERROR%");
 448         aTemplate.applyAddress("%MS_ERROR%", output.current(-1, 2));
 449         aTemplate.autoReplaceAddress("%F_ROW%", output.current());
 450         output.writeFormula(aTemplate.getTemplate());
 451         output.nextColumn();
 452
 453         // P-value
 454         aTemplate.setTemplate("=FDIST(%F_ROW%; %ROW_DF%; %ERROR_DF%");
 455         aTemplate.applyAddress("%ERROR_DF%",   output.current(-3, 2));
 456         output.writeFormula(aTemplate.getTemplate());
 457         output.nextColumn();
 458
 459         // F critical
 460         aTemplate.setTemplate("=FINV(%ALPHA%; %ROW_DF%; %ERROR_DF%");
 461         aTemplate.applyAddress("%ERROR_DF%",  output.current(-4, 2));
 462         output.writeFormula(aTemplate.getTemplate());
 463         output.nextColumn();
 464     }
 465     output.nextRow();
 466
 467     // Columns
 468     {
 469         // Label
 470         output.resetColumn();
 471         output.writeString("Columns");
 472         output.nextColumn();
 473
 474         // Sum of Squares
 475         aTemplate.setTemplate("=SUMPRODUCT(%SUM_RANGE_COLUMN%;%MEAN_RANGE_COLUMN%) - SUM(%RANGE%)^2 / COUNT(%RANGE%)");
 476         aTemplate.autoReplaceAddress("%COLUMN_SS%", output.current());
 477         output.writeFormula(aTemplate.getTemplate());
 478         output.nextColumn();
 479
 480         // Degree of freedom
 481         aTemplate.setTemplate("=MAX(%COUNT_RANGE_ROW%) - 1");
 482         aTemplate.autoReplaceAddress("%COLUMN_DF%", output.current());
 483         output.writeFormula(aTemplate.getTemplate());
 484         output.nextColumn();
 485
 486         // MS
 487         aTemplate.setTemplate("=%COLUMN_SS% / %COLUMN_DF%");
 488         aTemplate.autoReplaceAddress("%MS_COLUMN%", output.current());
 489         output.writeFormula(aTemplate.getTemplate());
 490         output.nextColumn();
 491
 492         // F
 493         aTemplate.setTemplate("=%MS_COLUMN% / %MS_ERROR%");
 494         aTemplate.applyAddress("%MS_ERROR%", output.current(-1, 1));
 495         aTemplate.autoReplaceAddress("%F_COLUMN%", output.current());
 496         output.writeFormula(aTemplate.getTemplate());
 497         output.nextColumn();
 498
 499          // P-value
 500         aTemplate.setTemplate("=FDIST(%F_COLUMN%; %COLUMN_DF%; %ERROR_DF%");
 501         aTemplate.applyAddress("%ERROR_DF%",   output.current(-3, 1));
 502         output.writeFormula(aTemplate.getTemplate());
 503         output.nextColumn();
 504
 505         // F critical
 506         aTemplate.setTemplate("=FINV(%ALPHA%; %COLUMN_DF%; %ERROR_DF%");
 507         aTemplate.applyAddress("%ERROR_DF%",  output.current(-4, 1));
 508         output.writeFormula(aTemplate.getTemplate());
 509         output.nextColumn();
 510     }
 511     output.nextRow();
 512
 513     // Error
 514     {
 515         // Label
 516         output.resetColumn();
 517         output.writeString("Error");
 518         output.nextColumn();
 519
 520         // Sum of Squares
 521         aTemplate.setTemplate("=SUMSQ(%RANGE%)+SUM(%RANGE%)^2/COUNT(%RANGE%) - (SUMPRODUCT(%SUM_RANGE_ROW%;%MEAN_RANGE_ROW%) + SUMPRODUCT(%SUM_RANGE_COLUMN%;%MEAN_RANGE_COLUMN%))");
 522         aTemplate.autoReplaceAddress("%ERROR_SS%", output.current());
 523         output.writeFormula(aTemplate.getTemplate());
 524         output.nextColumn();
 525
 526         // Degree of freedom
 527         aTemplate.setTemplate("=%TOTAL_DF% - %ROW_DF% - %COLUMN_DF%");
 528         aTemplate.applyAddress("%TOTAL_DF%", output.current(0,1,0));
 529         aTemplate.autoReplaceAddress("%ERROR_DF%", output.current());
 530         output.writeFormula(aTemplate.getTemplate());
 531         output.nextColumn();
 532
 533         // MS
 534         aTemplate.setTemplate("=%ERROR_SS% / %ERROR_DF%");
 535         output.writeFormula(aTemplate.getTemplate());
 536     }
 537     output.nextRow();
 538
 539      // Total
 540     {
 541         // Label
 542         output.resetColumn();
 543         output.writeString("Total");
 544         output.nextColumn();
 545
 546         // Sum of Squares
 547         aTemplate.setTemplate("=SUM(%ROW_SS%;%COLUMN_SS%;%ERROR_SS%)");
 548         output.writeFormula(aTemplate.getTemplate());
 549         output.nextColumn();
 550
 551         // Degree of freedom
 552         aTemplate.setTemplate("=COUNT(%RANGE%)-1");
 553         output.writeFormula(aTemplate.getTemplate());
 554         output.nextColumn();
 555     }
 556 }
 557
 558 ScRange ScAnalysisOfVarianceDialog::ApplyOutput(ScDocShell* pDocShell)
 559 {
 560     AddressWalkerWriter output(mOutputAddress, pDocShell, mDocument,
 561         formula::FormulaGrammar::mergeToGrammar(formula::FormulaGrammar::GRAM_ENGLISH, mAddressDetails.eConv));
 562     FormulaTemplate aTemplate(mDocument);
 563
 564     if (meFactor == SINGLE_FACTOR)
 565     {
 566         AnovaSingleFactor(output, aTemplate);
 567     }
 568     else if (meFactor == TWO_FACTOR)
 569     {
 570         AnovaTwoFactor(output, aTemplate);
 571     }
 572
 573     return ScRange(output.mMinimumAddress, output.mMaximumAddress);
 574 }
 575
 576 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */