Bug 55774 - : User Defined Functions
Summary: : User Defined Functions
Status: CLOSED DUPLICATE of bug 40203
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.2.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-08 19:08 UTC by ianus
Modified: 2012-10-09 22:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description ianus 2012-10-08 19:08:41 UTC 
Problem description: 

Steps to reproduce:
1. Create a user defined function e.g:

Function Demo ()

	Demo = "Ver 1"

End Function 

2. Use the function in cells where it will set those cells' values to "Ver 1"

3. Alter the function to return something else - say "Ver 2"

Current behavior:
The cells where the function has been used in the original form will not be recalculated (and won't show "Ver 2") even after pressing F9 (recalculate sheet).

Expected behavior:
The cells where the function has been used in the original form should update their content at least after having pressed F9; better would be to update the content of affected cells after successful compilation of the function.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20100101 Firefox/15.0.1
Comment 1 Regina Henschel 2012-10-09 22:33:17 UTC 
You need a hard recalculate, that is a Ctrl-Shift-F9.

There exists already a feature request to change it so, that altering a macro should also force a recalculate, see issue 40203

*** This bug has been marked as a duplicate of bug 40203 ***