java.lang.Object
com.aspose.cells.Validation
public class Validation
- extends java.lang.Object
Represents data validation.settings.
Example:
Workbook workbook = new Workbook();
ValidationCollection validations = workbook.getWorksheets().get(0).getValidations();
Validation validation = validations.get(validations.add());
validation.setType(com.aspose.cells.ValidationType.WHOLE_NUMBER);
validation.setOperator(OperatorType.BETWEEN);
validation.setFormula1("3");
validation.setFormula2("1234");
CellArea area;
area.StartRow = 0;
area.EndRow = 1;
area.StartColumn = 0;
area.EndColumn = 1;
m$ArrayList.add(validation.getAreaList(), area);
Property Getters/Setters Summary |
int | getAlertStyle() | |
void | setAlertStyle(int value) | |
|
Represents the validation alert style.
The value of the property is ValidationAlertType integer constant. |
java.util.ArrayList | getAreaList() | |
|
Represents a collection of CellArea which contains the data validation settings.
|
java.lang.String | getErrorMessage() | |
void | setErrorMessage(java.lang.String value) | |
|
Represents the data validation error message.
|
java.lang.String | getErrorTitle() | |
void | setErrorTitle(java.lang.String value) | |
|
Represents the title of the data-validation error dialog box.
|
java.lang.String | getFormula1() | |
void | setFormula1(java.lang.String value) | |
|
Represents the value or expression associated with the data validation.
|
java.lang.String | getFormula2() | |
void | setFormula2(java.lang.String value) | |
|
Represents the value or expression associated with the second part of the data validation.
|
boolean | getIgnoreBlank() | |
void | setIgnoreBlank(boolean value) | |
|
Indicates whether blank values are permitted by the range data validation.
|
boolean | getInCellDropDown() | |
void | setInCellDropDown(boolean value) | |
|
Indicates whether data validation displays a drop-down list that contains acceptable values.
|
java.lang.String | getInputMessage() | |
void | setInputMessage(java.lang.String value) | |
|
Represents the data validation input message.
|
java.lang.String | getInputTitle() | |
void | setInputTitle(java.lang.String value) | |
|
Represents the title of the data-validation input dialog box.
|
int | getOperator() | |
void | setOperator(int value) | |
|
Represents the operator for the data validation.
The value of the property is OperatorType integer constant. |
boolean | getShowError() | |
void | setShowError(boolean value) | |
|
Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
|
boolean | getShowInput() | |
void | setShowInput(boolean value) | |
|
Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
|
int | getType() | |
void | setType(int value) | |
|
Represents the data validation type.
The value of the property is ValidationType integer constant. |
java.lang.Object | getValue1() | |
void | setValue1(java.lang.Object value) | |
|
Represents the first value associated with the data validation.
|
java.lang.Object | getValue2() | |
void | setValue2(java.lang.Object value) | |
|
Represents the first value associated with the data validation.
|
Method Summary |
void | addArea(CellArea cellArea) | |
Applies the validation to the area.
|
void | removeACell(int row, int column) | |
Remove the validation settings in the cell.
|
void | removeArea(CellArea cellArea) | |
Remove the validation settings in the range.
|
Property Getters/Setters Detail |
getOperator/setOperator | |
public int getOperator() / public void setOperator(int value)
|
-
Represents the operator for the data validation.
The value of the property is OperatorType integer constant.
getAlertStyle/setAlertStyle | |
public int getAlertStyle() / public void setAlertStyle(int value)
|
-
Represents the validation alert style.
The value of the property is ValidationAlertType integer constant.
getType/setType | |
public int getType() / public void setType(int value)
|
-
Represents the data validation type.
The value of the property is ValidationType integer constant.
getInputMessage/setInputMessage | |
public java.lang.String getInputMessage() / public void setInputMessage(java.lang.String value)
|
-
Represents the data validation input message.
getInputTitle/setInputTitle | |
public java.lang.String getInputTitle() / public void setInputTitle(java.lang.String value)
|
-
Represents the title of the data-validation input dialog box.
getErrorMessage/setErrorMessage | |
public java.lang.String getErrorMessage() / public void setErrorMessage(java.lang.String value)
|
-
Represents the data validation error message.
getErrorTitle/setErrorTitle | |
public java.lang.String getErrorTitle() / public void setErrorTitle(java.lang.String value)
|
-
Represents the title of the data-validation error dialog box.
getShowInput/setShowInput | |
public boolean getShowInput() / public void setShowInput(boolean value)
|
-
Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
getShowError/setShowError | |
public boolean getShowError() / public void setShowError(boolean value)
|
-
Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
getIgnoreBlank/setIgnoreBlank | |
public boolean getIgnoreBlank() / public void setIgnoreBlank(boolean value)
|
-
Indicates whether blank values are permitted by the range data validation.
getFormula1/setFormula1 | |
public java.lang.String getFormula1() / public void setFormula1(java.lang.String value)
|
-
Represents the value or expression associated with the data validation.
getValue1/setValue1 | |
public java.lang.Object getValue1() / public void setValue1(java.lang.Object value)
|
-
Represents the first value associated with the data validation.
getValue2/setValue2 | |
public java.lang.Object getValue2() / public void setValue2(java.lang.Object value)
|
-
Represents the first value associated with the data validation.
getFormula2/setFormula2 | |
public java.lang.String getFormula2() / public void setFormula2(java.lang.String value)
|
-
Represents the value or expression associated with the second part of the data validation.
getInCellDropDown/setInCellDropDown | |
public boolean getInCellDropDown() / public void setInCellDropDown(boolean value)
|
-
Indicates whether data validation displays a drop-down list that contains acceptable values.
getAreaList | |
public java.util.ArrayList getAreaList()
|
-
Represents a collection of CellArea which contains the data validation settings.
The old valvidations on the area will not be removed if directly adding are to this list.
addArea | |
public void addArea(CellArea cellArea) |
-
Applies the validation to the area.
In this method , we will remove all old validations on this area.
- Parameters:
cellArea
- The area.
removeArea | |
public void removeArea(CellArea cellArea) |
-
Remove the validation settings in the range.
- Parameters:
cellArea
- The range which contains the data validation settings.
removeACell | |
public void removeACell(int row, int column) |
-
Remove the validation settings in the cell.
- Parameters:
row
- The row index.column
- The column index.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.