Copy & Paste whole column not working when having spanned column headers

Copy & Paste whole column not working when having spanned column headers

Posted by: hector.pascual on 18 February 2021, 10:09 pm EST

• 

  hector.pascual

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 February 2021, 10:09 pm EST

  Hello!

  If I create spanned column headers
  
  (this.sheet.addSpan …) therefore having multiple colHeader rows, the copy & paste from whole columns does not work anymore.

  If you take your demo for example:
  
  https://www.grapecity.com/spreadjs/demos/features/worksheet/sheet-header/purejs

  • Click on column header with the title “1”.
  • Press CTRL+C or context menu “Copy”.
  • Click on column header with the title “3”.
  • Press CTRL+V or context menu “Paste values”.

  Nothing happens.
  
  If you remove the spanned columns the same procedure works as expected.

  Can I enable the copy&paste feature for columns even if there are spanned-columns? Or is it a bug?

  Best regards

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2021, 3:09 pm EST

  Hi Hector,

  Thanks for the information. We are able to replicate the issue at our end hence we have forwarded it to the concerned team for further investigation. We will update you regarding this issue as soon as we get any information from the team. The internal ID for this issue will be SJS-7716.

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 24 February 2021, 2:02 pm EST

  Hi Hector,

  The Devs informed us that it isn’t support to select the spanned header to copy and paste, and you should instead select all of the columns in that header (i.e. select 1, 2 and 3) and then copy/paste and it will work.

  Regards
  
  Avinash

• 

  hector.pascual

  • Post Options:
  • Link
    Copy

  Posted 25 February 2021, 12:59 am EST

  Hello!

  If a user selects the top column header row, it would select multiple columns and that’s not exactly my use case.
  
  But it’s not that bad, there are other ways to get to the result.

  No worries, thank you!

  best regards