Cell.DisplayText Property

// Add a formula to the cell "A1".
worksheet.Cells["A1"].Formula = "= Now()";
// Format the cell's value.
worksheet.Cells["A1"].NumberFormat = "m/d/yy h:mm";
// Obtain the cell's display text.
// The property returns the current date and time
// (for instance, "6/19/2020 13:13").
string displayText1 = worksheet.Cells["A1"].DisplayText;

// Add a number to the cell "B1".
worksheet.Cells["B1"].Value = 1.6;
// Format the number as a percentage.
worksheet.Cells["B1"].NumberFormat = "0.0%";
// Obtain the cell's display text.
// The property returns "160.0%".
string displayText2 = worksheet.Cells["B1"].DisplayText;

' Add a formula to the cell "A1".
worksheet.Cells("A1").Formula = "= Now()"
' Format the cell's value.
worksheet.Cells("A1").NumberFormat = "m/d/yy h:mm"
' Obtain the cell's display text.
' The property returns the current date and time
' (for instance, "6/19/2020 13:13").
Dim displayText1 As String = worksheet.Cells("A1").DisplayText

' Add a number to the cell "B1".
worksheet.Cells("B1").Value = 1.6
' Format the number as a percentage.
worksheet.Cells("B1").NumberFormat = "0.0%"
' Obtain the cell's display text.
' The property returns "160.0%".
Dim displayText2 As String = worksheet.Cells("B1").DisplayText

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-how-to-use-a-worksheet-as-a-data-source-for-the-snap-report-t518070/CS/SpreadsheetDocumentServerAsDataSourceExample/MyColumnDetector.cs#L11

{
    return range[-1, offset].DisplayText;
}

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-how-to-use-a-worksheet-as-a-data-source-for-the-snap-report-t518070/VB/SpreadsheetDocumentServerAsDataSourceExample/MyColumnDetector.vb#L10

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