This project has moved. For the latest updates, please go here.

Check DataValidation

Nov 17, 2014 at 7:59 AM
if the cell has a validation like currency and the values in 'usd,cny,eur,cad' and its a dropdowslist
But if the cell value displayed 'abc' and not in the currency ranges.

How can i check or get the error msg? thanks your help.
Nov 17, 2014 at 3:43 PM
With Excel, the program wouldn't let you select a value not in the list. With ClosedXML you're responsible for setting a valid value.