FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > AlternatingRow Class : ResetCellType Method |
'Declaration Public Sub ResetCellType()
'Usage Dim instance As AlternatingRow instance.ResetCellType()
public void ResetCellType()
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(); } }
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8