Description

Creates a new Axlsx::DataValidation object

Parameters:

  • options (Hash) (defaults to: {})

    a customizable set of options

Options Hash (options):

  • formula1 (String)
  • formula2 (String)
  • allowBlank (Boolean)
    • A boolean value indicating whether the data validation allows the use of empty or blank entries.

  • error (String)
    • Message text of error alert.

  • errorStyle (Symbol)
    • The style of error alert used for this data validation.

  • errorTitle (String)
    • itle bar text of error alert.

  • operator (Symbol)
    • The relational operator used with this data validation.

  • prompt (String)
    • Message text of input prompt.

  • promptTitle (String)
    • Title bar text of input prompt.

  • showDropDown (Boolean)
    • A boolean value indicating whether to display a dropdown combo box for a list type data validation

  • showErrorMessage (Boolean)
    • A boolean value indicating whether to display the error alert message when an invalid value has been entered, according to the criteria specified.

  • showInputMessage (Boolean)
    • A boolean value indicating whether to display the input prompt message.

  • sqref (String)
    • Range over which data validation is applied, in “A1:B2” format.

  • type (Symbol)
    • The type of data validation.

initialize is referenced in 0 repositories