officefileapi-devexpress-dot-spreadsheet-dot-valueobject-dot-createlistsource-x28-devexpress-dot-spreadsheet-dot-cellvalue-x29.md
Creates the ValueObject instance from the specified array of values.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public static ValueObject CreateListSource(
CellValue[] values
)
Public Shared Function CreateListSource(
values As CellValue()
) As ValueObject
| Name | Type | Description |
|---|---|---|
| values | CellValue[] |
An array of CellValue objects.
|
| Type | Description |
|---|---|
| ValueObject |
A ValueObject instance.
|
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.
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.
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.
See Also