https://bugs.documentfoundation.org/show_bug.cgi?id=132809
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
Severity|normal |minor
Priority|medium |low
--- Comment #1 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
