Description: The documentation of RANDBETWEEN currently states that it 'returns a random integer between the numbers you specify'. It's a bit unclear if the upper and lower bounds can be included in the generated numbers or not. Steps to Reproduce: 1. Open Calc and its "Function Wizard" tool from the tool bar 2. Search for "RANDBETWEEN" Actual Results: The documentation is clear whether the specified integers can be included in the generated random numbers. Expected Results: The documentation is unclear. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.0.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 8; OS: Linux 5.18; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Debian package version: 1:7.4.0~rc2-3 Calc: threaded
The help page does make it clear that both Bottom and Top are included in the possible results. See [1]: [1] https://help.libreoffice.org/master/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3164669 I believe we can make it clear in the Function Wizard as well, without increasing too much the size of the description text. This fix should apply to RANDBETWEEN and RANDBETWEEN.NV.
https://gerrit.libreoffice.org/c/core/+/141922
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bed4d8f1eb32a39bfce5c7fa8546dbab155706a7 tdf#150465 Improve description of RANDBETWEEN in function wizard It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: ad085990b8073a122ac5222e5220f8f1d6826dcf CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded