https://bugs.documentfoundation.org/show_bug.cgi?id=154137
--- Comment #14 from Eike Rathke <[email protected]> --- (In reply to Alexander Van den Panhuysen from comment #13) > Your formula IF(TODAY()>A1;RAND.NV()) surprises me, so the result is > unstable Nothing surprising. The expression is volatile because it uses a volatile function, here TODAY(). > But with my formula IF(A1="Blabla";RAND.NV();""), it works as I wanted. Only as long as the expression is not recalculated for whatever reason. Which is out of the control of the user. Or rather, users can force recalculation with F9 (partial) or Shift+Ctrl+F9 (full) or on load of the document, but not prevent or even forbid it. > If function NOW.NV() will not be made, how can I get a fixed timestamp when > a product or person has arrived?, because that is exactly wat my formula > would accomplish. By using timestamp _data_. Either by the (unfortunately for your system not working, bug 154136) shortcuts, or a macro run (maybe triggered by an event or a button) that adds data according to conditions. -- You are receiving this mail because: You are the assignee for the bug.
