i’m currently evaluating Aspose.Cells.
It seems to solve a lot of issues i have to face. But there is still one i can’t solve by now :
I’ve imported a list of countries in a column of my worksheet and i’m trying to apply a validation rule that would force the values of an area to be included in the list of coutries e.g. i want a dropdown list :).
Some methods seem to allow this… here is a part of my code (assume the countries are in “H” colmun)
validation.Type = ValidationType.List;
validation.InCellDropDown = true;
validation.Operator = OperatorType.Between;//?????
validation.Formula1 = "$H$0"; //????
validation.Formula2 = "$H$25";//?????
then I add the validation to a specific area...
Where am I wrong??