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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128329
           Summary: 'incomplete autocalculations' - cooperation of
                    autocalculate and shared formulas / formulae still
                    broken in ver. 6.2.7.1 with *threaded* calculation on
           Product: LibreOffice
           Version: 6.2.7.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
hello to all, 

may be it's a duplicate?, may be it's claimed as 'fixed' in other threads? may
be it's left over from an incomplete patch. 

6.2.7.1 win(x64) does still produce errors or 'incomplete autocalculations'
while you work in threaded mode. 

thus, despite all plastering, this area isn't 'clean' yet. 

see attached file in next comment, the upper value in the red rectangle ist
calculated from the number below and the two values in the red ellipsoids.
check the formula bar. the result is obviously wrong. 

it resulted from pasting a line two lines below that line where the error shows
up, which reduced the value in the cell below by 10.000, that's obviously not
taken into account for the display of cell BA1436, despite the fact that
autocalculate is! on and works fine for nearly all cells in the sheet. 

it's happening randomly and not very often, i've seen it six times in the last
month and everytime instantly switched back to *unthreaded* calculation. 

the error can be 'corrected' by forced recalculation (srtg-shift-F9), but imho
that's not how spreadsheets are used normally, and if a wrong result is noted
and a weak bridge is build it's  not affected nor stabilisized by corrections
in the sheet. 

i think it would be a good idea if someone with programming and mathematical
skills looks in the code, and doesn't only plaster until he doesn't find errors
anymore, but tries an analysis for correctness. 

until that's done it's a good idea to either disable *treaded* mode, or at
least issue a warning to the users, 'careful, you are working in threaded mode,
results may be incorrect until you press <ctrl-shift-F9>'

Steps to Reproduce:
not yet tried due to lack of time, work in large sheets with multiple columns
calculating stacked on the previous line, such as financial sheets, implement
checksum or similar to detect errors ... 

Actual Results:
errors with cells not 'autoclculated' despite autocalculation is switched on, 

Expected Results:
correct calculation results for all cells, 


Reproducible: Sometimes


User Profile Reset: No



Additional Info:
Version: 6.2.7.1 (x64)
Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL

!the info was copied after! switching back to unthreaded! 

hardware 'all' doesnt mean i tested all, windows 'all' doesn't mean i tested
all, earliest affected doesn't mena earlier versions are proper, it's opposite,
all earlier versions have been worse, this bug is just to pinpoint that this
version - despite being the cleanest version i've ever seen - is also 'not
really clean'!

-- 
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/20191022/5e61d851/attachment.html>