<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Inconsistent behavior on cell update with F9 at cells filled by RANDBETWEEN() function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134933">134933</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Inconsistent behavior on cell update with F9 at cells filled by RANDBETWEEN() function
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.7.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>zoltan.theobald@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
The software changes behavior on cell update by F9. Some cells filled by
RANDBETWEEN() functions are getting updated unexpectedly at some cases. The
behavior changes after full sheet update by Ctrl+Shift+F9. It happens only at
certain circumstances. Creating a sheet produces the error is not trivial. (at
least not yet for me)
Steps to Reproduce:
1.open the attached file test_sheet.ods
2.select a cell in the F column filled by RANDBETWEEN() function
3.press F9 : the whole F column will update
4.select a random cell which is not in the F column
5.press F9 to update the cell: the whole F column will update as well
6.press Ctrl+Shift+F9
7.select any cell from anywhere but the F column
8.press F9: the behavior changed back to normal
Actual Results:
The RANDBETWEEN() functions in the column F got updated unexpectedly
Expected Results:
The selected cell and the related cells should update only
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc: group</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>