Paste cell from Excel that contains a comment?

Posted by: loy-chan on 8 September 2017, 1:29 pm EST

  • Posted 8 September 2017, 1:29 pm EST

    When I try to copy and paste a cell from Excel that contains a comment into FarPoint, I only get the contents (and formatting) of the original cell. I'm missing the comments.

    Is there any way I could get the comment as well?

    I tried to set the paste action to :

    <FONT size=2>

    im.Put(ksPaste, </FONT><FONT color=#2b91af size=2>SpreadActions</FONT><FONT size=2>.ClipboardPasteAll);</FONT>

    <FONT size=2>but I'm guessing that would only affect the paste function if the cut/copy originated within the spread.</FONT>

    <FONT size=2></FONT> 

    <FONT size=2>Any suggestions?

  • Replied 8 September 2017, 1:29 pm EST


    Spread is only reading the TextFormat and it's own CellInfoRangeFormat from the clipboard during the paste. The copy of the cell in Excel will not copy the Note into one of these formats, so you will not be able to copy cells with notes and paste the note into Spread.

Need extra support?

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

Learn More

Forum Channels