Bug 142636 - Libreoffice Calc does not recalculate formula (not even by forcing with F9 or CTRL+SHIFT+F9)
Summary: Libreoffice Calc does not recalculate formula (not even by forcing with F9 or...
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-06-03 10:48 UTC by d.philipp
Modified: 2021-06-03 11:37 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Example spread sheet of deficient recalculation (12.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-06-03 10:48 UTC, d.philipp 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description d.philipp 2021-06-03 10:48:48 UTC 
Created attachment 172592 [details]
Example spread sheet of deficient recalculation

OS: Windows 10

LibreOffice version: 7.1.3.2 (x64)

build: https://git.libreoffice.org/core/+log/47f78053abe362b9384784d31a6e56f8511eb1c1

Reproducible steps:
  1. In attached file change value in field B4
  2. Press F9
  3. Press CTRL + SHIFT + F9

Expected result: Calculated value in field B7 should be recalculated already after 1st step.

Observed result: Value in field B7 does not change even after 3rd step.

Is that behaviour related to bug https://bugs.documentfoundation.org/show_bug.cgi?id=137248
(already fixed in version 7.0.3)?
Comment 1 Eike Rathke 2021-06-03 11:37:33 UTC 
Check your math.

B6: =B5-B4
B7: =B3*B6+B3*B4
which is
=B3*(B5-B4)+B3*B4
which is
=B3*B5-B3*B4+B3*B4

You are effectively eliminating any change in B4 with -B3*B4+B3*B4