[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 |desktop.org | Status|NEW |ASSIGNED --- Comment #23 from Eike Rathke --- Taking. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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 bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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 time ... Thanks -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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 Ziemchanged: What|Removed |Added CC||ahz...@gmail.com --- Comment #20 from Andrew Ziem --- This bug still happens. That is, when I create an ANOVA the Total SS has ERR 508 until I edit it. LibreOffice version 6.0.0.3 Build ID 64a0f66915f38c6217de274f0aa8e15618924765 Ubuntu 16.04 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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 reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170901 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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 have 2 roots(2 correct answers), if I enter init value close to one(answer of bigger value), calc's algorithm can converge to it; if I enter init value close to another one(answer of smaller value), calc's algorithm can converge to it too, however, at the end, calc popup a "conclusion"-window which claimed (No Solution), and everything locked there unless I am be forced to click (OK), then that correct-smaller answer gone, back to original init value. I wish there is one post here when it be solved at some newer version maybe. Also, libreoffice 's calc algorithm spend a long time ~20-30 sec compare to another free-open-source on mathmatical calculation project, Octave, which can post out correct answers in 1 sec under my test. -- 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
[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 > nonlinear equation with one unknown; the correct answers have 2 roots(2 > correct answers), > if I enter init value close to one(answer of bigger value), calc's algorithm > can converge to it; if I enter init value close to another one(answer of > smaller value), calc's algorithm can converge to it too, however, at the > end, calc popup > a "conclusion"-window which claimed (No Solution), and everything locked > there unless I am be forced to click (OK), then that correct-smaller answer > gone, back to original init value. I wish there is one post here when it be > solved at some newer version maybe. Also, libreoffice 's calc algorithm > spend a long time ~20-30 sec compare to another free-open-source on > mathmatical calculation project, Octave, which can post out correct answers > in 1 sec under my test. This has nothing to do with this bug... except that both are in Calc. Create a new bug and provide an example document. -- 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
[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: 13010a13177025f633c9b85adcb3edf6920e44e3 Threads 4; Ver: Windows 6.19; Render: GL; Locale: zh-CN (zh_CN) -- 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
[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 the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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||mini...@poczta.onet.pl --- Comment #12 from Mirosław Zalewski mini...@poczta.onet.pl --- Few code pointers for those interested. Fixing this should be easy enough for people with basic knowledge of C++ (not me, unfortunately). sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx : Total Sum of Squares in one factor ANOVA is constructed by using applyRangeList method (line 324). Withing groups sum of squares is constructed by using lclCreateMultiParameterFormula() function (line 296), and between groups sum of squares has semicolon hardcoded (line 251). When output is written to spreadsheet, it's formula grammar is explicitly set to English (line 549). But applyRangeList method, defined in sc/source/ui/StatisticsDialogs/TableFillingAndNavigationTools.cxx line 65, uses mpDoc-GetAddressConvention() to format formula according to local grammar (I assume). This means that all formulas constructed using applyRangeList will return syntax error when local grammar is not compatible with English grammar. This affects only Total sum of squares of one factor ANOVA, but similar artifacts may be present in other statistical functions. -- 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
[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||qui...@gmail.com --- Comment #13 from Mirosław Zalewski mini...@poczta.onet.pl --- Hi Tomaz There is a problem while constructing formulas for one factor ANOVA. It affects Chinese users (and probably others who use comma as formula argument separators). Very similar to bug 76731. Could you take a look at this? -- 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
[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 comma as formula argument separators). Very similar to bug 76731. Could you take a look at this? Yes, sure I can. :) -- 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
[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 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
[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 when you reset your profile and go to Tools - Options - LibreOffice Calc - Formula - Separators: Function. * When I set the separator for function to ; then follow the steps, I do not get the Err:508. I think this may be why you do not reproduce this bug behaviour. * When I set the separator back to ,, I can reproduce this bug behaviour again. Also: * When set separator to ,, =SUM(1,2) and =SUM(1;2) all get result 3. (=SUM(1;2) will be atomically converted to =SUM(1,2) when you hit ENTER) * When set separator to ;, =SUM(1,2) results #NAME?, and =SUM(1;2) results 3. I hope these information will be helpful. Thanks! -- 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
[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 results error message. -- 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
[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 find comma for separator in functions and indeed this behaviour. But I think this is also the case for some other functions. It's already fine to have this. 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
[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||guillero...@aol.com --- Comment #6 from Jacques Guilleron guillero...@aol.com --- Hello Kevin, If I copy A1:B100 in a new sheet and generate ANOVA in D1, I don't reproduce the issue. 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. Input error? 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
[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 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
[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 |Analysis of Variance: DEVSQ |Variance (ANOVA): DEVSQ |returns Err:508, while |returns Err:508, while |direct DEVSQ formula|direct DEVSQ formula |returns correct result |returns correct result -- 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