IFunction.Volatile Property

Indicates whether the formula containing this function will always be recalculated at each recalculation, whether or not there are changes in the formula or its variables.

Namespace: DevExpress.Spreadsheet.Functions

Assembly: DevExpress.Spreadsheet.v17.2.Core.dll

Declaration

C#

bool Volatile { get; }

VB.NET

ReadOnly Property Volatile As Boolean

Property Value

Type	Description
Boolean	True, to always recalculate a formula with this function; otherwise, false.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Volatile property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

VB.NET

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/VB/SpreadsheetAddIn/Form1.vb#L117

' Do not reevaluate cells on every recalculation.
Public ReadOnly Property Volatile() As Boolean Implements IFunction.Volatile
    Get

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/VB/UDF_Discount/DiscountFunction.vb#L39

' The SpreadsheetControl ignores this value and assumes that the Volatile is always true.
Private ReadOnly Property Volatile() As Boolean Implements IFunction.Volatile
    Get

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/CustomFunctionActions.vb#L100

' Reevaluate cells on every recalculation.
Private ReadOnly Property IFunction_Volatile() As Boolean Implements IFunction.Volatile
    Get

winforms-spreadsheetcontrol-api-part-2-e4832/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/CustomFunctionActions.vb#L102

End Property
Private ReadOnly Property IFunction_Volatile() As Boolean Implements IFunction.Volatile
    Get

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538369/VB/CustomFunctionReturningArrayExample/TestArrayCustomFunction.vb#L36

End Property
Public ReadOnly Property Volatile() As Boolean Implements IFunction.Volatile
    Get