ValueObject.CreateListSource(CellValue[]) Method

Creates the ValueObject instance from the specified array of values.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public static ValueObject CreateListSource(
    CellValue[] values
)

VB.NET

Public Shared Function CreateListSource(
    values As CellValue()
) As ValueObject

Parameters

Name	Type	Description
values	CellValue[]	An array of CellValue objects.

Returns

Type	Description
ValueObject	A ValueObject instance.

Remarks

Use the CreateListSource method to create ValueObject from values of different kind. It allows you to combine worksheet cells, integers, strings and datetime values into a single object that can be used to populate a collection of data validation entries in the DataValidationCollection.Add method.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CreateListSource(CellValue[]) method.

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.

VB.NET

winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L52

Dim shipVia As CellValue() = {"Air", "Ground", "Ship"}
invoice.CustomCellInplaceEditors.Add(invoice("H18:I18"), CustomCellInplaceEditorType.ComboBox, ValueObject.CreateListSource(shipVia))
' Use the custom control (SpinEdit) as the in-place editor for cells containing the FOB value.