[Libreoffice-bugs] [Bug 121103] New: Version: 6.1.2.1 Build ID: 65905a128db06ba48db947242809d14d3f9a93fe

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121103

            Bug ID: 121103
           Summary: Version: 6.1.2.1 Build ID:
                    65905a128db06ba48db947242809d14d3f9a93fe
           Product: LibreOffice
           Version: 6.1.2.1 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sondra.kinsey at gmx.com

Description:
In LibreOffice 6.1.2.1, when I create a new ANOVA by
Menu/Data/Statistics/ANOVA, if the "Results to" field is on a different sheet
than the original data, then the Sum of Squares" value for the "Within Groups"
comparison is incorrect.
Specifically, the formula for this cell doesn't specify the sheet for the cells
referred to. For my data, the formula for this cell was this:
  =SUM(DEVSQ($A$2:$A$30),DEVSQ($B$2:$B$30),DEVSQ($C$2:$C$30),DEVSQ($D$2:$D$30))
when it should have been this:
 
=SUM(DEVSQ($Sheet3.$A$2:$A$30),DEVSQ($Sheet3.$B$2:$B$30),DEVSQ($Sheet3.$C$2:$C$30),DEVSQ($Sheet3.$D$2:$D$30))
To the user, this usually appears as a "#DIV/0" error, because $A$2:$A$30 is
partially empty in the current ANOVA results sheet. Instead the formula needs
to refer to $A$2:$A$30 in the data sheet.


Steps to Reproduce:
1. Select data
2. Menu/Data/Statistics/ANOVA
3. Set "Results to" field of dialog to any cell on a different sheet than the
original data.

Actual Results:
The "Sum of Squares" (SS) value for the "Within Groups" comparison is "#DIV/0".
The formula refers to the sheet the ANOVA is found on.

Expected Results:
The formula refers to the sheet the originally selected data is found on.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181101/27f83220/attachment.html>