DataValidation

General

DataValidation és una classe en Aspose.Cells per a Python.

Representa la configuració de validació dels dades per a un interval de cèl·lules.

Propietats

Name	Type	Access	Description
`sqref`	``	Read	Holds the cell reference(s) to which the validation applies
`ranges`	``	Read	Provides the collection of cell ranges covered by the validation
`type`	``	Read	Indicates the validation type (e.g., list, whole number, custom)
`operator`	``	Read	Specifies the comparison operator used in the validation rule
`formula1`	``	Read	Contains the first formula or value used by the validation
`formula2`	``	Read	Contains the second formula or value for range-based validation
`alert_style`	``	Read	Defines the style of alert shown when validation fails
`show_error_message`	``	Read	Determines whether an error message is displayed on invalid entry
`show_error`	``	Read	Toggles the display of an error dialog for invalid data
`error_title`	``	Read	Sets the title of the error dialog shown on validation failure
`error_message`	``	Read	Provides the detailed error text shown to the user
`error`	``	Read	Is a shortcut to configure both error title and message
`show_input_message`	``	Read	Controls whether an input prompt appears when the cell is selected
`show_input`	``	Read	Toggles the display of the input message for the validation
`input_title`	``	Read	Sets the title of the input prompt displayed to the user
`prompt_title`	``	Read	Is an alias for input_title, representing the prompt’s title
`input_message`	``	Read	Contains the text shown as the input prompt
`prompt`	``	Read	Is a shortcut for setting the input message text
`allow_blank`	``	Read	Indicates if blank entries are permitted by the validation
`ignore_blank`	``	Read	Specifies whether blank cells are ignored during validation
`show_dropdown`	``	Read	Determines if a dropdown arrow is shown for list validations
`in_cell_dropdown`	``	Read	Toggles the in‑cell dropdown list visibility
`ime_mode`	``	Read	Sets the Input Method Editor mode for the validated cells

Mètodes

Signature	Description
`__init__(sqref)`	Initializes a new DataValidation instance.
`add(validation_type, alert_style, operator, formula1, formula2)`	Configures the data validation with the specified parameters.
`modify(validation_type, alert_style, operator, formula1, formula2)`	Modifies the data validation settings.
`delete()`	Clears the validation settings (resets to no validation).
`copy()`	Creates a copy of this DataValidation.