Invalid Operation

Invalid Operation

Posted by: dhruv.barad on 31 July 2023, 2:05 pm EST

• 

  dhruv.barad

  • Post Options:
  • Link
    Copy

  Posted 31 July 2023, 2:05 pm EST

  Hello,

  I am trying to implement a feature where I want a dialog to show up if a user attempts to copy paste on a locked cell. So if a user is on A1 cell and does Ctrl+C and moves to A2 cell and does Ctrl+V, it should create a message dialog. So far, it only works if a user attempts the copy paste on the same cell.

  Here is a glimpse of what I have so far.

  activeSheet.bind(GC.Spread.Sheets.Events.InvalidOperation, function(e, args) {
  
  if (cell is locked){
  
  // create a dialog
  
  }
  
  });

  Again, the issue is when I paste into a different locked cell, the dialog does not show up.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 1 August 2023, 12:57 am EST

  Hi Dhruv,

  We tested with the latest version of SpreadJS V16.1.4 and it seems to be working fine at our end. At our end, we copied the cell from A1 and paste it into the A2 and dialog inside the InvalidOperation was shown.

  You could refer to the following code snippet and the sample:

      // Bind the Invalid Operation Event
      sheet.bind(GC.Spread.Sheets.Events.InvalidOperation, function (e, args) {
          if (args.invalidType === GC.Spread.Sheets.InvalidOperationType.copyPaste) {
              alert("Cannot Paste in Locked Cells");
          }
      });

  Further, if you want the cancel the paste when copied from locked cells, you could use the following code snippet:

      // Bind the Clipboard Pasting Event
      sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (e, args) {
          let fromRange = args.fromRange;
          // Check if the range is locked
          if (args.sheet.getRange(fromRange.row, fromRange.col, fromRange.rowCount, fromRange.colCount).locked()) {
              args.cancel = true;
              alert("Cannot Copy from Locked Cells");
          }
      });

  Sample: https://jscodemine.grapecity.com/share/-Zupe60uL06JSmJnSHhaGw/?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["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Could you kindly share us a minimal working sample replicating the issue? You may also modify the above sample and share it with us with your implementation. Please also let us know if we are missing anything in order to replicate the issue.

  References:

  InvalidOperation Type: https://www.grapecity.com/spreadjs/api/v15/enums/GC.Spread.Sheets.InvalidOperationType#enumeration-invalidoperationtype

  ClipboardPasting Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#clipboardpasting

  Protect Worksheet and locked cells: https://www.grapecity.com/spreadjs/docs/features/worksheet/celllock#site_main_content-doc-content_title

  Regards,

  Ankit