CellValue.Empty Property

Returns an empty cell value.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public static CellValue Empty { get; }

VB.NET

Public Shared ReadOnly Property Empty As CellValue

Property Value

Type	Description
CellValue	A CellValue object specifying an empty value of a cell.

Remarks

Assign an object returned by the Empty property to the Range.Value property to clear cell content.

To ensure that a cell does not contain any data and its value is empty, use the CellValue.IsEmpty property.

For more information on cell values, refer to the Cell Data Types document.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Empty 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-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L153

    }
    invoice["G12"].Value = CellValue.Empty;
}

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/CS/SpreadsheetAddIn/Form1.cs#L203

if (value == null)
    return DevExpress.Spreadsheet.CellValue.Empty;
if (value is int)

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

public CellValue TryConvertFromObject(object value) {
    return CellValue.Empty;
}

VB.NET

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L157

    Next rowOffset
    invoice("G12").Value = CellValue.Empty
End Sub

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/VB/SpreadsheetAddIn/Form1.vb#L215

If value Is Nothing Then
    Return CellValue.Empty
End If

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

Public Function TryConvertFromObject(ByVal value As Object) As CellValue Implements IBindingRangeValueConverter.TryConvertFromObject
    Return CellValue.Empty
End Function