NewValues Property

New values of cells.
Public ReadOnly Property NewValues As MultiCellOperationInfo.CellValuesCollection

New values of cells. This has different meaning depending on which operation is being performed. When copy operation is being performed, this contains the text representation of the cell values. You can write custom logic to convert the cell values to text by getting the original cell value from the Cell object (from the Cells collection) and perform a custom conversion. When pasting, this contains the text representation of the cell value from the clipboard. You can convert the value to the cell’s data type using custom logic. After converting, set the new value back in this collection. When cutting, the new values are all DBNull. When performing Undo or Redo, the raw cell values are the values that are going to be set on the cells.

To traverse through the cell values, traverse through the Cells collection and index into the CellValues using the interating cell. See the following example.


Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also