Column Interchange in SpreadSheet

Posted by: srinivasan.lakshmanan on 5 July 2018, 9:18 pm EST

  • Posted 5 July 2018, 9:18 pm EST

    Hi,

    Is there a way to do Column Interchange in SpreadSheet using SpreadJS.I checked but couldn't find anything.Please help me in doing this.
  • Replied 8 July 2018, 5:10 pm EST

    Hello,

    Currently, it is not possible to move row/column in SpreadJs.


    Thanks,
    Mohit
  • Replied 10 July 2018, 4:50 pm EST

    We have already have this feature in our product backlog. It may get added to our future version of SpreadJS. The request id for this is 197800.

    Thanks,
    Deepak Sharma
  • Replied 11 August 2020, 2:08 am EST

    Looks like haven't reached the top of the priority list yet? Any plans for implementing this any time soon? Big one for Excel parity.
  • Replied 12 August 2020, 1:00 am EST

    Hi Pawel,

    SJS now support drag insert functionality just like MS Excel, you may use shift+drag to drag insert, ctrl + drag to drag copy and ctrl + shift + drag to drag copy insert the selection.
    For API access, you may refer use the moveTo method:
    https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~moveTo.html

    Regards
  • Replied 12 August 2020, 1:14 am EST

    I think we're both referring to different features. I've been thinking of this. example from Google Sheets, as I don't have MS Excel - but I believe same is supported by Excel.
  • Replied 12 August 2020, 4:29 pm EST

    Actually, this is the same feature I was talking about. Please refer to the attached gif, in the gif, shift + drag operation is performed.
  • Replied 19 August 2020, 12:24 am EST

    I think there is a subtle difference in these features though..

    1. You showed a feature that allows to move the content of cells across row/column selection.
    2. I showed a feature that allows to move the selected rows and columns including the content.

    These 2. start making a difference if your rows/columns have meaning associated to it and should only be moved as a whole.

    This sheet is a good example: https://www.grapecity.com/spreadjs/demos/features/workbook/initialization/purejs

    At the moment you can't move "Film" column including its contents to a different position (2.). You can indeed move the content of "Film" column (1.), but that's a different user action.
  • Replied 20 August 2020, 1:52 am EST

    I'm sorry but I'm a little confused. I tried the sample link you shared and it seems to correctly move the Film column along with the header. Is there anything else I should be looking for? I've attached a gif of my observation too
  • Marked as Answer

    Replied 26 August 2020, 12:25 am EST

    Sharad, you're a star! I admire your patience with me.. That's exactly what I was looking for.

    The confusion on my side was that I was trying to drag by the column headers. And I misunderstood initially your point about keyboard modifiers.

    Thank you!
  • Replied 26 August 2020, 4:03 pm EST

    We are glad that we were able to help. Please feel free to reach out if you face any further issues.

    Regards
Need extra support?

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

Learn More

Forum Channels