spread.fromJSON(jsonData);
spread.resumePaint();
spread.options.tabStripVisible = false;
spread.options.tabEditable = false;
spread.options.newTabVisible = false;
spread.options.tabStripRatio = 1;
var activeSheet = spread.getActiveSheet();
activeSheet.frozenRowCount(1);
activeSheet.frozenColumnCount(3);
activeSheet.options.isProtected = true;
activeSheet.options.protectionOptions.allowFilter = true;
activeSheet.options.protectionOptions.allowSort = true;
已经设置了的,过滤功能是可以用的,但排序功能不能用 |