I created a simple spreadsheet in libreoffice-6.1.4.2 on windows with the following data:

```
A
Vals
1
2
3
4
```

I then clicked on Data->Statistics->Sampling, and provided the following input:

```
Input Range: $Sheet1.$A$2:$A$5
Results to: $B$2
Checked Random
Sample size: 4
```

I then clicked OK. and got the following result:

```
A B
Vals Res
1 1
2 2
3 3
4 4
```

What’s the problem? I expected column B to have 4 randomly selected values from column A…