禁止删除sheet页的方法,就是把右键菜单中的"删除"项隐藏掉。
在点击鼠标右键时,触发右键菜单前会触发onOpenMenu事件,
在其中可以判断是否显示某些右键菜单项,如下列代码所示:
- $(document).ready(function () {
- var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 3 });
- GC.Spread.Common.CultureManager.culture("zh-cn");
- var sheet = spread.getActiveSheet();
- sheet.setRowCount(5);
- function ContextMenu(){}
- ContextMenu.prototype = new GC.Spread.Sheets.ContextMenu.ContextMenu(spread);
- ContextMenu.prototype.onOpenMenu = function (menuData, itemsDataForShown, hitInfo, spread) {
- if(hitInfo.tabStripHitInfo){
- if(hitInfo.tabStripHitInfo.sheetTab.sheetName === "Sheet1"){
- var index = -1;
- for(let i=0; i<itemsDataForShown.length; i++){
- var item = itemsDataForShown[i];
- if(item.name === "gc.spread.deleteSheet"){
- index = i;
- break;
- }
- }
- if(index > -1){
- itemsDataForShown.splice(index, 1);
- }
- }
- }
- };
- spread.contextMenu = new ContextMenu();
- });
复制代码 |