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. Image for the cookie policy date

Syncfusion upgrade V6 -> V13 Insert Row Issue

Hi guys

I have a legacy application which uses syncfusion XlsIO for building excel reports. We have recently decided to upgrade from V6 to V13 so that we can save in excel 2007 format.

The application gets data, opens a template, inserts rows to make space for the data, and then places the data into the template.

On some templates, we have formulas that refer to the pre-set grand totals in a different worksheet. Using V6, when rows were inserted into the worksheet that has the grand totals, the formulas that referred to them updated themselves fine. However, since we upgraded, the formulas in other worksheets no longer update accordingly to the rows inserted on the referenced sheet?

Is there a setting to correct this? Is there an extra step we should be taking?

7 Replies

IN Ishwarya Narayanan Syncfusion Team May 5, 2016 11:47 AM UTC

Hi Paul,


We regret for the inconvenience.


The reported issue has been fixed recently. The fix for this issue will be included in our upcoming Main release 14.2 (Volume 2 ) which is expected to be rolled out by mid of June 2016.



Ishwarya N 

PA Paul May 5, 2016 03:50 PM UTC

Thanks for your reply Ishwarya

OK, no problem. That should be OK. We will have to delay the release of this feature till we get the update.

I do have another issue, that hopefully will also be getting fixed in your next release? We have these templates, and some have images in them. Logos etc. Now, when we pick up these templates, put our data into them and re-save them, we cannot open the report without getting a message saying that there is unreadable content, would we like to fix it automatically. Click yes, and it opens up fine, but reports that it was to do with the images.

Remove the images from the template and it all works fine.

I believe this is to do with how when the workbook is saved, additional information ends up in the source xml of the file where the images are described which is what messes it up. We found that by changing the xlsx file to a zip file, extracted the zip file and inspected the internal files, located these settings of large numbers (something like 65536) and changed them to something sensible, re-packed it as a zip, then turned it back into an xlsx file, and it opened with no warnings...

Is this something that may be on the cards? Or is hopefully in a later release than 13 which we are currently using?

Many thanks

AV Abirami Varadharajan Syncfusion Team May 6, 2016 12:20 PM UTC

Hi Paul, 
Thank you for updating us. 
Yes, we are able to reproduce the reported issue in Syncfusion assembly 13v. This issue has been fixed and included in our latest assembly 14.1v which was rolled out on April 2016 and it can be downloaded from the following link. 
Please let us know if you have any concerns. 

PA Paul May 8, 2016 10:41 PM UTC

Fantastic news. So the release of 14.2 in mid June should solve all my problems. 

Many thanks

IN Ishwarya Narayanan Syncfusion Team May 9, 2016 05:11 AM UTC

Hi Paul,


Thank you for your update.


Yes, in our upcoming main release 14.2v all your reported issues will be resolved which is expected to be rolled out by mid of June 2016.



Ishwarya N


PC Phil Comelio May 23, 2016 02:20 PM UTC


Do you now have the date  when 14.2v will ship? We are currently completing our internal release planning and need to understand the dependency.



IN Ishwarya Narayanan Syncfusion Team May 24, 2016 04:32 AM UTC

Hi Phil,


The upcoming main release 14.2 is tentatively expected to be rolled out by 17th June 2016.



Ishwarya N

Live Chat Icon For mobile
Up arrow icon