corelibraries-devexpress-dot-export-dot-xl-dot-xlbordersbase.md
Gets or sets the line style of the cell’s bottom border.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public XlBorderLineStyle BottomLineStyle { get; set; }
Public Property BottomLineStyle As XlBorderLineStyle
| Type | Description |
|---|---|
| XlBorderLineStyle |
An XlBorderLineStyle enumeration member that specifies the line style of a border.
|
Available values:
Show 14 items
| Name | Description |
|---|---|
| None |
Specifies that a border is not painted.
| | Thin |
Specifies the thin solid border line.
| | Medium |
Specifies the medium solid border line.
| | Dashed |
Specifies the thin dashed border line.
| | Dotted |
Specifies the thin dotted border line.
| | Thick |
Specifies the thick solid border line.
| | Double |
Specifies the double border line.
| | Hair |
Specifies the hair border line.
| | MediumDashed |
Specifies the medium dashed border line.
| | DashDot |
Specifies the thin dash-dotted border line.
| | MediumDashDot |
Specifies the medium dash-dotted border line.
| | DashDotDot |
Specifies the thin dash-dot-dotted border line.
| | MediumDashDotDot |
Specifies the medium dash-dot-dotted border line.
| | SlantDashDot |
Specifies the medium slanted dash-dotted border line.
|
To set the color of a bottom border, use the XlBorder.BottomColor property. If you specify the BottomLineStyle for a border without setting it’s color, the automatic color will be used.
For more information on how to customize cell borders, refer to the How to: Add Cell Borders example.
The following code snippets (auto-collected from DevExpress Examples) contain references to the BottomLineStyle property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
excel-export-library-generate-sales-analysis-report/CS/XLExportExample/Form1.cs#L47
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0);
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium;
excel-export-library-generate-a-list-of-employees/CS/XLExportExample/Form1.cs#L48
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0);
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium;
}
excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L204
formatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.5);
formatting.Border.BottomLineStyle = XlBorderLineStyle.Medium;
excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L52
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0)
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium
' Specify formatting settings for the total row.
excel-export-library-generate-a-list-of-employees/VB/XLExportExample/Form1.vb#L52
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0)
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium
End Sub
excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L216
formatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.5)
formatting.Border.BottomLineStyle = XlBorderLineStyle.Medium
See Also