Disable user dragfill in column direction

Disable user dragfill in column direction

Posted by: namratha.bejgam on 7 October 2021, 4:54 pm EST

• 

  namratha.bejgam

  • Post Options:
  • Link
    Copy

  Posted 7 October 2021, 4:54 pm EST

  Hi,

  Is there any way we can restrict the user drag and fill functionality in SpreadJS only to row direction (i.e., disable it in column direction)? Looks like there’s no such apt option available currently.

  Thanks

• 

  namratha.bejgam

  • Post Options:
  • Link
    Copy

  Posted 7 October 2021, 4:58 pm EST - Updated 29 September 2022, 5:01 am EST

  [quote=“namratha.bejgam”] Hi,

  Is there any way we can restrict the user drag and fill functionality in SpreadJS only to row direction (i.e., disable it in column direction)? Looks like there’s no such apt option available currently.

  Thanks [/quote] Here’s the image for reference

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 10 October 2021, 6:33 pm EST

  Hi,

  For this, You may use the DragFillBlock event and cancel it if the direction is left or right. Please refer to the following code snippet and let me know if you face any issues.

  
    sheet.bind(GC.Spread.Sheets.Events.DragFillBlock, (e, args) => {
      if (
        args.fillDirection === GC.Spread.Sheets.Fill.FillDirection.right ||
        args.fillDirection === GC.Spread.Sheets.Fill.FillDirection.left
      )
        args.cancel = true;
    });
  
  

  DragFillBlock: SpreadJS Overview | JavaScript Spreadsheet | SpreadJS

  Regards Avinash

• 

  namratha.bejgam

  • Post Options:
  • Link
    Copy

  Posted 11 October 2021, 6:07 pm EST

  The dragfill part works like a charm, thanks. But how do we handle the same for Copy-Paste?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 12 October 2021, 4:56 pm EST

  Hi,

  Similarly, you could handle ClipboardPasting event and cancel the action if the range has more than one column. Please refer to the following code snippet and let me know if you face any issues.

  
   sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, (e, args) => {
      if (args.cellRange.colCount > 1) args.cancel = true;
    });
  
  

  ClipboardPasting: SpreadJS Overview | JavaScript Spreadsheet | SpreadJS

  Regards Avinash