public virtual void ExcelService_AddValidations_LotsOfItems()
{
var oldNames = new[]
{
new NamedRange
{
Name = "testName3",
Range = new Range(0, 99, 0, 0, "testName4")
}
};
var oldValidations = new[]
{
new DataValidation
{
Name = "testName3",
Type = DataValidationType.Formula,
Range = new Range()
}
};
ExcelService.AddNames(MemoryToDiskObject, _version, oldNames);
ExcelService.AddValidations(MemoryToDiskObject, "testSheet5", _version, oldValidations);
ExcelService.SaveWorkbook(MemoryToDiskObject, _newFileName);
var newWorkbook = ExcelService.ReadWorkbook(_newFileName);
var newNames = newWorkbook.Names;
var newValidations = newWorkbook.Worksheets.First().Validations;
AssertHelper.AreDeeplyEqual(oldNames, newNames);
AssertHelper.AreDeeplyEqual(oldValidations, newValidations);
}
