Resets the cell type for this row and makes this row inherit the cell type from the default row.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Sub ResetCellType() |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As AlternatingRow
instance.ResetCellType() |
| C# | |
|---|
public void ResetCellType() |
Example
This example shows the use of this method (as well as other resets) to reset the alternating row properties.
| C# | Copy Code |
|---|
fpSpread1.ActiveSheet.AlternatingRows[0].BackColor = Color.LightBlue;
fpSpread1.ActiveSheet.AlternatingRows[0].Border = new FarPoint.Win.LineBorder(Color.DarkBlue);
fpSpread1.ActiveSheet.AlternatingRows[0].CellType = new FarPoint.Win.Spread.CellType.GeneralCellType();
fpSpread1.ActiveSheet.AlternatingRows[0].Font = new Font("Comic Sans MS", 10);
fpSpread1.ActiveSheet.AlternatingRows[0].ForeColor = Color.Red;
fpSpread1.ActiveSheet.AlternatingRows[0].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
fpSpread1.ActiveSheet.AlternatingRows[0].Locked = false;
fpSpread1.ActiveSheet.AlternatingRows[0].VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Topn
private void button1Click(object sender, System.EventArgs e)
{
DialogResult dlg = new DialogResult();
dlg = MessageBox.Show("Reset the AlternatingRow??", "Reset", MessageBoxButtons.OKCancel);
if (dlg == DialogResult.OK)
{
fpSpread1.ActiveSheet.AlternatingRows[0].ResetBackColor();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetBorder();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetCellType();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetFont();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetForeColor();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetHorizontalAlignment();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetLocked();
fpSpread1.ActiveSheet.AlternatingRows[0].ResetVerticalAlignment();
}
}
|
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheet.AlternatingRows(0).BackColor = Color.LightBlue
FpSpread1.ActiveSheet.AlternatingRows(0).Border = New FarPoint.Win.LineBorder(Color.DarkBlue)
FpSpread1.ActiveSheet.AlternatingRows(0).CellType = New FarPoint.Win.Spread.CellType.GeneralCellType
FpSpread1.ActiveSheet.AlternatingRows(0).Font = New Font("Comic Sans MS", 10)
FpSpread1.ActiveSheet.AlternatingRows(0).ForeColor = Color.Red
FpSpread1.ActiveSheet.AlternatingRows(0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
FpSpread1.ActiveSheet.AlternatingRows(0).Locked = False
FpSpread1.ActiveSheet.AlternatingRows(0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top
Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dlg As New DialogResult
dlg = MessageBox.Show("Reset the AlternatingRow??", "Reset", MessageBoxButtons.OKCancel)
If dlg = DialogResult.OK Then
FpSpread1.ActiveSheet.AlternatingRows(0).ResetBackColor()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetBorder()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetCellType()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetFont()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetForeColor()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetHorizontalAlignment()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetLocked()
FpSpread1.ActiveSheet.AlternatingRows(0).ResetVerticalAlignment()
End If
End Sub |
Requirements
Target Platforms: 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
