FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SpreadFontStyle Class > SpreadFontStyle Constructor : SpreadFontStyle Constructor(RegularBoldItalicFontStyle,StrikeoutFontStyle,UnderlineFontStyle,OverlineFontStyle) |
'Declaration Public Function New( _ ByVal regularBoldItalic As RegularBoldItalicFontStyle, _ ByVal strikeout As StrikeoutFontStyle, _ ByVal underline As UnderlineFontStyle, _ ByVal overline As OverlineFontStyle _ )
'Usage Dim regularBoldItalic As RegularBoldItalicFontStyle Dim strikeout As StrikeoutFontStyle Dim underline As UnderlineFontStyle Dim overline As OverlineFontStyle Dim instance As New SpreadFontStyle(regularBoldItalic, strikeout, underline, overline)
public SpreadFontStyle( RegularBoldItalicFontStyle regularBoldItalic, StrikeoutFontStyle strikeout, UnderlineFontStyle underline, OverlineFontStyle overline )
protected void Page_Load(object sender, EventArgs e) { if (this.IsPostBack) return; FpSpread1.Sheets[0].Cells[0, 0].Value = 3; FpSpread1.Sheets[0].Cells[1, 0].Value = 2; FpSpread1.Sheets[0].Cells[1, 1].Value = 10; FpSpread1.Sheets[0].Cells[0, 2].Value = 1; } protected void Button1_Click(object sender, EventArgs e) { //Unary comparison CF FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10); unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo; unary.Value = 10; unary.BackColor = System.Drawing.Color.Red; unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold, FarPoint.Web.Spread.StrikeoutFontStyle.None, FarPoint.Web.Spread.UnderlineFontStyle.Underline, FarPoint.Web.Spread.OverlineFontStyle.None); FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary); }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FpSpread1.Sheets(0).Cells(0, 0).Value = 3 FpSpread1.Sheets(0).Cells(1, 0).Value = 2 FpSpread1.Sheets(0).Cells(1, 1).Value = 10 FpSpread1.Sheets(0).Cells(0, 2).Value = 1 End Sub Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click 'Unary comparison CF Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10) unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo unary.Value = 10 unary.BackColor = Drawing.Color.Red unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold, FarPoint.Web.Spread.StrikeoutFontStyle.None, FarPoint.Web.Spread.UnderlineFontStyle.Underline, FarPoint.Web.Spread.OverlineFontStyle.None) FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary) End Sub
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6