In the LO Help the description for recalculating RAND is inconveniently. project: libo_help file: scalc/01.po context: 04060106.xhp par_id5092318 help.text KeyID: nktwg content: <cite>This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9.</cite> The second part should read: <cite>To force Calc to recalculate manually press F9.</cite> The RAND function already recalculates by pressing F9. (Unlike the RANDBETWEEN function that only recalculates by pressing Shift+Ctrl+F9.)
Good point; I pushed this update for review: https://gerrit.libreoffice.org/#/c/6703/
Stanislav Horacek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=cc73985d9544cadf9a28e85f22efdab87987b36e fdo#71595 use F9 for recalculation of RAND function The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.