SpreadJS Documentation
DataBarAxisPosition Enumeration
GC.Spread.Sheets.ConditionalFormatting Namespace : DataBarAxisPosition Enumeration
Specifies the position of the data bar's axis.
Members
MemberDescription
automaticSpecifies whether to display at a variable position based on negative values.
cellMidPointSpecifies whether to display at the cell midpoint.
noneSpecifies whether to display value bars in the same direction as positive values.
Example
This example creates a data bar rule.
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();
dataBarRule.ranges([new GC.Spread.Sheets.Range(0,0,4,1)]);
dataBarRule.minType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
dataBarRule.minValue(-1);
dataBarRule.maxType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
dataBarRule.maxValue(40);
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.DataBarAxisPosition

See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace