[Libreoffice-bugs] [Bug 128329] WORK: 'incomplete autocalculations' - cooperation of autocalculate and shared formulas / formulae still broken in LO calc ver. 6.2.7.1 with *threaded* calculation on

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #13 from b. <newbie-02 at gmx.de> ---
got one catched, in ver. 6.1.6.3 'unparallelized', 

(i reported the bug as 'threaded' problem as i exprienced plenty fails in that
mode, work without threading or openCL since then, and now spotted that typical
bug without parallelizing) 

have the file open and can rollback - rollforward with ctrl-z, ctrl-y and see
the error evolving, 

will try to keep that file open and answer questions you have, can't provide it
for privacy reasons, and it's useless as the fail isn't reproducible in copies, 

failing region: in col AF about 300 formulas totaling from their respective
row, e.g. in AF70: '=SUM(D70:AD70)' - that's the affected cell -, theese
formulas are grouped in blocks, sometimes single, most 2 to 30 identic, one big
block over 100, the blocks are separated by empty cells, in two positions are
additional formulas which total from a part of  the column below it, e.g. in
AF62: '=SUM(AF64:AF282)' - which includes AF70, the block where AF70 is in is
old-24, new-25 'shared formulas', 

all other formulas are 'inside' their respective row, no cross row
calculations, 

steps the error evolved: 

- inserted one row at row 69 with 'alt-s r a', 'insert row above', making the
former row 69 to now row 70, 

- copied 'now row 70' to row 69 with ctrl-c - ctrl-v to get the needed
formulas, 

- cell AF70 with the formula above is totaling '1' from cell M70 and '1' from
cell U70 to '2', 

- pasting a '1' in cell I70 failed to update AF70, still '2', expected '3', 

as far as i understand: a group of 24 shared formulas was split between
position 1 and 2, formula from position 3 (former 2) is copied to position 2,
position 3 lost it's 'autocalc capability' (the property listening to updates
of referenced cells), 

doe's that help to catch the bug?

-- 
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/20201125/fda92217/attachment.htm>