In "Edit"->"Fill"->"Random Number"->
random number generation should be given one more checkbox option of "filling cells with random INTEGERS ONLY, between supplied minimum and maximum value".
This can be done by using the inbuilt function of RANDBETWEEN() , which is available in libreoffice.
In the current random number generation dialog box, it can also be enhanced for limiting the number of decimal places in generated number. Ask from the user, how many decimal places he wants in the generated numbers.
Regarding the second point I would agree this seems for me to be a good enhancement.
Regarding the first point, I thought that this is already implemented if you select "Uniform Integer" in the field DISTRIBUTION. Do this already resolve your first issue or is there maybe a misunderstanding from my side?
Changed component to Spreadsheet as ux-advice is when an advice from ux team is needed, which is not the case here.
Your suggestion solves my POINT number (1).
Now only POINT number (2) remains to be implemented(that is, limiting the number of decimal places in generated number. )
point number (1) is resolved.
ONLY POINT NUMBER (2) NEEDS TO BE IMPLEMENTED.
Is there any else information, which needs to be given from my side? Should the status of this bug be changed from "NEEDINFO" to something else?
TomaÅ¾ Vajngerl committed a patch related to this issue.
It has been pushed to "master":
fdo#76718 Rounding for "fill > random number.." option
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:
Affected users are encouraged to test the fix and report feedback.