'Declaration
 
Public Shared Function ParseInput( _
   ByVal worksheet As Worksheet, _
   ByVal formula1 As String, _
   ByVal formula2 As String, _
   ByVal contextRow As Integer, _
   ByVal contextColumn As Integer, _
   ByVal dvType As DataValidationType, _
   ByVal operator As DataValidationOperator, _
   ByRef primitiveValue1 As IPrimitiveValue, _
   ByRef expression1 As Expression, _
   ByRef primitiveValue2 As IPrimitiveValue, _
   ByRef expression2 As Expression _
) As DataRestrictions

'Usage
 
Dim worksheet As Worksheet
Dim formula1 As String
Dim formula2 As String
Dim contextRow As Integer
Dim contextColumn As Integer
Dim dvType As DataValidationType
Dim operator As DataValidationOperator
Dim primitiveValue1 As IPrimitiveValue
Dim expression1 As Expression
Dim primitiveValue2 As IPrimitiveValue
Dim expression2 As Expression
Dim value As DataRestrictions
 
value = BuiltInDataValidation.ParseInput(worksheet, formula1, formula2, contextRow, contextColumn, dvType, operator, primitiveValue1, expression1, primitiveValue2, expression2)

public static DataRestrictions ParseInput( 
   Worksheet worksheet,
   string formula1,
   string formula2,
   int contextRow,
   int contextColumn,
   DataValidationType dvType,
   DataValidationOperator operator,
   out IPrimitiveValue primitiveValue1,
   out Expression expression1,
   out IPrimitiveValue primitiveValue2,
   out Expression expression2
)

Parameters

worksheet

A Worksheet object indicates the active worksheet.

formula1

A string value indicates the first formula.

formula2

A string value indicates the second formula.

contextRow

An integer value indicates the context row index.

contextColumn

An integer value indicates the context column index.

dvType

A DataValidationType value indicates the data validation type.

operator

primitiveValue1

A GrapeCity.CalcEngine.PrimitiveValue object represents the first parsed value.

expression1

An GrapeCity.CalcEngine.Expression object represents the first parsed expression.

primitiveValue2

A GrapeCity.CalcEngine.PrimitiveValue object represents the second parsed value.

expression2

An GrapeCity.CalcEngine.Expression object represents the second parsed expression.

Return Value

Reference

BuiltInDataValidation Class
BuiltInDataValidation Members