[Libreoffice-bugs] [Bug 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=46845 --- Comment #8 from b. --- for this and the plenty other questions / bugs regarding circular references / iterative calculations: explanation of the calculation order used in ex$el: https://stackoverflow.com/questions/18084718/calculation-order-when-iterative-calculation-circular-reference-is-enabled checked with ex$el 2010, works that way, is there a similar description for calc? differences: for a recalc - F9 - excel does a round as described above, while calc looks like start at the cell in focus, and stops after one round? (after which definition? re-raeching that cell?) thus some calculations give different results, ex$el does show 'invalid results' (results not converging and being off limt of 'minimum change') after the set number of steps, while calc shows err:523 if not reached the change limit, (try second variant of first example from https://www.spreadsheetweb.com/excel-iterative-calculation/ there are also samples to use iterations for timestamping ...) from C3: '=C4' and C4: '=C3+1' resulting in identical values (after hard recalc with one iteration and minimum change > 1) and results being different by one if you exchange the cells, i'd conclude that calc calculates from bottom to top, from C3 '=D3' and D3: '=C3+1' resulting in identical values (after hard recalc with one iteration and minimum change > 1) and the left cell being one more than the other if you exchange them, i'd conclude that calc calculates from right to left, from C3 '=D2' and D2: '=C3+1' resulting in identical values (after hard recalc with one iteration and minimum change > 1) and D2 being one more than C3 if you move it to B4, i'd conclude that calc first calculates the rightmost column from bottom to top, and then advances left to the next columns, so there are simple but significant differences between the schemes of Ex$el and calc to solve circular references, since the choice of the starting point and the calculation path are important for the output of iterative calculations it is normal that Ex$el and calc give different results, big question: 'do we find our own way right (and if so why 'more right' than Ex$el), or do we want to work more towards Ex$el compatibility? and! who dares to tackle this 'hairy soup'? (cited from erAck) -- 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 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=46845 b. changed: What|Removed |Added CC||newbie...@gmx.de --- Comment #7 from b. --- yes, there is still something buggy ... funny ... odd ... strange ... curious ... weird ... with 'calc and iterations'. testing with the file submitted it's clear: - it has circular references (e.g. C5 depends on C30, C30 depends on C27, C27 depends on C5) and needs iterations to solve. the solveability and what result is 'suspected' to be the correct result is difficult, sometimes undefined, and depends heavily on start conditions. (a very simple sample: A1:'10', B1:'=A1+10', C1:'=B1-10' will show | 10 | 20 | 10 |, what if you change A1 to '=C1'? i got as well | 10 | 20 | 10 | as | 0 | 10 | 0 | as results, and both are correct, even | 100 | 110 | 100 | is correct, and you can provoke it by changing A1 from '100' to '=C1'.) implementations in spreadsheets should try to come to a 'human acceptable' solution?, that's - in most cases - achieveable with the logic and default settings in calc , but not in all. on this sample and with ver. below i see three things 'funny': - if you provoke an err. condition by switching iterations off and on again calc produces heavily deviating results, (about 2.000.000 'off' in D37:G37 while C37 likes to stuck in err:523). hard recalc shows that better results are! possible except for C37, that's trapped. - the excel results in the provided pdf have no results in D35 and D37, the '20.000.000 case', i hope that's a fault from excel. - column C being trapped in the err: condition. this quite old case shows what kohei yoshida wrote somewhere about recursions / iterations in calc: 'old big problem, nothing to be fixed overnight', behaviour independent from file format (xls or ods). tested with ver. Version: 6.4.0.1 (x64) Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: GL; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: CL 'unthreaded' and 'unCL' and 'un-both-of-them' have the same problems ... -- 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 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=46845 hardcoder changed: What|Removed |Added Blocks||126866 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=126866 [Bug 126866] Iteration not only bug-laden, but neglected and misunderstood -- 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 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=46845 --- Comment #6 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.1.6 or 5.2.3 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-20161108 -- 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 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=46845 Beluga changed: What|Removed |Added CC||todven...@suomi24.fi --- Comment #5 from Beluga --- Yeah, erroring. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: fcc2415ade6ae93710bbbda9f7e163045e323105 TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-10-21_16:55:13 Locale: fi-FI (fi_FI) -- 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 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=46845 --- Comment #4 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 (4.4.1 or later): 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-07-18 -- 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 46845] Iterations not converging in Calc
https://bugs.freedesktop.org/show_bug.cgi?id=46845 Kevin Suo changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=46850 -- 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 46845] Iterations not converging in Calc
https://bugs.freedesktop.org/show_bug.cgi?id=46845 sasha.libreoff...@gmail.com changed: What|Removed |Added Status|UNCONFIRMED |NEW Severity|major |normal CC||sasha.libreoff...@gmail.com Ever Confirmed|0 |1 Version|unspecified |LibO 3.3.4 release --- Comment #3 from sasha.libreoff...@gmail.com 2012-05-29 07:01:36 PDT --- Thanks for bugreport reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit and in 3.5.2 on Windows 7 What is interesting: in column C all calculated. Problem appears in all remaining columns. When I delete content of cell in row 24 (name of row "Remainder after Option exercise proceeds"), all values in that column becomes calculated. Then I press Ctrl-Z, and values still calculated. And pressing F9 nothing changes. But values differs from Excel. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 46845] Iterations not converging in Calc
https://bugs.freedesktop.org/show_bug.cgi?id=46845 --- Comment #2 from sasha.libreoff...@gmail.com 2012-05-29 06:52:32 PDT --- Created attachment 62227 --> https://bugs.freedesktop.org/attachment.cgi?id=62227 previous document, saved as pdf using msExcel 2007 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 46845] Iterations not converging in Calc
https://bugs.freedesktop.org/show_bug.cgi?id=46845 Jose Manuel changed: What|Removed |Added Platform|x86 (IA32) |All OS/Version|Linux (All) |All Version|LibO 3.3.4 release |unspecified -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 46845] Iterations not converging in Calc
https://bugs.freedesktop.org/show_bug.cgi?id=46845 Jose Manuel changed: What|Removed |Added Platform|All |x86 (IA32) OS/Version|All |Linux (All) Version|LibO 3.5.0 Release |LibO 3.3.4 release --- Comment #1 from Jose Manuel 2012-04-20 12:56:53 PDT --- [Reproducible] with "LibreOffice 3.3.4 - Ubuntu 11.04 (32bit) Spanish UI" -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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