[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from koukasio at gmail.com ---
(In reply to Eike Rathke from comment #19 bug-127831)
> Given how OFFSET() and INDIRECT() work a non-volatile version doesn't make
> sense.
https://bugs.documentfoundation.org/show_bug.cgi?id=127831#c19

 I fully understand the implications of using a non-volatile version of
OFFSET() and INDIRECT() .
 I cannot speak for other people, even though I am sure that a lot of them
would find it useful. Once upon a time, I used to use those two functions and
my spreadsheets would get unbearably sluggish. It took years for me to realise
that the cause for the slowdown was the use of these functions, which were
causing the needless recalculation of everything rooted to the corresponding
cells. Having the functions available would also work in an educational manner.
 Speaking for myself (m.a.riosv seems to agree), OFFSET.NV and INDIRECT.NV make
perfect sense and their absence has been a longtime frustration and wish, in
the cases that replacing them with the INDEX() function is not possible. There
are cases where the use of the non-volatile versions cause absolutely no
implications, but instead offer solutions without having the downsides of the
volatile versions. It would be nice to have the user informed and be
responsible to make the decision.

-- 
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/20200525/c12e1efa/attachment.htm>