DataTableOptions.ShowHorizontalBorder Property

Gets or sets whether horizontal borders are displayed.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool ShowHorizontalBorder { get; set; }

VB.NET

Property ShowHorizontalBorder As Boolean

Property Value

Type	Description
Boolean	true to display horizontal borders; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowHorizontalBorder
ChartObject	.DataTable .ShowHorizontalBorder

Example

The following code snippet creates line charts, displays the data table, and hides its [whose] vertical and horizontal borders:

C#

using DevExpress.Spreadsheet;
using DevExpress.Spreadsheet.Charts;
//...

Worksheet worksheet = workbook.Worksheets["chartTask5"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a chart and specify its location
Chart chart = worksheet.Charts.Add(ChartType.Line, worksheet["B2:C8"]);
chart.TopLeftCell = worksheet.Cells["F2"];
chart.BottomRightCell = worksheet.Cells["L14"];

// Display the data table
DataTableOptions dataTableOptions = chart.DataTable;
dataTableOptions.Visible = true;
dataTableOptions.ShowLegendKeys = false;

// Display only table outline
dataTableOptions.ShowVerticalBorder = false;
dataTableOptions.ShowHorizontalBorder = false;

VB.NET

Imports DevExpress.Spreadsheet
Imports DevExpress.Spreadsheet.Charts
'...

Private worksheet As Worksheet = workbook.Worksheets("chartTask5")
workbook.Worksheets.ActiveWorksheet = worksheet

' Create a chart and specify its location
Dim chart As Chart = worksheet.Charts.Add(ChartType.Line, worksheet("B2:C8"))
chart.TopLeftCell = worksheet.Cells("F2")
chart.BottomRightCell = worksheet.Cells("L14")

' Display the data table
Dim dataTableOptions As DataTableOptions = chart.DataTable
dataTableOptions.Visible = True
dataTableOptions.ShowLegendKeys = False

' Display only table outline
dataTableOptions.ShowVerticalBorder = false
dataTableOptions.ShowHorizontalBorder = false

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowHorizontalBorder 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.

C#

wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/CodeExamples/DataTableActions.cs#L40

dataTableOptions.ShowVerticalBorder = false;
dataTableOptions.ShowHorizontalBorder = false;
#endregion #ChangeDataTableBorders

winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/DataTableActions.cs#L40

dataTableOptions.ShowVerticalBorder = false;
dataTableOptions.ShowHorizontalBorder = false;
#endregion #ChangeDataTableBorders

VB.NET

wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/DataTableActions.vb#L36

dataTableOptions.ShowVerticalBorder = False
dataTableOptions.ShowHorizontalBorder = False
'            #End Region ' #ChangeDataTableBorders