Class ExcelDataValidationWithFormula<T>

A validation containing a formula

Inheritance

object

ExcelDataValidation

ExcelDataValidationWithFormula<T>

ExcelDataValidationCustom

ExcelDataValidationList

ExcelDataValidationWithFormula2<T>

Implements

IExcelDataValidation

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.Operator

ExcelDataValidation.OnFormulaChanged

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.DataValidation

Assembly: EPPlus.dll

Syntax

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

Type Parameters

Name	Description
T

Fields

_workSheetName

Name of worksheet this datavalidation belongs to

Declaration

protected string _workSheetName

Field Value

Type	Description
string

Properties

Formula

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

Declaration

public T Formula { get; protected set; }

Property Value

Type	Description
T

Methods

Validate()

Validates the configuration of the validation.

Declaration

public override void Validate()

Overrides

ExcelDataValidation.Validate()

Exceptions

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

Implements

IExcelDataValidation