API Reference
ExcelDataValidationInfo
Read-only snapshot of a data validation rule.
Inheritance
- Object
- ExcelDataValidationInfo
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
Constructors
public ExcelDataValidationInfo() #Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public String Range { get; set; } #Gets or sets the A1 range covered by the validation.
public String Type { get; set; } #Gets or sets the OpenXML validation type.
public String Operator { get; set; } #Gets or sets the OpenXML validation operator.
public Boolean AllowBlank { get; set; } #Gets or sets whether blank values are allowed.
public Boolean SuppressDropDown { get; set; } #Gets or sets whether Excel should hide the in-cell dropdown for list validations.
public String ErrorStyle { get; set; } #Gets or sets the OpenXML validation error style.
public Boolean ShowInputMessage { get; set; } #Gets or sets whether Excel should show the input prompt.
public Boolean ShowErrorMessage { get; set; } #Gets or sets whether Excel should show the validation error.
public String Formula1 { get; set; } #Gets or sets the first validation formula.
public String Formula2 { get; set; } #Gets or sets the second validation formula.
public String PromptTitle { get; set; } #Gets or sets the input prompt title.
public String Prompt { get; set; } #Gets or sets the input prompt text.
public String ErrorTitle { get; set; } #Gets or sets the error title.