[17]新增右键添加多个按钮不生效

收藏

本帖最后由鸳鸯配2024 于 2024-8-5 16:12 编辑

config.commandMap = {
"insertMutiRows": {
text: "上方添加行",
commandName: "insertMutiRows",
},
"insertMutiRowsDown": {
text: "下方添加行",
commandName: "insertMutiRowsDown",
},
}
}
var insertRowsByCounts = {
canUndo: true,
canExcute: function () {
console.log(arguments)
},
execute: function (spread, options, isUndo) {
var Commands = GC.Spread.Sheets.Commands;
if (isUndo) {
Commands.undoTransaction(spread, options);
return true;
} else {
Commands.startTransaction(spread, options);
if (options.commandOptions) {
console.log('在上方插入' + options.commandOptions);
var sheet = spread.getSheetFromName(options.sheetName);
sheet.suspendPaint();
sheet.addRows(options.activeRow, parseInt(options.commandOptions));
sheet.resumePaint();
}
Commands.endTransaction(spread, options);
return true;
}
}
};
let insertRowsByCountsDown = {
canUndo: true,
canExcute: function () {
console.log(arguments)
},
execute: function (spread, options, isUndo) {
var Commands = GC.Spread.Sheets.Commands;
console.log(options, '--options--')
if (isUndo) {
Commands.undoTransaction(spread, options);
return true;
} else {
Commands.startTransaction(spread, options);
if (options.commandOptions) {
console.log('在下方插入++++' + options.commandOptions);
var sheet = spread.getSheetFromName(options.sheetName);
sheet.suspendPaint();
sheet.addRows(options.activeRow, parseInt(options.commandOptions));
sheet.resumePaint();
}
Commands.endTransaction(spread, options);
return true;
}
}
};
var commandManager = spread.commandManager();
let insertRowAndCopyContent = {
canUndo: true,
execute: function (context, options, isUndo) {
let Commands = GC.Spread.Sheets.Commands;
options.cmd = "insertRowAndCopyContent";
if (isUndo) {
Commands.undoTransaction(context, options);
return true;
} else {
Commands.startTransaction(context, options);
context.suspendPaint();
context.suspendEvent();
var sheet = context.getSheetFromName(options.sheetName);
var selections = sheet.getSelections();
for(var i = 0; i < selections.length; i++){
var row = selections[i].row;
sheet.addRows(row,options.rowCount);
var fromRange = [new GC.Spread.Sheets.Range(row + options.rowCount, 0, 1, sheet.getColumnCount())];
var toRanges = [new GC.Spread.Sheets.Range(row, 0, options.rowCount, sheet.getColumnCount())];
spread.commandManager().execute({cmd: "clipboardPaste", sheetName: options.sheetName, fromSheet: sheet, fromRanges: fromRange, pastedRanges: toRanges, isCutting: false, clipboardText: "", pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.formulasAndFormatting});
}
context.resumeEvent();
context.resumePaint();
Commands.endTransaction(context, options);
return true;
}
}
};
var commandManager = spread.commandManager();
commandManager.register("insertRowAndCopyContent", insertRowAndCopyContent);
commandManager.register("insertMutiRows", insertRowsByCounts, null, false, false, false, false);
commandManager.register("insertMutiRowsDown", insertRowsByCountsDown, null, false, false, false, false);
// 获取旧的菜单
var oldCreateMenuItemElement = spread.contextMenu.menuView.createMenuItemElement;
spread.contextMenu.menuView.createMenuItemElement = function (menuItemData) {
var self = this;
var menuItemView = oldCreateMenuItemElement.call(self, menuItemData);
if (menuItemData.name === "insertMutiRows") {
var supMenuItemContainer = menuItemView[0];
var inputBlock = createInput();
// var btnupBlock = createBtn();
supMenuItemContainer.appendChild(inputBlock);
// supMenuItemContainer.appendChild(btnupBlock);
}
// console.log(menuItemData.name, '--menuItemData.name--666')
if (menuItemData.name === "insertMutiRowsDown") {
// console.log(menuItemView, '--menuItemView--')
var supMenuItemContainer = menuItemView[0];
var inputBlock = createInput();
// var btnupBlock = createBtn();
supMenuItemContainer.appendChild(inputBlock);
// supMenuItemContainer.appendChild(btnupBlock);
}
return menuItemView;
}
var oldgetCommandOptions = spread.contextMenu.menuView.getCommandOptions;
spread.contextMenu.menuView.getCommandOptions = function (menuItemData, host, event) {
console.log(menuItemData.name, '--menuItemData.name--')
if (menuItemData && menuItemData.name === "insertMutiRows") {
var ele = document.getElementsByClassName("inputBlock")[0]
return ele.value;
}else if (menuItemData && menuItemData.name === "insertMutiRowsDown") {
var ele = document.getElementsByClassName("inputBlock")[0]
return ele.value;
} else {
return oldgetCommandOptions.apply(this, arguments)
}
};

复制代码

上方添加行是生效的

下方添加行这个是不生效的，不知道问题在哪，希望能帮忙看下。

img_v3_02df_05293b24-416f-4b1d-a1ee-ca1790e6effg.jpg64714659.png

Wilson.Zhang · Wilson.Zhang

您好！关于您对自定义右键菜单的需求，我已经在SperadJS中实现了，但是在在线表格编辑器中遇到点儿问题，正在排查解决中，请您稍候。
附件为SpreadJS中自定义右键菜单的demo，请您先参考。

Wilson.Zhang · Wilson.Zhang

本帖最后由 Wilson.Zhang 于 2024-8-6 08:53 编辑

您好！走读了您提供的代码，自定义右键菜单选项和命令的流程是正常的。您要自定义的菜单选项分别是“向上插入N行”和“向下插入N行”，分别创建了两个小容器用以接收输入的行数，但是两个菜单选项共用了同一个小容器接收行数，这才导致“向下插入N行”无效。如下图所示：
1722904700146.png648357848.png

如上所述，在SpreadJS和在线表格编辑器分别实现了该需求，附件即相关代码，供您参考！

鸳鸯配2024 · 鸳鸯配2024

Wilson.Zhang 发表于 2024-8-6 08:46
您好！走读了您提供的代码，自定义右键菜单选项和命令的流程是正常的。您要自定义的菜单选项分别是“向上插 ...

解决问题了，谢谢

Wilson.Zhang · Wilson.Zhang

鸳鸯配2024 发表于 2024-8-7 11:56
解决问题了，谢谢

不客气！那就结贴了，如有问题，欢迎继续发帖沟通！

		自动登录	找回密码
密码			立即注册

[已处理] [17]新增右键添加多个按钮不生效

4 个回复