[Libreoffice-bugs] [Bug 121103] ANOVA uses wrong formula when on new sheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Libomark <pnetmod at f2s.com> ---
This should be a very easy fix for anyone who has worked on Scaddins: most of
the formulae produced by ANOVA are correct, so there is already a good template
for the two that need amending. 

An alternative for the Total cell - Sheet2.C12 in the example file is to
replace

=DEVSQ($Sheet1.$B$1:$B$30,$Sheet1.$C$1:$C$30,$Sheet1.$D$1:$D$30)
with
=DEVSQ(($Sheet1.$B$1:$B$30),($Sheet1.$C$1:$C$30),($Sheet1.$D$1:$D$30))

only the extra brackets need inserting - the range and sheet references are
correct 

although =SUM($Sheet2.$C$10:$C$11) is simpler as a calculation for the same
result

(In this context Sheet2=OutputSheet Sheet1=DataSheet)

Sondra has nailed the amendment needed to the "Withing groups" calculation -
refer to the data input sheet in the formula references, rather than omitting
it.

-- 
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/20190112/28f016e9/attachment.html>