[Libreoffice-bugs] [Bug 79588] Macros called from within formulas doesn't survive save, close and reopen of the calc-document.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #26 from Eike Rathke <erack at redhat.com> ---
This

  GETCELL(sheetName As String, cellReference As String)

gets passed some strings, if the call isn't like GETCELL(A1;A2) but literal
GETCELL("Sheet1";"A1") or some such then there is no cell reference that would
be added to dependencies to trigger a recalculation. But even if it was
GETCELL(A1;A2) then the resulting "reference" used internally by the macro
would not lead to some recalculation of the macro if only that "referenced"
cell changed as again it is not part of the dependency tree, automatic
recalculation would happen only if A1 or A2 were changed.


> "Automatically recalculates all formulas in the document.
> 
> All cells are recalculated after a sheet cell has been modified. Any charts in > the sheet will also be refreshed."
That description is misleading. AutoCalculate does not recalculate *all*
formulas, but only so-called dirty cells, those that are affected by changes in
cells they depend on.

The behaviour described in comment 25 is not a bug and not even related to the
original 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/20200120/a31189af/attachment.htm>