Thanks for your interest,
The problem is always here, even if i use the fix :
This is a part of the code :
ValidationCollection validations = worksheet.getValidations();
int index = validations.add();
Validation validation = validations.get(index);
// Set the validation type.
validation.setType(ValidationType.LIST);
// Set the in cell drop down.
validation.setIgnoreBlank(true);
validation.setInCellDropDown(true);
validation.setShowError(true);
validation.setErrorTitle("Error");
validation.setErrorMessage("You must select one of the value available in the drop-down list box");
validation.setShowInput(true);
validation.setInputMessage("");
// Specify the validation area of cells.
CellArea area = new CellArea();
area.StartRow = 2;
area.EndRow = 500;
area.StartColumn = i;
area.EndColumn = i;
// Set the formula1.
validation.setFormula1(strValidation);
// Add the Validation area.
validation.addArea(area);
NB : strValidation is a concatenation of string separated by ";" like this one : 1- Support operations will halt if application goes down;2- Support operations will halt if application goes down, but there is no manual workaround;4- Critical business operations will halt if application goes down;3- Critical business operations will halt if application goes down, but there is an acceptable manual1- Support operations will halt if application goes down;2- Support operations will halt if application goes down, but there is no manual workaround;4- Critical business operations will halt if application goes down;3- Critical business operations will halt if application goes down, but there is an acceptable manual.