I'm using cells for java 2.2.1.0:
validation.setType(ValidationType.LIST);
validation.setOperator(OperatorType.NONE);
will throw an exception: java.lang.IllegalArgumentException: Invalid operator type of the data validation at com.aspose.cells.Validation.setOperator(Unknown Source)
at line validation.setOperator(OperatorType.NONE);
Hi,
When you use List Validation type, you don’t need to specify the operator type, please eliminate the line of code: validation.setOperator(OperatorType.NONE);
See the following sample code:
// Create a workbook object.
Workbook workbook = new Workbook();
// Get the first worksheet.
Worksheet ExcelWorkSheet = workbook.getWorksheets().getSheet(0);
// Add a new worksheet and access it.
Worksheet worksheet2 = workbook.getWorksheets().addSheet();
// Create a range with name in the second worksheet.
NamedRange range = worksheet2.getCells().createNamedRange(“MyRange”,0,4,3,4);
// Fill different cells with data in the range.
range.getCell(0,0).setValue(“Blue”);
range.getCell(1,0).setValue(“Red”);
range.getCell(2,0).setValue(“Green”);
range.getCell(3,0).setValue(“Yellow”);
// Obtain the existing Validations collection.
Validations validations = ExcelWorkSheet.getValidations();
// Create a validation object adding to the collection list.
int index = validations.add();
Validation validation = validations.get(index);
// Set the validation type.
validation.setType(ValidationType.LIST);
// Set the in cell drop down.
validation.setInCellDropDown(true);
// Set the formula1.
validation.setFormula1(“=MyRange”);
// Enable it to show error.
validation.setShowError(true);
// Set the alert type severity level.
validation.setAlertType(ValidationAlertType.STOP);
// Set the error title.
validation.setErrorTitle(“Error”);
// Set the error message.
validation.setErrorMessage(“Please select a color from the list”);
// Specify the validation area of cells.
CellArea area = new CellArea(0,0,4,0);
// Add the Validation area.
validation.addCellArea(area);
// Save the excel file.
workbook.save(“d:\files\validationtypelist.xls”);
For complete reference about validation, please see the document:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/data-filtering-and-validation.html
Thank you.