[Libreoffice-bugs] [Bug 125052] Data error risk from not calculating on large spreadsheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125052

--- Comment #9 from b. <newbie-02 at gmx.de> ---
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 tdf#128975, tdf#132451, tdf#132986,
such things spreaded into a sheet is ... evil and hard to spot, see tdf#124577, 

- as @david mentioned ver. between 6.0 and 6.2: tdf#124577 / tdf#132451 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?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200615/68b0b202/attachment-0001.htm>