Excel AddIn - Add case sensitivity option to Excel.ListDataValidation
The Excel API for list data validation has the source property defined as either a string (of comma separated values) or a range. However these two different types are not treated the same.
Data validation lists passed to source as strings will evaluate with case sensitivity. Lists passed to source as an Excel.range will evaluate without case sensitivity. This makes it impossible to use a list for data validation that comes from memory (or any place other than an Excel range) and to treat it with case insensitivity.
I suggest a case sensitivity/match case property be added to Excel,ListDataValidation so that there is a clear option to turn case sensitivity on or off, and so that string lists can be treated as case insensitive when needed.