Hi,
I have used a IDataValidation interface to make sure a cell value is in a range of possible values.
I Have used the ListOfValues member, but it seems to throw an exception when the total characters of the String Array is more than 256.
In the Excel Interface for that operation, the input of characters is stopped at that length.
So I am trying to use the DataRange Property to add the List of Values.
I have created a second sheet, Hidden to put the values.
Whan I try to set the DataRange Property to that range (that is on a different sheet) There is an exception that says that the cells must be on the same sheet.
Excel permits to do that so there is a method to do it with XlsIO?
For this particular operation I am still using an older version of Dlls (12.2.0.36). Maybe the newer version don't have this problem.
Thanks
Andrea Perazzolo