Context menu in protected sheet

Context menu in protected sheet

Posted by: khauam.cardoso on 6 May 2024, 1:27 pm EST

• 

  khauam.cardoso

  • Post Options:
  • Link
    Copy

  Posted 6 May 2024, 1:27 pm EST

  Hi, when my

      sheet.options.isProtected = true;

  my context menu is disabled in all rows, how i enable for some rows only?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 7 May 2024, 8:20 am EST

  Hi,

  From what I understand, when you set a sheet as protected, the context menu is disabled for all rows, meaning it doesn’t open, and you’re interested in enabling it for specific rows.

  However, on my end, when I set the sheet as protected, the context menu isn’t disabled for any row. To better understand your situation, could you please share a sample document along with the steps to reproduce the behavior you’re encountering? Alternatively, you can modify the existing sample to demonstrate the issue. Providing a GIF or video showcasing the problem would also be greatly beneficial.

  However, you can make the context menu open for certain rows by handling the “contextmenu” event and utilizing the hitText method to determine the cell’s location. Please refer to the attached snippet and sample for guidance on how to achieve this.

  spread.getHost().addEventListener("contextmenu", (e) => {
      // getting location 
      const offsetEle = spread.getHost();
      const x = e.pageX - offsetEle.offsetLeft;
      const y = e.pageY - offsetEle.offsetTop;
      // finding target
      const target = spread.hitTest(x, y);
  
      if (!(target.worksheetHitInfo.hitTestType == GC.Spread.Sheets.SheetArea.viewport && target.worksheetHitInfo.row == 0)) {
          e.stopPropagation();
          e.preventDefault();
      }
  }, true)

  Sample: https://jscodemine.mescius.io/share/G8x2E3yNvESRWi026aWZ3A/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"%2C"%2Fpackage.json"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  References:

  hitTest: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Workbook#hittest

  Regards,
  
  Priyam