[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 #27 from b. <newbie-02 at gmx.de> ---
hi, 

@Eike: 

thanks, that explains a lot... 

> "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."

i'd suggest to add something like: 

'autocalculate doesn't recalculate all cells but only those where it can see /
analyse the dependencies. some special constructions block that, thus to get a
fully calculated sheet use ctrl-shift-F9 (hard recalc).' 

or similar to the manual / help, it should propose something that would help in
all situations not being a bug. 

shall i file a separate request for that? 

> "The behaviour described in comment 25 is not a bug and not even related to the original problem."

one might argue about it having the same root as, being the source of, related
to, or a side effect of the OP problem, or vice versa, but that's not what i'm
going for. i'm seeking for clarity, thus if someone solves the original bug,
and if the behaviour of c#25 stays alive but is mentioned in the help / manual,
it's solved for me. 

it worries me that the 'non-auto-calculation' hampers the analysis / processing
of other bugs where the sheet authors and users cannot explain the
'non-auto-calculation' caused by such constructs, and the follow-up
'non-auto-calculation' of cells dependent on these non-calculated. 

maybe some old bugs can be closed as they are based on a misunderstanding of
the power of autocalculate and get a plausible explanation by your comment? 

reg. 

b.

-- 
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/566815bc/attachment.htm>