本帖最后由 tim123 于 2018-11-7 13:30 编辑
$("#setProtectionOptions").click(function() {
var sheet = spread.getActiveSheet();
sheet.options.isProtected=true;
var option = {
allowSelectLockedCells: false,
allowSelectUnlockedCells: false,
allowSort: false,
allowFilter: false,
allowResizeRows: false,
allowResizeColumns: false,
allowEditObjects: false,
allowDragInsertRows: false,
allowDragInsertColumns: false,
allowInsertRows: false,
allowInsertColumns: false,
allowDeleteRows: false,
allowDeleteColumns: false
};
sheet.options.protectionOptions = option;
});
|
|