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
Autocalculation is probably turned off : Menu Data > Calculate > Autocalculate. (You have a check mark if "on")
(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!