Does Grid support export to excel (xlsx) when groupping is enabled?

I was not able to find any demo?

 Hi,

I am a RadGrid newbie and would appreciate help with a few items.

I am using RadGrid in a SharePoint 2010 visual web-part.  I am also using server side code.

Skin = office2010blue

Here are my questions:

1. How do I declaratively set the font for the rows (not just the header)?

2. How do I specify the columns and their width?

3. How do I at runtime set the background color of individual cells and for entire row?

4. How do I stop inheriting the font color from twitter bootstrap css?

Hi ,

how can i get target grid cell index or row key when i drag and drop my cell with same grid. I have attached screen shot and sample code below. Any help will be appreciated.

 var dragging = false;
            var dragContainer = null;
            var currentDraggedElement = null;

            function onColumnCreated(sender, args) {
                // hook to columns mousedown event;
                $addHandler(sender.get_element(), "mousedown", onMouseDown);
            }

            function onGridCreated() {
                // hook to columns document's events
                $addHandler(document, "mouseup", onMouseUp);
                $addHandler(document, "mousemove", onMouseMove);
            }

            function onMouseMove(e) {
                if (dragging && dragContainer) // if in drag mode move the dragged container
                {
                    dragContainer.style.display = "";
                    dragContainer.style.position = "absolute";
                    Telerik.Web.UI.Grid.PositionDragElement(dragContainer, e);
                }
            }

            function onMouseDown(e) {
                //create the dragged container
                dragging = true;
                dragContainer = document.createElement("div");
                dragContainer.style.position = "absolute";
                dragContainer.style.zIndex = 99999;
                dragContainer.style.display = "none";
                document.body.insertBefore(dragContainer, document.body.firstChild);

                var currentElement = Telerik.Web.UI.Grid.GetCurrentElement(e);

                //get parent row element then get the OnwerTableView in order to get objects for the column            
                var row = Telerik.Web.UI.Grid.GetFirstParentByTagName(currentElement, "tr");
                if (row.id == "")
                    return;

                var item = $find('<%=grdAvailability.ClientID%>').get_masterTableView()._getRowByIndexOrItemIndexHierarchical(row)

                var ownerTableViewId = item.id.split("__")[0];
                var ownerTableView = $find(ownerTableViewId);

                if (!ownerTableView)
                    return;

                currentDraggedElement = currentElement;//store the current cell as we will need it inside the mouseup event                    
                dragContainer.innerHTML = currentElement.innerHTML;
                Telerik.Web.UI.Grid.ClearDocumentEvents();
            }

            function onMouseUp(e) {
                if (dragging) {
                    // get the element that you are dropping on 
                    var currentElement = Telerik.Web.UI.Grid.GetCurrentElement(e);
                    if (dragContainer !== null && dragContainer.innerHTML !==null) {
                        currentElement.value = dragContainer.innerHTML;
                        currentDraggedElement.isDragged = true;
                        PageMethods.GetReservationKeyWithDocNo(dragContainer.innerHTML,
                                                       function (result) {
                                                           if (result !== null) {
                                                               url = '../Reservation/Update/NewMoveReservation.aspx?RK=' + result;
                                                               ShowRadWindow('Move Folio', url, 650, 530)
                                                           }
                                                       }, function (e) {
                                                           alert(e.get_message);
                                                           $telerik.$.unblockUI();
                                                       });
                    }
                   
                   
                    Telerik.Web.UI.Grid.RestoreDocumentEvents();
                    document.body.removeChild(dragContainer);
                    dragContainer = null;
                    currentDraggedElement = null;
                }
                dragging = false;
            }
            function onGridDestroying() {
                $removeHandler(document, "mouseup", onMouseUp);
                $removeHandler(document, "mousemove", onMouseMove);
            }

Hi,

I have a RadPivotGrid which has Item as RowField, Location as ColumnField and Quantity as Aggregate Field. The Aggregate field is a textbox. The user will change the values in the textboxes and clicks on the "Update" button. Now on the Update button click, I have to get the values from all the textboxes and update them with the values in database. Can you please help how to read the values in the textboxes?

Thanks

Hi from France,

I came from old Infragistics software version (7x) and now i'm the last in my society to work on new project with telerik software.

recently i use, splitter,dock and tiles with no problem.

But now I'm using for the first time a grid, a hierachical grid.

before use my sql table (idRubrique,libelle,iOrdre,idRubriqueParent,...)

i prefert test how it's work with simulate datatable, because when i was getting sql table i need to modify data before bind it.

This is my sample to create grid hierarchical content, and i don't know why i don't see my last child (t3) on grid.

If someone can open my eyes ? Thanks ! (excuse me for my bad english)

The code behind: 

Dim t1 As New System.Data.DataTable
        t1.Columns.Add("idRubrique")
        t1.Columns.Add("idRubriqueParent")
        t1.Columns.Add("DEPENSES")
        t1.Columns.Add("BilanAcquisition")
        t1.Columns.Add("ESTIMEES")

        Dim r As Data.DataRow

        r = t1.NewRow
        r.ItemArray = {1, 0, "FONCIER", "TEST", Nothing}
        t1.Rows.Add(r)

        r = t1.NewRow
        r.ItemArray = {2, 0, "VRD", Nothing, Nothing}
        t1.Rows.Add(r)

        Dim t2 As New System.Data.DataTable
        t2.Columns.Add("idRubrique")
        t2.Columns.Add("idRubriqueParent")
        t2.Columns.Add("DEPENSES")
        t2.Columns.Add("BILANACQUISITION")
        t2.Columns.Add("ESTIMEES")

        r = t2.NewRow
        r.ItemArray = {1, 1, "Acquisition", Nothing, Nothing}
        t2.Rows.Add(r)

        r = t2.NewRow
        r.ItemArray = {2, 1, "Frais de Notaire", Nothing, Nothing}
        t2.Rows.Add(r)

        r = t2.NewRow
        r.ItemArray = {3, 1, "Archeologie", Nothing, Nothing}
        t2.Rows.Add(r)

        Dim t3 As New System.Data.DataTable
        t3.Columns.Add("idRubrique")
        t3.Columns.Add("idRubriqueParent")
        t3.Columns.Add("DEPENSES")
        t3.Columns.Add("BILANACQUISITION")
        t3.Columns.Add("ESTIMEES")

        r = t3.NewRow
        r.ItemArray = {1, 1, "Frais liés à la négociation foncière", Nothing, Nothing}
        t3.Rows.Add(r)

        r = t3.NewRow
        r.ItemArray = {2, 1, "Aquisition Terrain", Nothing, Nothing}
        t3.Rows.Add(r)

        r = t3.NewRow
        r.ItemArray = {3, 1, "Commission d'acquisition", Nothing, Nothing}
        t3.Rows.Add(r)

        RadGrid1.MasterTableView.DataSource = t1
        RadGrid1.MasterTableView.DataKeyNames = New String() {"idRubrique"}

        'LV2
        Dim tableViewOrders As New Telerik.Web.UI.GridTableView(RadGrid1)
        tableViewOrders.DataSource = t2
        tableViewOrders.DataKeyNames = New String() {"idRubrique"}

        Dim relationFields As Telerik.Web.UI.GridRelationFields = New Telerik.Web.UI.GridRelationFields()
        relationFields.MasterKeyField = "idRubrique"
        relationFields.DetailKeyField = "idRubriqueParent"
        tableViewOrders.ParentTableRelation.Add(relationFields)
        RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders)

        'LV3
        Dim tableViewOrders2 As New Telerik.Web.UI.GridTableView(RadGrid1)
        tableViewOrders2.DataSource = t3
        tableViewOrders2.DataKeyNames = New String() {"idRubrique"}

        Dim relationFields2 As Telerik.Web.UI.GridRelationFields = New Telerik.Web.UI.GridRelationFields()
        relationFields2.MasterKeyField = "idRubrique"
        relationFields2.DetailKeyField = "idRubriqueParent"
        tableViewOrders2.ParentTableRelation.Add(relationFields2)
        tableViewOrders.DetailTables.Add(tableViewOrders2)

Hi,

I'm starting to profile my site locally (using http://www.prefix.io/) and I see the following exceptions that I can't seem to control:

Telerik.Web.UI.InsecureExternalStyleSheetException: empty string
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference

System.ArgumentException: Illegal characters in path.
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.QuickDemand
  at System.IO.Path.GetFullPath
  at System.Web.Util.FileUtil.IsSuspiciousPhysicalPath
  at System.IO.Path.CheckInvalidPathChars
  at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters
  at System.Security.Permissions.FileIOPermission.AddPathList
  at System.Security.Permissions.FileIOPermission..ctor
  at System.Web.InternalSecurityPermissions.PathDiscovery
  at System.Web.HttpRequest.MapPath
  at System.Web.HttpServerUtility.MapPath
  at Telerik.Web.UI.ExternalScriptHelper.ResolveSecurePath
  at Telerik.Web.UI.RadScriptManager.OnResolveScriptReference

I can't seem to actually catch this exception during run time (debugging with all exceptions turned on), nor do I see any way to ignore/stop that exception from being used. Any ideas?