The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Borders.SetDiagonalBorders(Color, BorderLineStyle, DiagonalBorderType) Method

Sets cell diagonal borders.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

void SetDiagonalBorders(
    Color color,
    BorderLineStyle style,
    DiagonalBorderType diagonalBorderType
)
Sub SetDiagonalBorders(
    color As Color,
    style As BorderLineStyle,
    diagonalBorderType As DiagonalBorderType
)
void SetDiagonalBorders(
    Color color,
    BorderLineStyle style,
    DiagonalBorderType diagonalBorderType
)
Sub SetDiagonalBorders(
    color As Color,
    style As BorderLineStyle,
    diagonalBorderType As DiagonalBorderType
)
void SetDiagonalBorders(
    Color color,
    BorderLineStyle style,
    DiagonalBorderType diagonalBorderType
)
Sub SetDiagonalBorders(
    color As Color,
    style As BorderLineStyle,
    diagonalBorderType As DiagonalBorderType
)

Parameters

Name Type Description
color Color

A Color value specifying the border line color.

style BorderLineStyle

A BorderLineStyle enumeration member specifying the border line style.

diagonalBorderType DiagonalBorderType

A DiagonalBorderType enumerator member specifying the diagonal border type.

Parameters

Name Type Description
color Color

A Color value specifying the border line color.

style BorderLineStyle

A BorderLineStyle enumeration member specifying the border line style.

diagonalBorderType DiagonalBorderType

A DiagonalBorderType enumerator member specifying the diagonal border type.

Parameters

Name Type Description
color Color

A Color value specifying the border line color.

style BorderLineStyle

A BorderLineStyle enumeration member specifying the border line style.

diagonalBorderType DiagonalBorderType

A DiagonalBorderType enumerator member specifying the diagonal border type.

Remarks

The SetDiagonalBorders method specifies a diagonal border or borders for a single cell or range of cells (each cell within a range). Another way to set cell diagonal borders is to use the Borders.DiagonalBorderColor, Borders.DiagonalBorderLineStyle and Borders.DiagonalBorderType properties.

To specify any other cell borders (e.g., top, bottom, left, right, inside and outside borders), use corresponding properties and methods of the Borders object. Access this object via the cell's or cell range's Formatting.Borders property.

For examples on how to specify formatting for an individual cell and cell range, or modify a style, refer to the How to: Format a Cell or Range of Cells or How to: Create or Modify a Style document, respectively.

Examples

This example demonstrates how to specify different borders for individual cells and ranges of cells by modifying the Borders object.

Worksheet worksheet = workbook.Worksheets[0];

// Set each particular border for the cell.
Cell cellB2 = worksheet.Cells["B2"];
Borders cellB2Borders = cellB2.Borders;
cellB2Borders.LeftBorder.LineStyle = BorderLineStyle.MediumDashDot;
cellB2Borders.LeftBorder.Color = Color.Pink;
cellB2Borders.TopBorder.LineStyle = BorderLineStyle.MediumDashDotDot;
cellB2Borders.TopBorder.Color = Color.HotPink;
cellB2Borders.RightBorder.LineStyle = BorderLineStyle.MediumDashed;
cellB2Borders.RightBorder.Color = Color.DeepPink;
cellB2Borders.BottomBorder.LineStyle = BorderLineStyle.Medium;
cellB2Borders.BottomBorder.Color = Color.Red;
cellB2Borders.DiagonalBorderType = DiagonalBorderType.Up;
cellB2Borders.DiagonalBorderLineStyle = BorderLineStyle.Thick;
cellB2Borders.DiagonalBorderColor = Color.Red;

// Set diagonal borders for the cell.
Cell cellC4 = worksheet.Cells["C4"];
Borders cellC4Borders = cellC4.Borders;
cellC4Borders.SetDiagonalBorders(Color.Orange, BorderLineStyle.Double, DiagonalBorderType.UpAndDown);

// Set all outside borders for the cell in one step. 
Cell cellD6 = worksheet.Cells["D6"];
cellD6.Borders.SetOutsideBorders(Color.Gold, BorderLineStyle.Double);
// Set all borders for the range of cells in one step.
CellRange range1 = worksheet.Range["B8:F13"];
range1.Borders.SetAllBorders(Color.Green, BorderLineStyle.Double);

// Set all inside and outside borders separately for the range of cells.
CellRange range2 = worksheet.Range["C15:F18"];
range2.SetInsideBorders(Color.SkyBlue, BorderLineStyle.MediumDashed);
range2.Borders.SetOutsideBorders(Color.DeepSkyBlue, BorderLineStyle.Medium);

// Set all horizontal and vertical borders separately for the range of cells.
CellRange range3 = worksheet.Range["D21:F23"];
Formatting range3Formatting = range3.BeginUpdateFormatting();
Borders range3Borders = range3Formatting.Borders;
range3Borders.InsideHorizontalBorders.LineStyle = BorderLineStyle.MediumDashDot;
range3Borders.InsideHorizontalBorders.Color = Color.DarkBlue;
range3Borders.InsideVerticalBorders.LineStyle = BorderLineStyle.MediumDashDotDot;
range3Borders.InsideVerticalBorders.Color = Color.Blue;
range3.EndUpdateFormatting(range3Formatting);

// Set each particular border for the range of cell. 
CellRange range4 = worksheet.Range["E25:F26"];
Formatting range4Formatting = range4.BeginUpdateFormatting();
Borders range4Borders = range4Formatting.Borders;
range4Borders.SetOutsideBorders(Color.Black, BorderLineStyle.Thick);
range4Borders.LeftBorder.Color = Color.Violet;
range4Borders.TopBorder.Color = Color.Violet;
range4Borders.RightBorder.Color = Color.DarkViolet;
range4Borders.BottomBorder.Color = Color.DarkViolet;
range4Borders.DiagonalBorderType = DiagonalBorderType.UpAndDown;
range4Borders.DiagonalBorderLineStyle = BorderLineStyle.MediumDashed;
range4Borders.DiagonalBorderColor = Color.BlueViolet;
range4.EndUpdateFormatting(range4Formatting);
See Also