[Libreoffice-bugs] [Bug 125320] New: combination of autocalculate and shared formulae still broken in 6.3.0.0.alpha1+ with threaded off

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125320
           Summary: combination of autocalculate and shared formulae still
                    broken in 6.3.0.0.alpha1+ with threaded off
           Product: LibreOffice
           Version: 6.3.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
see file attached with next comment, 

(sorry for the size, the error happens in rare cases and in large sheets)

the results in CG1:CG1105 are obviously wrong, while CG1106:CG1365 are correct, 

*** with the same formula, and the same history how the line / formula is
created ***

ctrl-shift-F9 corrects the problem, thus *only* 'broken autocalculate', 

we had this sort of bugs for some time, i assume this problem is related to
plenty other bugs which i have difficulties to find because they are closed and
the headlines are changed, 'autocalculate' and 'shared formulae' together is
still buggy. 

i stepped into this while working on 124270 and having err:522 with threaded
enabled, boiling down and even disabling threaded results in this fault. 

i assume it's related to 123714 and 123736, seeing them not as the special
symptom handeled there but as one symptom of the general fault 'Yes their
(shared formulas) dependency handling is broken and was from the beginning it
seems'. 

my 2 cents, this should be fixed in general, or pulled out until it can be
solved, unconsistencies like this are fundamentally underminig the reliability
of calc. 

(it's of no use to fix the error appearing in column CG or special rows,
autocalculate should work correctly anytime and anywhere in the sheet while
turned on.) 

Steps to Reproduce:
1. open file attached with next comment, 
2. check results in CG1:CG1105 being '0' despite the formula should result in
'18', 
3. if corrected by recalc on load or other: 
4. i copied lines 1:8 from another sheet into this one, 
5. expanded A1:CZ5 down to row 1365, 
6. filled in some start values in row 1365, 
7. checked the results, 
(autocalculate was! on all the time), 

a second try overpasting the existing faulty sheet failed - to fail -, a third
attempt with deleting the contents in the sheet, pasting in 5 rows and pulling
A1:CZ5 down to 1300 inserting the same values in row 1300 produced faulty '0'
only in rows 1 to 5.  

Actual Results:
CG1:CG1105 display wrong result, 
until 'forced recalculation'

Expected Results:
CG1:CG1105 producing the same result as CG1106:CG1365, 
without requiring 'forced recalculation', 


Reproducible: Sometimes


User Profile Reset: No



Additional Info:
Version: 6.3.0.0.alpha1+ (x64)
Build ID: e92dcfdc7bd7b237e0bee26ff226a102d9e8e766
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86_64 at 42, Branch:master, Time: 2019-05-14_00:00:57
Locale: de-DE (de_DE); UI-Language: en-US
Calc: *unthreaded*

-- 
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/20190516/48b48002/attachment-0001.html>