https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #7 from Kevin Suo <suokunl...@gmail.com> ---
(In reply to comment #6)

> If I copy A1:B100 in a new sheet and generate ANOVA in D1, I don't reproduce
> the issue. 
When you were generating ANOVA in D1, are you sure you are using A1:B100 as
data source? (not only a single cell?)
I can 100% reproduce even I copy A1:B100 anywhere.

Those numbers in A1:A100 were generated by using the "Edit - Fill - Random
Numbers".
In fact, even the following simple numbers in A1:B2 will get the same ERR 509:
1,2
3,4

> If now I select E11 and function wizard fx, I see the issue: Number 1 and
> Number 2 are together in the same input line, separated by a comma, wheras a
> semicolon is expected.

There is no problem with Number1 and Number2 separated by comma. In calc,
formula both accepts "," and ";". For example, "=SUM(1,2)" and "=SUM(1;2)" all
get the expected results.

> Input error?
The formula in E11 was not input manually, it was generated by "Data -
Statistics - Analysis of Variance". So even there was "input error", its not
the user's fault.
However, the reality is that, there is no input error. (If you copy and paste
the exact same formula within E11 to another cell, it get the expected result,
rather than ERR 508.)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to