<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - OFFSET.NV and INDIRECT.NV non-volatile functions in Calc" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133295#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - OFFSET.NV and INDIRECT.NV non-volatile functions in Calc" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133295">bug 133295</a> from <a class="email" href="mailto:koukasio@gmail.com" title="koukasio@gmail.com">koukasio@gmail.com</a> <pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=133295#c19">comment #19</a> bug-127831) > Given how OFFSET() and INDIRECT() work a non-volatile version doesn't make > sense. <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - recalculate vs. random functions in Calc" href="show_bug.cgi?id=127831#c19">https://bugs.documentfoundation.org/show_bug.cgi?id=127831#c19</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>