Copy filtered rows.

Posted by: bo-jangles on 8 September 2017, 2:19 pm EST

  • Posted 8 September 2017, 2:19 pm EST

    I've must spent days reading all posts about how to copy data to clipboard without copying filtered rows. In version 5 you've added AsStringSkipHidden to ClipboardCopy but this options is useless as it copies dates to Excel as strings. How complicated can it be to do the same thing as Excel. When I filter rows in Excel, higlight and copy, only visible rows get copied.


     


    :-(

  • Replied 8 September 2017, 2:19 pm EST

    Hello,

    We are unable to replicate the issue when the filtered rows are copied with ClipboardCopyOptions.AsStringSkipHidden. The date fields are not taken as text rather it takes no format for date fields which is usual even if you copy normal rows or date data from other application to excel.

    Please let us know if we misunderstood the issue.

    Thanks.

Need extra support?

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

Learn More

Forum Channels