[Libreoffice-bugs] [Bug 123714] New: calc autocalculate failing sometimes on editing (move or delete of cells or undo) in ranges referenced in formulas

Tue Feb 26 07:02:48 UTC 2019

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

            Bug ID: 123714
           Summary: calc autocalculate failing sometimes on editing (move
                    or delete of cells or undo) in ranges referenced in
                    formulas
           Product: LibreOffice
           Version: 4.2.0.4 release
          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:
i observed some funny malfunctions, 

suspect them being results of malfunctioning 'autocalculate', 

(strg-shift-F9 corrects them) 

got a hint on #121002, tested the 'fix' mentioned there with ver. dev
6.2.2.0.0, 

got funny results again, 

(sum of a range not updated after deleting the content of one of the cells in
the calculated range), 

i tried to produce a script to reproduce, 

got one for moving cells, see in 'steps to reproduce', 

acc. to my testing still buggy in ver. dev 6.2.2.0.0

a long description and links to other errors which i suspect being related to
this bug you can find in 

https://ask.libreoffice.org/en/question/184419/strange-wrong-results-in-lo-calc-autocalculate-broken/

Steps to Reproduce:
0. maybee simpler sheets fail too, i had no time to check, 

1. create a new sheet, 

2. check that autocalculate is on, 

3. enter '77,05' in C2, C3, C4 (without the quotation marks), 

4. enter '1,1' in D1 (without the quotation marks), 

5. enter '1,2' in E1 (without the quotation marks),

6. enter formula '=$C2*A2*D$1' in D2 (without quotation marks)

7. copy this formula to E2

8. mark cells D2 and E2 and drag down - expand - the formula to D2:E4, 

9. enter '1' in A2, A3, A4 (without the quotation marks),

10. observe results in D2:D4,

11. select cells A2 and A3 and move them with the mouse to B2:B3, 

12. check the results in E2:E3, in my case E3 gave a result, but E2 remained
'0' despite that the formula and referenced cells should produce the same
result as E3, 

13. triggering a 'hard recalc' with 'strg-shift-F9' changes the value shown in
E2 from '0' to '92,46', that looks better, 

14. from other research i suspect something fundamentally broken with
autocalculate since ver. 4.2.2 and request in depth  research and fixing, it
can't be tolerated that a productive software produces results 'by chance', 

15. frequently pressing 'ctrl-shift-F9' may help, but i'd prefer a functioning
function 'autocalculate' as it was in versions up to 4.1.6.2, 

Actual Results:
E2 is not! updated as expected, 

the result shown in E2: '0' and the formula in the cell: '=$C2*B2*E$1' do not
match!

E3 is! updated, 

E2 is! updated after pressing ctrl-shift-F9

Expected Results:
E2 should be updated by autocalculate in the same manner as E3

when autocalculate is on cell E2 should always! show a value that matches the
formula in the cell, 

Reproducible: Sometimes

User Profile Reset: No

Additional Info:
i think this bug is one of a group of similar malfunctions based on one
fundamental fault. it is severe and should not! be plastered with something
that corrects just this occurence, instead someone should try to find and
correct the fundamental error.  

hardware all: i couldn't test on 'all' systems, other reports reg. similar
malfunctions let me think the fault is hardware independent, 

OS all: same as above, 

happens sometimes: the bug shows up in random rare cases, the script i provided
is somewhat 'stable' in failing 

latest tested version: 

Version: 6.2.2.0.0+ (x64)
Build ID: f184af314ec43fbac5bb22cd3ebc09ccdf865a7c
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86_64 at 42, Branch:libreoffice-6-2, Time: 2019-02-24_01:44:59
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
See Log: f184af314ec43fbac5bb22cd3ebc09ccdf865a7c

first version i found complaints over similar problems: 

4.2, 

i tested: 

- 4.1.6.2 being free of all malfunctions i found reported on the web, 

- 4.2.0.1 changing the behaviour how to adopt formulas with references to
ranges when cells within the range are moved, 

- many inbetween, x86 as well as x64, all having randomly inconsistent
behaviour reg. what and when is to be 'autocalculated' on deletion, move or
undos in referenced ranges, 

- the ocurrence of the errors is unpredictible, mostly the calculations are
correct, the errors show up in random places, random situations and random
times, it's difficult to catch one reproducible, 

- the malfunction is somehow dependent on the place in the sheet, if you copy
the range A1:G4 produced with the script above to another place in the sheet -
e.g. A6 or I1 - the results there are correct, in my case E2 still shows '0'
despite plenty cells in the sheet have been altered and autocalculate should!
have been triggered! 

user profile: i'd reset once when testing on version 5.4.X, no change, 

opengl: the many occurences reported on the web make me believe it's a
fundamental fault in design, openglviewer is announced to be 'not signed', at
the moment i'd like to avoid treating my system with more unsigned software 

- i think the bug isn't just a problem in view, if the affected cells are used
in other calculations the results there become buggy too, you can test in the
script provided, entering '=E2*2' in G2 will show '0',

-- 
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/20190226/80a224d9/attachment-0001.html>