DataValidation Issue

[Administrator]

Hello Syncfusion --

How can I use the DataValidation of a cell with list values that are not in the same sheet??

In Excel it is possible. You have to define a "Name" for the specific range in the other sheet and then you can assign it to the DataValidation.

With Syncfusion XlsIO I can create a IName Object, but I can't assign it to the DataValidation property of the cell.

Any help will be appreciated.

Thx
Georg

[Administrator]

I already found the solution in an other thread (Allow3DRangesInDataValidation, FirstFormula).

BUT: Is there a way to choose more than one entry out of the list??

Thx
Georg

[Melba Winshia]

Hi Georg,

I regret to let you know that it is not possible to choose more than one entry out of the DataValidation list.

Please let me know if you have any concerns.

Thanks,
Melba