Bug 137843

Summary:	Calc cell update disfunction
Product:	LibreOffice	Reporter:	zeffur
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	medium
Version:	7.0.0.2 rc
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Relative Cell Update Problem

Description zeffur 2020-10-29 03:00:37 UTC

Description:
Relative cells don't auto update properly when the source cell is changed.

To replicate the problem do the following:
1. Enter 1 into cell A1
2. Pull down the lower right corner of cell A1 to do a series fill to fill 10 cells.
3. Enter 120 in cell B1. Enter =b1 in cell B3.
4. Copy cell B3 & paste it into cells B4 through B10
5. Enter =b1/a1 in cell C1
6. Copy cell C1 & paste it into cells C2 through C10
7. Change the value in B1 to 125 & press enter key

Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will not get auto updated as they should. Also notice, that the caluation results of cells C4 through C10 are also not updated because cells B4 through B10 were not updated.

Why is that auto update capability not working in the spreadsheet? It makes me seriously consider whether or not more complex spreadsheets are not providing me with accurate results when I make changes to input cells.

Can you fix this?

Thanks, D

Steps to Reproduce:
1. Enter 1 into cell A1
2. Pull down the lower right corner of cell A1 to do a series fill to fill 10 cells.
3. Enter 120 in cell B1. Enter =b1 in cell B3.
4. Copy cell B3 & paste it into cells B4 through B10
5. Enter =b1/a1 in cell C1
6. Copy cell C1 & paste it into cells C2 through C10
7. Change the value in B1 to 125 & press enter key
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will not get auto updated as they should. Also notice, that the caluation results of cells C4 through C10 are also not updated because cells B4 through B10 were not updated.

Actual Results:
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will not get auto updated as they should. Also notice, that the caluation results of cells C4 through C10 are also not updated because cells B4 through B10 were not updated.

Expected Results:
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will not get auto updated as they should. Also notice, that the caluation results of cells C4 through C10 are also not updated because cells B4 through B10 were not updated.

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: 7.0.0.2.2 (x64)
Build: 8349ace3c3162073abd90d81fd06dcfb6b36b994

Comment 1 zeffur 2020-10-29 03:05:25 UTC

Created attachment 166825 [details]
Relative Cell Update Problem

Comment 2 Mike Kaganski 2020-10-29 04:32:30 UTC


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

Comment 3 zeffur 2020-10-29 04:53:14 UTC

(In reply to Mike Kaganski from comment #2)
> 
> *** This bug has been marked as a duplicate of bug 137248 ***

If this bug has been resolved, what was the fix & how & when can I apply it?

Thx, D

Comment 4 Mike Kaganski 2020-10-29 05:41:31 UTC

(In reply to zeffur from comment #3)
> If this bug has been resolved, what was the fix & how & when can I apply it?

As seen on the bug 137248 page (which is the main bug, duplicate of which this one is marked), it was resolved in versions 7.1.0 and 7.0.3 ("target" in whiteboard, and commit notifications in comments); and the mentioned commit notifications link to the code changes that you may check for "what was the fix".

The release plan [1], together with the target version information in the bug, will help to answer the "when can I apply it". The "how" part is described on the related Get Help / Installation Instructions / Windows [2], which is available as "How do I install LibreOffice?" link on download page [3].

[1] https://wiki.documentfoundation.org/ReleasePlan
[2] https://www.libreoffice.org/get-help/install-howto/windows/
[3] https://www.libreoffice.org/download/download/