[Libreoffice-bugs] [Bug 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 jaromirwysog...@gmail.com changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |jaromirwysog...@gmail.com |desktop.org | -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Xisco Faulí changed: What|Removed |Added Keywords||difficultyBeginner, ||easyHack, skillCpp, ||topicDebug -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #11 from Dennis Francis --- (In reply to Xisco Faulí from comment #9) > Hi Dennis Francis, > I thought you could be interested in this issue... > Is it already implemented by your multivariate regression work ? Hi Xisco, In the regression dialog, it checks if result sheet is same as the input sheet and uses this info to format the addresses/ranges in all formulae written to the result sheet. -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #10 from Dennis Francis --- The problem is at https://opengrok.libreoffice.org/xref/core/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx?r=470a91cb#70 where the ScRefFlags flag is hard-coded to ScRefFlags::RANGE_ABS. Instead it should be decided based on whether the input and output ranges/addresses are in same sheet or not - if they are in the same sheet then ScRefFlags::RANGE_ABS should be fine, else ScRefFlags::RANGE_ABS_3D should be used. I think this bug can be marked as an easy-hack for the new contributors with the above code-pointer to help them. -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Xisco Faulí changed: What|Removed |Added CC||dennisfrancis...@gmail.com --- Comment #9 from Xisco Faulí --- Hi Dennis Francis, I thought you could be interested in this issue... Is it already implemented by your multivariate regression work ? -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Keywords|easyHack| -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #8 from Libomark --- Dennis Francis, author of the new regression statistics interface to be released in 6.2, seems to think that his version (which also provides ANOVA results) works OK: https://dennisfrancis.wordpress.com/2018/07/03/multivariate-regression-in-calc/#comment-56 He has a slightly different approach to coding, as revealed here: https://cgit.freedesktop.org/libreoffice/core/commit/?id=b7a02f2bb66b990289eb7f4dc80069d1545179a4 -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Libomark changed: What|Removed |Added Keywords||easyHack -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #7 from Sondra Kinsey --- More specifically, line 309 here: https://gerrit.libreoffice.org/plugins/gitiles/core/+/8e1f198ae521c4b99ce5e8b03bf2c72849badbd2/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx#309 -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #6 from Sondra Kinsey --- Relevant code is at /sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx Link: https://gerrit.libreoffice.org/plugins/gitiles/core/+/8e1f198ae521c4b99ce5e8b03bf2c72849badbd2/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #5 from Libomark --- I have discovered that the Err508 problem has been addressed: https://bugs.documentfoundation.org/show_bug.cgi?id=80583 That still leaves the problem for output on a different sheet to the input data. The discussion at 80583 is helpful to someone seeking to resolve this bug, because it refers to the code location. -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 --- Comment #4 from Libomark --- This should be a very easy fix for anyone who has worked on Scaddins: most of the formulae produced by ANOVA are correct, so there is already a good template for the two that need amending. An alternative for the Total cell - Sheet2.C12 in the example file is to replace =DEVSQ($Sheet1.$B$1:$B$30,$Sheet1.$C$1:$C$30,$Sheet1.$D$1:$D$30) with =DEVSQ(($Sheet1.$B$1:$B$30),($Sheet1.$C$1:$C$30),($Sheet1.$D$1:$D$30)) only the extra brackets need inserting - the range and sheet references are correct although =SUM($Sheet2.$C$10:$C$11) is simpler as a calculation for the same result (In this context Sheet2=OutputSheet Sheet1=DataSheet) Sondra has nailed the amendment needed to the "Withing groups" calculation - refer to the data input sheet in the formula references, rather than omitting it. -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Libomark changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Libomark changed: What|Removed |Added CC||pnet...@f2s.com --- Comment #3 from Libomark --- Created attachment 148180 --> https://bugs.documentfoundation.org/attachment.cgi?id=148180=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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Joel Madero changed: What|Removed |Added Ever confirmed|0 |1 CC||jmadero@gmail.com Status|UNCONFIRMED |NEEDINFO --- Comment #2 from Joel Madero --- We need a simple (very simple) test document. Marking as NEEDINFO, once attachment is added set to UNCONFIRMED. Thank you. -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Sondra Kinsey changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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 121103] ANOVA uses wrong formula when on new sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=121103 Sondra Kinsey changed: What|Removed |Added Summary|Version: 6.1.2.1 Build ID: |ANOVA uses wrong formula |65905a128db06ba48db94724280 |when on new sheet |9d14d3f9a93fe | -- 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