[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #22 from raal --- Created attachment 142635 --> https://bugs.documentfoundation.org/attachment.cgi?id=142635=edit Calc 6.2master -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #21 from raal --- LO 6.2master - bug still happens in Total cell. It doesn't work in EN language settings, but works in CZ language settings (comma as decimal separator, ; as separator in functions) Tomaz,if you find some

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 Andrew Ziem changed: What|Removed |Added CC||ahz...@gmail.com

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #19 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #17 from fs...@yahoo.com --- in my trial(12/23/2015), a very similar problem on my 5.0.2 LibraOffice download, about calc to using its (tools->solver) to solve a simple nonlinear equation with one unknown; the correct answers

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #18 from Tomaz Vajngerl --- (In reply to fsshl from comment #17) > in my trial(12/23/2015), a very similar problem on my 5.0.2 LibraOffice > download, about calc to using its (tools->solver) to solve a simple

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #16 from Kevin Suo --- Bug still exists in: Version: 5.0.4.1 (x64) Build ID: 2def61bcbb29a7a8611b833682fe1291910b11ad Locale: zh-CN (zh_CN) also exists in: Version: 5.1.0.0.beta1-buildfix1 (x64) Build ID:

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.documentfoundation.org/show_bug.cgi?id=80583 --- Comment #15 from Kevin Suo suokunl...@126.com --- This bug still exists with: Version: 5.0.0.1 Build ID: 9a0b23dd0ab9652e0965484934309f2d49a7758e Locale: zh-CN (zh_CN) -- You are receiving this mail because: You are the assignee for

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 Mirosław Zalewski mini...@poczta.onet.pl changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 Mirosław Zalewski mini...@poczta.onet.pl changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 --- Comment #14 from Tomaz Vajngerl qui...@gmail.com --- (In reply to Mirosław Zalewski from comment #13) Hi Tomaz There is a problem while constructing formulas for one factor ANOVA. It affects Chinese users (and probably others who use

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

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

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 --- Comment #9 from Kevin Suo suokunl...@gmail.com --- (In reply to comment #8) Hi, Jacques. Thank you very much for your useful info. This bug is becoming really interesting. * By default, LibreOffice uses , as separator. (This can be verified

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 --- Comment #10 from Kevin Suo suokunl...@gmail.com --- (In reply to comment #9) So I guess maybe libreoffice is using ; as separator when applying Data - Statistics - Analysis of Variance, even if the separator for calc is configured as ,, thus

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 --- Comment #11 from Jacques Guilleron guillero...@aol.com --- Well done! Kevin, you got it ! That's the right explanation. I forgot to look at there. Another difficulty: those parameters are locale dependent. If I set Locale to English(USA), I

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 Jacques Guilleron guillero...@aol.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

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

[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

https://bugs.freedesktop.org/show_bug.cgi?id=80583 Jay Philips philip...@hotmail.com changed: What|Removed |Added Summary|Data - Statistics - |EDITING: Analysis of