As far as I know, recalculation is performed
1) when cells are changed/edited, and other events related
2) on cells that depends on the changed cells.
but recalculation does not occurs when a function is changed in the spreadsheet.
It will be nice to trigger recalculation when a change in macros occurs.
Function AnyFunction( i as long) as Long
AnyFunction = i +1
If AnyFunction is used in the spreadsheet and we chage the line
AnyFunction = I + 1 to AnyFunction = I + 10
The change is not automatically recalculated. Only by Ctrl+Shift+F9.
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter!
Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.
To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement
Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.
Created attachment 68251 [details]
test case for automatically updating in Calc
reproduced in 3.6.2 on Fedora 64 bit
*** Bug 55774 has been marked as a duplicate of this bug. ***
Verified, marking as NEW and prioritizing:
Enhancement: This is behaving as it's intended to but your solution does seem to be a good enhancement
Low: Number of users using macros is very low, easy work around (manually updating using the keys you said), and only happens under specific conditions (changing a macro after it's already being used in a sheet)
Thanks for your patience and your help in reporting.
imho it's not a good idea to apply changes automatically.
while creating macros and functions a little more complex than the sample by 'trial and error' usually plenty errors evolve before success. this would lead to plenty ruined sheets where it's difficult for the user to go back and find a healthy version.
if he's informed that a 'hard' recalc is needed he can apply that quite simple when editing is finished.
may be it's good to apply a hint 'function in use in sheet, recalc by ctrl-shift-F9 required' into the editor as it is for subs with 'you'll have to restart the program after this edit'.
as of today and with ver. 188.8.131.52 recalculation for a cell respecting the changed function can also be triggered by hitting F9 while the cell is selected (while it is the 'focus'),
other cells using the same function are not! recalculated, they still need ctrl-shift-F9