Hello

Attacted File : problem1.png, problem2.xlsx, problem3.png

Can't save excel in Radgrid.

If you look at the attached file(Problem1.png), there is a GridColumnGroup-Header.
However, the GridColumnGroup-Header does not appear in this Excel attached file (Problem3.png).

 protected void ibtnExcel_Click(object sender, ImageClickEventArgs e)
        {
            ConfigureExport();
            gv.MasterTableView.ExportToExcel();
        }

        private void ConfigureExport()
        {
            if (gv == null)
                throw new ArgumentNullException("gv");

            string fileName = DateTime.Now.ToShortDateString();

            //Export settings
            gv.ExportSettings.HideStructureColumns = false;
            gv.ExportSettings.SuppressColumnDataFormatStrings = false;
            gv.ExportSettings.ExportOnlyData = true;
            gv.ExportSettings.IgnorePaging =  true;
            gv.ExportSettings.OpenInNewWindow = true;
            gv.ExportSettings.FileName = fileName.Replace("-", "").ToString();

            //Excel Format
            gv.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
            //SetExportFileName(radGrid);
        }

<telerik:radgrid id="gv" runat="server" allowpaging="true" allowsorting="true" enableembeddedskins="false" height="610px"
                                                            cellspacing="0" autogeneratecolumns="false" gridlines="Both" pagesize="100" onneeddatasource="gv_NeedDataSource" onexcelexportcellformatting="gv_ExcelExportCellFormatting">
                       <ClientSettings>
                               <Selecting AllowRowSelect="True" />
                               <Resizing AllowColumnResize="True" AllowRowResize="false" ResizeGridOnColumnResize="false" ClipCellContentOnResize="true" EnableRealTimeResize="false" AllowResizeToFit="false" />

                                          <Scrolling AllowScroll="True" UseStaticHeaders="True" FrozenColumnsCount="4"></Scrolling>
                             </ClientSettings>
                               <MasterTableView AlternatingItemStyle-Wrap="true" EnableNoRecordsTemplate="true" ShowHeader="true" ShowHeadersWhenNoRecords="true" Width="100%" ItemStyle-Wrap="false" HeaderStyle-Wrap="false" HeaderStyle-Font-Bold="true" TableLayout="Fixed">
                                 <ColumnGroups>


                               

                                 </ColumnGroups>
                                 <Columns>   

                                   

                                    <telerik:GridBoundColumn DataField="ALC_CODE" HeaderText="ALC" Visible="true">
                                      <HeaderStyle Width="100px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" />
                                      <ItemStyle Width="100px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                 

                                    <telerik:GridBoundColumn DataField="D1_2_TOTAL" HeaderText="D+1<br>(1~2T)" Visible="true">
                                      <HeaderStyle Width="60px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" />
                                      <ItemStyle Width="60px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn DataField="D1_6_TOTAL" HeaderText="D+1<br>(3~6T)" Visible="true">
                                      <HeaderStyle Width="60px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" />
                                      <ItemStyle Width="60px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn DataField="D0_PLAN" HeaderText="금일계획" Visible="true">
                                      <HeaderStyle Width="60px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" />
                                      <ItemStyle Width="60px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D0T01" HeaderText="1T" Visible="true" ColumnGroupName="T1">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D0T02" HeaderText="2T" Visible="true" ColumnGroupName="T2">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D0T03" HeaderText="3T" Visible="true" ColumnGroupName="T3">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D0T04" HeaderText="4T" Visible="true" ColumnGroupName="T4">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D0T05" HeaderText="5T" Visible="true" ColumnGroupName="T5">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D0T06" HeaderText="6T" Visible="true" ColumnGroupName="T6">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D0T07" HeaderText="7T" Visible="true" ColumnGroupName="T7">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D0T08" HeaderText="8T" Visible="true" ColumnGroupName="T8">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D0T09" HeaderText="9T" Visible="true" ColumnGroupName="T9">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D0T10" HeaderText="10T" Visible="true" ColumnGroupName="T10">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>




                                        <telerik:GridBoundColumn DataField="D1T01" HeaderText="1T" Visible="true" ColumnGroupName="D1T1">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn DataField="D1T02" HeaderText="2T" Visible="true" ColumnGroupName="D1T2">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D1T03" HeaderText="3T" Visible="true" ColumnGroupName="D1T3">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D1T04" HeaderText="4T" Visible="true" ColumnGroupName="D1T4">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D1T05" HeaderText="5T" Visible="true" ColumnGroupName="D1T5">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                    <telerik:GridBoundColumn DataField="D1T06" HeaderText="6T" Visible="true" ColumnGroupName="D1T6">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D1T07" HeaderText="7T" Visible="true" ColumnGroupName="D1T7">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D1T08" HeaderText="8T" Visible="true" ColumnGroupName="D1T8">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>


                                        <telerik:GridBoundColumn DataField="D1T09" HeaderText="9T" Visible="true" ColumnGroupName="D1T9">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>



                                       <telerik:GridBoundColumn DataField="D1T10" HeaderText="10T" Visible="true" ColumnGroupName="D1T10">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="D4T10" HeaderText="10T" Visible="true" ColumnGroupName="D4T10">
                                  <HeaderStyle Width="65px" CssClass="main_column_header2"  HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
                                  <ItemStyle Width="65px"  CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
                                    </telerik:GridBoundColumn>



                                  </Columns>
                                  <PagerStyle AlwaysVisible="true" PageSizeControlType="RadDropDownList" PageSizes="20,50,100,200 "  FirstPageImageUrl="../../image/list_paging_v1.gif" PrevPageImageUrl="../../image/list_paging_v2.gif" NextPageImageUrl="../../image/list_paging_v3.gif" LastPageImageUrl="../../image/list_paging_v4.gif"></PagerStyle>
                                  <NoRecordsTemplate>
                                    <div style="text-align: center; height: 35px;padding-top:20px;">
                                    </div>
                                  </NoRecordsTemplate>
                              </MasterTableView>
                            </telerik:radgrid>

My grid works with aggregates (Count, Average, Max) or with grouping, but not with both.  When i try to add a group when i have any columns that display aggregates it misaligns the columns and the drag/drops column header gets stuck (see screenshot).  The only fix is to refresh the page.

[pre group screenshot]

[post group screenshot]

[Grid Code]

    @(Html.Kendo().Grid<FullResultsView>()
        .Name(Model.GridName)
        .Columns(columns =>
        {
       columns.Bound(c => c.Code).Width(200);
        columns.Bound(c => c.FacilityIdWithName).Width(250).Title("Facility");
        columns.Bound(c => c.SampleType).Title("Sample Type").Width(120);
        columns.Bound(c => c.Result).Width(120).ClientFooterTemplate("Max:#=max#, Avg:#=average#").ClientGroupFooterTemplate("Max:#=max#, Avg:#=average#");
        columns.Bound(c => c.SequenceNumber).Title("Sequence Number").Hidden(true).Width(120);
        columns.Bound(c => c.RequiresReTest).Title("Requires Re-Test").Hidden(true).Width(120);
        })
        .ToolBar(tools => tools.Excel())
        .Scrollable(s => s.Endless(true).Height(200))
        .Filterable()
        .Sortable()
        .Groupable()
        .ColumnMenu(cm => cm.Enabled(true))
        .Resizable(resize => resize.Columns(true))
        .Reorderable(reorder => reorder.Columns(true))
        .Excel(excel => excel
        .FileName("Data Export.xlsx")
        .Filterable(true)
        .ProxyURL(Url.Action("Report_Export", "Report"))
        )
        .Editable(editable => editable.Enabled(false))
        .DataSource(Model.GridName+"dataSource").AutoBind(false)
        )

[Datasource Code]

        @(Html.Kendo().DataSource<FullLeadResultsView>()
        .Name(Model.GridName+"dataSource").Ajax(dataSource => dataSource
        .Sort(s => s.Add(sa => sa.ResultCreatedOnLocal).Descending())
        .PageSize(1000)
        .Events(events =>
        {
        events.Error("function(e){error_handler(e,'" + Model.GridName + "');}");
        })
        .Model(model =>
        {
        model.Id(m => m.Id);
        model.Field(f => f.Id).Editable(false);
        })
        .Aggregates(ag =>
        {
        ag.Add(f => f.Code).Count();
        ag.Add(f => f.Result).Average().Max();
        })
        .Read(read => read.Action("Report_Read", "Report", Model.Search).Data("onGridRead"))
        )
        )

Hello.

Attacted File : Res27_aspx.txt, Res27_aspx_cs.txt, Problem.png

I wrote the code as you taught me. 

But, I wrote the code as you taught, But it doesn't work.

I have attached the file in question.

Question 1 ) Click the link below.

https://www.telerik.com/forums/in-radgrid-backcolor-of-selected-cell#1550610

I wrote the code as you taught me.
However, if I write the code as you taught, it doesn't work.
Please check the attached files Res27.aspx and Res27.aspx.cs to see what the problem is.
In Res27.aspx, The code below is written.
html body .RadGrid .pinkCell{
        background-image:none;
        background-color: lightpink;
    }
In Res27.aspx.cs, The code below is written.
item.CssClass = "pinkCell";

Question 2) Click the link below.

https://www.telerik.com/forums/radgrid#1552730

Please check the attached file (Res27.aspx, Res27.aspx.cs)

setTimeout(function() {  sender.get_masterTableView().fireCommand("cellSelected", output);})

In Attached file Res27.aspx, There is function cellSelected(sender, args).

In Attached file Res27.aspx.cs , There is if (e.CommandName == "cellSelected").

Please check the attached file Res27.aspx , Res27.aspx.cs.

Question 3) Click the link below.

https://www.telerik.com/forums/gap-between-radgrid-and-radtextbox#1553328

There is a gap between the Radgrid and RadTextbox.

I want there to be no gap between the grid and the box.

In Attached file Res27.aspx , There is 

My grid have one column it's start with 0 (As example:001120435)

Here's my grid data

Here's my excel export code,

 Protected Sub btnExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExcel.Click
        radgrid.ExportSettings.FileName = "ListofApplicant"
        radgrid.ExportSettings.IgnorePaging = True
        radgrid.ExportSettings.ExportOnlyData = True
        radgrid.ExportSettings.OpenInNewWindow = True
        radgrid.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx
        radgrid.MasterTableView.ExportToExcel()
    End Sub

Here's my excel result,

I did the two latest upgrades and I cannot compile my project now. Every Telerik reference gives "The type or namespace name 'Telerik' could not be found"

I am always nervous when I do Telerik upgrades.

I emptied the licenses.licx file, which is frequently the problem.

In the Webconfig

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Web.UI" publicKeyToken="121FAE78165BA3D4" />
        <bindingRedirect oldVersion="1.0.0.0-2018.3.909.45" newVersion="2020.1.114.45" />
      </dependentAssembly>
      <dependentAssembly>

The version is now 2022.1.19.45. Why does the upgrade not set the correct settings?

Should it be

  like all the other dependenticies?

This change gives the same errors.  I assume the publicKeyToken is unchanged.

Hello!

Using RadGrid client side batch editing.

Is there a way to capture when the updates are complete when using the saveTableChanges?  Adding a callback function maybe?

I need to display a "saving" layer/message to let users know something is happening and prevent them from interacting with the grid.

Here is my code snippet:

                    var batchManager = grid1.get_batchEditingManager();
                    showLoadingPanel(true, 'Saving...');
                    batchManager.saveTableChanges(tables) ;
                    showLoadingPanel(false);

I would like to be able to ShowLoadingPanel before saving the table changes and hide it after the changes have been saved.

Thanks

Is it possible to hide specific rows but still have access to them client side?  I need to pull and update cell data from the hidden rows.  My updates are handled in batch edit value changed function.  Any ideas or advise would be great.  

I have tried to hide/show with batch edit opening and closing but this makes the rows visible to the user while they are editing fields.

If I hide the rows server side in pre render event I can't seem to access client side, unless I am doing something incorrectly.

Thanks!

Hi Team,

How can we restrict the auto correction of Raddatepicker input.?

Say example, if I enter 25/10/2020 in raddatepicker (if format  is MM/DD/YYYY) it is automatically changes to 10/25/2020 when I click outside!.

I don't want to rearrange the date. Instead it should warn depends on the date format.

Also if we enter date as "00" and month as "00" , it shows an invalid date!. Instead can we make it as a warning as we enter invalid date in RaddatePicker ?

Please suggest your thoughts or comments.

Note : we are using a bit old dll version shown below

RadControls for ASP.NET AJAX Q1 2013

Regards,

Ramesh.