[Libreoffice-bugs] [Bug 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #11 from diego.guella...@gmail.com --- OK. I confirm that I tried today to recreate the testcase by following my own instructions, and I haven't been able to reproduce it any more, both on my office PC and on my home PC. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 Eike Rathke changed: What|Removed |Added Resolution|--- |INSUFFICIENTDATA Status|UNCONFIRMED |RESOLVED --- Comment #10 from Eike Rathke --- Let's close. It can't be reproduced and it's unclear how and with which version those values initially were written (and not just loaded and saved without recalculation). -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 Joel Madero changed: What|Removed |Added CC||jmadero@gmail.com --- Comment #9 from Joel Madero --- Should this be closed given the comments? It's unclear if this is a one-off file that is not clear how it went awry (and thus no need to have an open bug report) or if it's a consistently reproducible problem across multiple files. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #8 from diego.guella...@gmail.com --- (In reply to Aron Budea from comment #7) > (In reply to diego.guella.85 from comment #5) > > Additional information: Original bug was encountered and reported from my > > office PC, which is a Core i7-920 on Windows 7 Pro SP1. I tried opening the > > testcase.ods file from my home PC, Core i7-6700k on Windows 10 Pro 1803, and > > got the same results. I confirm that recalculating with CTRL+SHIFT+F9 > > produces the right values here too, but simply opening the file I get the > > wrong ones. > The formula results are cached in the spreadsheet, so just opening the file > will produce wrong results everywhere, unless Calc is set to always > recalculate formula. What is interesting is what happens when you > recalculate, if the results are fine then, then that particular system+LO > combination is okay. I wasn't aware about that. So, I recreated the spreadsheet from a blank one on the Core i7-6700K Win10 Pro 1803, LO 5.4.7.2 x64, and I found no issues on the "0,2" row. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #7 from Aron Budea --- (In reply to diego.guella.85 from comment #5) > Additional information: Original bug was encountered and reported from my > office PC, which is a Core i7-920 on Windows 7 Pro SP1. I tried opening the > testcase.ods file from my home PC, Core i7-6700k on Windows 10 Pro 1803, and > got the same results. I confirm that recalculating with CTRL+SHIFT+F9 > produces the right values here too, but simply opening the file I get the > wrong ones. The formula results are cached in the spreadsheet, so just opening the file will produce wrong results everywhere, unless Calc is set to always recalculate formula. What is interesting is what happens when you recalculate, if the results are fine then, then that particular system+LO combination is okay. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #6 from diego.guella...@gmail.com --- Sorry, I forgot to mention: on my home PC I have LibreOffice 5.4.7.2 x64. The 6.0.6.2 version on my office PC is an x64 one too. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #5 from diego.guella...@gmail.com --- Additional information: Original bug was encountered and reported from my office PC, which is a Core i7-920 on Windows 7 Pro SP1. I tried opening the testcase.ods file from my home PC, Core i7-6700k on Windows 10 Pro 1803, and got the same results. I confirm that recalculating with CTRL+SHIFT+F9 produces the right values here too, but simply opening the file I get the wrong ones. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #4 from Aron Budea --- I tested with LO 6.0.6.2 / Windows 7, and got the correct values. Even typed/filled in the initial numbers/formula, so not just opened the file and recalculated the results. Both were fine. Version: 6.0.6.2 (x64) Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77 CPU threads: 16; OS: Windows 6.1; UI render: GL; Locale: hu-HU (hu_HU); Calc: CL -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 BogdanB changed: What|Removed |Added CC||bogdan...@gmail.com --- Comment #3 from BogdanB --- The same thing on Version: 6.2.0.0.alpha0+ Build ID: 3846561f79cf9065abd9ca83c9fbfbe7e52e28e2 CPU threads: 4; OS: Linux 4.15; UI render: GL; VCL: gtk3; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-10-21_02:45:54 Locale: en-US (ro_RO.UTF-8); Calc: threaded If recalculating (Shift+Ctrl+F9) the document produces correct values. But WHY this change? Why the figures change on a saved document?... -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 Eike Rathke changed: What|Removed |Added CC||er...@redhat.com --- Comment #2 from Eike Rathke --- The document contains values with precision errors, like the calculated value 400 in B5 was stored as office:value="400.0001"; the calculated value 400 in B7 was stored as office:value="399.". A manual =BITXOR(399., 1) also produces 398, same as =BITXOR(399,1) Recalculating (Shift+Ctrl+F9) the document after load produces correct values here on Linux. Saving the recalculated document results in correct office:value="400" and office:value="6400" in all cases. The test case document was generated using LibreOffice/6.0.6.2$Windows_X86_64 Is this reproducible for others? Btw, also the calculated value 6400 in B2 was stored as office:value="6400.001", the calculated value 6400 in B10 was stored as office:value="6400"; which both are stored as office:value="6400" after recalculating. -- 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 120939] Calc performs a wrong calculation!!!
https://bugs.documentfoundation.org/show_bug.cgi?id=120939 --- Comment #1 from diego.guella...@gmail.com --- Created attachment 146032 --> https://bugs.documentfoundation.org/attachment.cgi?id=146032=edit test case -- 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
