Validation Class |
Namespace: Aspose.Cells
The Validation type exposes the following members.
Name | Description | |
---|---|---|
![]() | AlertStyle |
Represents the validation alert style.
|
![]() | Areas |
Gets all CellArea which contain the data validation settings.
|
![]() | ErrorMessage |
Represents the data validation error message.
|
![]() | ErrorTitle |
Represents the title of the data-validation error dialog box.
|
![]() | Formula1 |
Represents the value or expression associated with the data validation.
|
![]() | Formula2 |
Represents the value or expression associated with the data validation.
|
![]() | IgnoreBlank |
Indicates whether blank values are permitted by the range data validation.
|
![]() | InCellDropDown |
Indicates whether data validation displays a drop-down list that contains acceptable values.
|
![]() | InputMessage |
Represents the data validation input message.
|
![]() | InputTitle |
Represents the title of the data-validation input dialog box.
|
![]() | Operator |
Represents the operator for the data validation.
|
![]() | ShowError |
Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
|
![]() | ShowInput |
Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
|
![]() | Type |
Represents the data validation type.
|
![]() | Value1 |
Represents the first value associated with the data validation.
|
![]() | Value2 |
Represents the second value associated with the data validation.
|
Name | Description | |
---|---|---|
![]() | AddArea(CellArea) |
Applies the validation to the area.
|
![]() | AddArea(CellArea, Boolean, Boolean) |
Applies the validation to the area.
|
![]() | AddAreas |
Applies the validation to given areas.
|
![]() | Copy |
Copy validation.
|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetFormula1(Boolean, Boolean) |
Gets the value or expression associated with this validation.
|
![]() | GetFormula1(Boolean, Boolean, Int32, Int32) |
Gets the value or expression associated with this validation for specific cell.
|
![]() | GetFormula2(Boolean, Boolean) |
Gets the value or expression associated with this validation.
|
![]() | GetFormula2(Boolean, Boolean, Int32, Int32) |
Gets the value or expression associated with this validation for specific cell.
|
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetListValue |
Get the value for list of the validation for the specified cell.
|
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | RemoveACell |
Remove the validation settings in the cell.
|
![]() | RemoveArea |
Remove the validation settings in the range.
|
![]() | RemoveAreas |
Removes this validation from given areas.
|
![]() | SetFormula1 |
Sets the value or expression associated with this validation.
|
![]() | SetFormula2 |
Sets the value or expression associated with this validation.
|
![]() | ToString | (Inherited from Object.) |
[C#] Workbook workbook = new Workbook(); ValidationCollection validations = workbook.Worksheets[0].Validations; CellArea area = CellArea.CreateCellArea(0, 0, 1, 1); Validation validation = validations[validations.Add(area)]; validation.Type = Aspose.Cells.ValidationType.WholeNumber; validation.Operator = OperatorType.Between; validation.Formula1 = "3"; validation.Formula2 = "1234"; [Visual Basic] Dim workbook as Workbook = new Workbook() Dim validations as ValidationCollection = workbook.Worksheets(0).Validations Dim area as CellArea = CellArea.CreateCellArea(0, 0, 1, 1); Dim validation as Validation = validations(validations.Add(area)) validation.Type = ValidationType.WholeNumber validation.Operator = OperatorType.Between validation.Formula1 = "3" validation.Formula2 = "1234"