Skip to content

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

Inherited Members

ExcelDataValidation.Address
ExcelDataValidation.AllowBlank
ExcelDataValidation.AllowsOperator
ExcelDataValidation.As
ExcelDataValidation.Error
ExcelDataValidation.ErrorStyle
ExcelDataValidation.ErrorTitle
ExcelDataValidation.ImeMode
ExcelDataValidation.IsStale
ExcelDataValidation.OnFormulaChanged
ExcelDataValidation.Operator
ExcelDataValidation.Prompt
ExcelDataValidation.PromptTitle
ExcelDataValidation.ShowErrorMessage
ExcelDataValidation.ShowInputMessage
ExcelDataValidation.Uid
ExcelDataValidation.Validate()
ExcelDataValidation.ValidationType
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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.