<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:stephane.guillou@member.fsf.org" title="stragu <stephane.guillou@member.fsf.org>"> <span class="fn">stragu</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - In "Data - Statistics - Sampling" options, not possible to use a sampling size greater than 100"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142986">bug 142986</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Problem with Data - Statistics - Sampling option
</td>
<td>In "Data - Statistics - Sampling" options, not possible to use a sampling size greater than 100
</td>
</tr>
<tr>
<td style="text-align:right;">Blocks</td>
<td>
</td>
<td>111310
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - In "Data - Statistics - Sampling" options, not possible to use a sampling size greater than 100"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142986#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - In "Data - Statistics - Sampling" options, not possible to use a sampling size greater than 100"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142986">bug 142986</a>
from <span class="vcard"><a class="email" href="mailto:stephane.guillou@member.fsf.org" title="stragu <stephane.guillou@member.fsf.org>"> <span class="fn">stragu</span></a>
</span></b>
<pre>Whatever settings are used (as long as there are enough values to pick from
according to settings), if the sample size is bigger than 100, it switches back
to a maximum of 100.
Minimal reproducible steps from scratch:
1. Open Calc
2. Fill a range with numbers (for example the sequence 1 to 10 in range A1:A10)
3. Select range with numbers
4. Menu: Data > Statistics > Sampling...
5. The "Input range" should be the one previously selected
6. Results to: B1
7. Sampling method: Random
8. Tick "With replacement" (so numbers in the sample can be reused)
9. Input a Sample size greater than 100 (for example 105)
10. Click out of the Size field (by clicking into another field, or clicking
OK)
Actual results:
The sample size is reset to a maximum of 100.
Expected results:
Any number is kept, as "With replacement" is ticked and therefore the sample
size is not limited.
Confirmed with:
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: e3086b58eb5427d520b86c185f9d911bb6f7a3a0
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time:
2021-06-21_15:37:11
Calc: threaded
And:
Version: 7.2.0.0.beta1 / LibreOffice Community
Build ID: c6974f7afec4cd5195617ae48c6ef9aacfe85ddd
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Data statistics bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111310">Bug 111310</a>] [META] Data statistics bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>