Represents a data validation rule which allows any formula to be used to validate the value applied to a cell.
Inheritance
Constructors
Section titled "Constructors"constructor
public CustomDataValidationRule()Returns CustomDataValidationRule
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; }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
GetFormula(string)
Section titled "GetFormula(string)"Gets the formula used to validate the value applied to a cell.
public string GetFormula(string address)Parameters
- address:
string
Returns any
GetFormula(string, WorkbookFormat, CellReferenceMode, CultureInfo)
Section titled "GetFormula(string, WorkbookFormat, CellReferenceMode, CultureInfo)"Gets the formula used to validate the value applied to a cell.
public string GetFormula(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
SetFormula(string, string)
Section titled "SetFormula(string, string)"Sets the formula used to validate the value applied to a cell.
public void SetFormula(string formula, string address)Parameters
- formula:
string - address:
string
Returns any
SetFormula(string, string, WorkbookFormat, CellReferenceMode, CultureInfo)
Section titled "SetFormula(string, string, WorkbookFormat, CellReferenceMode, CultureInfo)"Sets the formula used to validate the value applied to a cell.
public void SetFormula(string formula, string address, WorkbookFormat format, CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- formula:
string - address:
string - format:
WorkbookFormat - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo