SpreadJS Documentation
reverseIconOrder Method
Whether to reverse icon order.
Gets or sets whether to reverse icon order.
Syntax
var instance = new GcSpread.Sheets.IconSetRule(iconSetType);
var returnValue; // Type: boolean
returnValue = instance.reverseIconOrder(value);
function reverseIconOrder( 
   value : boolean
) : boolean;

Parameters

value
Whether to reverse icon order.

Return Value

The value that indicates whether to reverse icon order.
Example
This example creates a 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 cfs = activeSheet.getConditionalFormats();
var iconSetRule = new GcSpread.Sheets.IconSetRule();
iconSetRule.ranges =[new GcSpread.Sheets.Range(0,0,4,1)];
iconSetRule.iconSetType(GcSpread.Sheets.IconSetType.FourTrafficLights);
var iconCriteria = iconSetRule.iconCriteria();
iconCriteria[0] = new GcSpread.Sheets.IconCriterion(true, GcSpread.Sheets.IconValueType.Number, 1);
iconCriteria[1] = new GcSpread.Sheets.IconCriterion(true, GcSpread.Sheets.IconValueType.Number, 10);
iconCriteria[2] = new GcSpread.Sheets.IconCriterion(true, GcSpread.Sheets.IconValueType.Number, 20);
iconSetRule.reverseIconOrder(false);
iconSetRule.showIconOnly(false);
cfs.addRule(iconSetRule);
Remarks
The default value is false.
See Also

Reference

IconSetRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.