<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Version: 6.1.2.1 Build ID: 65905a128db06ba48db947242809d14d3f9a93fe"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121103">121103</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Version: 6.1.2.1 Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.2.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>sondra.kinsey@gmx.com
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>