[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 #19 from b. <newbie-02 at gmx.de> ---
Created attachment 166689
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166689&action=edit
screenshot of a sporadic dropout of autocalculate

besides mostly suffering from a missing dot ('.') in
'=IF($Data.A1="LS";$datax10;$Data.L2)' in Activity.E59 - probably intended as 
'=IF($Data.A1="LS";$Data.X10;$Data.L2)' - 
the file from @Vincent likely had the common 'not update' problem of 7.0.2.2,
but that's something different than @davidpbrown described (@Vincent
reproducible, also on small files, only in 7.0.2.2, @davidpbrown hard repro,
only big files, plenty versions), 

thus it's neither a dup, nor a valid repro, nor a proof of solved, unduping and
setting 'needinfo', 

@davidpbrown, if you ever again stumble over such behaviour try to 'catch' it,
keep the last saved version of the file (don't! 'save'), do a 'save a copy',
try with ctrl-z and ctrl-y to find the step(s) injecting the error, make 'save
a copie(s)' from states before and after, note a script which changes you did
from the beginning, try if reproducible, if yes try to anonymize the file
(there is a wiki somewhere around how to do) and if the error is kept, provide
whatever you can, 

for linux there shall be a tool to work with journaling capabilities which can
save a file together with start state and rollforward journal, 

if your errors affect multiple cells not dependent of each other they are
different from what i experienced sometimes, for me it was sporadic fails for
one cell and sometimes others referencing it, 

(got one 'catched' recently, including rollback - rollforward and screen
recording, but :-( not reproducible from new load, and with ver. 6.1.6.3 which
i have to do my daily work in, thus 'outdated' and likey that flavour fixed
inbetween, thus not going to invest the effort to anonymize the video,
screenshot is attached ... it occured after copying the range S22:CG24 to
S23:CG25, doing some changes in texts in S22:CG22 and some other cells, none
referencing or being referenced from V22:AV22, changing two values and some
text entries in V22:AV22 (was identical to V23:AV23 before because copied),
noticing AX22 not! updated, you can see the correct formula in the input line,
and the wrong result in the cell, autocalculate was! on, 'threaded' and openCL
were off)

-- 
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/20201025/88d85bca/attachment.htm>