[Libreoffice-bugs] [Bug 133295] New: 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

            Bug ID: 133295
           Summary: OFFSET.NV and INDIRECT.NV non-volatile functions in
                    Calc
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: koukasio at gmail.com

Description:
While it is obvious to everyone that RAND() is volatile, many users are not
aware that OFFSET() and INDIRECT() are volatile as well. This can absolutely
kill the performance of a spreadsheet, without even realizing the reason why
this is happening, due to recalculating everything.
This is a correct behaviour and the same behaviour happens on msoffice.
While an experienced user can get around this issue by using the INDEX()
function which is non-volatile, this is not possible on all cases. In some of
these cases the user may responsibly want to absolutely avoid the volatility.
Would you please create two functions OFFSET.NV() and INDIRECT.NV() ?
This would work just like the RAND.NV() and RANDBETWEEN.NV() functions
introduced on lo7.0.0 .
This would be a great feature and it will also work as a reminder/informer that
OFFSET() and INDIRECT() are volatile and should be avoided in case performance
is important.
I am attaching a lo7.0.0 spreadsheet sample that shows how one can test whether
a function is volatile. The volatile cells refresh with every change or by
simple "recalculate", while the non-volatile ones with "recalculate hard" .

Actual Results:
-

Expected Results:
-


Reproducible: Always


User Profile Reset: No



Additional Info:
-

-- 
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/20200522/0242b1a6/attachment.htm>