Class DV
This class contains constants used for data validation parsing / serialization in Excel 2007 SpreadsheetML format.
Inheritance
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.UWP.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 |
---|
System.String |
CFSequenceOfReferencesAttributeName
Name of xml attribute name that represents data validation sequence of references.
Declaration
public const string CFSequenceOfReferencesAttributeName = "sqref"
Field Value
Type |
---|
System.String |
DataValidationsTagName
Name of xml tag that represents data validations.
Declaration
public const string DataValidationsTagName = "dataValidations"
Field Value
Type |
---|
System.String |
DataValidationTagName
Name of xml tag that represents data validation.
Declaration
public const string DataValidationTagName = "dataValidation"
Field Value
Type |
---|
System.String |
DEF_CELLRANGELIST_PREF
Represents Selected pref.
Declaration
public const string DEF_CELLRANGELIST_PREF = "CellRangeList"
Field Value
Type |
---|
System.String |
DEF_ERRORMESSAGE_PREF
Represents Selected pref.
Declaration
public const string DEF_ERRORMESSAGE_PREF = "ErrorMessage"
Field Value
Type |
---|
System.String |
DEF_ERRORSTYLE_PREF
Represents Selected pref.
Declaration
public const string DEF_ERRORSTYLE_PREF = "ErrorStyle"
Field Value
Type |
---|
System.String |
DEF_ERRORTITLE_PREF
Represents Selected pref.
Declaration
public const string DEF_ERRORTITLE_PREF = "ErrorTitle"
Field Value
Type |
---|
System.String |
DEF_INPUTMESSAGE_PREF
Represents Selected pref.
Declaration
public const string DEF_INPUTMESSAGE_PREF = "InputMessage"
Field Value
Type |
---|
System.String |
DEF_INPUTTITLE_PREF
Represents Selected pref.
Declaration
public const string DEF_INPUTTITLE_PREF = "InputTitle"
Field Value
Type |
---|
System.String |
DEF_MAX_PREF
Represents Selected pref.
Declaration
public const string DEF_MAX_PREF = "Max"
Field Value
Type |
---|
System.String |
DEF_MIN_PREF
Represents Selected pref.
Declaration
public const string DEF_MIN_PREF = "Min"
Field Value
Type |
---|
System.String |
DEF_QUALIFIER_PREF
Represents Qualifier pref.
Declaration
public const string DEF_QUALIFIER_PREF = "Qualifier"
Field Value
Type |
---|
System.String |
DEF_RANGE_PREF
Represents Range pref.
Declaration
public const string DEF_RANGE_PREF = "Range"
Field Value
Type |
---|
System.String |
DEF_TYPE_PREF
Represents Type pref.
Declaration
public const string DEF_TYPE_PREF = "Type"
Field Value
Type |
---|
System.String |
DEF_VALUE_PREF
Represents Value pref.
Declaration
public const string DEF_VALUE_PREF = "Value"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |
ErrorAttributeName
Name of xml attribute name that represents data validation error message.
Declaration
public const string ErrorAttributeName = "error"
Field Value
Type |
---|
System.String |
ErrorMessageAttributeName
Name of xml attribute name that represents data validation message text.
Declaration
public const string ErrorMessageAttributeName = "error"
Field Value
Type |
---|
System.String |
ErrorStyleAttributeName
Name of xml attribute name that represents data validation error style.
Declaration
public const string ErrorStyleAttributeName = "errorStyle"
Field Value
Type |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
System.String |
ItemCountAttributeName
Name of xml attribute name that represents data validation item count
Declaration
public const string ItemCountAttributeName = "count"
Field Value
Type |
---|
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 |
---|
System.String |
OperatorBetween
Represents value which checks if a value is between two other values.
Declaration
public const string OperatorBetween = "between"
Field Value
Type |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
System.String |
TypeAttributeName
Name of xml attribute name that represents data validation type.
Declaration
public const string TypeAttributeName = "type"
Field Value
Type |
---|
System.String |
TypeCustom
Represents which uses a custom formula to check the cell value.
Declaration
public const string TypeCustom = "custom"
Field Value
Type |
---|
System.String |
TypeDate
Represents which checks for date values satisfying the given condition.
Declaration
public const string TypeDate = "date"
Field Value
Type |
---|
System.String |
TypeDecimal
Represents which checks for decimal values satisfying the given condition.
Declaration
public const string TypeDecimal = "decimal"
Field Value
Type |
---|
System.String |
TypeList
Represents which checks for a value matching one of list of values.
Declaration
public const string TypeList = "list"
Field Value
Type |
---|
System.String |
TypeNone
Represents no data validation.
Declaration
public const string TypeNone = "none"
Field Value
Type |
---|
System.String |
TypeTextLength
Represents which checks for text values, whose length satisfies the given condition.
Declaration
public const string TypeTextLength = "textLength"
Field Value
Type |
---|
System.String |
TypeTime
Represents which checks for time values satisfying the given condition.
Declaration
public const string TypeTime = "time"
Field Value
Type |
---|
System.String |
TypeWhole
Represrnts which checks for whole number values satisfying the given condition.
Declaration
public const string TypeWhole = "whole"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |