[Libreoffice-bugs] [Bug 129199] New: AutoCalculate silent, deceptive fail. Indicative pattern of one edit step lag in AC update noticed.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129199
           Summary: AutoCalculate silent, deceptive fail. Indicative
                    pattern of one edit step lag in AC update noticed.
           Product: LibreOffice
           Version: 6.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rdbingham at verizon.net

Created attachment 156318
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156318&action=edit
Example .ods for AutoCalc deceptive fail

LO Version: 6.3.3.2 (x64)
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc:

OpenCL OFF
Multi-thread OFF
AutoCalculate ON

First noticed by accident in a multi-tab, complex, power-user spreadsheet.  The
attaced example .ods is an C/P extract of key rows for this demo in a multi-row
table with formulas otherwise unchanged in case exact formulas or their
complexity is an underlying indicator.  Only SOME cells in the orginal table
exhibit the AutoCalculate failure and not others.  This behavior also shows and
is annotated in the attached example.

The failure is silent for no Err: or message box indications.

The failure is decpetive because, as shown in this demo,
+ AutoCalulate DOES update when there is a change to a formula predecessor but
it updates with a STALE value, and
+ The update fail affects some cells but not others, so to the user's eye the
failures are spot fails buried in the visual clutter of the entire spreadsheet.
 In any but the simplest spreadsheet, to the user's eye the user does an input
value cell change and the dependent formula cells change value so it all looks
good unless by happenstance other parts of the spreadsheet obviously fail a
smell test or calc hand check.

Instructions with annotated, observed vs. expected results in the example file.
 Observed results were captured via copy the paste unformatted character. Cell
comment annotations to the right.  Notes on patterns noticed at the bottom.

I have marked this bug as MAJOR since it undermines the entire concept of
depending on LO Calc for even the simplest business or personal calculations.

WORAROUNDS: RECALCULATE (F9 on a selection) and HARD RECALCULATE (all cells) do
work.  But this depends on humans consistently remembering to do this.

-- 
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/20191204/e82fbc6b/attachment-0001.html>