API Reference
Class
ExcelDataValidationSnapshot
Immutable worksheet data-validation metadata discovered during inspection.
Inheritance
- Object
- ExcelDataValidationSnapshot
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
- Property ExcelWorksheetSnapshot.Validations
Constructors
public ExcelDataValidationSnapshot() #Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public String Type { get; set; } #Validation type such as list or whole.
public String Operator { get; set; } #Validation operator, when present.
public Boolean AllowBlank { get; set; } #Whether blank values are allowed.
public Boolean SuppressDropDown { get; set; } #Whether Excel hides the in-cell dropdown for a list validation.
public String Formula1 { get; set; } #Formula1 text stored by Excel, when present.
public String Formula2 { get; set; } #Formula2 text stored by Excel, when present.
public Boolean ShowInputMessage { get; set; } #Whether Excel displays the input prompt.
public String PromptTitle { get; set; } #Input prompt title.
public String Prompt { get; set; } #Input prompt text.
public Boolean ShowErrorMessage { get; set; } #Whether Excel displays a validation error.
public String ErrorTitle { get; set; } #Validation error title.
public String Error { get; set; } #Validation error text.
public String ErrorStyle { get; set; } #Validation error style token.
public IReadOnlyList<String> A1Ranges { get; } #All A1 ranges targeted by the validation.