https://bugs.documentfoundation.org/show_bug.cgi?id=131932
Eike Rathke <[email protected]> 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 <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
