Greg S

Well - this fixed the empty string problem, but created a new problem.Date data types are being handled differently in the Excel export. After this update, sql columns defined as "datetime" are being exported as numbers. You can reformat the numbers as dates in Excel, but that's a huge hassle to do for multiple columns every time you export. Before this update, users would not have to do this.

Is there a way to configure the radgrid Excel export so it formats dates?

Greg S

I was running the code below and changing the formatting of every cell to "@". This is because my page is actually a generic report processor, and if the data started with a character that Excel interpreted as a function (e.g. "-", "+", etc.) then it would cause problems. The previous version of the controls however still exported a date in a date format however. After upgrading to the newest version however, dates were exported as their Excel numeric equivalent.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.