以前初始化的时候用你给的代码可以取消设计器全部锁定
function reset(init) {
if (init === void 0) { init = false; }
if (!init) {
wrapper.spread.destroy();
element.empty();
wrapper.spread = null;
}
wrapper.spread = new Sheets.Spread(element[0], { sheetCount: 1 });
wrapper.spreadElement = element;
designer.formulaBar.initFormulaBar(init);
designer.contextMenu.addTabStripEvents();
//Register F2 key to enter editing status.
for (var i = 0; i < wrapper.spread.getSheetCount(); i++) {
var sheet = wrapper.spread.sheets;
sheet.addKeyMap(113, false, false, false, false, function () {
if (!this.isEditing()) {
this.startEdit();
}
});
//新增
//set sheet detault lock false
var defaultSheetStyle = sheet.getDefaultStyle() || new Sheets.Style();
defaultSheetStyle.locked = false;
sheet.setDefaultStyle(defaultSheetStyle);
}
导入后为什么不能了呢
var excelIo = new GC.Spread.Excel.IO();
var excelFile = document.getElementById("fileSelector2").files[0];
excelIo.open(excelFile,function(json){
json.version = "9.40.20161.0";
for(var sheetProp in json.sheets){
var sheet = json.sheets[sheetProp];
if(sheet.floatingObjects){
for(var foProp in sheet.floatingObjects){
var fo = sheet.floatingObjects[foProp]
fo.floatingObjectType = fo.typeName
}
}
if(sheet.protectionOptions){
sheet.protectionOption = sheet.protectionOptions;
}
}
var spread2 = $("#ss").data("spread");
spread2.fromJSON(json);
jsonStrflag = 1;
maxaddandrow(spread2);
layer.alert("<center>导入成功!</center>");
for (var i = 0; i < spread2.getSheetCount(); i++) {
var sheet = spread2.sheets;
sheet.addKeyMap(113, false, false, false, false, function () {
if (!this.isEditing()) {
this.startEdit();
}
});
//新增
//set sheet detault lock false
var defaultSheetStyle = sheet.getDefaultStyle() || new Sheets.Style();
defaultSheetStyle.locked = false;
sheet.setDefaultStyle(defaultSheetStyle);
}
|
|