Approved
Last Updated: 04 Dec 2019 09:02 by ADMIN
Naveen
Created on: 27 May 2019 07:00
Category: Spreadsheet
Type: Feature Request
4
Conditional Formatting in Spreadhseet

Dear Concerned,

I have observed that Conditional Formatting in Spreadhseet is not supported. Please add support for the same as it is very important feature of XLSX.  during financial calculation this feature plays an important role. Here is the issue that needs a fix.

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Check attached file CellColorFormula.xlsx, conditional formatting set for B2, C2, D2

3. Import attached file CellColorFormula.xlsx

4. Check Cells B2, C2, D2 and try to change values for A2, C2, D2

5. None of the conditional formatting is working

 

Attached Files:
5 comments
ADMIN
Veselin Tsvetanov
Posted on: 04 Dec 2019 09:02

Hi Naveen,

The request in question is yet not scheduled for implementation. Whether and when it will be included in our implementation queue depends mainly on the interest among the community for that specific feature. It also depends on the other tasks, that we have in our backlog and their priority. We will keep tracking the interest for the above and will plan its potential implementation accordingly.

Regards,
Veselin Tsvetanov
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.
Naveen
Posted on: 03 Dec 2019 14:09

Dear Concerned,

Please plan this feature in next release as it is very important feature in context of spreading and excel file support. Waiting since last 6 months but still in approved state.

ADMIN
Veselin Tsvetanov
Posted on: 03 Jun 2019 12:18
Hello Naveen,

Please, excuse me for missing that info from my last post. Here is the relevant documentation article: https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/format

Regards,
Veselin Tsvetanov
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.
Naveen
Posted on: 03 Jun 2019 10:03

You have mentioned that - Here you could find some more info on that....

Please share where we can find information for the same?

ADMIN
Veselin Tsvetanov
Posted on: 03 Jun 2019 08:21
Hello Naveen,

Thank you for your request. The Spreadsheet widget support conditional coloring of numbers according to their values. Here you could find some more info on that. If, however, does not support the Excel-like exponential formatting used in the xlsx file sent. That Is why I have changed the status of the current request to Approved. I would recommend you to also cast your vote for it.

Regards,
Veselin Tsvetanov
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.