Paste cell from Excel that contains a comment?

Paste cell from Excel that contains a comment?

Posted by: loy-chan on 8 September 2017, 4:29 am EST

• 

  loy-chan

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 4:29 am 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 :

  im.Put(ksPaste, SpreadActions.ClipboardPasteAll);

  but I'm guessing that would only affect the paste function if the cut/copy originated within the spread.

   

  Any suggestions?

• 

  scotts-fp

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 4:29 am EST

  Hello,

  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.

• 

  larsenmcleod9827295

  • Post Options:
  • Link
    Copy

  Posted 8 November 2022, 2:06 pm EST - Updated 8 November 2022, 2:07 pm EST

  Oh! I tried following the instructions and it really works
  
  basket random