您好,我想问一下,当我选择区域冻结的时,是没有问题的,如图一- var selectedRanges = spread.getActiveSheet().getSelections();
- for(var i=0;i<selectedRanges.length;i++){
- var rowCount = selectedRanges[i].row + selectedRanges[i].rowCount
- var colCount = selectedRanges[i].col + selectedRanges[i].colCount;
- sheet.frozenRowCount(rowCount);
- sheet.frozenColumnCount(colCount);
- sheet.options.frozenlineColor = "red";
- };
复制代码 但是再取消冻结的时候,我之前冻结的那些列就消失了,不知道是什么情况?如图二- spread.getActiveSheet().frozenRowCount(0);
- spread.getActiveSheet().frozenColumnCount(0);
- spread.getActiveSheet().frozenTrailingRowCount(0);
- spread.getActiveSheet().frozenTrailingColumnCount(0);
复制代码 然后这个时候再点击冻结的按钮,又还原了回来,又出现图一的样子,这块不太理解,求解答
|
-
图一
-
图二
|