1
Vote

DataValidation Explicit Values Extra Quotes

description

When setting data validation to an explicit list in excel, say 1 and 2, NPOI reads the datavalidation formula enclosed in an extra double quotes: ""1,2"" instead of "1,2", resulting in the ExplicitValues array to also contains the quotes.

using NPOI 2.2.1

Nic

file attachments

comments