SpreadJS Documentation
color Method
The fill color.
Gets or sets the postive fill color of the data bar.
Syntax
var instance = new GcSpread.Sheets.DataBarRule(minType, minValue, maxType, maxValue, color);
var returnValue; // Type: string
returnValue = instance.color(value);
function color( 
   value : string
) : string;

Parameters

value
The fill color.

Return Value

The postive fill color of the data bar.
Example
This example uses the color method.
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);

var cfs = activeSheet.getConditionalFormats();
var dataBarRule = new GcSpread.Sheets.DataBarRule();
dataBarRule.ranges=[new GcSpread.Sheets.Range(0,0,4,1)];
dataBarRule.minimumType(GcSpread.Sheets.ScaleValueType.Number);
dataBarRule.minimumValue(-1);
dataBarRule.maximumType(GcSpread.Sheets.ScaleValueType.Number);
dataBarRule.maximumValue(40);
dataBarRule.color("green");
dataBarRule.showBorder(true);
dataBarRule.borderColor("orange");
dataBarRule.dataBarDirection(GcSpread.Sheets.BarDirection.LeftToRight);
dataBarRule.negativeFillColor("yellow");
dataBarRule.useNegativeFillColor(true);
dataBarRule.negativeBorderColor("red");
dataBarRule.useNegativeBorderColor(true);
dataBarRule.axisPosition(GcSpread.Sheets.DataBarAxisPosition.Automatic);
dataBarRule.axisColor("blue");
dataBarRule.showBarOnly(false);
cfs.addRule(dataBarRule);
Remarks
The default value is rgba(255, 99, 142, 198).
See Also

Reference

DataBarRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.