没有设置单元格lock属性,全部代码如下:
var count = sheet.getColumnCount();
var rowcount = sheet.getRowCount();
for (var i = 0; i < count; i++) {
sheet.autoFitColumn(i);
var colwidth = sheet.getColumnWidth(i);
if (colwidth < 100)
sheet.setColumnWidth(i, 100);
var colname = sheet.getValue(0, i, GC.Spread.Sheets.SheetArea.colHeader);
if (colname == "是否作废") {
//作废行灰色
for (var j = 0; j < rowcount; j++) {
var zf = sheet.getValue(j, i, GC.Spread.Sheets.SheetArea.viewport);
if (trimRight(trimLeft(zf))=="作废")
{
sheet.getCell(j, -1).locked(true);
sheet.getRange(j, 0, 1, sheet.getColumnCount()).backColor("lightgray");
}
}
sheet.setColumnVisible(i, false);
}
}
|