Bug 137552 - AutoCalculate only partly works when Cell referring to an Absolute Address
Summary: AutoCalculate only partly works when Cell referring to an Absolute Address
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-17 08:54 UTC by Hans-Olov Ericsson
Modified: 2020-10-17 15:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Calc sheet showing the bug (9.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-17 08:57 UTC, Hans-Olov Ericsson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hans-Olov Ericsson 2020-10-17 08:54:03 UTC
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.
Comment 1 Hans-Olov Ericsson 2020-10-17 08:57:41 UTC
Created attachment 166456 [details]
Calc sheet showing the bug
Comment 2 Hans-Olov Ericsson 2020-10-17 08:58:37 UTC
Version: 7.0.2.2 (x86)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: sv-SE (sv_SE); UI: sv-SE
Calc: threaded
Comment 3 Aron Budea 2020-10-17 15:21:26 UTC
Duplicate of bug 137248.

*** This bug has been marked as a duplicate of bug 137248 ***