[Libreoffice-bugs] [Bug 40203] Recalculation Issue: changes in macros not recalculated.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from b. <newbie-02 at gmx.de> ---
after some re-think ... 

forget comment #10: 
1. sheets have to be responsive, 
2. sheets have to be reactive, 
3. sheets have to be consistent, 
4. sheets may not carry traps which produce 'later errors', thus each change
must be immediately reflected in the workbook while autocalc is on, 
5. against the risk of messing up things while experimenting with macros users
have to use backups, 

regarding 'Low: Number of users using macros is very low ...' from c#9: perhaps
it would be more users if macros were a bit less complicated and a bit more
reliable? 

thus it would be a good idea to include used functions! into the 'dependency
chain'? and trigger recalculation on changes, (macros in opposite have their
trigger and are intentionally only calculated when triggered?), 

there is some (not good working, it omits some pasting actions?) functionality
in the macro editor which interrupts edits with dialogs 'you have to restart
after that change' or similar, perhaps that can be used to set a recalc trigger
for the sheet / cells / functions? 

complications: functions are not bound to the file, thus it may happen that a
sheet is opened on a different system with different functions called by the
same name? that ... is too complex for me at the moment ... forced recalc on
open with user dialog 'functions results have changed, perhaps reg. different
system, pls. check results in cells [list of cells with functions where values
changed on recalc]'?

-- 
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/20200706/3740d4b1/attachment.htm>