sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)
New commits:
commit 205f9756f70fe32db169d6f81795f4c66382d014
Author: Jaromir Wysoglad <jaromirwysog...@gmail.com>
AuthorDate: Thu Mar 28 19:55:23 2019 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Wed Apr 3 11:18:42 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 <er...@redhat.com>
(cherry picked from commit 66c08a0d308fd6119460546a906434bbc9d23c2e)
Reviewed-on: https://gerrit.libreoffice.org/70153
diff --git a/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
b/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
index a655c8c1bd51..1f823fae8204 100644
--- a/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
+++ b/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx
@@ -67,7 +67,7 @@ OUString lclCreateMultiParameterFormula(
OUStringBuffer 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.append(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());
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
