Bug 147684 - automatic recalculation does not work
Summary: automatic recalculation does not work
Status: RESOLVED DUPLICATE of bug 147298
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-27 09:42 UTC by tobyps
Modified: 2022-02-27 15:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example of not working recalculation (12.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-02-27 09:44 UTC, tobyps 		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 tobyps 2022-02-27 09:42:00 UTC 
Description:
Checkbox for automatic recalculation ist ticked

Still no cell is recalculated

Needs to be triggered by Ctrl+shift+F9

The Bug seems to have appeared in 7.0.2.2 and fixed in 7.0.3.1 
(see https://ask.libreoffice.org/t/lo-calc-7-0-2-2-automatische-berechnung-geht-nicht-mehr/57297/3 )

But I have the problem in the current version.

Steps to Reproduce:
1.Put a formula in a cell with a least one parameter in another cell
2. change the parameter
3. 

Actual Results:
Formulas dont recalculate

Expected Results:
Formulas recalculate


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 tobyps 2022-02-27 09:44:58 UTC 
Created attachment 178565 [details]
Example of not working recalculation

D1 is parameter, D2-D10 should change but dont
Comment 2 Buovjaga 2022-02-27 11:37:02 UTC 

*** This bug has been marked as a duplicate of bug 147298 ***
Comment 3 tobyps 2022-02-27 12:10:10 UTC 
Thx, I searched but 147298 didnt came up.
Comment 4 JO3EMC 2022-02-27 14:34:08 UTC 
I looked at the attachment, but it doesn't seem to reproduce in my 7.3.0.
If I change D1, the value of D2: D9 will be recalculated.

Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL
Comment 5 Buovjaga 2022-02-27 14:37:28 UTC 
tobyps: can you try with Win-x86_64@tb77-TDF from https://dev-builds.libreoffice.org/daily/master/current.html ?

It installs separately and will not mess with your 7.3
Comment 6 tobyps 2022-02-27 15:45:46 UTC 
It works with the Daily from today.