SpreadJS Documentation
expected Field
The expected rank.
Syntax
var instance = new GcSpread.Sheets.Top10Condition(type, rank, ranges);
var value; // Type: number
value = instance.expected;
var expected : number;
Example
This example sets the expected property.
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);
See Also

Reference

Top10Condition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.