Description: See them when comparing .ods and .pdf files in the annex. -- I cannot find a way to "Add an attachment". Please download from https://www.dropbox.com/s/oo8a96mh9gbov0m/Wrong%20additions.zip?dl=0 Steps to Reproduce: 1.Open the attached examples in different hardware and operating systems. 2. 3. Actual Results: wrong additions Expected Results: correct additions Reproducible: Sometimes User Profile Reset: No Additional Info: I had reported one of these earlier (and using an earlier Version of Calc) in "[Bug 119448] Wrong addition in Libre Office Calc" but without the .pdf equivalent. So your Computer may simply have shown the correct addition.
Created attachment 148167 [details] 3 Calc files showing wrong additions together with their PDF images
tested with three version of Lo: 6.1.4.2; 6.2.0.1 and master with ctrl+shift+f9 i have the correct value and reinserting the formula does the same. after saving the file's the value stay's correct WFM
All these documents have a wrong value stored in the document file already. Recalculating (either F9 on a single wrong value, or Shift+Ctrl+F9 to recalculate all) produces the correct value. Documents seem to have been created with LibreOffice 5.3.7.2. Maybe AutoCalc was off when changing values and then turned on again, but a dependency for some reason was not recalculated? Or some other change did not trigger a proper update of the formula result? Anyway, there's not much we can do if wrong values are stored in the document, the documents need to get recalculated and saved again.
hello may i know whether this bug is assigned to anyone ,can the maintainer please assign it to me if it is unassigned.
*** Bug 119448 has been marked as a duplicate of this bug. ***
Eberhard, please do not submit new bug for already reported issue like this Bug 119448. Also: If reporting bug, do not put Dropbox and Drive links, but attach files. Do not zip it, but attach original. Do not say: Actual Results: wrong / Expected Results: correct but explain exactly what is actual and expected and where. Do not set Assignee to yourself, it's for developer. But prior to all, search for existing bugs and help - keyword is "recalculation". Raghu, this is your first message ever. Are you a developer? If yes, you can take this bug. Generally you may submit a code. But since we have Eike's comment here please explain first what's your expected solution. As for the bug: There are many similar cases. Underlying problem is that developers decided not to recalculate all the time on each fileopen. See Bug 107929 and Bug 107930. According to that, in attached ODS problem is not that it's now opened wrong (up to master 6.3+) but that cached values are saved wrong. And we don't know exactly how they were created, LO? which version? and how the problem arose in the first place. Just see Bug 120013 what may be the reason. So for "fileopen" as reported, this is WontFix (because cached value is wrong and LO will not recalculate by default). My personal solution is given in Bug 107929 and reporter may use it. If we (and here I mean "reporter") discover what's the exact cause of wrong saving value, first time it doesn't looks good, we may consider this a valid bug. Meaning: recalculate all and keep working until wrong value appears, then report what exactly you did.
Raghu, feel free to still assign and set to New if you have feasible solution.
Thanks to all of you! I will follow your hints. -- As I wrote, when completing the first screen I could not find a way to "Add an attachment" and did not expect it after Submission: (1) Please turn the text quoted into a link (or announce the subsequent possibility to attach files). -- My typing is miserable; perhaps I have inadvertently switched off (and on again) AutoCalc by some combination of keys: (2) A warning message may resolve the problem.