[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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
           Hardware|x86-64 (AMD64)              |All
                 OS|Windows (All)               |All

--- Comment #8 from Eike Rathke <erack at redhat.com> ---
OFFSET() is a volatile function recalculated (like RAND() and others) because
no dependencies can be established between the calculated referenced
cell(range) and the formula cell containing the OFFSET() expression. A chart
referencing such expression directly or indirectly leads to recalculation
because the chart asks for the current data of its range and hence the document
is marked as changed.

This *might* be solvable by assigning another volatile classification to
OFFSET() (and INDIRECT()) so that they are not recalculated just after load
upon first dereference, but may also need some document state assuring that so
far no user or macro action whatsoever has occurred.

-- 
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/8ca615a6/attachment-0001.htm>