OverlineFontStyle Enumeration

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Enum OverlineFontStyle 
   Inherits System.Enum

'Usage
 
Dim instance As OverlineFontStyle

public enum OverlineFontStyle : System.Enum

Members

Member	Description
None	Specifies no overline text.
NotSet	Specifies that the overline font style is not set.
Overline	Specifies overline text.

Example

This example sets the OverlineFontStyle 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);
        }

VB.NET

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.OverlineFontStyle

Reference

FarPoint.Web.Spread Namespace

Product Support Forum | Print this page