Bug 131526

Summary:	Random number generator Option no duplicates
Product:	LibreOffice	Reporter:	lol <lobugs>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	buzea.bogdan, lobugs, rafael.palma.lima, stephane.guillou
Priority:	medium
Version:	6.4.2.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=60244 https://bugs.documentfoundation.org/show_bug.cgi?id=154872
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108827

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.