https://bugs.freedesktop.org/show_bug.cgi?id=80583
--- Comment #8 from Jacques Guilleron <guillero...@aol.com> --- Hello Kevin, Installed in a new profile, I don't reproduce the issue with LO 4.2.5.2 and Windows 7 Home Premium. > When you were generating ANOVA in D1, are you sure you are using A1:B100 as > > data source? (not only a single cell?) Yes. Dialog window at the beginning was made for that. > I can 100% reproduce even I copy A1:B100 anywhere. OK. > Those numbers in A1:A100 were generated by using the "Edit - Fill - Random > > Numbers". If I copied them, it's mainly to have the same results with ANOVA. > In fact, even the following simple numbers in A1:B2 will get the same ERR 509: > 1,2 > 3,4 OK. > 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. I don't think so. "SUM(1,2)" give me "1,2", "SUM(1, 2)" give "Err:509" and delete the comma, and "SUM(1;2)" give "3". Anyway, for ANNOVA, changing the comma by semicolon give the result into the formula of Total. > 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. Yes. You are right and that has to be fixed. > 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.) If I do that, I get Err:501 regards, Jacques -- 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