Volatility Enumeration

Specifies the volatility of a custom function.

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'Declaration
 
Public Enum Volatility 
   Inherits System.Enum

'Usage
 
Dim instance As Volatility

public enum Volatility : System.Enum

public enum Volatility = class(System.Enum)

public enum Volatility extends System.Enum

__value public enum Volatility : public System.Enum

public enum class Volatility : public System.Enum

Members

Member	Description
Invariant	Specifies that a function always returns the same result for a given set of arguments.
VolatileEveryInstance	Specifies a volatile function which must be recalculated for every instance.
VolatileEveryRecalc	Specifies a volatile function which must be recalculated at least once every time the workbook set is recalculated or different arguments are passed to it.

Remarks

An example of VolatileEveryRecalc might be a custom function which returns a stock price. There is no guarantee that a VolatileEveryRecalc custom function will only be called once per recalc.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         SpreadsheetGear.CustomFunctions.Volatility

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SpreadsheetGear.CustomFunctions Namespace