/// <summary>
/// Returns a validation type by <see cref="eDataValidationType"/>
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
internal static ExcelDataValidationType GetByValidationType(eDataValidationType type)
{
switch (type)
{
case eDataValidationType.Any:
return(ExcelDataValidationType.Any);
case eDataValidationType.Whole:
return(ExcelDataValidationType.Whole);
case eDataValidationType.List:
return(ExcelDataValidationType.List);
case eDataValidationType.Decimal:
return(ExcelDataValidationType.Decimal);
case eDataValidationType.TextLength:
return(ExcelDataValidationType.TextLength);
case eDataValidationType.DateTime:
return(ExcelDataValidationType.DateTime);
case eDataValidationType.Time:
return(ExcelDataValidationType.Time);
case eDataValidationType.Custom:
return(ExcelDataValidationType.Custom);
default:
throw new InvalidOperationException("Non supported Validationtype : " + type.ToString());
}
}
private ExcelDataValidationType(eDataValidationType validationType, bool allowOperator, string schemaName)
{
Type = validationType;
AllowOperator = allowOperator;
SchemaName = schemaName;
}
private ExcelDataValidationType(eDataValidationType validationType, bool allowOperator, string schemaName)
{
Type = validationType;
AllowOperator = allowOperator;
SchemaName = schemaName;
}
/// <summary>
/// Returns a validation type by <see cref="eDataValidationType"/>
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
internal static ExcelDataValidationType GetByValidationType(eDataValidationType type)
{
switch (type)
{
case eDataValidationType.Whole:
return ExcelDataValidationType.Whole;
case eDataValidationType.List:
return ExcelDataValidationType.List;
case eDataValidationType.Decimal:
return ExcelDataValidationType.Decimal;
case eDataValidationType.TextLength:
return ExcelDataValidationType.TextLength;
case eDataValidationType.DateTime:
return ExcelDataValidationType.DateTime;
case eDataValidationType.Time:
return ExcelDataValidationType.Time;
case eDataValidationType.Custom:
return ExcelDataValidationType.Custom;
default:
throw new InvalidOperationException("Non supported Validationtype : " + type.ToString());
}
}
// XlsxDataValidation.ValidationType.None has no corresponding representation in EPPlus
public static void ValidationType(XlsxDataValidation.ValidationType validationType, eDataValidationType expected)
{
using (var stream = new MemoryStream())
{
using (var xlsxWriter = new XlsxWriter(stream))
xlsxWriter.BeginWorksheet("Sheet 1").BeginRow().AddDataValidation(new XlsxDataValidation(validationType: validationType));
using (var package = new ExcelPackage(stream))
package.Workbook.Worksheets[0].DataValidations[0].ValidationType.Type.Should().Be(expected);
}
}
