[Libreoffice-bugs] [Bug 137797] New: Some cells with formula do not Update

Tue Oct 27 11:59:59 UTC 2020

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

            Bug ID: 137797
           Summary: Some cells with formula do not Update
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86 (IA32)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: fedelop at gmail.com

Description:
I create anew calc sheet and some cells updateswhile other don't.
User can't rely on the cell results, some updaets and some do not. 
If some cell update this could lead to think every cell value is correct, when
is is not.
Data->Calculate->Autocalculate is checked
Tools->Options->Libreoffice Calc->Formula->Recalculation on File Load both set
to Always recalculate.

F9 manual calculation works and updates all cells but Autocalculate is not
working on A3 and A4. 

Steps to Reproduce:
1. Create new spreadsheet
2. Enter cell value A1=1
3. A2 = A1*20000
4. A3 = 0.42* SQRT(A2)
5. A4 = 0.016 * A2
6. Change values in A1, A2 updates but A3 and A4 do not 

Actual Results:
User can-t rely on the cell results, some updaets and some do not. 
Seen some cell update could lead to think every cell value is correct, when is
is not.

Expected Results:
To autocalculate all cells and get consistent results.

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: 7.0.2.2 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded

-- 
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/20201027/f367b520/attachment.htm>