Spread.Sheets Documentation
value2 Method
The second value.
Gets or sets the second value.
Syntax
var instance = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
var returnValue; // Type: any
returnValue = instance.value2(value);
function value2( 
   value : object
) : any;

Parameters

value
The second value.

Return Value

If no value is set, returns the second value; otherwise, returns the number condition rule.
Example
This example uses the value2 method.
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between);
cell.value1(5);
cell.value2(7);
cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.foreColor = "black";
cell.style(style);
activeSheet.conditionalFormats.addRule(cell);
See Also

Reference

NormalConditionRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.