Class ExcelDataValidation

Excel datavalidation

Inheritance

System.Object

XmlHelper

ExcelDataValidation

ExcelDataValidationWithFormula<T>

Implements

IExcelDataValidation

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml.DataValidation

Assembly: Experior.Core.dll

Syntax

public abstract class ExcelDataValidation : XmlHelper, IExcelDataValidation

Fields

_formula1Path

Declaration

protected readonly string _formula1Path

Field Value

Type	Description
System.String

_formula2Path

Declaration

protected readonly string _formula2Path

Field Value

Type	Description
System.String

Properties

Address

Address of data validation

Declaration

public ExcelAddress Address { get; }

Property Value

Type	Description
ExcelAddress

AllowBlank

True if blanks should be allowed

Declaration

public bool? AllowBlank { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

AllowsOperator

True if the validation type allows operator to be set.

Declaration

public bool AllowsOperator { get; }

Property Value

Type	Description
System.Boolean

Error

Error message box text

Declaration

public string Error { get; set; }

Property Value

Type	Description
System.String

ErrorStyle

Warning style

Declaration

public ExcelDataValidationWarningStyle ErrorStyle { get; set; }

Property Value

Type	Description
ExcelDataValidationWarningStyle

ErrorTitle

Title of error message box

Declaration

public string ErrorTitle { get; set; }

Property Value

Type	Description
System.String

Formula1Internal

Formula 1

Declaration

protected string Formula1Internal { get; }

Property Value

Type	Description
System.String

Formula2Internal

Formula 2

Declaration

protected string Formula2Internal { get; }

Property Value

Type	Description
System.String

Operator

Operator for comparison between the entered value and Formula/Formulas.

Declaration

public ExcelDataValidationOperator Operator { get; set; }

Property Value

Type	Description
ExcelDataValidationOperator

Prompt

Declaration

public string Prompt { get; set; }

Property Value

Type	Description
System.String

PromptTitle

Declaration

public string PromptTitle { get; set; }

Property Value

Type	Description
System.String

ShowErrorMessage

True if error message should be shown

Declaration

public bool? ShowErrorMessage { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

ShowInputMessage

True if input message should be shown

Declaration

public bool? ShowInputMessage { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

ValidationType

Validation type

Declaration

public ExcelDataValidationType ValidationType { get; }

Property Value

Type	Description
ExcelDataValidationType

Methods

SetValue<T>(Nullable<T>, String)

Declaration

protected void SetValue<T>(T? val, string path)
    where T : struct

Parameters

Type	Name	Description
System.Nullable<T>	val
System.String	path

Type Parameters

Name	Description
T

Validate()

This method will validate the state of the validation

Declaration

public virtual void Validate()

Exceptions

Type	Condition
System.InvalidOperationException	If the state breaks the rules of the validation

Implements

IExcelDataValidation