https://bugs.documentfoundation.org/show_bug.cgi?id=154137
--- Comment #4 from Alexander Van den Panhuysen <[email protected]> --- > But such non-volatile functions don't avoid to change with a calculation [F9] or a hard recacl [Ctrl+Shift+F9] -> don't avoid to change? -> Yes, it does! because I tested it with function RAND.NV(). Do these steps: 1. in cell B1 enter: =IF(A1="Blabla";RAND.NV();"") 2. In cell A1 enter "Blabla" 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! -- You are receiving this mail because: You are the assignee for the bug.
