Hi! I'm trying to use the AddCopy method to copy a sheet in mt designer template, but I get a Object reference not set to an instance of an object Error. The sheet ha some validation lists and merged cells, but other than that nothing special. If i try to copy a simpler sheet it works fine.
I have the latest version of the component.
The stacktrace is:
[NullReferenceException: Object reference not set to an instance of an object.] Aspose.Excel.Worksheet.a(Worksheet A_0) Aspose.Excel.Worksheets.AddCopy(Int32 sheetIndex) BL.ExcelUtility.CreateSheet() in C:\Projects\Customer\FMEA\1.0\BL\BL\ExcelUtility.vb:35 PL.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\FMEA\1.0\PL\WebForm1.aspx.vb:25 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain()
Could you send your designer file to me by email? I will find what caused your problem of AddCopy method. About the formula problem, I will check it right now and report back later.