Bug 100875

Summary:	EDITING: cells unresponsive to changed input data
Product:	LibreOffice	Reporter:	Filip Tomášek <filip.tomasek>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	gerard.fargeot
Priority:	medium
Version:	5.1.4.2 release
Hardware:	PowerPC
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Filip Tomášek 2016-07-12 16:29:24 UTC

I use LibreOffice Calc for creating summary tabs for my personal overview of my contracts (time spent, costs, ... and so on).
Unfortunetely I ´ve noticed, that any changes to input data made afterwards (for example the nuber of working hours) do not have any impact on values shown in "result" cells, even when the formula is right.
To update it (to show the right value appropriate to new input) I must click into the "result" cell and "rewrite" the formula (despite writing the same formula again ), and confirm with "enter". Then this one changes.

I work on PC, Windows 7 Home Premium Service Pack 1, 64bit, Intel(R) Core(TM) i5-3450 CPU @3.10GHz 3.50GHz

Comment 1 GerardF 2016-07-12 19:55:42 UTC

Autocalculation is probably turned off :
Menu Data > Calculate > Autocalculate. (You have a check mark if "on")

Comment 2 Filip Tomášek 2016-07-13 08:35:10 UTC

(In reply to GerardF from comment #1)
> Autocalculation is probably turned off :
> Menu Data > Calculate > Autocalculate. (You have a check mark if "on")

Thanks!
First (after checking Autocalculate On) it made no immediate change..., but after a while, and while eorking with the file, all values refreshed. 
Now it looks it works ;-)
Thaks for your help!