Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Cell Class / Strikethrough Property
Example


In This Topic
    Strikethrough Property (Cell)
    In This Topic
    Gets or sets a value that indicates whether Strikethrough take effect.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(False)>
    Public Property Strikethrough As Boolean
    'Usage
     
    Dim instance As Cell
    Dim value As Boolean
     
    instance.Strikethrough = value
     
    value = instance.Strikethrough
    [DefaultValue(false)]
    public bool Strikethrough {get; set;}

    Property Value

    true the cell will show strikethrough; otherwise, false. The default value is false.
    Example
    This example uses the Strikethrough property.
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Underline = true;
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Strikethrough = true;
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "Testing";
    gcSpreadSheet1.Sheets[0].Columns[2].Underline = true;
    gcSpreadSheet1.Sheets[0].Columns[2].Strikethrough = false;
    gcSpreadSheet1.Sheets[0].Rows[3].Underline = false;
    gcSpreadSheet1.Sheets[0].Rows[3].Strikethrough = true;
    listBox1.Items.Add(gcSpreadSheet1.Sheets[0].Cells[0, 0].ActualUnderline.ToString());
    listBox1.Items.Add(gcSpreadSheet1.Sheets[0].Cells[0, 0].ActualStrikethrough.ToString());
    
    private void button1_Click(object sender, RoutedEventArgs e)
            {
    gcSpreadSheet1.Sheets[0].Cells[0, 0].ResetUnderline();
    gcSpreadSheet1.Sheets[0].Cells[0, 0].ResetStrikethrough();
    gcSpreadSheet1.Sheets[0].Columns[2].ResetStrikethrough();
    gcSpreadSheet1.Sheets[0].Columns[2].ResetUnderline();
    gcSpreadSheet1.Sheets[0].Rows[3].ResetStrikethrough();
    gcSpreadSheet1.Sheets[0].Rows[3].ResetUnderline();
            }
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Underline = True
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Strikethrough = True
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "Testing"
    GcSpreadSheet1.Sheets(0).Columns(2).Underline = True
    GcSpreadSheet1.Sheets(0).Columns(2).Strikethrough = False
    GcSpreadSheet1.Sheets(0).Rows(3).Underline = False
    GcSpreadSheet1.Sheets(0).Rows(3).Strikethrough = True
    ListBox1.Items.Add(gcSpreadSheet1.Sheets(0).Cells(0, 0).ActualUnderline.ToString())
    ListBox1.Items.Add(gcSpreadSheet1.Sheets(0).Cells(0, 0).ActualStrikethrough.ToString())
    
    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
            GcSpreadSheet1.Sheets(0).Cells(0, 0).ResetUnderline()
            GcSpreadSheet1.Sheets(0).Cells(0, 0).ResetStrikethrough()
            GcSpreadSheet1.Sheets(0).Columns(2).ResetStrikethrough()
            GcSpreadSheet1.Sheets(0).Columns(2).ResetUnderline()
            GcSpreadSheet1.Sheets(0).Rows(3).ResetStrikethrough()
            GcSpreadSheet1.Sheets(0).Rows(3).ResetUnderline()
    End Sub
    See Also