GrapeCity.Xaml.SpreadSheet.Data
Value Property (Cell)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Cell Class : Value Property
Gets or sets the value in a cell.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property Value As Object
'Usage
 
Dim instance As Cell
Dim value As Object
 
instance.Value = value
 
value = instance.Value
[DefaultValue()]
public object Value {get; set;}

Property Value

The value in the cell. The default value is null.
Example
This example sets the Value property.
gcSpreadSheet1.AutoClipboard = true;
gcSpreadSheet1.ClipBoardOptions = GrapeCity.Xaml.SpreadSheet.Data.ClipboardPasteOptions.All;
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = "Copy";
gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = "Cut";

private void Button_Click_1(object sender, RoutedEventArgs e)
  {
        GrapeCity.Xaml.SpreadSheet.Data.CellRange r;
       r = new  GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 2, 2);
       GrapeCity.Xaml.SpreadSheet.Data.CellRange r2;
       r2 = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(3, 3, 2, 2);
       GrapeCity.Xaml.SpreadSheet.UI.GcSpreadSheet test;
        
       test = gcSpreadSheet1;
       test.View.ClipboardCopy(r);
       //test.View.ClipboardCut(r);
       test.View.ClipboardPaste(r2);       
   }
GcSpreadSheet1.AutoClipboard = True
GcSpreadSheet1.ClipBoardOptions = GrapeCity.Xaml.SpreadSheet.Data.ClipboardPasteOptions.All
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = "Copy"
GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = "Cut"
 
    Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
        Dim r As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 2, 2)
        Dim r2 As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(3, 3, 2, 2)
        Dim test = GcSpreadSheet1
        test.View.ClipboardCopy(r)
        'test.View.ClipboardCut(r)
        test.View.ClipboardPaste(r2)        
    End Sub
See Also

Reference

Cell Class
Cell Members