Can I programmatically copy out of the spread into Excel and maintain formatting

Posted by: j2associates on 8 September 2017, 12:55 pm EST

  • Posted 8 September 2017, 12:55 pm EST

    Hello all,


    We have a detail process that processes about 1200 text files and accumulates summarized information which is dumped to a spread. Certain information is highlighted using various colors.


    If I click in the upper left hand corner of the spread, I can select it all and copy it to Excel but I lose all of the background colors, some Row.BackColor and some Cell.BackColor. Is there a way to copy the information from the clipboard and keep the back ground colors? Thanks!

  • Replied 8 September 2017, 12:55 pm EST

    Hello,


    This is not possible with our Spread product and copying to the clipboard.

Need extra support?

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

Learn More

Forum Channels