I am returning bound data to a RadGridView via a DataTable. In the process I need to modify one of the columns which is contains a timestamp value (seconds from midnight) to display time. The code below shows where I intercept the column in the CellFormatting event and convert the timestamp value to a DateSerial, which I then set the CellElement.Text to.
Based on this function the grid displays the timestamp exactly as I want - ie:
44233 is displayed correctly as
12:17:13 PM in the grid. However, when export the grid to Excel, the timestamp value (44233) is exported and not the new CellElement.Text.
Am I doing something wrong or can I modify the column via the exporter before it gets into Excel? Thanks