$(function () {
var workbook = new GC.Spread.Sheets.Workbook($("#ss")[0]);
var activeSheet = workbook.getActiveSheet();
activeSheet.setRowCount(7);
activeSheet.setValue(0, 0, "North");
activeSheet.setValue(1, 0, "South");
activeSheet.setValue(2, 0, "East");
activeSheet.setValue(3, 0, "South");
activeSheet.setValue(4, 0, "North");
activeSheet.setValue(5, 0, "North");
activeSheet.setValue(6, 0, "West");
activeSheet.setColumnWidth(0, 80);
activeSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(0, 0, 7, 1)));
$("#button1").click(function(){
//列1を「North」によってフィルタリングします。
var rowFilter = $("#ss").data("workbook").getActiveSheet().rowFilter();
var condition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.TextCondition, {
compareType: GC.Spread.Sheets.ConditionalFormatting.TextCompareType.EqualsTo,
expected: "North"
});
rowFilter.addFilterItem(0, condition);
rowFilter.filter(0);
});
$("#button2").click(function(){
// 列1のフィルタリングを解除します。
var rowFilter = $("#ss").data("workbook").getActiveSheet().rowFilter();
if(rowFilter){
rowFilter.removeFilterItems(0);
rowFilter.filter();
}
});
});
//ページにボタンコントロールを追加します。
<input type="button" id="button1" value="button1"/>
<input type="button" id="button2" value="button2"/>
|