I need something like the native Excel insert cells using a named range.

[Karl Hauschildt]

We have a template and at some predefined location there is 3 row table consisting of a header, blank data row and a total row with formula formatted wit boarders all around. The template may have other tables to the left, right or below the preceding table.

Using the XLSIO ImportDataTable directly into the target table using a named range fills the table but it overwrites all the cell data including the formatting and formula. It also overwrites an table that might be directly below it.

I added a call to InsertRow with FormatAsBefore to make room and then call the ImportDataTable and the formatting is preserved as is the formula and tables below also push down. However, any tables on either side are damaged.

I am unable to locate an InsertRow that respects a named range so what would be the best way to accomplish this behavior.

[Ishwarya Narayanan]

Hi Karl,

 

Thank you for using Syncfusion products.

 

We are unable to reproduce the issue at our end. So we have provided the simplified sample for importing data with named range using XlsIO in the following link. Kindly refer to this and share us the screenshot for the scenario you are expecting or modify the provided sample for your requirement if possible, to assist you with a prompt solution.

 

Please let us know if you need any clarification.

 

Sample Link:

http://www.syncfusion.com/downloads/support/directtrac/general/Forum118386InsertRowwithNamedRange-2127688076.zip

 

Regards,

Ishwarya N

[Rilfanayasmin Jamal Nasar]

From: Karl Hauschildt [mailto:[e-mail]]
Sent: Friday, March 06, 2015 6:30 AM
To: Syncfusion Support; [e-mail]
Subject: RE: Syncfusion support community forum 118386, I need something like the native Excel insert cells using a named range., has been updated.

Your solution uses ImportDataTable and it’s behavior will be to overwrite any cells in the range and that is the behavior I have to prevent. It needs to insert new cells within the range and push down.

The InsertRows method does the push down and preserves any formula but there is not concept of a range.

[Ishwarya Narayanan]

Hi Karl,

 

We were able to reproduce the problem and have logged defect report regarding this. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates

 

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

 

Please let me know if you have any questions.

 

Regards,

Ishwarya N