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

Conditional Formatting problem

2 Answers 36 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Sandra
Top achievements
Rank 1
Sandra asked on 28 Dec 2018, 05:38 PM

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 Answers, 1 is accepted

Sort by
0
Plamen
Telerik team
answered on 01 Jan 2019, 09:34 AM
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.
0
Sandra
Top achievements
Rank 1
answered on 02 Jan 2019, 10:14 AM
Thank you.
Tags
Spreadsheet
Asked by
Sandra
Top achievements
Rank 1
Answers by
Plamen
Telerik team
Sandra
Top achievements
Rank 1
Share this question
or