Bug 124783 - enhancement request: UI - warn user if sheet contains 'unrecalculated outdated values'
Summary: enhancement request: UI - warn user if sheet contains 'unrecalculated outdate...
Status: RESOLVED DUPLICATE of bug 128708
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-17 04:32 UTC by b.
Modified: 2019-11-11 13:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description b. 2019-04-17 04:32:32 UTC
Description:
while discussing https://bugs.documentfoundation.org/show_bug.cgi?id=124669 it come up that it's possible to have values stored in a file which do not match with the result of the formula in the cell by saving a file with data - calculate - autocalculate: off. 

this is a correct behaviour of the program, but may cause errors at least when users have to work with files created and stored by other persons. 

it would be nice to have any, some or all of: 

- a warning when opening a file where autocalculate is off, 

- a clear visible sign somewhere in the status- or toolbar 'autocalculate is off', 

- a warning when a file contains values which deviate from the result of the formula in that cell, 

- a 'flag' on each cell where the shown value deviates from the result of the formula in that cell, 

Winfried Donkers asked me to file new bugs since the original problem is solved, 

this request is for '- it would be nice to have a warning towards the user whenever (s)he's dealing with files that contain deviations between formula and formerly stored values' mentioned there. 

Steps to Reproduce:
follow the steps in #124669 comment 7 to produce a file with a value having a 'false result' in a cell. 

Actual Results:
no hint to the user 

Expected Results:
anything warning the user or helping him to understand the situation, (otherwise he might ask 'silly questions' in 'ask' or 'bugs'). 


Reproducible: Always


User Profile Reset: No



Additional Info:
i think the problem is around in all versions,
Comment 1 m_a_riosv 2019-04-17 09:04:50 UTC
Agree.
Visible sign in the status bar about if there are calculations pending.
Comment 2 b. 2019-11-11 13:00:07 UTC

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