Percent Support in Top10Rule class for Conditional Formatting

Percent Support in Top10Rule class for Conditional Formatting

Posted by: hghanta on 24 December 2017, 8:27 pm EST

• 

  hghanta

  • Post Options:
  • Link
    Copy

  Posted 24 December 2017, 8:27 pm EST

  Does Spread.Sheets support Percentage in Top10Rule Class for ConditionalFormatting ?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 26 December 2017, 1:54 am EST

  Hello,

  Top10Rule accepts a range and of that range contains percent value it should work for you.
  
  With DataBarRule has minType/maxType method that can be set to Number, LowestValue, HighestValue, Percent, Formula, Percentile, and Automin, or Automax.

  Thanks,
  
  Deepak Sharma

• 

  hghanta

  • Post Options:
  • Link
    Copy

  Posted 2 January 2018, 2:01 pm EST

  Are you saying we should have cells formatted as percent to use Top10Rule with Percentage ?

  i went through the below documentation link and i don’t find how to use top10rule along with percentage.
  
  http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#JavascriptLibrary~GcSpread.Sheets.Top10ConditionType.html

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 3 January 2018, 1:07 am EST

  Hello,

  This option is not there currently. It has option for above or below average for selected range but not the percent.

  Thanks,
  
  Deepak Sharma

• 

  hghanta

  • Post Options:
  • Link
    Copy

  Posted 4 January 2018, 5:27 pm EST

  Can you please bring up this issue with your product management & ensure it gets prioritized ?

  Thanks,
  
  Sri Harsha

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 January 2018, 2:23 am EST

  Hello,

  I have submitted it as an enhancement request for Spread.Sheets. I will let you know once I get an update on this.
  
  The enhancement id for this issue is 252573.

  Thanks,
  
  Deepak Sharma