Spread for ASP.NET 7.0 Product Documentation
UnderlineFontStyle Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : UnderlineFontStyle Enumeration


Glossary Item Box

Specifies whether the underline font style is applied to the text.

Syntax

Visual Basic (Declaration) 
Public Enum UnderlineFontStyle 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As UnderlineFontStyle
C# 
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.
C#Copy Code
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);
        }
VB.NETCopy Code
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.