Validation.AddArea
Contents
[
Hide
]AddArea(CellArea)
Applies the validation to the area.
public void AddArea(CellArea cellArea)
| Parameter | Type | Description |
|---|---|---|
| cellArea | CellArea | The area. |
Remarks
It is equivalent to use AddArea with checking intersection and edge.
See Also
- struct CellArea
- class Validation
- namespace Aspose.Cells
- assembly Aspose.Cells
AddArea(CellArea, bool, bool)
Applies the validation to the area.
public void AddArea(CellArea cellArea, bool checkIntersection, bool checkEdge)
| Parameter | Type | Description |
|---|---|---|
| cellArea | CellArea | The area. |
| checkIntersection | Boolean | Whether check the intersection of given area with existing validations’ areas. If one validation has been applied in given area(or part of it), then the existing validation should be removed at first from given area. Otherwise corruption may be caused for the generated Validations. If user is sure that the added area does not intersect with any existing area, this parameter can be set as false for performance consideration. |
| checkEdge | Boolean | Whether check the edge of this validation’s applied areas. Validation’s internal settings depend on the top-left one of its applied ranges, so if given area will become the new top-left one of the applied ranges, the internal settings should be changed and rebuilt, otherwise unexpected result may be caused. If user is sure that the added area is not the top-left one, this parameter can be set as false for performance consideration. |
Remarks
In this method, we will remove all old validations in given area. For the top-left one of Validation’s applied ranges, firstly its StartRow is smallest, secondly its StartColumn is the smallest one of those areas who have the same smallest StartRow.
See Also
- struct CellArea
- class Validation
- namespace Aspose.Cells
- assembly Aspose.Cells
