https://bugs.documentfoundation.org/show_bug.cgi?id=139985
--- Comment #5 from ady <[email protected]> --- NOW() is a volatile function; REPT() is not. RANDBETWEEN.NV() is not a volatile function either, but it is recalculated under certain circumstances such as when opening the file (see help content). You could modify menu Tools > Options > LibreOffice Calc > Formula > Recalculation on File Load, or manually use Data > Calculate > Recalculate Hard ([CTRL]+[SHIFT]+[F9]), but these might not be enough when sharing the file. Or instead of =REPT("a";B1) ...you add some volatile function. For instance (just as a generic example): =REPT("a";B1)&T(NOW()) If you have to use this method on multiple cells, you could have: C1: =T(NOW()) A1: =REPT("a";B1)&$C$1 ...and re-use "&$C$1" (or "+$C$1" on numeric functions/cells) on each relevant cell. These methods would force the recalculation on that/those specific cell(s). Each alternative has its own pros and cons. Another possibility would be to use the RANDBETWEEN.NV() function as the second argument of REPT(), but that would be only useful when there are no other cells that would need to depend on the same resulting value of the same RANDBETWEEN.NV() function. When multiple cells must depend on the _same_ result of the RANDBETWEEN.NV() function, this alternative would not be a valid approach. -- You are receiving this mail because: You are the assignee for the bug.
