DataBarRule class

Represents a data bar conditional rule with the specified parameters.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule(minType, minValue, maxType, maxValue, color, ranges);

function DataBarRule;

Example

This example creates a data bar rule.

Javascript

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 dataBarRule = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number, -1, GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number, 40, "green", [new GC.Spread.Sheets.Range(0,0,4,1)]);
dataBarRule.color("green");
dataBarRule.showBorder(true);
dataBarRule.borderColor("orange");
dataBarRule.dataBarDirection(GC.Spread.Sheets.ConditionalFormatting.BarDirection.leftToRight);
dataBarRule.negativeFillColor("yellow");
dataBarRule.useNegativeFillColor(true);
dataBarRule.negativeBorderColor("red");
dataBarRule.useNegativeBorderColor(true);
dataBarRule.axisPosition(GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition.automatic);
dataBarRule.axisColor("blue");
dataBarRule.showBarOnly(false);
activeSheet.conditionalFormats.addRule(dataBarRule);

Inheritance Hierarchy

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

Constructors

	Name	Description
	DataBarRule Constructor	Represents a data bar conditional rule with the specified parameters.

Top

Methods

	Name	Description
	axisColor	Gets or sets the axis color of the data bar.
	axisPosition	Gets or sets the axis position of the data bar.
	borderColor	Gets or sets the color of the border.
	color	Gets or sets the postive fill color of the data bar.
	createCondition	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	dataBarDirection	Gets or sets the data bar direction.
	evaluate	Returns the specified value of the rule if the cell meets the condition.
	gradient	Gets or sets a value that indicates whether the data bar is a gradient.
	maxColor	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	maxType	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	maxValue	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	midColor	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	midType	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	midValue	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	minColor	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	minType	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	minValue	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	negativeBorderColor	Gets or sets the color of the negative border.
	negativeFillColor	Gets or sets the color of the negative fill.
	showBarOnly	Gets or sets whether to display the data bar without text.
	showBorder	Gets or sets a value that indicates whether to paint the border.
	stopIfTrue	(Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule)
	useNegativeBorderColor	Gets or sets a value that indicates whether the negative border color is used to paint the border for the negative value.
	useNegativeFillColor	Gets or sets a value that indicates whether the negative fill color is used to paint the negative value.

Top

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace
Using the Data Bar Rule