Posted 8 September 2017, 2:39 pm EST
Currently I have a datatable I've populated and changed the column type of to an enum I have defined:
Active = 1,
The data that then fills this column comes in the form of an Int32 type from a SQL database. However, when I attach the datatable to a fpSpread.DataSource, the column displays the integer instead of the enumeration's .ToString() output. This is in contrast to how the DataGridView changes the display text to reflect the enum text.
My question is what do I have to do to have my Sheet display the text, while holding the correct integer value?
I even tried to overwrite the value using the enum directly once populated and the number is still displayed
fswsWorkUnits.Cells[0, 1].Value = Workflows.WorkFlowStatus.Inactive;