[Libreoffice-commits] core.git: Branch 'libreoffice-6-1' - sc/source

[Jaromir Wysoglad (via logerrit)]

 sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx |    3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

New commits:
commit 1dc8088162a66a99217dae3258711cbfa8f9bc28
Author:     Jaromir Wysoglad <jaromirwysoglad at gmail.com>
AuthorDate: Thu Mar 28 19:55:23 2019 +0100
Commit:     Eike Rathke <erack at redhat.com>
CommitDate: Wed Apr 3 11:18:55 2019 +0200

    tdf#121103 ANOVA sum of squares formula correction
    
    The ANOVA sum of squares is now hardcoded to use '$Sheet?' in the
    source cell addless every time.
    
    Change-Id: I215b719be11ecfc2ae20c5df8e86876bc22d50f0
    Reviewed-on: https://gerrit.libreoffice.org/69899
    Tested-by: Jenkins
    Reviewed-by: Eike Rathke <erack at redhat.com>
    (cherry picked from commit 66c08a0d308fd6119460546a906434bbc9d23c2e)
    Reviewed-on: https://gerrit.libreoffice.org/70155
    Reviewed-by: vyzigold <jaromirwysoglad at gmail.com>

diff --git a/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx b/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
index c31fc9fb4c09..14662c18b3b0 100644
--- a/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
+++ b/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
@@ -67,7 +67,7 @@ OUString lclCreateMultiParameterFormula(
     OUString aResult;
     for (size_t i = 0; i < aRangeList.size(); i++)
     {
-        OUString aRangeString(aRangeList[i].Format(ScRefFlags::RANGE_ABS, pDocument, aAddressDetails));
+        OUString aRangeString(aRangeList[i].Format(ScRefFlags::RANGE_ABS_3D, pDocument, aAddressDetails));
         OUString aFormulaString = aFormulaTemplate.replaceAll(aWildcard, aRangeString);
         aResult += aFormulaString;
         if(i != aRangeList.size() - 1) // Not Last
@@ -260,7 +260,6 @@ void ScAnalysisOfVarianceDialog::AnovaSingleFactor(AddressWalkerWriter& output,
         output.nextColumn();
 
         // Sum of Squares
-
         aTemplate.setTemplate("=SUMPRODUCT(%SUM_RANGE%;%MEAN_RANGE%)-SUM(%SUM_RANGE%)^2/SUM(%COUNT_RANGE%)");
         aTemplate.autoReplaceAddress("%BETWEEN_SS%", output.current());
         output.writeFormula(aTemplate.getTemplate());