diff options
| author | Jaromir Wysoglad <jaromirwysoglad@gmail.com> | 2019-03-28 19:55:23 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2019-04-03 11:18:42 +0200 |
| commit | 205f9756f70fe32db169d6f81795f4c66382d014 (patch) | |
| tree | d55bfec4a5bf09560a2cf919f7d573faa5015d79 /sc | |
| parent | 0ece057c0ed75c2de108fc89b6c4e963f8ee3363 (diff) | |
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@redhat.com>
(cherry picked from commit 66c08a0d308fd6119460546a906434bbc9d23c2e)
Reviewed-on: https://gerrit.libreoffice.org/70153
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx | 3 |
1 files changed, 1 insertions, 2 deletions
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()); |