更新进展:
经调研,此问题属于SpreadJS table与Excel存在差异的设计范畴内(比如table单元格合并等),如果修复可能会影响此前版本文件的导入,所以目前按设计处理。
您可以先尝试以下workaround方案,限制用户在tableName中输入&符号:
- var designer = new GC.Spread.Sheets.Designer.Designer("dss");
- var spread = designer.getWorkbook();
- var setTableNameFn = spread.commandManager()['Designer.setTableName'].execute;
- spread.commandManager()['Designer.setTableName'].execute = function (context, options, actionType) {
- if (options.newTableName && options.newTableName.indexOf("&") === -1) {
- return setTableNameFn.apply(this, arguments);
- } else {
- GC.Spread.Sheets.Designer.showMessageBox("Invalid Table name", "Error Dialog", GC.Spread.Sheets.Designer.MessageBoxIcon.error);
- }
- }
复制代码 效果图如下:
|