[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from m.a.riosv <miguelangelrv at libreoffice.org> ---
(In reply to Eike Rathke from comment #8)
> OFFSET() is a volatile function recalculated (like RAND() and others)
> .....
> so far no user or macro action whatsoever has occurred.

+100 if they lose their volatile status.
I try to avoid them because of this issue. And I don't recall any situation
where I needed them to be volatile. E.g. INDIRECT() has a very valuable used to
create links to other files, without modify formulas or editing links, but
normally it does not need to be recalculated every time there is some kind of
modification on the sheet, only when its precedents are modified. Or in many
cases people use them massively, without knowing the problem of volatility.
Maybe there are special cases where they need to be volatile, but I think it
can be forced with simple tricks.

-- 
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/20200512/11735653/attachment.htm>