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

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

  • Posted 18 February 2021, 10:09 pm EST


    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:

    * 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

  • Replied 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.

  • Marked as Answer

    Replied 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.

  • Replied 25 February 2021, 12:59 am EST


    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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels