Class XlsValidation

Namespace

Spire.Xls.Core.Spreadsheet

Assembly

Spire.XLS.dll

public class XlsValidation : IDataValidation, IExcelApplication, IOptimizedUpdate, ICloneParent

Inheritance

object

XlsValidation

Implements

IDataValidation

IExcelApplication

IOptimizedUpdate

ICloneParent

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

AlertStyle

public AlertStyleType AlertStyle { get; set; }

Property Value

AlertStyleType

AllowType

public CellDataType AllowType { get; set; }

Property Value

CellDataType

CompareOperator

public ValidationComparisonOperator CompareOperator { get; set; }

Property Value

ValidationComparisonOperator

DataRange

public IXLSRange DataRange { get; set; }

Property Value

IXLSRange

DateTime1

public DateTime DateTime1 { get; set; }

Property Value

DateTime

DateTime2

public DateTime DateTime2 { get; set; }

Property Value

DateTime

ErrorMessage

public string ErrorMessage { get; set; }

Property Value

string

ErrorTitle

public string ErrorTitle { get; set; }

Property Value

string

Formula1

public string Formula1 { get; set; }

Property Value

string

Formula2

public string Formula2 { get; set; }

Property Value

string

IgnoreBlank

public bool IgnoreBlank { get; set; }

Property Value

bool

InputMessage

public string InputMessage { get; set; }

Property Value

string

InputTitle

public string InputTitle { get; set; }

Property Value

string

IsInputPositionFixed

public bool IsInputPositionFixed { get; set; }

Property Value

bool

IsInputVisible

public bool IsInputVisible { get; set; }

Property Value

bool

IsListInFormula

public bool IsListInFormula { get; set; }

Property Value

bool

IsSuppressDropDownArrow

public bool IsSuppressDropDownArrow { get; set; }

Property Value

bool

Parent

public object Parent { get; }

Property Value

object

ParentCollection

public XlsDataValidationCollection ParentCollection { get; set; }

Property Value

XlsDataValidationCollection

PromptBoxHPosition

public int PromptBoxHPosition { get; set; }

Property Value

int

PromptBoxVPosition

public int PromptBoxVPosition { get; set; }

Property Value

int

ShapesCount

public int ShapesCount { get; }

Property Value

int

ShowError

public bool ShowError { get; set; }

Property Value

bool

ShowInput

public bool ShowInput { get; set; }

Property Value

bool

Values

public string[] Values { get; set; }

Property Value

string[]

Worksheet

public XlsWorksheet Worksheet { get; }

Property Value

XlsWorksheet

Methods

AddRange(XlsRange)

public void AddRange(XlsRange range)

Parameters

range XlsRange

AddRange(XlsValidation)

public void AddRange(XlsValidation dv)

Parameters

dv XlsValidation

BeginUpdate()

[Obsolete("the method is not implemented")]
public void BeginUpdate()

Clone(object)

public object Clone(object parent)

Parameters

parent object

Returns

object

ContainsCell(long)

public bool ContainsCell(long lCellIndex)

Parameters

lCellIndex long

Returns

bool

EndUpdate()

[Obsolete("the method is not implemented")]
public void EndUpdate()

RemoveRange(XlsRange)

public void RemoveRange(XlsRange range)

Parameters

range XlsRange

RemoveRange(Rectangle[])

[Obsolete("the method is not implemented")]
public void RemoveRange(Rectangle[] rectangles)

Parameters

rectangles Rectangle[]