https://bugs.documentfoundation.org/show_bug.cgi?id=154137
--- Comment #12 from Eike Rathke <er...@redhat.com> --- (In reply to Alexander Van den Panhuysen from comment #11) > When is that going to happen then? Whenever needed or as a side effect when an expression is recalculated that happens to also contain RAND.NV(), like IF(TODAY()>A1;RAND.NV()) where A1 contains a date smaller than today the RAND.NV() is still recalculated on every sheet content change. > It brings me to the question: "What is the purpose of the existing functions > NOW() and TODAY() in a Calc sheet as the resulted values changes al the > time?" Obviously with TODAY() one can calculate the current days since a given date or until a given date or determine a calendar date. -- You are receiving this mail because: You are the assignee for the bug.