如何在进入页面第一次点击右键就筛选好右键菜单

Joestar.Xu · Joestar.Xu

您好，根据您之前的描述，推测您是想问在某些情况下，部分右键菜单中的选项为什么不显示吗？

这是因为每个选项是否显示还受enableContext的影响，当enableContext中的结果返回false时，该选项将不会显示。

anyOneCode · anyOneCode

Joestar.Xu 发表于 2023-9-18 18:00
您好，根据您之前的描述，推测您是想问在某些情况下，部分右键菜单中的选项为什么不显示吗？

这是因为每 ...

问题其他的选项可以用啊，还有个问题就是我用上面的示例代码，我的选项菜单变成英文

Joestar.Xu · Joestar.Xu

我这边尝试在您之前提供的代码中复现您的问题，但是缺少一些变量的定义，请您提供一个完整的Demo，我这边复现后帮您调研一下。

anyOneCode · anyOneCode

Joestar.Xu 发表于 2023-9-19 17:29
我这边尝试在您之前提供的代码中复现您的问题，但是缺少一些变量的定义，请您提供一个完整的Demo，我这边复 ...

let elements = sheetList[sheetIndex].elements;
let isAllowDeleteRow = sheetList[sheetIndex].isAllowDeleteRow;
let oldOpenMenu = spread.contextMenu.onOpenMenu;
function ContextMenu() {}
ContextMenu.prototype = new GC.Spread.Sheets.ContextMenu.ContextMenu(spread);
ContextMenu.prototype.onOpenMenu = function (
menuData,
itemsDataForShown,
hitInfo,
spread
) {
const Alltrue = [
"gc.spread.insertComment",
"formatCells",
"gc.spread.tableDelete",
"gc.spread.tableInsert",
"link",
"richText",
"defineName",
"cellTag",
];
const coltrue = ["gc.spread.deleteRows", "gc.spread.clearContents"];
const Allfalse = [
"gc.spread.clearContents",
"gc.spread.tableDelete",
"gc.spread.insertComment",
"gc.spread.tableInsert",
"formatCells",
"link",
"richText",
"defineName",
"cellTag",
];
// const Alltrue = ["插入批注","设置单元格格式...","超链接...","编辑富文本...","定义名称..." ,"标签..."]
// const Allfalse = ["清除内容","删除","插入批注","设置单元格格式...","超链接...","编辑富文本...","定义名称..." ,"标签..."]
const selections = spread.getSheetFromName(element.sheetName).getSelections();
console.log(selections);
console.log(itemsDataForShown);
for (let i = 0; i < itemsDataForShown.length; i++) {
var item = itemsDataForShown[i];
if (selections[0].row == -1) {
item.disable = true;
if (item.subMenu) {
item.subMenu.forEach((citem) => {
citem.disable = true;
});
}
}
if (
!isAllowDeleteRow &&
selections[0].col == -1 &&
coltrue.includes(item.name)
) {
item.disable = true;
if (item.subMenu) {
item.subMenu.forEach((citem) => {
citem.disable = true;
});
}
}
if (
elements[selections[0].col]?.isAllowEdit === 1 &&
Alltrue.includes(item.name)
) {
item.disable = true;
if (item.subMenu) {
item.subMenu.forEach((citem) => {
citem.disable = true;
if (
citem.name == "gc.spread.tableDeleteRows" ||
citem.name == "gc.spread.tableInsertRowsAbove"
) {
citem.disable = false;
}
});
}
}
if (
elements[selections[0].col]?.isAllowEdit === 0 &&
Allfalse.includes(item.name)
) {
item.disable = true;
if (item.subMenu) {
item.subMenu.forEach((citem) => {
citem.disable = true;
if (citem.name == "gc.spread.tableInsertRowsAbove") {
citem.disable = false;
}
});
}
}
}
};
// 将自定义右键菜单赋值给spread.contextMenu
spread.contextMenu = new ContextMenu();