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 Dec 27, 2016 7:04 am

Here's my code. The InsertRow function with InsertOptionsType parameter cause a format error. The picture shows three files, the original one, the file edited by "InsertRow(6, 1);" , the file exported from code below. Could someone please tell me how to fix this? Thanks.

Code: Select all
            Workbook book = new Workbook();
            book.LoadFromFile(@"C:\Users\Nie\Desktop\工作簿1.xlsx");
            //book.Worksheets[0].InsertRow(6, 1);
            book.Worksheets[0].InsertRow(6, 1, InsertOptionsType.FormatAsBefore);
            book.SaveToFile(@"C:\Users\Nie\Desktop\工作簿3.xlsx");


[img]
捕获.PNG
捕获.PNG (49.03 KiB) Viewed 1589 times

[/img]

okiwill
 
Posts: 2
Joined: Mon May 30, 2016 2:37 am

Tue Dec 27, 2016 9:02 am

Dear okiwill,

Thank you for contacting us.
I have reproduced the issue and transfered it to our dev team. You will be informed when it is resolved.
Sorry for the inconvenience caused.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Tue Jan 24, 2017 6:10 am

Hi okiwill,

Thanks for your patient waiting.
The InsertOptionsType parameter issue has been fixed in the Spire.XLS Pack Hotfix Version:7.11.49, please download and test it to get the effect you want.
Do not hesitate to contact us in case of any confusion.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Wed Jan 25, 2017 7:41 am

Hello,

Sorry to bother you.
How is your issue now? Did you tried the newest version? We will appreciate you giving us some feedback at you convenience.
Looking forward to your reply.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Thu May 04, 2017 3:53 pm

Hi Nina.Tang,

Sorry for my late reply. I wrote some code just a moment ago, tested the newest version. Yes, it has been fixed. :lol: :lol:

Thank you for your help!

okiwill
 
Posts: 2
Joined: Mon May 30, 2016 2:37 am

Return to Spire.XLS