OfficeIMO

API Reference

Class

ExcelDataValidationSnapshot

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Immutable worksheet data-validation metadata discovered during inspection.

Inheritance

  • Object
  • ExcelDataValidationSnapshot

Constructors

public ExcelDataValidationSnapshot() #

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 String Formula1 { get; set; } #

Formula1 text stored by Excel, when present.

public String Formula2 { get; set; } #

Formula2 text stored by Excel, when present.

public IReadOnlyList<String> A1Ranges { get; } #

All A1 ranges targeted by the validation.