Cell.DisplayText Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

string DisplayText { get; }

VB.NET

ReadOnly Property DisplayText As String

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 Range.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.

Related GitHub Examples

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

how-to-use-a-spreadsheet-control-as-an-in-place-editor-gridcontrol-propertygridcontrol-e4777/CS/WindowsFormsApplication1/Form1.cs#L64

{
    newRow[j] = workSheet.Cells[i,j].DisplayText;
}

xtraspreadsheet-custom-draw-examples-e5044/CS/CustomDrawExample/Form1.cs#L37

Worksheet settingsSheet = spreadsheetControl1.Document.Worksheets["SheetSettings"];
string text = settingsSheet.Cells[0, e.ColumnIndex].DisplayText;
if (text != String.Empty)

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.cs#L76

        sheet["E4"].Value.TextValue, sheet["E6"].Value.TextValue, sheet["E8"].Value.TextValue,
        sheet.Cells["G4"].DisplayText, sheet.Cells["G6"].DisplayText);
}

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/CS/SuppliersExample/Form1.cs#L63

        sheet["E4"].Value.TextValue, sheet["E6"].Value.TextValue, sheet["E8"].Value.TextValue,
        sheet.Cells["G4"].DisplayText, sheet.Cells["G6"].DisplayText);
}

spreadsheet-document-api-use-worksheet-table-as-data-source/CS/SpreadsheetDocumentServerAsDataSourceExample/MyColumnDetector.cs#L8

public string GetColumnName(int index, int offset, Range range) {
    return range[-1, offset].DisplayText;
}

VB.NET

how-to-use-a-spreadsheet-control-as-an-in-place-editor-gridcontrol-propertygridcontrol-e4777/VB/WindowsFormsApplication1/Form1.vb#L65

For j As Integer = 0 To usedRange.ColumnCount - 1
    newRow(j) = workSheet.Cells(i,j).DisplayText
Next j

xtraspreadsheet-custom-draw-examples-e5044/VB/CustomDrawExample/Form1.vb#L37

'INSTANT VB NOTE: The variable text was renamed since Visual Basic does not handle local variables named the same as class members well:
            Dim text_Conflict As String = settingsSheet.Cells(0, e.ColumnIndex).DisplayText
            If text_Conflict <> String.Empty Then

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/VB/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.vb#L66

    ' Append a new row to the "Suppliers" data table.
    dataSet.Suppliers.AddSuppliersRow(sheet("C4").Value.TextValue, sheet("C6").Value.TextValue, sheet("C8").Value.TextValue, sheet("E4").Value.TextValue, sheet("E6").Value.TextValue, sheet("E8").Value.TextValue, sheet.Cells("G4").DisplayText, sheet.Cells("G6").DisplayText)
Catch ex As Exception

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/VB/SuppliersExample/Form1.vb#L60

    ' Append a new row to the "Suppliers" data table.
    dataSet.Suppliers.AddSuppliersRow(sheet("C4").Value.TextValue, sheet("C6").Value.TextValue, sheet("C8").Value.TextValue, sheet("E4").Value.TextValue, sheet("E6").Value.TextValue, sheet("E8").Value.TextValue, sheet.Cells("G4").DisplayText, sheet.Cells("G6").DisplayText)
Catch ex As Exception

spreadsheet-document-api-use-worksheet-table-as-data-source/VB/SpreadsheetDocumentServerAsDataSourceExample/MyColumnDetector.vb#L10

Public Function GetColumnName(ByVal index As Integer, ByVal offset As Integer, ByVal range As Range) As String Implements IDataSourceColumnTypeDetector.GetColumnName
    Return range(-1, offset).DisplayText
End Function