Represents a data validation rule which allows a value from a list of accepted values to be applied to a cell.
Inheritance
Constructors
Section titled "Constructors"constructor
public ListDataValidationRule()Returns ListDataValidationRule
Properties
Section titled "Properties"AllowNull
Section titled "AllowNull"Inherited from: LimitedValueDataValidationRule
Gets or sets the value which indicates whether a null, or blank, value is allowed to be set on a cell.
public bool AllowNull { get; set; }ErrorMessageDescription
Section titled "ErrorMessageDescription"Inherited from: DataValidationRule
Gets or sets the description which appears in the dialog box when an invalid value is applied to a cell in Microsoft Excel.
public string ErrorMessageDescription { get; set; }ErrorMessageTitle
Section titled "ErrorMessageTitle"Inherited from: DataValidationRule
Gets or sets the title which appears in the dialog box when an invalid value is applied to a cell in Microsoft Excel.
public string ErrorMessageTitle { get; set; }ErrorStyle
Section titled "ErrorStyle"Inherited from: DataValidationRule
Gets or sets the value which indicates whether the value is allowed when it is invalid and which options are given to the user in the error dialog shown by Microsoft Excel.
public DataValidationErrorStyle ErrorStyle { get; set; }ImeMode
Section titled "ImeMode"Inherited from: DataValidationRule
Gets or sets the description of the Japanese input rules.
public DataValidationImeMode ImeMode { get; set; }InputMessageDescription
Section titled "InputMessageDescription"Inherited from: DataValidationRule
Gets or sets the description in the tooltip which appears when the user selects the cell in Microsoft Excel.
public string InputMessageDescription { get; set; }InputMessageTitle
Section titled "InputMessageTitle"Inherited from: DataValidationRule
Gets or sets the title in the tooltip which appears when the user selects the cell in Microsoft Excel.
public string InputMessageTitle { get; set; }ShowErrorMessageForInvalidValue
Section titled "ShowErrorMessageForInvalidValue"Inherited from: DataValidationRule
Gets or sets the value which indicates whether the error dialog should appear in Microsoft Excel when invalid data is entered in the cell.
public bool ShowErrorMessageForInvalidValue { get; set; }ShowInputMessage
Section titled "ShowInputMessage"Inherited from: DataValidationRule
Gets or sets the value which indicates whether to show the user an input prompt tooltip when the user selects the cell in Microsoft Excel.
public bool ShowInputMessage { get; set; }ShowDropdown
Section titled "ShowDropdown"Gets or sets the value which indicates whether a drop down should be displayed in Microsoft Excel with the list of accepted values.
public bool ShowDropdown { get; set; }Methods
Section titled "Methods"Clone()
Section titled "Clone()"Inherited from: DataValidationRule
Creates a copy of this rule which can be applied to other worksheets.
public DataValidationRule Clone()Returns any
GetValuesFormula(string)
Section titled "GetValuesFormula(string)"Gets the formula which specifies the accepted values.
public string GetValuesFormula(string address)Parameters
- address:
string
Returns any
GetValuesFormula(string, WorkbookFormat, CellReferenceMode, CultureInfo)
Section titled "GetValuesFormula(string, WorkbookFormat, CellReferenceMode, CultureInfo)"Gets the formula which specifies the accepted values.
public string GetValuesFormula(string address, WorkbookFormat format, CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- address:
string - format:
WorkbookFormat - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo
Returns any
IsEquivalentTo(DataValidationRule)
Section titled "IsEquivalentTo(DataValidationRule)"Indicates if this rule is structurally equivalent to another.
public override bool IsEquivalentTo(DataValidationRule other)Parameters
- other:
DataValidationRule
Returns any
SetValues(params object[])
Section titled "SetValues(params object[])"Sets the list of accepted values the cell can accept.
public void SetValues(params object[] values)Parameters
- values:
object[]
Returns any
SetValuesFormula(string, string)
Section titled "SetValuesFormula(string, string)"Sets the formula which specifies the accepted values.
public void SetValuesFormula(string valuesFormula, string address)Parameters
- valuesFormula:
string - address:
string
Returns any
SetValuesFormula(string, string, WorkbookFormat, CellReferenceMode, CultureInfo)
Section titled "SetValuesFormula(string, string, WorkbookFormat, CellReferenceMode, CultureInfo)"Sets the formula which specifies the accepted values.
public void SetValuesFormula(string valuesFormula, string address, WorkbookFormat format, CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- valuesFormula:
string - address:
string - format:
WorkbookFormat - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo
Returns any
TryGetValues(out object[])
Section titled "TryGetValues(out object[])"Tries to obtain the value of the constraint.
public bool TryGetValues(out object[] values)Parameters
- values:
object[]