ClipBoardCopy() + Hidden Columns

Posted by: imgodot on 8 September 2017, 3:18 pm EST

  • Posted 8 September 2017, 3:18 pm EST

    I am trying to copy my grid data into the clipboard with ClipboardCopy().
    I have hidden columns that I do NOT want to include in the copy.

    The only way I see to do this it is to use the ClipboardCopyOption of "AsStringSkipHidden".
    However, doing that causes some of our numeric columns to be copied as dates.

    I hope there is something simple I'm missing.
    Thanks.

    -- Paul
  • Marked as Answer

    Replied 8 September 2017, 3:18 pm EST

    Hello,

    We are sorry but we were unable to replicate the behavior menioned by you. The data was copied/pasted correctly without changing the format of any value.

    Please refer to the attached sample wherein the data is copied from FpSpread1 to FpSpread2. FpSpread1 has two hidden columns, namely FirstName and TitleofCourtesy. And on pasting the data from FpSpread1 to FpSpread2, the format of the numeric values remains unchanged.

    Please note, the sample was created with the latest build of Spread : 8.20.20151.0

    Request you to test with the latest build if not using the same and share your observations with us. It would also be helpful if you could share your sample application with us.

    Regards,
    Mohita
    2015/05/Spread_CopyPasteColumns.zip
  • Replied 8 September 2017, 3:18 pm EST

    Sorry, please ignore the original post.
    The problems was in the Excel sheet I was pasting INTO.
    My bad.
    Thank you.
    -- Paul
  • Replied 8 September 2017, 3:18 pm EST

    Hello,

    We are glad to know that your issue is resolved.

    Thanks,
    Reeva
Need extra support?

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

Learn More

Forum Channels