We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

118386 Mar 4,2015 09:28 AM Mar 9,2015 03:27 AM ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Karl Hauschildt
Asked On March 4, 2015 09:28 AM

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 [Syncfusion]
Replied On March 5, 2015 05:00 AM

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 [Syncfusion]
Replied On March 6, 2015 07:16 AM

From: Karl Hauschildt [mailto:karl.hauschildt@gmail.com]
Sent: Friday, March 06, 2015 6:30 AM
To: Syncfusion Support; Karl@TheSoftwareCafe.com
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 [Syncfusion]
Replied On March 9, 2015 03:27 AM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;