Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Mar 31, 2020 2:21 am

Hello,

I using Spire.XLS 10.3.8.

Copying a sheet containing a series of formulas and adding row to the copied sheet will throwing in NullReferenceException.
I run the following code using 'src.xltx'.

Code: Select all
using (var workbook = new Workbook())
{
   workbook.LoadTemplateFromFile("src.xltx");
   var sheet = workbook.Worksheets["Sheet1"];
   var copiedSheet = workbook.Worksheets.AddCopy(sheet);
   copiedSheet.InsertRow(1, 1);
}


Is there a solution for this problem?
Thanks in advance.
Attachments
20200331_0.zip
src.xltx
(6.18 KiB) Downloaded 140 times

nf64
 
Posts: 24
Joined: Fri Aug 17, 2018 1:45 am

Tue Mar 31, 2020 3:16 am

Hello,

Thanks for your inquiry.
I have reproduced your issue and logged it in our bug tracking system with the ticket SPIREXLS-2230 for further investigation and fixing. If there is any update, we will inform you.
Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Thu Apr 23, 2020 1:55 am

Hello,

We have confirmed that this issue is fixed in Spire.XLS 10.4.9.
I am always grateful for your help.

Thank you.

nf64
 
Posts: 24
Joined: Fri Aug 17, 2018 1:45 am

Thu Apr 23, 2020 2:01 am

Hello,

Thanks for your feedback.
Feel free to contact us if you encounter any question related to our product in the future.
Wish you all the best!

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Return to Spire.XLS