Sample of Standard Header Names (there will be between 25-50 standard column names):Įxample: If you had an Excel spreadsheet like the following columns:Īnd utilized the application to drag-and-drop the standard column header names, the result would be: Otherwise the drag and drop operation will be performed with plain postback.Would like Excel 2007 Add-In to provide ability for users to rename column headers by dragging and dropping the header name from a list of standard column names.ġ) Ability to drag standard column header name from a list and replace the current column headerĢ) Visual indicator that the standard header name from the list has been used (change color, or bold, or check-marked, etc.)ģ) Ability to edit list of standard header names to add/remove/edit entries from the listĤ) Ability to order the standard header names (move a standard header name up or down in list) For richer end userĮxperience you can ajaxify the grid via RadAjaxManager and use RadAjaxLoadingPanel
This depends strictly on the underlying data source and its data model. Will have to undertake in order to change the source structure may vary because To this event allows you to reorder the items in the source grid or remove themĪnd append these rows to a destination grid instance. On the server there is a single event (named OnRowDrop). This eventĬannot be cancelled and have the same set of arguments as the OnRowDropping client event.
#EXCEL DRAG AND DROP COLUMN CODE#
The OnRowDropped event can be handled if you would like to execute some extra code logic prior to the server-side OnRowDrop event rising.
The general client-side event signature of RadGrid for ASP.NET AJAX. Again, the syntax of the event handler follows To determine the destination element or set it explicitly use the get_destinationHtmlElement()Īnd set_destinationHtmlElement() properties that can be accessed through Where args is the second argument passed to the OnRowDropping handler. If this element does not meet your criteria forĪcceptable target, cancel the operation by setting t_cancel(true)
The syntax of the event handler follows the general client-side event signature Some conditional check and determine whether to cancel the drag operation or not.