Class DV

This class contains constants used for data validation parsing / serialization in Excel 2007 SpreadsheetML format.

Inheritance
System.Object
DV
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public sealed class DV : Object

Fields

AllowBlankAttributeName

Name of xml attribute name that represents data validation allow blank status.

Declaration
public const string AllowBlankAttributeName = "allowBlank"
Field Value
Type Description
System.String

CFSequenceOfReferencesAttributeName

Name of xml attribute name that represents data validation sequence of references.

Declaration
public const string CFSequenceOfReferencesAttributeName = "sqref"
Field Value
Type Description
System.String

DataValidationsTagName

Name of xml tag that represents data validations.

Declaration
public const string DataValidationsTagName = "dataValidations"
Field Value
Type Description
System.String

DataValidationTagName

Name of xml tag that represents data validation.

Declaration
public const string DataValidationTagName = "dataValidation"
Field Value
Type Description
System.String

DEF_CELLRANGELIST_PREF

Represents Selected pref.

Declaration
public const string DEF_CELLRANGELIST_PREF = "CellRangeList"
Field Value
Type Description
System.String

DEF_ERRORMESSAGE_PREF

Represents Selected pref.

Declaration
public const string DEF_ERRORMESSAGE_PREF = "ErrorMessage"
Field Value
Type Description
System.String

DEF_ERRORSTYLE_PREF

Represents Selected pref.

Declaration
public const string DEF_ERRORSTYLE_PREF = "ErrorStyle"
Field Value
Type Description
System.String

DEF_ERRORTITLE_PREF

Represents Selected pref.

Declaration
public const string DEF_ERRORTITLE_PREF = "ErrorTitle"
Field Value
Type Description
System.String

DEF_INPUTMESSAGE_PREF

Represents Selected pref.

Declaration
public const string DEF_INPUTMESSAGE_PREF = "InputMessage"
Field Value
Type Description
System.String

DEF_INPUTTITLE_PREF

Represents Selected pref.

Declaration
public const string DEF_INPUTTITLE_PREF = "InputTitle"
Field Value
Type Description
System.String

DEF_MAX_PREF

Represents Selected pref.

Declaration
public const string DEF_MAX_PREF = "Max"
Field Value
Type Description
System.String

DEF_MIN_PREF

Represents Selected pref.

Declaration
public const string DEF_MIN_PREF = "Min"
Field Value
Type Description
System.String

DEF_QUALIFIER_PREF

Represents Qualifier pref.

Declaration
public const string DEF_QUALIFIER_PREF = "Qualifier"
Field Value
Type Description
System.String

DEF_RANGE_PREF

Represents Range pref.

Declaration
public const string DEF_RANGE_PREF = "Range"
Field Value
Type Description
System.String

DEF_TYPE_PREF

Represents Type pref.

Declaration
public const string DEF_TYPE_PREF = "Type"
Field Value
Type Description
System.String

DEF_VALUE_PREF

Represents Value pref.

Declaration
public const string DEF_VALUE_PREF = "Value"
Field Value
Type Description
System.String

DisablePromptsAttributeName

Name of xml attribute name that indicates whether all input prompts for the worksheet are disabled.

Declaration
public const string DisablePromptsAttributeName = "disablePrompts"
Field Value
Type Description
System.String

ErrorAlertTextAttributeName

Name of xml attribute name that represents data validation title bar text of error alert.

Declaration
public const string ErrorAlertTextAttributeName = "errorTitle"
Field Value
Type Description
System.String

ErrorAttributeName

Name of xml attribute name that represents data validation error message.

Declaration
public const string ErrorAttributeName = "error"
Field Value
Type Description
System.String

ErrorMessageAttributeName

Name of xml attribute name that represents data validation message text.

Declaration
public const string ErrorMessageAttributeName = "error"
Field Value
Type Description
System.String

ErrorStyleAttributeName

Name of xml attribute name that represents data validation error style.

Declaration
public const string ErrorStyleAttributeName = "errorStyle"
Field Value
Type Description
System.String

ErrorStyleInformationIcon

This data validation error style uses an information icon in the error alert.

Declaration
public const string ErrorStyleInformationIcon = "information"
Field Value
Type Description
System.String

ErrorStyleStopIcon

This data validation error style uses a stop icon in the error alert.

Declaration
public const string ErrorStyleStopIcon = "stop"
Field Value
Type Description
System.String

ErrorStyleWarningIcon

This data validation error style uses a warning icon in the error alert.

Declaration
public const string ErrorStyleWarningIcon = "warning"
Field Value
Type Description
System.String

FormulaOneTagName

Name of xml tag name that represents the first formula in the data validation dropdown.

Declaration
public const string FormulaOneTagName = "formula1"
Field Value
Type Description
System.String

FormulaTwoTagName

Name of xml tag name that represents the second formula in the data validation dropdown.

Declaration
public const string FormulaTwoTagName = "formula2"
Field Value
Type Description
System.String

InputPromptAttributeName

Name of xml attribute name that represents data validation message text of input prompt.

Declaration
public const string InputPromptAttributeName = "prompt"
Field Value
Type Description
System.String

ItemCountAttributeName

Name of xml attribute name that represents data validation item count

Declaration
public const string ItemCountAttributeName = "count"
Field Value
Type Description
System.String

OperatorAttributeName

Name of xml attribute name that represents data validation relational operator used with this data validation.

Declaration
public const string OperatorAttributeName = "operator"
Field Value
Type Description
System.String

OperatorBetween

Represents value which checks if a value is between two other values.

Declaration
public const string OperatorBetween = "between"
Field Value
Type Description
System.String

OperatorEqual

Represents value which checks if a value is equal to a specified value.

Declaration
public const string OperatorEqual = "equal"
Field Value
Type Description
System.String

OperatorGreaterThan

Represents value which checks if a value is greater than a specified value.

Declaration
public const string OperatorGreaterThan = "greaterThan"
Field Value
Type Description
System.String

OperatorGreaterThanOrEqual

Represents value which checks if a value is greater than or equal to a specified value.

Declaration
public const string OperatorGreaterThanOrEqual = "greaterThanOrEqual"
Field Value
Type Description
System.String

OperatorLessThan

Represents value which checks if a value is less than a specified value.

Declaration
public const string OperatorLessThan = "lessThan"
Field Value
Type Description
System.String

OperatorLessThanOrEqual

Represents value which checks if a value is less than or equal to a specified value.

Declaration
public const string OperatorLessThanOrEqual = "lessThanOrEqual"
Field Value
Type Description
System.String

OperatorNotBetween

Represents value which checks if a value is not between two other values.

Declaration
public const string OperatorNotBetween = "notBetween"
Field Value
Type Description
System.String

OperatorNotEqual

Represents value which checks if a value is not equal to a specified value.

Declaration
public const string OperatorNotEqual = "notEqual"
Field Value
Type Description
System.String

PromptTitleAttributeName

Name of xml attribute name that represents data validation title bar text of input prompt.

Declaration
public const string PromptTitleAttributeName = "promptTitle"
Field Value
Type Description
System.String

ShowDropDownAttributeName

Name of xml attribute name that indicates whether to display the dropdown combo box for a list type data validation.

Declaration
public const string ShowDropDownAttributeName = "showDropDown"
Field Value
Type Description
System.String

ShowErrorMessageAttributeName

Name of xml attribute name that indicates whether to display the error alert message.

Declaration
public const string ShowErrorMessageAttributeName = "showErrorMessage"
Field Value
Type Description
System.String

ShowInputMessageAttributeName

Name of xml attribute name that indicates whether to display the input prompt message.

Declaration
public const string ShowInputMessageAttributeName = "showInputMessage"
Field Value
Type Description
System.String

TypeAttributeName

Name of xml attribute name that represents data validation type.

Declaration
public const string TypeAttributeName = "type"
Field Value
Type Description
System.String

TypeCustom

Represents which uses a custom formula to check the cell value.

Declaration
public const string TypeCustom = "custom"
Field Value
Type Description
System.String

TypeDate

Represents which checks for date values satisfying the given condition.

Declaration
public const string TypeDate = "date"
Field Value
Type Description
System.String

TypeDecimal

Represents which checks for decimal values satisfying the given condition.

Declaration
public const string TypeDecimal = "decimal"
Field Value
Type Description
System.String

TypeList

Represents which checks for a value matching one of list of values.

Declaration
public const string TypeList = "list"
Field Value
Type Description
System.String

TypeNone

Represents no data validation.

Declaration
public const string TypeNone = "none"
Field Value
Type Description
System.String

TypeTextLength

Represents which checks for text values, whose length satisfies the given condition.

Declaration
public const string TypeTextLength = "textLength"
Field Value
Type Description
System.String

TypeTime

Represents which checks for time values satisfying the given condition.

Declaration
public const string TypeTime = "time"
Field Value
Type Description
System.String

TypeWhole

Represrnts which checks for whole number values satisfying the given condition.

Declaration
public const string TypeWhole = "whole"
Field Value
Type Description
System.String

XCoodrinateAttributeName

Name of xml attribute name that represents the x-coordinate (relative to window) of top-left corner of the data validation input prompt (textbox).

Declaration
public const string XCoodrinateAttributeName = "xWindow"
Field Value
Type Description
System.String

YCoodrinateAttributeName

Name of xml attribute name that represents the y-coordinate (relative to window) of top-left corner of the data validation input prompt (textbox).

Declaration
public const string YCoodrinateAttributeName = "yWindow"
Field Value
Type Description
System.String