type Field

Gets or sets the top 10 condition type.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Top10Condition(type, rank, ranges);
var value; // Type: Top10ConditionType
value = instance.type;

var type : Top10ConditionType;

Example

This example sets the type property.

Javascript

activeSheet.isPaintSuspended(true);
for (var row = 0; row < 25; row++) {
    activeSheet.setValue(row, 0, row, GcSpread.Sheets.SheetArea.viewport);
}
var rowFilter = new GcSpread.Sheets.HideRowFilter(new GcSpread.Sheets.Range(0, 0, 25, 1));
activeSheet.rowFilter(rowFilter);
var top10Con = new GcSpread.Sheets.Top10Condition();
top10Con.type = GcSpread.Sheets.Top10ConditionType.Top;
top10Con.expected = 10;
var filter = activeSheet.rowFilter();
filter.addFilterItem(0, top10Con);
filter.filter(0);
activeSheet.isPaintSuspended(false);

Reference

Top10Condition type