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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 12 15:41:55 UTC 2020


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

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
No simple trick there. Apart from maybe external references that are cached
until updated (for which the dependency then would have to be individually
remembered), as soon as and each time the reference string argument of
INDIRECT() is changed or recalculated the old listening would had to be
discarded and a new one based on the new argument be established. Similar for
OFFSET(). For the initial load that would even be counter productive because
the arguments would have to be calculated to determine whether or if and how
the function would have to be recalculated later. Additionally, in array
context it gets more complicated.

-- 
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/901e5ad5/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list