Table of Contents

Class XlsValidationWrapper

Namespace
Spire.Xls.Core.Spreadsheet
Assembly
Spire.XLS.dll
public class XlsValidationWrapper : CommonWrapper, ICloneParent, IDataValidation, IExcelApplication, IOptimizedUpdate
Inheritance
XlsValidationWrapper
Implements
Derived
Inherited Members

Constructors

XlsValidationWrapper(XlsRange, XlsValidation)

public XlsValidationWrapper(XlsRange range, XlsValidation wrap)

Parameters

range XlsRange
wrap XlsValidation

XlsValidationWrapper(XlsRange, XlsValidation, bool)

public XlsValidationWrapper(XlsRange range, XlsValidation wrap, bool readOnly)

Parameters

range XlsRange
wrap XlsValidation
readOnly bool

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

Message of the error box.

public string ErrorMessage { get; set; }

Property Value

string

ErrorTitle

Title of the error box.

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

Message of the input box.

public string InputMessage { get; set; }

Property Value

string

InputTitle

Title of the input box.

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

PromptBoxHPosition

public int PromptBoxHPosition { get; set; }

Property Value

int

PromptBoxVPosition

public int PromptBoxVPosition { get; set; }

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[]