Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IValidation Interface
Methods

In This Topic
    IValidation Interface Members
    In This Topic

    The following tables list the members exposed by IValidation.

    Public Methods
     NameDescription
    MethodaddOverloaded. Adds data validation to the specified range.  
    MethoddeleteDeletes the object.  
    MethodfromJsonGenerates the data validation from the json string.  
    MethodgetAlertStyleGets the validation alert style.  
    MethodgetErrorMessageGets the data validation error message.  
    MethodgetErrorTitleGets the title of the data-validation error dialog box.  
    MethodgetFormula1Gets the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula.  
    MethodgetFormula2Gets the value or expression associated with the second part of a conditional format or data validation.  
    MethodgetIgnoreBlankGets whether blank values are permitted by the data range validation.  
    MethodgetIMEModeGets the description of the Japanese input rules.  
    MethodgetInCellDropdownGets whether data validation displays a drop-down list that contains acceptable values.  
    MethodgetInputMessageGets the data validation input message.  
    MethodgetInputTitleGets the title of the data-validation input dialog box.  
    MethodgetOperatorGets the operator for the conditional format or data validation.  
    MethodgetShowErrorGets whether the data validation error message will be displayed whenever the user enters invalid data.  
    MethodgetShowInputMessageGets whether the data validation input message is displayed whenever the user selects a cell in the data validation range.  
    MethodgetTypeGets the data type validation for a range.  
    MethodgetValueGets whether all the validation criteria are met (that is, if the range contains valid data).  
    MethodsetAlertStyleSets the validation alert style.  
    MethodsetErrorMessageSets the data validation error message.  
    MethodsetErrorTitleSets the title of the data-validation error dialog box.  
    MethodsetFormula1Sets the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula.  
    MethodsetFormula2Sets the value or expression associated with the second part of a conditional format or data validation.  
    MethodsetIgnoreBlankSets whether blank values are permitted by the data range validation.  
    MethodsetIMEModeSets the description of the Japanese input rules.  
    MethodsetInCellDropdownSets whether data validation displays a drop-down list that contains acceptable values.  
    MethodsetInputMessageSets the data validation input message.  
    MethodsetInputTitleSets the title of the data-validation input dialog box.  
    MethodsetOperatorSets the operator for the conditional format or data validation.  
    MethodsetShowErrorSets whether the data validation error message will be displayed whenever the user enters invalid data.  
    MethodsetShowInputMessageSets whether the data validation input message is displayed whenever the user selects a cell in the data validation range.  
    MethodsetTypeSets the data type validation for a range.  
    MethodtoJsonGenerates a json string from the data validation.  
    Top
    See Also

    Reference

    IValidation Interface
    com.grapecity.documents.excel Package