[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 --- Comment #5 from Mike Kaganski --- (In reply to Eike Rathke from bug 127831 comment #19) > Given how OFFSET() and INDIRECT() work a non-volatile version doesn't make > sense. Eike: is it possible to add a way for a function implementation to add some range(s) to their dependency list explicitly, so that not only the direct references that parser may resolve are taken into account at "set dirty" stage, but also this explicit list? That could enable implementation of OFFSET.NV / INDIRECT.NV variants, hopefully without a drawback of having stale values there? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||7541 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||1932 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 Eike Rathke changed: What|Removed |Added Version|3.3.0 release |Inherited From OOo -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 --- Comment #4 from gdimi --- +1 performance is important in large calcs' -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 --- Comment #3 from kouka...@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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #2 from m.a.riosv --- +1 Even better if all volatile functions would have their equivalent as nonvolatile. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133295] OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=133295 kouka...@gmail.com changed: What|Removed |Added CC||kouka...@gmail.com --- Comment #1 from kouka...@gmail.com --- Created attachment 161171 --> https://bugs.documentfoundation.org/attachment.cgi?id=161171&action=edit volatile_functions_test -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs