ADD. Paging functionality for RadGridView.

Currently each grid is exported in a separate excel file with one or more sheets. It will be good to add the possibility to export a grid to a separate sheet in an existing file.

Currently the Excel-Like filtering popup displays all values regardless if other columns contain filter expressions.

Deleted as a duplicate of http://teampulse.telerik.com/view#item/96230

ADD. RadGridView - add export of ViewDefiniton

1. Add export functionality for ColumnGroupsViewDefinition 
2. Add export functionality for HtmlViewDefinition 

AutoSizeRows is not currently supported.

Add the ability to print all levels of a hierarchical RadGridView.

Allow drag and drop of rows, when RadGridView is in bound mode.

Please refer to the following article demonstrating how to do that: http://www.telerik.com/help/winforms/gridview-rows-drag-and-drop.html

Filtering in self-reference hierarchy should be performed over the rows from all levels

Currently all exported cells are static.

Horizontal scroll bar should appear when auto size columns mode is enabled and columns has minimum width that cause the total width of the columns to be more that the visible area width.

When exporting to HTML or PDF image columns should be exported properly.

One may want to perform a search operatior over the records of RadGridView instead of filtering them. The search should be incremental and should scroll to the first position that contains a record that matches the search criteria.

Save and load layout to work in all view definitions.

When RadGridView is displaying a self-referencing it should be able to show the data with ColumnGroupsViewDefinition and HtmlViewDefinition.

A title or caption that can be positioned on the top or bottom of RadGridView that shows a text defined by developer.

Add a Card view layout.

When columns are reorder by the user RadGridView should persist these settings through the Save/LoadLayout routines.

Load-On-Demand - full lazy mode support

WORKAROUND:

The format of the file that ExportToExcelML creates is ExcelML which is an extended XML. If you do not want to receive the message, you have to change the extension of the file to ".xml". Even though the file will have an xml extension, it will still be associated with MS Excel and will be opened by Excel.There is a possibility to turn this warning message off on the client machine. You can read more about that on the following blog post - Excel 2007 Extension Warning On Opening Excel Workbook from a Web Site (http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx)

Another workaround is to use Interop to open the file and excel and save it in XLSX format. However, this would require Administrator or Power User  (http://msdn.microsoft.com/en-us/library/ms173186%28v=vs.80%29.aspx). A reference from COM to the corresponding office version should be added. Here is the code for saving:

    ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);

    exporter.ExportVisualSettings = true;

    string tempPath = Path.GetTempPath();

    tempPath += "tempgrid.xls";

    exporter.RunExport(tempPath);

    Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();

    if (app == null)

    {

        Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct.");

        return;

    }

    app.Visible = false;

    app.Interactive = false;

    Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(tempPath);

    string desktopPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

    desktopPath += "\\grid.xlsx";

    wb.SaveAs(desktopPath, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault);

    wb.Close();

    app.Quit();

    Marshal.ReleaseComObject(wb);

    Marshal.ReleaseComObject(app);

    File.Delete(tempPath);

There should be a fit mode which allows one to print a RadGridView on two pages.