SpreadJS Documentation
ScaleValueType Enumeration
GC.Spread.Sheets.ConditionalFormatting Namespace : ScaleValueType Enumeration
Specifies the scale value type.
Members
MemberDescription
automaxIndicates whether to return the automatic maximum value in a specified range.
autominIndicates whether to return the automatic minimum value in a specified range.
formulaIndicates whether to return the result of a formula calculation.
highestValueIndicates whether to return the highest value in a specified cell range.
lowestValueIndicates whether to return the lowest value in a specified cell range.
numberIndicates whether to return a specified number directly.
percentIndicates whether to return the percentage of a cell value in a specified cell range.
percentileIndicates whether to return the percentile of a cell value in a specified cell range.
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);
This example creates a rule.
sheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);
Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.ScaleValueType

See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace