[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 #5 from tom at lautenbacher.biz ---
(In reply to m.a.riosv from comment #4)
> Maybe because OFFSET() It's a volatile function like NOW() or INDIRECT(), so
> it is always recalculated with any change in the spreadsheet.

I could not reproduce the same effect when just using OFFSET in a different
file, or in the same file when deleting the chart on the other sheet, which
seems to be part of the problem.

-- 
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/20200406/cc22fa72/attachment.htm>