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.

Thu Oct 27, 2022 3:09 pm

Hello

when I insert x rows with FormatDefaults it does not insert any

Code: Select all
sheet.InsertRow(1, 5, InsertOptionsType.FormatDefault);


but if I use either FormatAsAfter or FormatAsBefore it does add the x rows. Problem here is that I want to maintain the format of the row I want to insert

xel_wise
 
Posts: 13
Joined: Thu Sep 15, 2022 8:33 am

Fri Oct 28, 2022 9:17 am

Hello,

Thanks for your inquiry.
I simulated a file and tested your case using the latest version of the Spire.XLS Pack Version:12.10. But I didn't reproduce your question. If you are using an older version, I suggest you use this version to test again. If your problem persists after the test, to help us further investigate it, please provide us with your test documentation. You can attache it here or send it to us via email (support@e-iceblue.com). Thank you in advance.

Sincerely,
Simple
E-iceblue support team
User avatar

Simple.Li
 
Posts: 248
Joined: Fri Jul 01, 2022 2:33 am

Wed Nov 02, 2022 7:36 am

Hello,

Could you please let us know how is your issue going? Thanks in advance for your feedback and time.

Sincerely,
Simple
E-iceblue support team
User avatar

Simple.Li
 
Posts: 248
Joined: Fri Jul 01, 2022 2:33 am

Return to Spire.XLS

cron