Posted 22 November 2022, 10:23 pm EST - Updated 22 November 2022, 10:29 pm EST
Hi Team
i want to disable the delete sheet button in the context menu ,if number of worksheets are only one.
Forums Home / Spread / SpreadJS
Posted by: sharaththota.zem on 22 November 2022, 10:23 pm EST
Posted 22 November 2022, 10:23 pm EST - Updated 22 November 2022, 10:29 pm EST
Hi Team
i want to disable the delete sheet button in the context menu ,if number of worksheets are only one.
Posted 23 November 2022, 4:20 am EST
Hi,
For this, you need to add disable property to delete the Sheet Item from the Context menu. Please refer to the following code snippet and the attached sample that implements the same.
function setVisibleForDeleteSheet(spread, value) {
spread.contextMenu.menuData.forEach((el) => {
if (el.name === "gc.spread.deleteSheet") {
el.disable = value;
}
});
}
sample: https://codesandbox.io/s/great-bush-lvq5qq?file=/src/index.js:780-786
Regards,
Avinash