Conditional Formatting problem

3 posts, 0 answers
  1. Sandra
    Sandra avatar
    2 posts
    Member since:
    Dec 2018

    Posted 28 Dec 2018 Link to this post

    Hello. I'm been dealing with a problem when using conditional formatting. I've created a dojo to explain my problem.

    https://dojo.telerik.com/UNoCUfiL/2

     

    TL;DR of my problem: I have to use this format: "[<-10][RED]##,##0.00\%;[>10][RED]##,##0.00\%;##,##0.00\%". Everytime my cell value is < 10 ([<-10][RED]) or > 10 ([>10][RED]), it loses the negative sign. I can't write any rule based on the value 10, because it will change programmatically.. I'm just giving an example with the value 10.

     

     

    Thank you!

  2. Plamen
    Admin
    Plamen avatar
    3057 posts

    Posted 01 Jan 2019 Link to this post

    Hi,

    It seems like a bug in the Spreadsheet - I have logged it here and you can follow its status there. Please excuse us for the inconvenience caused by the issue. 

    Regards,
    Plamen
    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.
  3. Sandra
    Sandra avatar
    2 posts
    Member since:
    Dec 2018

    Posted 02 Jan 2019 in reply to Plamen Link to this post

    Thank you.
Back to Top