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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
