Description:
short: 

sometimes wrong or outdated results are stored in files, and displayed on screen when reloading the file, 

i think it would be nice if the users gets a hint on that

>>> for military and other critical use it's a 'must have'! <<<

long: 

in my opinion libreoffice calc lacks some functionality to keep users informed about the status of the processed file

i think three cases should be handeled

1) - the loaded file displays wrong or outdated values, for whatever reason, something should be red in that case, green if everything is ok, and on mousover show a note 'outdated values loaded with file, consider recalculation' or 'values loaded from file match current calculation results', 

2) - the user changes something in a map / sheet and it's not recalculated (e.g. reg. autocalculate being 'off' or whatever other reason), something should be red in that case, green if everything is ok, and on mousover show a note 'shown results not recalculated after changes, consider recalculation' or 'all changes recalculated', 

3) - the user changed something in the map / sheet and it's not saved after that, something is! red in that case (a little floppy symbol at the bottom of the window), that could be placed in better sight of the user, green if everything is ok (as is it's grey when no saving is neccessary), and on mousover it shows a note 'The document has been modified. Click to save the document.', it's combined with functionality. 

------------ 

for 1) this is the most critical point, users may be trapped by shortcomings in files they get from others, shortcomings in files saved with buggy versions, or other problems out of their sight and influence, 

see: https://bugs.documentfoundation.org/show_bug.cgi?id=120013#c17

you can check the file 

http://bugs.documentfoundation.org/attachment.cgi?id=145073

by opening with a zipper proram (e.g. 7zip) and opening the file content.xml inside with a browser (e.g. firefox), 

i couldn't find a cell reference in the entries, thus it's not too easy to find the affected entries, i think they are the lines 

<table:table-cell table:style-name="ce111" table:formula="of:=SUM([.C$3:.C12])-SUM([.D$3:.D12])" office:value-type="float" office:value="1900" calcext:value-type="float">

near the end of the file, 

somewhere else Eike Rathke and others stated that it's not possible to check whether recalculation is neccessary, i think it should be possible, just do a recalc in background - with reduced priority to lessen impact in workflow, and compare to displayed or stored results, 

this point affects the whole range of autocalculate off, compatibility with xls and xlsx files and 'freshness' of calculations there, settings for recalculate on load in options (are they removed?) and so on ... 

contrary to check and explain what happened to irritated users one by one after they stepped into problems - consider calculating target coordinates for missile s - it could be a better idea to keep all users informed before problems occur. 

during the check of necessity of a recalculation (this can happen in the background with reduced priority) the signal could be yellow with a hint-text 'processing data integrity check' 

------------

for 2) this is critical too, users may be trapped by settings done by others, settings they forgot about, or other stuff blocking recalculation. 

------------

for 3) it could be 'nice to have' that symbol somewhere 'in sight' of the user, perhaps a stacked 'hamburger menu symbol' in the upper right corner of the screen, one dot (bottom) for 'loaded file lacks recalc', one (middle) for 'actual work not saved', one (top) for 'changes require recalculation', when a user see's 'all green' he knows 'everything ok' (despite unfixed bugs). 

------------

apologize if i missed something already in the program, 

reg. 

b. 

Steps to Reproduce:
see above description

Actual Results:
user uninformed

Expected Results:
would ease use of program when user gets qualified status information, 


Reproducible: Always


User Profile Reset: No



Additional Info:
actually testing: 

Version: 6.4.0.0.alpha1+ (x64)
Build ID: d456ca6efb98d707427228e8131dfe8a5f27e2f6
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

user profile reset?: no as it's not a bug, 

opengl enabled?: no