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);
The scenario which should be covered is selecting some data from Excel and pasting in the new row of RadGridView. This is an easy way for inserting data in the grid.
IMPROVE. RadGridView - add the current selection and the new selection to the SelectionChanging event.
Add similar like DateColumn.DateTimeMode property for GridViewDateTimeColumn. Link in MSDN: http://msdn.microsoft.com/en-us/library/system.data.datacolumn.datetimemode.aspx
Allow RadGridVIew Exports to perform independently in BackgroundWorker without suspending UI thread of RadGridView.
ADD. RadGridView - add support for self-reference hierarchy for child levels as well
GridTimeColumn will display and allow user to edit with TimeEditor Time and Time-Span column types from the Database.
Add Page format functionality (like header, footer, page number) when you export a RadGridView to pdf similar to RadPrintDocument. http://www.telerik.com/help/winforms/tpf-printing-support-radprintdocument-header-and-footer.html
Currently there is no way to sort group rows in RadGridView.
Print support for RadGridView.
ADD. RadGridView - add ability to move the column with the expanders to different position then the first one Resolution: Set the SelfReferenceExpanderColumn property of the MasterTemplate to the preferred column. Here is the code snippet: radGridView1.MasterTemplate.SelfReferenceExpanderColumn = this.radGridView1.MasterTemplate.Columns[4];
A user should be able to disable executing any of the cut/copy/paste (ctrl+x, ctrl+c, ctrl+v) commands.
ADD. RadGridView - add support for scrolling the grid while dragging in SelectionMode = CellSelect
Currently sub-property binding is supported in the MasterTemplate of the grid (level 1). We should make this functionality available in lower levels when users are creating an object relational hierarchy.
ADD. RadGridView - add functionality to automatically scroll to the needed position, during multiple selection of cells with the traslucent rectangle. MultiSelect = true SelectionMode = cells
IMPROVE. RadGridView - add ability to change and customize the font (bold, italic, etc) in the ConditionalFormattingForm
ADD. RadGridView should support filtering operations when custom TypeConverters are used.
ADD. RadGridView - add the ability to group by a certain column and display the groups sorted by the values of another column