[Libreoffice-bugs] [Bug 137552] New: AutoCalculate only partly works when Cell referring to an Absolute Address

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137552
           Summary: AutoCalculate only partly works when Cell referring to
                    an Absolute Address
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hosslobos at hotmail.com

Description:
A table created in 7.0.2.2 consisting of more than 3 cells is only partly Auto
(Re-)Calculated when the cells are referring to an absolute addressed cell and
this cell value is changed. Manually pressing F9 updates all of the cells
correctly.


Steps to Reproduce:
1. Create a table, cell B2-B13 containing numbers 1 to 12 and a formula in Cell
C2-C13.
2. The formula in Cells C2-C13 should contain an absolute reference to a cell,
eg $A$1, so "=$A$1+B2" in Cell C2 , "=$A$1+B3" in Cell C3 and so on until Cell
C13 has formula "=$A$1+B13"
3. Add a value to cell A1, eg "10"
3. Change the value of cell A1. Only the first two cells in C2-C13 are
automatically updated, but not the other cells

Actual Results:
Only a few cells are updated

Expected Results:
All cells should have been updated


Reproducible: Always


User Profile Reset: No



Additional Info:
The automatic recalculation in the example works in earlier version 6.0.7.3
Pressing F9 does update the whole table.

-- 
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/20201017/3621b112/attachment.htm>