SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / ScaleValueType Enumeration
In This Topic
    ScaleValueType Enumeration
    In This Topic
    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