I have 4 grid controlss on 4 MultiPage controls and am exporting to a single Excel file.  The problem is that when I load the spreadsheet into Excel, It loads in Protected View. When I click the 'Enable Editing' button each of the data cells shows a comment that says," The number in this cell is formatted as text or preceded by an apostrophy." I then have to click the warning and convert 'each' cell to a number. Trying to select a whole column and format to number does not work.  I've looked at some of the articles on formatting cells when exporting but don't think the discussed events are firing.
Here is my exporting code:
#Region "exporting"

    Private struct As xls.ExportStructure = New xls.ExportStructure()
    Private tbl As xls.Table = New xls.Table()
    Private row As Integer = 1
    Private col As Integer = 1
    Private gridControlsFound As List(Of RadGrid) = New List(Of RadGrid)

    Private Sub btnexport_Click(sender As Object, e As EventArgs) Handles btnexport.Click
        FindGridsRecursive()
        ExportGrid()
    End Sub
    Private Sub FindGridsRecursive()
        Dim i = 1
        For Each pg As RadPageView In RadPageView1.MultiPage.PageViews
            Select Case i
                Case 1
                    Dim Grid As RadGrid = FindControl("Week1")
                    gridControlsFound.Add(DirectCast(Grid, RadGrid))
                    i += 1
                Case 2
                    Dim Grid As RadGrid = pg.FindControl("Week2")
                    gridControlsFound.Add(DirectCast(Grid, RadGrid))
                    i += 1
                Case 3
                    Dim Grid As RadGrid = pg.FindControl("PayPeriod")
                    gridControlsFound.Add(DirectCast(Grid, RadGrid))
                    i += 1
                Case 4
                    Dim Grid As RadGrid = pg.FindControl("ACDetail")
                    gridControlsFound.Add(DirectCast(Grid, RadGrid))
            End Select
        Next
    End Sub

    Private isFirstItem As Boolean = True
    Private Sub GenerateTable(grid As RadGrid, singleTable As xls.Table)
        '       If ExportingType.SelectedValue = "1" Then
        singleTable = New xls.Table(grid.ID)
        row = 1
        col = 1
        'Else
        'If Not isFirstItem Then
        'row += 1
        'Else
        'isFirstItem = False
        'End If
        'End If

        Dim headerItem As GridHeaderItem = TryCast(grid.MasterTableView.GetItems(GridItemType.Header)(0), GridHeaderItem)

        For i As Integer = 3 To headerItem.Cells.Count - 1
            singleTable.Cells(i - 1, row).Value = headerItem.Cells(i).Text
        Next

        row += 1

        For Each item As GridDataItem In grid.MasterTableView.Items
            For Each column As GridColumn In grid.Columns
                singleTable.Cells(col, row).Value = item(column.UniqueName).Text
                col += 1
            Next
            col = 1
            row += 1
        Next

        struct.Tables.Add(singleTable)
    End Sub

    Private Sub ExportGrid()
        For Each grid As RadGrid In gridControlsFound
            grid.AllowPaging = False
            grid.CurrentPageIndex = 0
            getlocadate()
            grid.Rebind()
            GenerateTable(grid, tbl)
        Next

        Dim renderer As New xls.XlsBiffRenderer(struct)
        Dim renderedBytes As Byte() = renderer.Render()
        Response.Clear()
        Dim filename As String = loca & "|" & startDate.ToShortDateString & "<>" & endDate2.ToString & ".xls"
        Response.AppendHeader("Content-Disposition:", "attachment; filename=" & filename)
        Response.ContentType = "application/vnd.ms-excel"
        Response.BinaryWrite(renderedBytes)
        Response.End()
    End Sub
#End Region

Mycode: 
<telerik:RadAjaxManagerProxy ID="uxRMP" runat="server">
    <AjaxSettings>
        <ext:AjaxSetting AjaxControlID="bt_sencomments">
            <UpdatedControls>
                <ext:AjaxUpdatedControl ControlID="rpcommentcontainner" LoadingPanelID="uxLoadingPanel" UpdatePanelCssClass="" />
            </UpdatedControls>
        </ext:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManagerProxy>
 <div id="commentsContainer">
            <asp:Repeater runat="server" ID="rpcommentcontainner">
                <ItemTemplate>
                    <div class="commentWrapper">
                        <img alt="avatar" src='<%#ProcessingImage((byte[])Eval("ProfilePicture"))  %>'>
                        <span>
                            <strong>From: </strong><%# Eval("FullName")%> - <%#Eval("CreatedDate")%>
                            
                        </span>
                        <div class="commentContent">
                            <%# Eval("CommentContent")%>
                        </div>
                    </div>
                </ItemTemplate>
            </asp:Repeater>
        </div>
------------
I dont see effect, webpage have loaded again!
Do you have a method for me?

Hello

Can you accept  Zero : "0" or null value in ROOT item : please ?

I don't usually  use Null value in my database.

thanks
Olivier

Hi,

I implemented drilldown by following "https://github.com/telerik/aspnet-sdk/tree/master/PivotGrid/DrillDown". In my case, I am building a url and attaching to each cell to open detail report. If I view all the records in PivotGrid in single page, drill works as expected.

If it's multipage grid, then it's throwing an exception except in first page.

Please advice.

Hi Friends,
I am looking cloud-upload in rad editor
I think there is example of image upload inside rad-editor but I did not found any example to use cloud upload inside rad-editor can some one please list an example
So I can add a button , open RadCloudUpload in popup and upload images and list those images in rad-editor once upload

Thanks,
Shakti

It seems like no matter what i do, switching between HTML and code view removes the <!doctype> tag from my content.  I've recorded a video that demonstrates this behavior using your online demos. 

http://youtu.be/G7xR036tRXQ?hd=1

Is there a way to correct this behavior?

Thanks!
-Mark

Hi,

One of our page uses Radgrid and in client-side wanted to add one more column to the grid. Have been searching the whole site for any ideas or answers but no luck.

Below is the code

<script type="text/javascript">
 
Sys.Application.add_load(function () {

$("#master_DefaultContent_rts_ts1891_s4143_f3987srvgrid_ctl00 thead tr").append("<th>Primary Selection</th>");
$("#master_DefaultContent_rts_ts1891_s4143_f3987srvgrid_ctl00 tr:gt(0)").append("<td><input id='PrimarySelection' type='checkbox' onclick='handleClick(this);' /></td>");

var tableView = $find("<%= master_DefaultContent_rts_ts1891_s4143_f3987srvgrid %>").get_masterTableView();
tableView.rebind();

});

function handleClick(cb) {
var user = $(this).closest("tr").find("td:eq(1)").text();
alert(user);
userIds.splice($.inArray(user, userIds), 1);
if (cb.checked) {
userIds.push(user);
}
}

</script>

Thanks,
Prem

Hi,
Can someone guide me on how to generate hierarchical grids dynamically from code behind based on certain business rules that will reside in separate tabs of a RadTabStrip. The grids should be fully editable and ajaxified. The grids will bind to different data sources based on the rules.

Thanks.

​ for (int i = 0; i < 5; i++)
{

RadGrid RadGrid1 = new RadGrid();
if (i == 0)
RadGrid1.DataSource = crList0;
else RadGrid1.DataSource = crList1;
RadGrid1.DataBind();
RadGrid1.MasterTableView.DataKeyNames = new string[] { "FriendlyKey" };
RadGrid1.AllowPaging = true;
RadGrid1.AutoGenerateColumns = false;
RadGrid1.AutoGenerateEditColumn = true;
RadGrid1.Skin = "Metro";
RadGrid1.AllowPaging = false;
RadGrid1.ItemDataBound += new GridItemEventHandler(RadGrid1_ItemDataBound);
RadGrid1.RenderMode = RenderMode.Lightweight;

GridBoundColumn boundColumn1;
boundColumn1 = new GridBoundColumn();
boundColumn1.DataField = "FriendlyKey";
boundColumn1.HeaderText = "FriendlyKey";
boundColumn1.UniqueName = "FriendlyKey";
RadGrid1.MasterTableView.Columns.Add(boundColumn1);
GridBoundColumn boundColumn2;
boundColumn2 = new GridBoundColumn();
boundColumn2.DataField = "ApplicationName";
boundColumn2.HeaderText = "Application Name";
boundColumn2.UniqueName = "ApplicationName";
RadGrid1.MasterTableView.Columns.Add(boundColumn2);

//PlaceHolder1.Controls.Add(RadGrid1);

RadTab tab = new RadTab();
tab.Text = i.ToString();
tab.PageViewID = i.ToString();
myStrip.Tabs.Add(tab);
RadPageView pageView = new RadPageView();
pageView.ID = i.ToString();
RadMultiPage1.PageViews.Add(pageView);
RadMultiPage1.PageViews[i].Controls.Add(RadGrid1);

}

Hi,

How can i specify port number and SSL requirement for SocialShare EmailSettings of SocialShare control?

I have a form with multiple RadComboBoxes in it.  There are populated by the NeedsDataSource option.  The grid is being edited using InLine batch updating.  When the item is saved, the hash values are missing for the combobox fields unless I have opened them once while editing the record.  It seems I need to have the all populate.  How can I do that?

ASPX


C#