Could you please share your template Excel file and sample code (runnable)/standalone VS.NET console application to reproduce the issue on our end. We will check it soon. We also recommend to give it a try to our latest version Aspose.Cells for .NET 22.1 if it makes any difference.
PS. please zip the Excel file and exclude Aspose.Cells.Dll from the zipped application archive prior attaching here.
After an initial test, I am able to reproduce the issue as you mentioned by using template file. I found Cells.RemoveDuplicates throws “System.IndexOutOfRangeException: Index was outside the bounds of the array”. I am using latest version of Aspose.Cells for .NET and still the issue is produced. I have logged a ticket with an id “CELLSNET-50286” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
This is to inform you that we have fixed your issue now. Your fix will be included in our upcoming official release: Aspose.Cells for .NET v22.2. The next release is due in the second week of February, 2022.
The issues you have found earlier (filed as CELLSNET-50286) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi