Bug 139920 - LibreOffice 7 0 2 2 - Autocalculate does not work
Summary: LibreOffice 7 0 2 2 - Autocalculate does not work
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.1.0.2 rc
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-26 08:23 UTC by Michael Both
Modified: 2021-01-26 10:11 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Michael Both 2021-01-26 08:23:09 UTC 
Description:
Autocalculate doesn't work in the calc module of LibreOffice 7 0 2 2. 
Respectfully suggest to either remove the menu tick, so users don't mistakenly think it is working, or better still, please fix it. This is a spreadsheet, with complicated formulae, and recalculating really is a fairly fundamental requirement. It is one of the reasons I regularly contribute money to LibreOffice.

Steps to Reproduce:
1. Change formula / cell value when autocalculate ticked, or unticked
2. Spreadsheet does not recalculate and update values
3. press "manual recalculate and it does recalculate and update values.

Actual Results:
Nothing happens

Expected Results:
all other cells dependant on changes should recalculate


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 m_a_riosv 2021-01-26 08:31:26 UTC 
Can you attach an example file where this occurs?
Comment 2 Mike Kaganski 2021-01-26 08:55:15 UTC 
It's likely a dupe of tdf#, which is confirmed by the "LibreOffice 7 0 2 2" (with confusingly missing dots). What adds to confusion is using "7.1.0.0 rc" in the "Version (earliest affected)" field.

So the question is: is the problem actually visible in the latest versions, as hinted by the Version field, or was that just a mistake?

Ref: https://ask.libreoffice.org/en/question/289291/autocalculate-not-performing-in-expected-manner/
Comment 3 Mike Kaganski 2021-01-26 08:56:01 UTC 
Sorry, meant to write "tdf#137248"
Comment 4 m_a_riosv 2021-01-26 10:11:45 UTC 
As communicated it's solver resetting the profile.