Imported charts not able to be customized properly

Question

Good day,In working with the spreadsheet control I have found that charts that are imported from excel do not operate like a chart that is added at runtime. For example, I have added functions to change the colors of each series, as well as grid lines, label properties, etc. For newly created charts these functions work great. However, charts that are imported do not work the same way. I have found that one or more series will not change color with my color changing function. The legend entry for the series will change and reflect the newly selected color but the column, bar, etc. does not change.Is this a known issue? Is it possible that some excel chart types are just not fully supported?

Kanimozhi Bharathi · Answer

Hi Travis, 
 
After applying the formats such as changing the color of the series, label properties, fill type etc. to the charts, you need to invalidate/refresh the charts like the below code example 
 




spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicObjects(); spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicVisual(); 
 
 
 
Please refer the below UG link for more reference, 
 
https://help.syncfusion.com/windowsforms/spreadsheet/shapes#accessing-the-selected-shapes 
 
Regards 
Kanimozhi B

Travis Chambers · Answer

Thank you for your response. Unfortunately, that is not my issue as I am already invalidating everything. As I mentioned, my code to change the series colors works great for any chart I create at runtime. The issue is with charts imported from excel (such as a combo chart with one series being clustered column and the other being line with markers). I can change the column series to line and back to column, and when I do that I can then change the color of the column on the chart, but still not the line chart. Before I update the range, neither series colors can be changed, but the square next to the series names in the legend does change color like it is supposed to, it just doesn't change the color of the actual series on the chart.

Thirumurugan Loganathan · Answer

Hi Travis,   
   
We have checked the issue “Customized style not applied properly for the imported chart from the excel” and we required your sample excel sheet to validate and give you the optimal solution. Please let us know if you have any other concern.   
   
Regards,   
Thirumurugan

Travis Chambers · Answer

I have attached the sample document. Thank you!Attachment: Sample_ec62680d.zip

Thirumurugan Loganathan · Answer

Hi Travis, 
  
We were able to reproduce the reported issue and validating on it. A support incident has been created under your account to track the status of this issue. Please log on to our support website to check for further updates.     
https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents   
 
Regards, 
Thirumurugan