WebDataGrid - DataType vs DataFormatString
For a bounddatafield, if the dataType is numeric like decimal, as soon as you specify a DataFormatString, this field is treated as Text/String. When you export the grid to Excel, the column displays as Text and you can't apply SUM function to the column unless you convert it to Number. We have to give up the format in order to keep the SUM function. I'd love to know if there is a way to have both.