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

Cell.DisplayText Property

Gets the string that specifies the formatted cell value as it is displayed.

Namespace: DevExpress.Spreadsheet

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

Declaration

string DisplayText { get; }
ReadOnly Property DisplayText As String
string DisplayText { get; }
ReadOnly Property DisplayText As String
string DisplayText { get; }
ReadOnly Property DisplayText As String

Property Value

Type Description
String

A String value that specifies the cell's display text.

Property Value

Type Description
String

A String value that specifies the cell's display text.

Property Value

Type Description
String

A String value that specifies the cell's display text.

Remarks

A CellValue object specifies a piece of data contained in a cell - cell value. It is accessed via the CellRange.Value property. A cell can contain data of the numeric, text, Boolean or error type. You can apply different number formats to display a cell's numeric data in the appropriate view. For example, a numeric value can be displayed as a decimal number, a percentage, currency value, etc. Also, a number contained in a cell can be formatted as a date and time value (see the Dates and Times in Cells document for details). The DisplayText property returns the string that specifies how the formatted value is displayed in the cell.

Cell Value Number Format Cell Display Value
cell.Value = 41253 cell.NumberFormat = "$#,##0.00" cell.DisplayText = "$41,253.00"
cell.Value = 41253 cell.NumberFormat = "d-mmm-yy" cell.DisplayText = "10-Dec-12"

The Cell.IsDisplayedAsDateTime property indicates whether the cell value is formatted as date and time.

See Also