Bug 60244 - Unique random number generator function
Summary: Unique random number generator function
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2013-02-03 17:21 UTC by Justin
Modified: 2020-04-03 08:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Justin 2013-02-03 17:21:59 UTC
I would like a new function similar to randbetween() that allows you generate a list of random integers that are not duplicate.  Maybe we call it randlist() and the parameters are starting cell, ending cell low range, high range, unique bit (set to 0 or 1 if a unique response is required).

Not sure on implemenation, but generating a list of random numbers that do not duplicate is done so often that it should be easier in Calc.
Comment 1 Jorendc 2013-02-03 20:35:16 UTC
Thanks for reporting!

This is an enhancement, not a bug; therefore I mark it as such. Can't find any duplicates, therefore I mark this as NEW.
Comment 2 Kevin Suo 2014-06-26 08:07:29 UTC
I see in the newest libreoffice that "Edit - Fill - Random Numbers" is the sames as what you described. Does this resolve your request?

Comment 3 Justin L 2020-04-03 08:38:38 UTC
This has effectively been in "need info" state for 6 years. Closing as insufficent data, since comment 3 indicates that this ought to be possible now.