Class DataValidation

Represents the data validation of a worksheet range

Inheritance

System.Object

DataValidation

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class DataValidation : object

Constructors

DataValidation()

Declaration

public DataValidation()

Properties

AllowBlank

Declaration

public bool AllowBlank { get; set; }

Property Value

Type	Description
System.Boolean

Error

Declaration

public string Error { get; set; }

Property Value

Type	Description
System.String

ErrorStyle

Declaration

public DataValidationErrorStyle ErrorStyle { get; set; }

Property Value

Type	Description
DataValidationErrorStyle

ErrorTitle

Declaration

public string ErrorTitle { get; set; }

Property Value

Type	Description
System.String

Formula1

Get or set the first formula

Declaration

public string Formula1 { get; set; }

Property Value

Type	Description
System.String

Formula2

Declaration

public string Formula2 { get; set; }

Property Value

Type	Description
System.String

ImeMode

Declaration

public DataValidationImeMode ImeMode { get; set; }

Property Value

Type	Description
DataValidationImeMode

InCellDropDown

Declaration

public bool InCellDropDown { get; set; }

Property Value

Type	Description
System.Boolean

InputMessage

Declaration

public string InputMessage { get; set; }

Property Value

Type	Description
System.String

InputMessageTitle

Declaration

public string InputMessageTitle { get; set; }

Property Value

Type	Description
System.String

Operator

Declaration

public DataValidationOperator Operator { get; set; }

Property Value

Type	Description
DataValidationOperator

Range

Get or set the range where the data valibation should be applied.

Declaration

public Range Range { get; set; }

Property Value

Type	Description
Range

ShowErrorMessage

Declaration

public bool ShowErrorMessage { get; set; }

Property Value

Type	Description
System.Boolean

ShowInputMessage

Declaration

public bool ShowInputMessage { get; set; }

Property Value

Type	Description
System.Boolean

Type

Declaration

public DataValidationType Type { get; set; }

Property Value

Type	Description
DataValidationType