<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Recalculation of random values on row/col resize"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132809">bug 132809</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;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Severity</td>
<td>normal
</td>
<td>minor
</td>
</tr>
<tr>
<td style="text-align:right;">Priority</td>
<td>medium
</td>
<td>low
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Recalculation of random values on row/col resize"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132809#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Recalculation of random values on row/col resize"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132809">bug 132809</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Why not? Any rand is as good as another ;-)
I didn't investigate deeply but background probably is that hiding rows/columns
may affect SUBTOTAL() and AGGREGATE() and dirty formulas are recalculated (of
which in this example there are none explicitly, but..), including all volatile
functions like RAND(). Also, changing the view may display cells previously
undisplayed and not yet calculated, so some recalculation has to happen.
Given that LO 7 will have non-volatile RAND.NV() and RANDBETWEEN.NV() I don't
consider this issue important enough to disentangle the volatile/subtotal logic
for these; however, doing so (not recalculating all volatile when
sizing/hiding/showing columns or rows) might save some recalculation cycles on
larger documents using also other volatile functions like OFFSET() or
INDIRECT() or others. So might be worth investigating.</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>