hello

Please answer the questions in the link below.

No reply after two days.

I am waiting for a reply..

Please Help me

https://www.telerik.com/forums/radlistbox-i-want-to-insert-just-below-the-selected-index-in-radlistbox1

Hello
Attacted File : RadListBox.png, 544016CancelTransferEventAndAddManullyItems.aspx, 544016CancelTransferEventAndAddManullyItems.aspx.cs

Please Check the Attacted File(RadListBox)

Please answer Questions-1 & Questions-2

Question - 1 ) If you use AllowTransfer="true"
Is it possible to use InsertAt(It means inserting at the index position of the RadListBox I want) function while using AllowTransfer="true" function?

Can I use [ InsertAt ] function while using  AllowTransfer="true" for RadListBox ?

RadListBox, I want to Insert just below the Selected Index in RadListBox1.

***The goal is to migrate the source code below to RadListBox and AllowTransfer="true"

if (RadListBox2.SelectedIndex >= 0)
{
   for (int i = 0; i < RadListBox2.Items.Count; i++)
   {
       if (RadListBox2.Items[i].Selected)
      {
         arraylist.Add(RadListBox2.Items[i]);
      }
  }

int nSelectIndex = RadListBox1.SelectedIndex + 1;

 for (int j = 0; j < arraylist.Count; j++)
{
     RadListBox1.Items.Insert(nSelectIndex, ((ListItem)arraylist[j]));
     nSelectIndex++;

     RadListBox2.Items.Remove(((ListItem)arraylist[j]));
}
}

Question - 2 ) If you don't use AllowTransfer="true"
Using a generic RadListBox, Is it possible to migrate the code below to RadListBox?

Does RadListBox have an  <<< InsertAt >>>> function?

if (RadListBox2.SelectedIndex >= 0)
{
   for (int i = 0; i < RadListBox2.Items.Count; i++)
   {
       if (RadListBox2.Items[i].Selected)
      {
         arraylist.Add(RadListBox2.Items[i]);
      }
  }

int nSelectIndex = RadListBox1.SelectedIndex + 1;

 for (int j = 0; j < arraylist.Count; j++)
{
     RadListBox1.Items.Insert(nSelectIndex, ((ListItem)arraylist[j]));
     nSelectIndex++;

     RadListBox2.Items.Remove(((ListItem)arraylist[j]));
}
}

Please Help me. waiting for response.

Hi,

RadSpreadsheet for ASP.NET AJAX
My goal is to type values in the cells (numbers, letters, etc) having a simple background image as background: this can be useful

if the image is a technical drawing and the cells could represent measurements....

more or less:

it's possible in some way?

Thanks for the support.

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.