Copying more than one column to cells is adding columns

Copying more than one column to cells is adding columns

Posted by: sundaydavid on 9 December 2019, 6:39 pm EST

• 

  sundaydavid

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 December 2019, 6:39 pm EST

  Say for instance, there’s a sheet that has 10 columns, and I try to copy Column 1 Row 1 (C1-R1), and C2-R1 using extended paste range to C9-R1 and C10-R1. After pasting the cells, additional columns were added.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 10 December 2019, 2:01 am EST

  Hi,

  This is the expected behavior. When allowExtendPasteRange is set to true, the paste range(including both row and column) is extended(if required) according to the paste data i.e if paste range is not enough to paste the copied data then additional rows and columns are created to allow the paste.
  
  Please refer to the following documentation:
  
  http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.Workbook.html

  Further, could you please let us know if you are trying to implement some specific use case and what are your requirements?

  Regards
  
  Sharad

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy

  Posted 12 November 2024, 5:33 am EST - Updated 12 November 2024, 5:34 am EST

  Thank you a lot for supporting me, I resolved my issue, just created a GC.Spread.Sheets.Range(0, 0, 10, 10) which has ‘row = 0’ then add

    const selections = new GC.Spread.Sheets.Range(0, 0, 10, 10);
    const hideRowFilter = new GC.Spread.Sheets.Filter.HideRowFilter(selections);
    workSheet.rowFilter(hideRowFilter);
  

  , it’ will add filter icon on the header cell area automaticlly.