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)
Version:
(earliest affected)
6.4.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2020-03-24 11:14 UTC by lol
Modified: 2023-05-03 08:09 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 
Description:
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: 6.4.2.2 (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.
Comment 3 Stéphane Guillou (stragu) 2023-05-03 08:09:59 UTC 
Isn't this just sampling without replacement?

1. Range of numbers 1 to 10 selected
2. Data > Statistics > Sampling
3. Results to whatever cell
4. Sampling method: Random
5. "With replacement" off, "Keep order" off

In my opinion, for the most part already covered in the sampling feature.