I have a cell with a validation list applied to it. One of the strings in the list contains a comma and a slash. This is not being correctly included in the list, because of the comma.
Eg: cell.Validation.ValueList.Add("a, b and c") will result in the entry " b and c" being added to the validation list
I tried escaping the comma, but it did not work for me.
Could you please advise whether this is a bug, and if so how to resolve this.
Thanks