Class ExcelDataValidationWithFormula<T>

Namespace

OfficeOpenXml.DataValidation

Assembly

EPPlus.dll

A validation containing a formula

public abstract class ExcelDataValidationWithFormula<T> : ExcelDataValidation, IExcelDataValidation where T : IExcelDataValidationFormula

Type Parameters

T

Inheritance

object

ExcelDataValidation

ExcelDataValidationWithFormula<T>

Implements

IExcelDataValidation

Derived

ExcelDataValidationCustom

ExcelDataValidationList

ExcelDataValidationWithFormula2<T>

Inherited Members

ExcelDataValidation.Uid

ExcelDataValidation.Address

ExcelDataValidation.ValidationType

ExcelDataValidation.ErrorStyle

ExcelDataValidation.ImeMode

ExcelDataValidation.AllowBlank

ExcelDataValidation.ShowInputMessage

ExcelDataValidation.ShowErrorMessage

ExcelDataValidation.ErrorTitle

ExcelDataValidation.Error

ExcelDataValidation.PromptTitle

ExcelDataValidation.Prompt

ExcelDataValidation.AllowsOperator

ExcelDataValidation.As

ExcelDataValidation.IsStale

ExcelDataValidation.Operator

ExcelDataValidation.OnFormulaChanged

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Fields

_workSheetName

Name of worksheet this datavalidation belongs to

protected string _workSheetName

Field Value

string

Properties

Formula

Formula - Either a {T} value (except for custom validation) or a spreadsheet formula

public T Formula { get; protected set; }

Property Value

T

Methods

Validate()

Validates the configuration of the validation.

public override void Validate()

Exceptions

InvalidOperationException

Will be thrown if invalid configuration of the validation. Details will be in the message of the exception.