Spreadsheet - Missing Charts after save bug?

[Richard]

I'm having an issue where I have some code that opens an existing Excel file, adds some data then saves the file. When this runs all the charts in the original Excel file disappear. 

I have tested it and even if I just open the Excel file and save it without making any changes the charts are gone. 

I can't upload Excel files here but I have attached a screenshot of the before / after.

Example code

var xlsxFormatProvider = new XlsxFormatProvider();

// Import 
using Stream input = new FileStream("c:\\tmp\\Charts.xlsx", FileMode.Open);
var workbook = xlsxFormatProvider.Import(input);


// Export
using Stream output = new FileStream("c:\\tmp\\Charts_Edited.xlsx", FileMode.Create);
xlsxFormatProvider.Export(workbook, output);

 

Thanks,

Richard

[Stoyan]

Hi Richard,

I have tested the reported behavior and have indeed observed that Excel charts aren't imported to the Spreadsheet Component. To determine the cause of this issue I have contacted our Developer Team. 

That being said we need some additional to investigate the behavior. I will contact you as soon as possible to let you know of our findings. 

Thank you for your patience.

Regards,
Stoyan
Progress Telerik

[Richard]

Thanks Stoyan, looking forward to having it working. 

Cheers,

Richard

[Stoyan]

Hello Richard,

Once again thank you for your report.

I have found out that unfortunately importing a chart in the Spreadsheet is not currently support. This is the reason the charts are missing when Imported/Exported to the Component.

That being said I have submitted a request to implement this feature on your behalf. Please review the Feature Request Spreadsheet - Charts aren't imported from Excel files here. We monitor the community interest in the requested features to determine which of them to include in future releases.

In addition as a token of gratitude for your contribution I have updated your Telerik points.

Please don't hesitate to contact us should further questions emerge.