Strikethrough Property (Cell)

Gets or sets a value that indicates whether Strikethrough take effect.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Strikethrough As System.Boolean

'Usage
 
Dim instance As Cell
Dim value As System.Boolean
 
instance.Strikethrough = value
 
value = instance.Strikethrough

[System.ComponentModel.DefaultValue()]
public System.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();
        }

VB.NET

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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Cell Class
Cell Members