Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelDataValidationInspectionInfo

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
e163ccb36643 with working tree changes
Modifiers
sealed

Immutable worksheet data-validation metadata discovered during inspection.

Inheritance

  • object
  • ExcelDataValidationInspectionInfo

Usage

Explore 1 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by 1

Constructors

public ExcelDataValidationInspectionInfo() #

Properties

public string? Type { get; internal set; } #

Validation type such as list or whole.

public string? Operator { get; internal set; } #

Validation operator, when present.

public bool AllowBlank { get; internal set; } #

Whether blank values are allowed.

public bool SuppressDropDown { get; internal set; } #

Whether Excel hides the in-cell dropdown for a list validation.

public string? Formula1 { get; internal set; } #

Formula1 text stored by Excel, when present.

public string? Formula2 { get; internal set; } #

Formula2 text stored by Excel, when present.

public bool ShowInputMessage { get; internal set; } #

Whether Excel displays the input prompt.

public string? PromptTitle { get; internal set; } #

Input prompt title.

public string? Prompt { get; internal set; } #

Input prompt text.

public bool ShowErrorMessage { get; internal set; } #

Whether Excel displays a validation error.

public string? ErrorTitle { get; internal set; } #

Validation error title.

public string? Error { get; internal set; } #

Validation error text.

public string? ErrorStyle { get; internal set; } #

Validation error style token.

public IReadOnlyList<string> A1Ranges { get; } #

All A1 ranges targeted by the validation.