Mark border cells like excel when you copy

Mark border cells like excel when you copy

Posted by: Lmqr9011 on 28 September 2018, 6:10 pm EST

• 

  Lmqr9011

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 September 2018, 6:10 pm EST

  I want to keep the selection of the copied cells, mean while I do copys of them. Like the excel’s behavior

• 

  meenakshi.singh

  

  • Post Options:
  • Link
    Copy

  Posted 1 October 2018, 3:07 am EST

  Hi Luis!

  I think, you are trying this with C1FlexGrid control. However, this is not possible in the grid.

  If the use case is just to change appearance of the copied range, then what you can do is:
  
  In KeyDown event of C1FlexGrid, check if ‘Ctrl+C’ key combination has been pressed then get the currently selected range using C1FlexGrid.Selection property. Now, you can customize its appearance.

  private void C1FlexGrid1_KeyDown(object sender, KeyEventArgs e)
  {
        if (e.KeyCode == Keys.C && e.Modifiers == Keys.Control)
        {
               //Your Code here...
        }
  }
  

  • Meenakshi
• 

  Lmqr9011

  • Post Options:
  • Link
    Copy

  Posted 2 October 2018, 8:50 am EST

  Thanks for answer,Im using spread 11 vb.net, and I want to copy the styles from a range of cells, mean while the user can see the range selected by him, thats what I mean by excel behavior. I know the spread in js has a option call cutcopyindicador, I want to know if in windows form exists something similar.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 4 October 2018, 9:22 am EST

  Hello,

  It seems you are talking about the dashed-border which shows on copy a range of cells in Excel. This feature is not available with Spread for Windows Forms currently. Sorry for the inconvenience.
  
  However, you can set the dashed border around the selected cells on copy and then remove the same on paste. This would not have animation like Excel shows.

  Thanks,
  
  Deepak Sharma