This is a migrated thread and some comments may be shown as answers.

Conditional Formatting

5 Answers 129 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Andy
Top achievements
Rank 1
Andy asked on 03 Aug 2013, 09:34 AM
Hi,

i am currently evaluating some of the Telerik-Controls. So i created a sample project.
Now i have one question related to the Spreadsheet Control:

There was functionality included in the roadmap:
Conditional Formatting
Applying different visual settings to cells based on the data they contain allows you to identify variances in a range of values with a quick glance. The feature is very useful for comparing values, selecting rows dynamically and spotting duplicates easily.

Is Conditional Formatting included in the current WPF-Spreadsheet? I also tried out the demos but i was not able to find the fomatting.

I also wrote an email to the Trial-Support, but i do not receive an response :(.

Thank you very much!
Andy



5 Answers, 1 is accepted

Sort by
0
Boryana
Telerik team
answered on 07 Aug 2013, 10:58 AM
Hi Andy,

Thank you for writing.

Unfortunately, the Conditional Formatting feature was rescheduled and it will not be implemented for Q3 2013. We will do our best to implement it in a future release. 


Regards,
Boryana
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
0
Joel Palmer
Top achievements
Rank 2
answered on 30 Jan 2015, 08:01 PM
Can I get an update on this?  Is Conditional Formatting in the current (2014 Q4) build?

Also, my project requires "validation"... which, in Excel basically gives you a drop down list.  Is the ability to provide a drop down list for a cell an option?
0
Tanya
Telerik team
answered on 02 Feb 2015, 05:32 PM
Hi Joel,

Conditional Formatting is not implemented nor scheduled yet. We have a public item for it in our feedback portal, where you can vote and subscribe in order to receive updates on the matter.

The validation feature is coming with our next official release - Q1 2015, which will be available at the end of this month. By subscribing the Data Validation public item, you will be immediately notified when the feature is released. 

Let me know if I can assist you with anything else.

Regards,
Tanya
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Joel Palmer
Top achievements
Rank 2
answered on 02 Feb 2015, 05:41 PM
One last feature question... do you have Protection?  This is my use case:

I have a context/hierarchy that tracks a lot of items.  Some of those items, when selected, need to load a spreadsheet and allow the user to enter data.  Conditional Formatting is needed because, depending on how a user answers a question, some fields will no longer be relevant.  Formatting can be used to "grey them out".  The spreadsheet should only allow specific values in some fields.  This is where the Validation and Protection comes in.  The user should not be able to enter invalid values or enter data into cells that aren't defined.
0
Tanya
Telerik team
answered on 03 Feb 2015, 05:39 PM
Hi Joel,

RadSpreadsheet allows protecting the Workbook as well as the Worksheets in it. You can find information about how to use this feature in the Workbook protection and Worksheet Protection articles in our documentation. 

If you have further questions, I'll be glad to assist you.

Regards,
Tanya
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
Spreadsheet
Asked by
Andy
Top achievements
Rank 1
Answers by
Boryana
Telerik team
Joel Palmer
Top achievements
Rank 2
Tanya
Telerik team
Share this question
or