Bug Hunting Session
Bug 40203 - Recalculation Issue: changes in macros not recalculated.
Summary: Recalculation Issue: changes in macros not recalculated.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: low enhancement
Assignee: Not Assigned
: 55774 (view as bug list)
Depends on:
Blocks: Calculate
  Show dependency treegraph
Reported: 2011-08-18 09:45 UTC by Olivier Hallot
Modified: 2017-07-24 22:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

test case for automatically updating in Calc (8.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-08 12:06 UTC, sasha.libreoffice

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2011-08-18 09:45:13 UTC
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.

For example:

Function AnyFunction( i as long) as Long

   AnyFunction = i +1

End Function

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.
Comment 1 Björn Michaelsen 2011-12-23 12:35:17 UTC Comment hidden (obsolete)
Comment 2 Florian Reisinger 2012-08-14 13:58:14 UTC
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.


Comment 3 Florian Reisinger 2012-08-14 13:59:31 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 14:04:07 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 14:06:20 UTC Comment hidden (obsolete)
Comment 6 sasha.libreoffice 2012-10-08 12:06:39 UTC
Created attachment 68251 [details]
test case for automatically updating in Calc
Comment 7 sasha.libreoffice 2012-10-08 12:07:15 UTC
reproduced in 3.6.2 on Fedora 64 bit
Comment 8 Regina Henschel 2012-10-09 22:33:17 UTC
*** Bug 55774 has been marked as a duplicate of this bug. ***
Comment 9 Joel Madero 2012-11-21 17:41:49 UTC
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.