Pasting lines

Pasting lines

Posted by: khauam.cardoso on 20 May 2024, 1:57 am EST

• 

  khauam.cardoso

  • Post Options:
  • Link
    Copy

  Posted 20 May 2024, 1:57 am EST

  Hello, is there any way to capture the event of pasting lines coming from another worksheet and at that moment before pasting the information identify the number of lines coming and if the current worksheet has fewer add these lines and then continue the paste event

  using angular 16 spreadjs 17

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 20 May 2024, 4:27 pm EST

  Hi,

  You could set the “allowExtendPasteRange” to true and it will automatically adjust the number of rows and columns while pasting.

  Refer to the following docs on ClipboardOperations: https://developer.mescius.com/spreadjs/docs/features/workbook/clipboard#site_main_content-doc-content_title

  allowExtendPasteRange Option: https://developer.mescius.com/spreadjs/api/interfaces/GC.Spread.Sheets.IWorkBookDefaultOptions#allowextendpasterange

  Regards,

  Ankit

• 

  khauam.cardoso

  • Post Options:
  • Link
    Copy

  Posted 23 May 2024, 5:46 am EST

  I only need it for rows, is there a way to block the creation of columns in this case?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 23 May 2024, 6:35 pm EST - Updated 23 May 2024, 6:40 pm EST

  Hi,

  You could use the following code snippet to cancel the pasting if the column count exceeded:

  
          spread.options.allowExtendPasteRange = true;
          spread.bind(GC.Spread.Sheets.Events.ClipboardPasting, (sender: any, args: any) => {
              console.log("Clipboard Pasting");
              console.log(args);
              let pastingrange = args.cellRange;
              if((pastingrange.col + pastingrange.colCount) > args.sheet.getColumnCount()) {
                  // Perform Custom Actions Here
                  args.cancel = true;
                  alert("Column Count Exceeded");
              }
          });

  Sample: https://jscodemine.mescius.io/share/6V9Uxjo7mUiehYDcgyLFJQ/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.component.ts"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.component.ts"}

  Using the above code snippet, it adds new rows when pasting but restrict the pasting when the column count exceeded the current column count of the sheet.

  Further, you could perform custom actions after cancelling the pasting. The ClipboardPasting Event gives information about the pasting range, the range from where it is pasting, and other information.

  You could perform other actions, such as copying the range based on your condition. Use the ClipboardPaste command in case you want to perform custom copy/paste: https://developer.mescius.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#clipboardpaste

  Let us know if you face any issues.

  Regards,

  Ankit