https://bugs.documentfoundation.org/show_bug.cgi?id=154137
--- Comment #5 from ady <[email protected]> --- (In reply to Alexander Van den Panhuysen from comment #4) > 3. In an other cell enter something else OR when an other cell is selected, > do a recalculation. > Result: the value in cell B1 doesn't change anymore! Let's clarify: _ Any function recalculates according to the Calculate settings (or it should). _ function.NV() recalculates as any other non-volatile function. This means that, for example: 1. New Calc. 2. B1: =IF(A1=1;NOW();"") 3. A1: 1 ...will show you the serial number for NOW() in cell B1, and then... 4. While in A2, pressing [F9] will not recalculate B1. 5. While in A2, pressing [CTRL]+[SHIFT]+[F9] _will_ recalculate B1. For MacOS, that would be [CMD]+[SHIFT]+[F9]. If you need to _never_ recalculate, that would be a static value (no need for a function in that case). If there is another trigger that would force to update the value, that would not be a completely static value. Whether the requested functions may or may not be useful, that's another matter. -- You are receiving this mail because: You are the assignee for the bug.
