Spread for ASP.NET 9.0 Product Documentation
UnderlineFontStyle Enumeration
Example Example 


Specifies whether the underline font style is applied to the text.
Syntax
'Declaration
 
Public Enum UnderlineFontStyle 
   Inherits System.Enum
'Usage
 
Dim instance As UnderlineFontStyle
public enum UnderlineFontStyle : System.Enum 
Members
MemberDescription
NoneSpecifies no underlined text.
NotSetSpecifies that the underline font style is not set.
UnderlineSpecifies underlined text.
Example
This example sets the UnderlineFontStyle enumeration.
protected void Page_Load(object sender, System.EventArgs e)
        {
            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)
        {
            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 = Color.Red;
            unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.Underline);
            unary.FontStyle.Underline = FarPoint.Web.Spread.UnderlineFontStyle.Underline;
            unary.FontStyle.Overline = FarPoint.Web.Spread.OverlineFontStyle.Overline;
            unary.FontStyle.Strikeout = FarPoint.Web.Spread.StrikeoutFontStyle.Strikeout;

            FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule between = new FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(false, 1, false, 20, false);
            between.FirstValue = 1;
            between.SecondValue = 20;
            between.IsNotBetween = true;
            between.BackColor = Color.Bisque;

            //SetConditionalFormatting Overload
            FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, false, unary, between);
        }
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.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      
        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.UnderlineFontStyle.Underline)
        unary.FontStyle.Underline = FarPoint.Web.Spread.UnderlineFontStyle.Underline
        unary.FontStyle.Overline = FarPoint.Web.Spread.OverlineFontStyle.Overline
        unary.FontStyle.Strikeout = FarPoint.Web.Spread.StrikeoutFontStyle.Strikeout

        Dim between As New FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(False, 1, False, 20, False)
        between.FirstValue = 1
        between.SecondValue = 20
        between.IsNotBetween = True
        between.BackColor = Drawing.Color.Bisque

        'SetConditionalFormatting Overload
        FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, False, unary, between)
    End Sub
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.UnderlineFontStyle

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FarPoint.Web.Spread Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.