CellValue Class

A cell value in the chart’s underlying spreadsheet.

Namespace: DevExpress.Docs.Office

Assembly: DevExpress.Docs.Core.v26.1.dll

Declaration

C#

public class CellValue :
    OfficeObject

VB.NET

Public Class CellValue
    Inherits OfficeObject

Related API Members

The following members return CellValue objects:

• CellValue.Clone()
• ChartData.Item[Int32, String]
• ChartData.Item[String]

Remarks

For additional information on how to work with cell values, refer to the following help topic: Specify Series Data by a Cell Reference.

The following code snippet checks whether a cell value is numeric:

C#

using DevExpress.Docs.Office;
using DevExpress.Docs.Presentation;

// Specify data for the chart.
chart.Data[0, "A1"].NumericValue = 120;
chart.Data[0, "A2"].NumericValue = 95;
chart.Data[0, "A3"].NumericValue = 140;
chart.Data[0, "A4"].NumericValue = 100;
chart.Data[0, "A5"].NumericValue = 80;

CellValue value = chart.Data[0, "A1"];
if (value.IsNumeric) {
    // Do something
}

VB.NET

Imports DevExpress.Docs.Office
Imports DevExpress.Docs.Presentation

' Specify data for the chart.
chart.Data(0, "A1").NumericValue = 120
chart.Data(0, "A2").NumericValue = 95
chart.Data(0, "A3").NumericValue = 140
chart.Data(0, "A4").NumericValue = 100
chart.Data(0, "A5").NumericValue = 80

Dim value As CellValue = chart.Data(0, "A1")
If value.IsNumeric Then
  ' Do something
End If

Implements

ICloneable

Inheritance

Object

OfficeObject

CellValue