Class FormattableBorders

Provides access to border formatting properties for a formattable range.

Inheritance

object

AbstractBorders

FormattableBorders

Inherited Members

AbstractBorders.IsDefault()

AbstractBorders.From(AbstractBorders)

AbstractBorders.SetDiagonalCrossBorder(BorderStyle, SpreadsheetColor)

AbstractBorders.SetBoxBorder(BorderStyle, SpreadsheetColor)

AbstractBorders.SetBoxBorder(BorderStyle, Color)

AbstractBorders.SetAll(BorderStyle, SpreadsheetColor)

AbstractBorders.SetAll(BorderStyle)

AbstractBorders.SetOutline(BorderStyle, SpreadsheetColor)

AbstractBorders.SetOutline(BorderStyle)

AbstractBorders.Set(BorderType, BorderStyle, SpreadsheetColor)

AbstractBorders.Set(BorderType, BorderStyle)

AbstractBorders.Equals(object)

AbstractBorders.GetHashCode()

AbstractBorders.Outline

object.ToString()

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class FormattableBorders : AbstractBorders

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Constructors

FormattableBorders(AbstractFormattable)

Initializes a new FormattableBorders for the supplied workbook data.

Declaration

public FormattableBorders(AbstractFormattable formattable)

Parameters

Type	Name	Description
AbstractFormattable	formattable

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Properties

Bottom

Specifies the bottom border of the range.

Declaration

public override Border Bottom { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Bottom

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Diagonal

Specifies the diagonal border of the range.

Declaration

public override Border Diagonal { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Diagonal

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

DiagonalDown

Gets or sets whether the diagonal border goes down.

Declaration

public override bool DiagonalDown { get; set; }

Property Value

Type	Description
bool

Overrides

AbstractBorders.DiagonalDown

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

DiagonalUp

Gets or sets whether the diagonal border goes up.

Declaration

public override bool DiagonalUp { get; set; }

Property Value

Type	Description
bool

Overrides

AbstractBorders.DiagonalUp

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Horizontal

Get the horizontal border

Declaration

public override Border Horizontal { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Horizontal

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Left

Specifies the left border of the range.

Declaration

public override Border Left { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Left

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Right

Specifies the right border of the range.

Declaration

public override Border Right { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Right

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Top

Specifies the top border of the range.

Declaration

public override Border Top { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Top

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Vertical

Get the vertical border

Declaration

public override Border Vertical { get; set; }

Property Value

Type	Description
Border

Overrides

AbstractBorders.Vertical

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

Methods

SetBoxBorder(BorderStyle)

Updates the box border held by the FormattableBorders.

Declaration

public override void SetBoxBorder(BorderStyle borderStyle)

Parameters

Type	Name	Description
BorderStyle	borderStyle	The border style used by the operation.

Overrides

AbstractBorders.SetBoxBorder(BorderStyle)

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

SetDiagonalCrossBorder(BorderStyle)

Updates the diagonal cross border held by the FormattableBorders.

Declaration

public override void SetDiagonalCrossBorder(BorderStyle borderStyle)

Parameters

Type	Name	Description
BorderStyle	borderStyle	The border style used by the operation.

Overrides

AbstractBorders.SetDiagonalCrossBorder(BorderStyle)

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

SetDiagonalCrossBorder(BorderStyle, Color)

Updates the diagonal cross border held by the FormattableBorders.

Declaration

public override void SetDiagonalCrossBorder(BorderStyle borderStyle, Color color)

Parameters

Type	Name	Description
BorderStyle	borderStyle	The border style used by the operation.
Color	color	The color used by the operation.

Overrides

AbstractBorders.SetDiagonalCrossBorder(BorderStyle, Color)

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

SetDiagonalDownBorder(BorderStyle)

Updates the diagonal down border held by the FormattableBorders.

Declaration

public override void SetDiagonalDownBorder(BorderStyle borderStyle)

Parameters

Type	Name	Description
BorderStyle	borderStyle	The border style used by the operation.

Overrides

AbstractBorders.SetDiagonalDownBorder(BorderStyle)

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.

SetDiagonalUpBorder(BorderStyle)

Updates the diagonal up border held by the FormattableBorders.

Declaration

public override void SetDiagonalUpBorder(BorderStyle borderStyle)

Parameters

Type	Name	Description
BorderStyle	borderStyle	The border style used by the operation.

Overrides

AbstractBorders.SetDiagonalUpBorder(BorderStyle)

Remarks

FormattableBorders is obtained through the the Range.Borders property property and allows getting and setting border properties for an entire range.