public static void CreateCollectionEditor <T>(CellsKind cell, Worksheet invoice, IEnumerable <T> source, Func <T, string> getValue)
{
var cellInfo = FindCell(cell);
var cellValues = source.Select(x => CellValue.FromObject(getValue(x))).ToArray();
invoice.CustomCellInplaceEditors.Add(invoice[cellInfo.CellRange], cellInfo.EditorType.Value,
ValueObject.CreateListSource(cellValues));
}
public bool TryConvert(object value, int columnIndex, out CellValue result)
{
if (columnIndex == 0)
{
result = DevExpress.Docs.Text.NumberInWords.Ordinal.ConvertToText((int)value);
return(true);
}
else
{
result = CellValue.FromObject(value);
}
return(true);
}
static void CellValueFromObjectViaCustomConverter(IWorkbook workbook)
{
workbook.BeginUpdate();
try {
#region #CustomCellValueConverter
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet.Cells["A1"];
cell.FillColor = Color.Orange;
cell.Value = CellValue.FromObject(cell.FillColor, new ColorToNameConverter());
// ...
#endregion #CustomCellValueConverter
}
finally {
workbook.EndUpdate();
}
}
