Syncfusion upgrade V6 -> V13 Insert Row Issue

[Paul]

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?

[Ishwarya Narayanan]

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.

 

Regards,

Ishwarya N 

[Paul]

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

[Abirami Varadharajan]

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. 

 

Download link: http://www.syncfusion.com/forums/123633/essential-studio-2016-volume-1-release-v14-1-0-41-is-available-for-download  

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami 

[Paul]

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

Many thanks

[Ishwarya Narayanan]

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.

 

Regards,

Ishwarya N

 

[Phil Comelio]

Hi,

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.

Thanks,

Phil

[Ishwarya Narayanan]

Hi Phil,

 

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

 

Regards,

Ishwarya N