Working with Clipboard

The user can copy and paste cell values in GcMultiRow using the clipboard.

Allowing Clipboard Operations

To allow clipboard operations, set the GcMultiRow.AllowClipboard property to True. The following clipboard operations are allowed in this case.

Cut Cell Values
Copy Cell Values
Paste Cell Values

The shortcut keys for the clipboard are the same as Windows standard keys. For details, refer to Shortcut Keys.

Clipboard Data Format

The data copied to the clipboard uses a comma to separate the cell values of the Cell.FormattedValue property, and separates the rows with a new line code (vbCrLf in Visual Basic, "\r\n" in C#). The cell order is based on the cell index (Cell.Index). To change the cell index at design time, refer to Changing Cell Index in the Designer.

Clipboard Events

When the clipboard operations are executed on the GcMultiRow control, the GcMultiRow.ClipboardOperating event occurs. You can use this event to cancel the clipboard operation using your own conditions. For example, you can cancel the built-in clipboard operations and implement your own clipboard operations.

PasswordChar property and InvalidOperationException

When you set the value of the TextBoxCell.PasswordChar property, you cannot copy the cell values to the clipboard. An InvalidOperationException is thrown if the user tries to copy in this state. In order to suppress the display of the message box due to this exception, use the GcMultiRow.DataError event.