Corrupted Copied Sheets

[A-Shawqi]

Hello,
I'm using the following function to copy a sheet multiple times but the copied sheets are corrupted while using the attached excel file and it throws the following exception in other cases as shown in the below image.

OfficeOpenXml.ExcelWorksheets public ExcelWorksheet Copy(string Name, string NewName)
TestCopySheet.zip

[JanKallman]

Please provide some code to reproduce this issue.

[A-Shawqi]

Herein a simple test method that throws the null exception

[TestMethod()]
       public void CopySheetNullExceptionTest()
       {
           ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
           using var excelPackage = new ExcelPackage(new FileInfo("TestCopySheet.xlsm"));
           excelPackage.Workbook.Worksheets.Copy(excelPackage.Workbook.Worksheets.First().Name, "copied sheet");
           excelPackage.SaveAs(new FileInfo("OutputFile.xlsm"));
       }

[JanKallman]

It seems to work when I try it. Which version are you using? Which Environment (Windows, Linux), Regional settings (CultureInfo)?

[JanKallman]

The above commit references #675, not this issue

[A-Shawqi]

I noticed that I wasn't using the latest version and the issue is fixed after using it.
Thanks.