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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
