Approved
Last Updated: 03 Jun 2019 12:18 by ADMIN
Naveen
Created on: 27 May 2019 07:00
Category: Spreadsheet
Type: Feature Request
2
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:
3 comments
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.