Spread.Sheets Documentation
ScaleRule class
GC.Spread.Sheets.ConditionalFormatting Namespace : ScaleRule class
Represents a scale conditional rule.
Syntax
var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();
function ScaleRule;
Example
This example creates a rule.
activeSheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]);
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,45,3);
activeSheet.setValue(2,0,75,3);
Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.ScaleRule
      GC.Spread.Sheets.ConditionalFormatting.DataBarRule
      GC.Spread.Sheets.ConditionalFormatting.IconSetRule

Constructors
 NameDescription
public ConstructorRepresents a scale conditional rule.  
Top
Methods
 NameDescription
public MethodCreates a condition for the rule.  
public MethodReturns a specified value of the rule if the cell satisfies the condition.  
public MethodGets or sets the maximum color scale.  
public MethodGets or sets the maximum scale type.  
public MethodGets or sets the maximum scale value.  
public MethodGets or sets the midpoint scale color.  
public MethodGets or sets the midpoint scale type.  
public MethodGets or sets the midpoint scale value.  
public MethodGets or sets the minimum scale color.  
public MethodGets or sets the type of minimum scale.  
public MethodGets or sets the minimum scale value.  
public MethodGets whether evaluation should stop if the condition evaluates to true.  
Top
See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace
Using the Scale Rule