[Libreoffice-bugs] [Bug 132809] Recalculation of random values on row/col resize

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132809

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
           Severity|normal                      |minor
           Priority|medium                      |low

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200507/8e8e2157/attachment.htm>