SpreadProcessing: Add support for chart color customization

ADMIN

Peshito

Posted on: 05 Oct 2021 12:57

Hello Robby,

I am writing as a follow-up to let you know that series color is now preserved when exported to XLSX. The fix will be available in our next internal build - LIB 2021.3.1011 (11 Oct 2021).

Regards,
Peshito
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

ADMIN

Peshito

Posted on: 25 Aug 2021 12:06

Hello Robby,

Thank you for reporting this! The chart in RadSpreadsheet does not fully support the features from MS Excel and some scenarios might have unexpected behaviors as the current one. I have forwarded this to our developers and they will look into it and attempt to resolve the issue. I will further let you know when there is additional info on the matter.

As for the labels, it seems that is an issue and I have logged it in our public portal as a bug - The size of the chart's axis labels and title is changed on export. Please subscribe to this item in order to be notified of status changes. I have updated your Telerik points as gratitude to this finding.

Regards,
Peshito
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Robby

Posted on: 24 Aug 2021 14:27

Hi,

Suggested usage:

chartShape.Chart.SeriesGroups.First().Series.First().Fill = new SolidFill(Colors.Aqua);

Is working using the Telerik spreadsheet component. But after saving this file and reopening in MS Excel, no color change is applied. We have tested this with the most simple chart setup:

Reopening of the file in Telerik spreadsheet, is working fine however.

Note also that letter types are changed in the axis and title.

Tested with version: WPF_2021_2_809

Attached Files:

documents.zip

ADMIN

Peshito

Posted on: 19 Aug 2021 15:20

Hi Robby,

Thank you for sharing your sample project and the documents as well. I was able to reproduce the issue and found out what is causing it. Currently, the TickLabelPosition is skipped when a document containing charts is imported. This is quite noticeable when the Value Axis has positive and negative values.

I created a feature request on your behalf where you could vote for it and also track its progress - Keep TickLabelPosition on chart import. Thank you for helping us improve our product. As gratitude, your Telerik points are updated.

Regards,
Peshito
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Robby

Posted on: 18 Aug 2021 08:10

Hi,

I have created an empty application with Telerik v2021.2.217. Open document:.\Resources\Telerik chart test2.xlsx and save this document to another file name. This will already introduce the described issue.

Regards,

Robby

Attached Files:

telerikcharttest.zip

ADMIN

Peshito

Posted on: 17 Aug 2021 12:28

Hi Robby,

I tried reproducing the latest formatting issue from your last reply but to no avail. Could you elaborate on the steps to reproduce? Sharing a sample runnable project reproducing the issue would be helpful.

Regards,
Peshito
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

ADMIN

Peshito

Posted on: 17 Aug 2021 11:52

Hello Robby,

Thank you for sharing this. I will check this behavior and will write you back shortly.

Regards,
Peshito
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Robby

Posted on: 10 Aug 2021 12:00

Hi Peshito,

Thanks for your suggestion. When I apply your code suggestion to an existing Excel book, it seems to work. But when I save the book with the orange serie color, and reopen the book in MS Excel, it seems that chart formatting is partly lost.

Attached Files:

documents.zip

ADMIN

Peshito

Posted on: 12 Jul 2021 08:19

Hello,

As part of expanding the chart's color customization abilities, with R3 2021 Release the series' Fill color can be changed through the API. For example:

chartShape.Chart.SeriesGroups.First().Series.First().Fill = new SolidFill(Colors.Orange);

It is also available with Telerik UI for WPF's latest internal build - LIB 2021.2.712 (12 Jul 2021) if you need it earlier.

Regards,
Peshito
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

ADMIN

Vladislav

Posted on: 10 Sep 2019 08:08

Possible workaround shared by Julian Turner:

"I wanted to share that I was able to change the column fill color through the use of a custom ThemeColorScheme for the document with custom accent colors. I would still prefer to have full control within the chart object so each chart can be customized independently, but this solved my problem of not wanting to display precipitation data in red. I thought I would pass it on as a work around in case someone else has the same issue I had."

Regards,
Vladislav
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.