SpreadJS Documentation
getMaximumType Method
Gets the maximum scale type.
Syntax
var instance = new GcSpread.Sheets.TwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor);
var value; // Type: object
value = instance.getMaximumType();
function getMaximumType() : object;

Return Value

The maximum scale type.
Example
This example uses the getMaximumType method.
var scale = new GcSpread.Sheets.TwoScaleRule();
scale.setMaximumColor("blue");
scale.setMaximumType(2);
scale.setMaximumValue(100);
scale.setMinimumColor("yellow");
scale.setMinimumType(1);
scale.setMinimumValue(10);
scale.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 3)];
activeSheet.getConditionalFormats().addRule(scale);
activeSheet.setValue(0,0, 1,3);
activeSheet.setValue(1,0, 50,3);
activeSheet.setValue(2,0, 100,3);
alert("Color: " + scale.getMaximumColor() + " Type: " + scale.getMaximumType() + " Value: " + scale.getMaximumValue());
Remarks
The default value is ScaleValueType.HighestValue.
See Also

Reference

TwoScaleRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.