Bug 131526 - Random number generator Option no duplicates
Summary: Random number generator Option no duplicates
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2020-03-24 11:14 UTC by lol
Modified: 2020-05-13 23:04 UTC (History)
1 user (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 lol 2020-03-24 11:14:11 UTC
It would be great if the Random Number Generator in Calc gets the option "No duplicates" if distribution "Uniform Integer" is used.

Steps to Reproduce:
1. open the Random Number Generator in Calc
2. mark 10 cells as cell range
3. select distribution uniform integer
4. enter 1 as minimum and 10 as maximum
5. click ok

Actual Results:
there are some numbers more than once

Expected Results:
there should be the option "No duplicates" so it is possible to have each number once

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build-ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU-Threads: 4; BS: Windows 10.0 Build 18362; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded
Comment 1 Xavier Van Wijmeersch 2020-03-25 07:08:45 UTC
+1 would be nice to have
Comment 2 So 2020-03-29 07:47:48 UTC
Bug 60244 requests a cell function like that.