In this video you will learn:
The use of different types of validation through .ValidationType.
The use of different types of alerts through .ValidationAlertStyle.
The application of the different types of conditional operators of .ConditionOperator.
Manipulation of validation properties using .TableValidation service.
All derived from the com.sun.star.sheet object.
The tutorial tries to be self-contained but it is necessary:
Either choose between the following options:
Previously, in a previous tutorial of this series I had shown how to apply validations using the UNO Service through the Dispatcher. Actually, that procedure only called the dialog box and the user had to fill in the parameters of the validation.
In the present tutorial we will explore the use of validations in a deeper way. We will assign each of the parameters directly in the range object. Within this learning session we will make use of the following services, properties and enumerations.
Model examples will be provided so that you can apply this knowledge to your needs.
The code generated for this tutorial can be consulted in the following link: CODE
Although the current video is in English, some of the previous videos are in Spanish. You can find the other videos of the series in the following links:
