<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Data error risk from not calculating on large spreadsheets" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125052#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Data error risk from not calculating on large spreadsheets" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125052">bug 125052</a> from <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>it's a minefiled ... @davidpbrown is commenting about miscalculations ... resulting in wrong values displayed ... not pinpointing, no sample, may be diferent issues, thus somewhat unclear, but i think he's right, from my experience: - size of sheet likely is not causing issues, but 'helps' bugs and errors evolving unnoticed since harder to spot, - large sheets become slow, one can switch off autocalculate [menu - data - calculate - autocalculate] - be careful you have no sign that it's off, i haven't seen calc switching this off by itself, - there have been plenty and are still at least 3 ways to produce cells 'decoupled' from autocalculate, see bugs <a class="bz_bug_link bz_status_NEW " title="NEW - WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )" href="show_bug.cgi?id=128975">tdf#128975</a>, <a class="bz_bug_link bz_status_ASSIGNED " title="ASSIGNED - Wrong calculation after copy/paste of a formula" href="show_bug.cgi?id=132451">tdf#132451</a>, <a class="bz_bug_link bz_status_NEW " title="NEW - Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell" href="show_bug.cgi?id=132986">tdf#132986</a>, such things spreaded into a sheet is ... evil and hard to spot, see <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED DUPLICATE - clear reproducible error with combination of shared formulas, parallelized computing, autocalc weakness, see comment c#10 | was: Copying by dragging calculates false values (different every time)" href="show_bug.cgi?id=124577">tdf#124577</a>, - as @david mentioned ver. between 6.0 and 6.2: <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED DUPLICATE - clear reproducible error with combination of shared formulas, parallelized computing, autocalc weakness, see comment c#10 | was: Copying by dragging calculates false values (different every time)" href="show_bug.cgi?id=124577">tdf#124577</a> / <a class="bz_bug_link bz_status_ASSIGNED " title="ASSIGNED - Wrong calculation after copy/paste of a formula" href="show_bug.cgi?id=132451">tdf#132451</a> stepped in between 6.1.6.3 and 6.2.0 - i recently had a quite strange experience with vlookup, it suddenly pulled values from wrong rows in many similar tables (one row lower than it should have been), i'm not finished assigning it, i have / had 1 - older LO versions installed in parallel for research, 2 - M$S office 2010 installed in parallel for comparison, 3 - added several - ~20 - additional 'if-nested' vlookup functions in addition to the ~60 already existing in the sheet, i'm still trying to see if i can narrow it down, the error affected some but not all calculations / sheets, it was persistent, but disappeared when i tried to 'reduce' the sheet to provide a sample, - 'suggests "1048575 of 1048575 records found"' - vague remembering having seen similar, @david: what happens if you delete the rows below instead of their content? (don't worry, calc will give you new ones), thus ... it's likely that @david is right with his observations, but doesn't help identifying the issue(s), how to proceed?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>