SpreadJS Documentation
ThreeScaleRule class
Represents a three-color scale conditional rule with the specified parameters.
Syntax
var instance = new GcSpread.Sheets.ThreeScaleRule(minType,
                                                 minValue,
                                                 minColor,
                                                 midType,
                                                 midValue,
                                                 midColor,
                                                 maxType,
                                                 maxValue,
                                                 maxColor);
function ThreeScaleRule;
Inheritance Hierarchy

Object
   GcSpread.Sheets.ScaleRule
      GcSpread.Sheets.ThreeScaleRule

Constructors
 NameDescription
public ConstructorThreeScaleRule ConstructorRepresents a three-color scale conditional rule with the specified parameters.  
Top
Fields
 NameDescription
public Fieldranges (Inherited from GcSpread.Sheets.ConditionRuleBase)
public Fieldstyle (Inherited from GcSpread.Sheets.ConditionRuleBase)
Top
Methods
 NameDescription
public Methodcontains (Inherited from GcSpread.Sheets.ConditionRuleBase)
public MethodevaluateReturns the specified value of the rule if the cell meets the condition.  
public MethodgetExpected (Inherited from GcSpread.Sheets.ConditionRuleBase)
public MethodgetMaximumColorGets the maximum scale color.  
public MethodgetMaximumTypeGets the maximum scale type.  
public MethodgetMaximumValueGets the maximum scale value.  
public MethodgetMidpointColorGets the midpoint scale color.  
public MethodgetMidpointTypeGets the midpoint scale type.  
public MethodgetMidpointValueGets the midpoint scale value.  
public MethodgetMinimumColorGets the minimum scale color.  
public MethodgetMinimumTypeGets the minimum scale type.  
public MethodgetMinimumValueGets the minimum scale value.  
public Methodintersects (Inherited from GcSpread.Sheets.ConditionRuleBase)
public Methodpriority (Inherited from GcSpread.Sheets.ConditionRuleBase)
public MethodresetResets the rule.  
public MethodsetMaximumColorSets the maximum scale color.  
public MethodsetMaximumTypeSets the maximum scale type.  
public MethodsetMaximumValueSets the maximum scale value.  
public MethodsetMidpointColorSets the midpoint scale color.  
public MethodsetMidpointTypeSets the midpoint scale type.  
public MethodsetMidpointValueSets the midpoint scale value.  
public MethodsetMinimumColorSets the minimum scale color.  
public MethodsetMinimumTypeSets the minimum scale type.  
public MethodsetMinimumValueSets the minimum scale value.  
public MethodstopIfTrue (Inherited from GcSpread.Sheets.ScaleRule)
Top
See Also

Reference

GcSpread.Sheets Namespace
Using the Scale Rule

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.