[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

Libomark <pnetmod at f2s.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |pnetmod at f2s.com

--- Comment #3 from Libomark <pnetmod at f2s.com> ---
Created attachment 148180
  --> https://bugs.documentfoundation.org/attachment.cgi?id=148180&action=edit
Example of ANOVA calculation problem

This is an example sheet illustrating the problem.  Data is in Sheet1.b1:d30

ANOVA (single factor) was performed with Sheet1.G2 as the output start cell:
the generated formula for total variation in Sheet1.H13 is incorrect, producing
Err:508 - it should simply be SUM(Sheet1.H11:H12) 

ANOVA (single factor) was performed again with Sheet2.B1 as the output start
cell.  Cells C11 and C12 on Sheet2 (highlighted in yellow) contain incorrect
formulae, as specified above and in the original comment.  This echoes through
to dependent cells.

ANOVA was also performed on a two factor basis with Sheet2.B19 as the
destination.  This appears to work correctly.

-- 
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/20190109/44a274fb/attachment-0001.html>