https://bugs.freedesktop.org/show_bug.cgi?id=80583

Mirosław Zalewski <mini...@poczta.onet.pl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mini...@poczta.onet.pl

--- Comment #12 from Mirosław Zalewski <mini...@poczta.onet.pl> ---
Few code pointers for those interested. Fixing this should be easy enough for
people with basic knowledge of C++ (not me, unfortunately).

sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx :
Total Sum of Squares in one factor ANOVA is constructed by using applyRangeList
method (line 324). 
Withing groups sum of squares is constructed by using
lclCreateMultiParameterFormula() function (line 296), and between groups sum of
squares has semicolon hardcoded (line 251).

When output is written to spreadsheet, it's formula grammar is explicitly set
to English (line 549).

But applyRangeList method, defined in
sc/source/ui/StatisticsDialogs/TableFillingAndNavigationTools.cxx line 65, uses
mpDoc->GetAddressConvention() to format formula according to local grammar (I
assume).

This means that all formulas constructed using applyRangeList will return
syntax error when local grammar is not compatible with English grammar. This
affects only Total sum of squares of one factor ANOVA, but similar artifacts
may be present in other statistical functions.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to