Class $.wijmo.wijspread.ScaleValueType

Class Summary
Constructor Attributes	Constructor Name and Description
	$.wijmo.wijspread.ScaleValueType() Specifies the scale value type.

Field Summary
Field Attributes	Field Name and Description
	Automax Indicates whether to return the automatic maximum value in a specified range.
	Automin Indicates whether to return the automatic minimum value in a specified range.
	Formula Indicates whether to return the result of a formula calculation.
	HighestValue Indicates whether to return the highest value in a specified cell range.
	LowestValue Indicates whether to return the lowest value in a specified cell range.
	Number Indicates whether to return a specified number directly.
	Percent Indicates whether to return the percentage of a cell value in a specified cell range.
	Percentile Indicates whether to return the percentile of a cell value in a specified cell range.

Class Detail

$.wijmo.wijspread.ScaleValueType()

Specifies the scale value type.

var style = new $.wijmo.wijspread.Style();
style.backColor = "red";

var rule = new $.wijmo.wijspread.TwoScaleRule($.wijmo.wijspread.ScaleValueType.Number,1,"Yellow",$.wijmo.wijspread.ScaleValueType.Number,50,"Blue");
rule.ranges=[new $.wijmo.wijspread.Range(0,0,20,1)];

sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);

Field Detail

Automax

Indicates whether to return the automatic maximum value in a specified range.

Automin

Indicates whether to return the automatic minimum value in a specified range.

Formula

Indicates whether to return the result of a formula calculation.

HighestValue

Indicates whether to return the highest value in a specified cell range.

LowestValue

Indicates whether to return the lowest value in a specified cell range.

Number

Indicates whether to return a specified number directly.

Percent

Indicates whether to return the percentage of a cell value in a specified cell range.

Percentile

Indicates whether to return the percentile of a cell value in a specified cell range.

Classes

Class $.wijmo.wijspread.ScaleValueType