description
Cell's data validation doesn't correspond:
var wb = new XLWorkbook();
var ws = wb.Worksheets.Add("People");
ws.FirstCell().SetValue("Categories")
.CellBelow().SetValue("A")
.CellBelow().SetValue("B")
.CellBelow().SetValue("")
.CellBelow().SetValue("D");
var table = ws.RangeUsed().CreateTable();
var dv = table.DataRange.DataValidation;
dv.TextLength.GreaterThan(0);
dv.ErrorTitle = "Error";
foreach (var c in table.DataRange.Cells(c => c.HasDataValidation))
{
Console.WriteLine(String.Format("Cell({0}) = '{1}' ErrorTitle: {2}",
c.Address.ToStringRelative(),
c.GetString(),
c.DataValidation.ErrorTitle));
}
Console.ReadKey();