SpreadJS Documentation
value2 Field
The value of the second object.
Syntax
var instance = new GcSpread.Sheets.CellValueRule(operator, value1, value2, style);
var value; // Type: object
value = instance.value2;
var value2 : object;
Example
This example sets the value2 field.
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var cell = new GcSpread.Sheets.CellValueRule();
cell.operator = 2;
cell.value1 = 5;
cell.value2 = 7;
cell.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 1)];
cell.style = new GcSpread.Sheets.Style();
cell.style.backColor = "red";
cell.style.foreColor = "black";
activeSheet.getConditionalFormats().addRule(cell);
See Also

Reference

CellValueRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.