Conditional Formatting

6 posts, 0 answers
  1. Andy
    Andy avatar
    1 posts
    Member since:
    Dec 2011

    Posted 03 Aug 2013 Link to this post

    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



  2. Boryana
    Admin
    Boryana avatar
    330 posts

    Posted 07 Aug 2013 Link to this post

    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 >>
  3. UI for WPF is Visual Studio 2017 Ready
  4. Joel Palmer
    Joel Palmer avatar
    164 posts
    Member since:
    May 2009

    Posted 30 Jan 2015 in reply to Boryana Link to this post

    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?
  5. Tanya
    Admin
    Tanya avatar
    405 posts

    Posted 02 Feb 2015 Link to this post

    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.

     
  6. Joel Palmer
    Joel Palmer avatar
    164 posts
    Member since:
    May 2009

    Posted 02 Feb 2015 in reply to Tanya Link to this post

    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.
  7. Tanya
    Admin
    Tanya avatar
    405 posts

    Posted 03 Feb 2015 Link to this post

    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.

     
Back to Top
UI for WPF is Visual Studio 2017 Ready