/// <summary>
/// 添加范围小数的数据验证
/// </summary>
/// <param name="collection"></param>
/// <param name="address"></param>
/// <param name="minValue"></param>
/// <param name="maxValue"></param>
/// <param name="errorStyle"></param>
/// <param name="allowBlank"></param>
/// <param name="showErrorMessage"></param>
/// <param name="error"></param>
/// <returns></returns>
public static IExcelDataValidationDecimal AddDoubleRangeValidation(this ExcelDataValidationCollection collection,
String address, Double minValue, Double maxValue,
ExcelDataValidationWarningStyle errorStyle = ExcelDataValidationWarningStyle.stop,
Boolean allowBlank = true, Boolean showErrorMessage = true,
String error = null)
{
IExcelDataValidationDecimal excelDataValidation = collection.AddDecimalValidation(address);
excelDataValidation.Operator = ExcelDataValidationOperator.between;
excelDataValidation.Formula.Value = minValue;
excelDataValidation.Formula2.Value = maxValue;
excelDataValidation.AllowBlank = allowBlank;
excelDataValidation.ShowErrorMessage = showErrorMessage;
excelDataValidation.Error = error ?? String.Format("数值范围[{0},{1}]", excelDataValidation.Formula.Value, excelDataValidation.Formula2.Value);
return(excelDataValidation);
}
public void Setup()
{
SetupTestData();
_validation = _package.Workbook.Worksheets[1].DataValidations.AddDecimalValidation("A1");
}
public void Cleanup()
{
CleanupTestData();
_validation = null;
}
public void Cleanup()
{
CleanupTestData();
_validation = null;
}
public void Setup()
{
SetupTestData();
_validation = _package.Workbook.Worksheets[1].DataValidations.AddDecimalValidation("A1");
}
