blob: 499b27ba9c1b8fd49b7cbba0597860125d64e465 [file] [log] [blame]
using Microsoft.VisualStudio.TestTools.UnitTesting;
using OfficeOpenXml;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
namespace EPPlusTest
{
[TestClass]
public class DTS_FailingTests
{
[TestMethod]
public void DeleteWorksheetWithReferencedImage()
{
var ms = new MemoryStream();
using (var pck = new ExcelPackage())
{
var ws = pck.Workbook.Worksheets.Add("original");
ws.Drawings.AddPicture("Pic1", Properties.Resources.Test1);
pck.Workbook.Worksheets.Copy("original", "copy");
pck.SaveAs(ms);
}
ms.Position = 0;
using (var pck = new ExcelPackage(ms))
{
var ws = pck.Workbook.Worksheets["original"];
pck.Workbook.Worksheets.Delete(ws);
pck.Save();
}
}
[TestMethod]
public void CopyAndDeleteWorksheetWithImage()
{
using (var pck = new ExcelPackage(new MemoryStream()))
{
var ws = pck.Workbook.Worksheets.Add("original");
ws.Drawings.AddPicture("Pic1", Properties.Resources.Test1);
pck.Workbook.Worksheets.Copy("original", "copy");
pck.Workbook.Worksheets.Delete(ws);
pck.Save();
}
}
}
}