DataTableOptions.Font Property

Retrieves font settings used to display text in a data table.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ShapeTextFont Font { get; }

VB.NET

ReadOnly Property Font As ShapeTextFont

Property Value

Type	Description
ShapeTextFont	A ShapeTextFont object that contains font settings.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Font
ChartObject	.DataTable .Font

Remarks

Note

SpreadsheetControl does not display highlight and fill colors in data tables.

The following code snippet creates line charts, displays the data table, and specifies the data table’s font parameters:

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;

// Change font parameters
dataTableOptions.Font.Name = "Helvetica";
dataTableOptions.Font.Size = 12;

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

' Change font parameters
dataTableOptions.Font.Name = "Helvetica"
dataTableOptions.Font.Size = 12