SpreadJS Documentation
setMidpointColor Method
The midpoint scale color.
Sets the midpoint scale color.
Syntax
var instance = new GcSpread.Sheets.ThreeScaleRule(minType,
                                                 minValue,
                                                 minColor,
                                                 midType,
                                                 midValue,
                                                 midColor,
                                                 maxType,
                                                 maxValue,
                                                 maxColor);
var value; // Type: any
value = instance.setMidpointColor(color);
function setMidpointColor( 
   color : string
) : any;

Parameters

color
The midpoint scale color.
Example
This example uses the setMidpointColor method.
var scale = new GcSpread.Sheets.ThreeScaleRule();
scale.setMidpointColor("red");
scale.setMidpointType(0);
scale.setMidpointValue(50);
scale.setMaximumColor("blue");
scale.setMaximumType(2);
scale.setMaximumValue(100);
scale.setMinimumColor("yellow");
scale.setMinimumType(1);
scale.setMinimumValue(10);
scale.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 3)];
activeSheet.getConditionalFormats().addRule(scale);
activeSheet.setValue(0,0, 1,3);
activeSheet.setValue(1,0, 50,3);
activeSheet.setValue(2,0, 100,3);
See Also

Reference

ThreeScaleRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.