Issue 69903 - RecalcAlways property for Addin functions (RANDBETWEEN does not recalculate on F9)
Summary: RecalcAlways property for Addin functions (RANDBETWEEN does not recalculate o...
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 92747 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-09-27 07:53 UTC by niederbayern
Modified: 2017-05-20 11:13 UTC (History)
5 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
patch from ooo-build (32.40 KB, patch)
2009-11-16 15:02 UTC, kyoshida
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description niederbayern 2006-09-27 07:53:26 UTC
(1) Open a new spreadsheet document in Calc
(2) Enter the two following formulas into two different cells:
    =RAND()
    =RANDBETWEEN(1;10)
(3) Press the key F9 (Tools | Cell Contents | Recalculate)
(4) Press the key F9
(5) Press the key F9
(6) ...

The result from RANDBETWEEN won´t change. But it should recalculate, just like
the RAND-function does.
Comment 1 frank 2006-09-27 09:33:18 UTC
Hi Eike,

please have a look at this one.

Frank
Comment 2 jolatt 2006-09-27 16:52:47 UTC
You must use SHIFT-STRG-F9 to recalculate. This is documented in the help.
RANDBETWEEN comes from the analysis addin, may be thats the reason. 
Comment 3 ooo 2006-09-27 17:34:54 UTC
Correct, AddIn functions currently can't have a RecalcAlways property.
Comment 4 erack 2008-08-14 21:24:44 UTC
*** Issue 92747 has been marked as a duplicate of this issue. ***
Comment 5 kyoshida 2009-11-16 15:01:01 UTC
Noel and I have worked on implementing support for volatile functions in VBA,
but I believe the implementation in the core is generic enough so that we can
extend that to support "volatility" for Add-In functions as well.
Comment 6 kyoshida 2009-11-16 15:02:07 UTC
Created attachment 66140 [details]
patch from ooo-build
Comment 7 Marcus 2017-05-20 11:13:22 UTC
Reset assigne to the default "issues@openoffice.apache.org".