Hi,

I'm exporting a grid in Xlsx format. I tried many methods to set borders on excel cells but in no avail.

Is it even possible ? Are borders supported ?

Hello Telerik Team
I have a usercontrol.ascx in which I have put a RadComboBox.
I am trying to generate the RadComboBoxItems and HeaderTemplate and ItemTemplate dynamically.
I have succeded in generating the HeaderTemplate.
But I have an issue in ItemTemplate generation.
I have tried the following Code in the usercontrol.ascx where ‘drpLookup’ is the RadComboBox ID:

protected override void OnPreRender(EventArgs e)
        {
            if (!IsPostBack)
            {
                drpLookup.Attributes.Add("LookupType", LookupType);
                drpLookup.Attributes.Add("ServiceClass", ServiceClass);
            }
            HeaderTemplate.ServiceClass = drpLookup.Attributes["ServiceClass"];
            ItemTemplate.ServiceClass = drpLookup.Attributes["ServiceClass"];
            base.OnPreRender(e);
        }
protected override void OnInit(EventArgs e)
        {
            drpLookup.HeaderTemplate = new HeaderTemplate();
            drpLookup.ItemTemplate = new ItemTemplate();
            base.OnInit(e);
        }
protected void drpLookup_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
        {
                     Datatable dt=//some code to get data
                     BindDrpLookup(dt, properties, DataValueFieldName, DataTextFieldName);
        }
private void BindDrpLookup(DataTable dataTable, List<PropertyInfo> properties, string DataValueFieldName, string DataTextFieldName)
        {
            drpLookup.DataValueField = DataValueFieldName;
            drpLookup.DataTextField = DataTextFieldName;

            foreach (DataRow l in dataTable.Rows)
            {
                RadComboBoxItem item = new RadComboBoxItem();

                foreach (var p in properties)
                {
                    item.Attributes.Add(p.Name, l[p.Name].ToString());
                }
                drpLookup.Items.Add(item);
  item.DataBind();
            }
            drpLookup.DataBind();

        }


private class ItemTemplate : ITemplate
        {
            public static string ServiceClass { get; set; }
            public void InstantiateIn(Control container)
            {
                PropertyInfo propertyWithLookupValue =//Do Some Code To get values

                HtmlTable table = new HtmlTable();
                table.Width = "100%";
                table.CellPadding = 0;
                table.CellSpacing = 0;
                HtmlTableRow row = new HtmlTableRow();
                row.Style.Add("width", "100%");
                int numberofColumns = propertiesWithLookup.Count - 1;
                string ColumnWidth = Math.Round((decimal)(100 / numberofColumns)).ToString();
                foreach (PropertyInfo p in propertiesWithLookup)
                {
                    if (p != propertyWithLookupValue)
                    {
                        HtmlTableCell cell = new HtmlTableCell();
                        cell.Width = ColumnWidth + "%";
                        cell.ID = p.Name;
                        cell.DataBinding += new EventHandler(cell_DataBinding);
                        row.Controls.Add(cell);
                    }
                }
                table.Controls.Add(row);
                container.Controls.Add(table);
            }

            private void cell_DataBinding(object sender, EventArgs e)
            {
                HtmlTableCell target = (HtmlTableCell)sender;
                RadComboBoxItem item = (RadComboBoxItem)target.BindingContainer;
                string[] id = target.ClientID.Split('_');
string itemText = (string)DataBinder.Eval(item, id[id.Length - 1].ToString());
                target.InnerText = itemText;
            }
        }



The issue is that in the cell_DataBinding event at the following line of Code:
string itemText = (string)DataBinder.Eval(item, id[id.Length - 1].ToString());


I get an exception with the following Error message:
{"DataBinding: 'Telerik.Web.UI.RadComboBoxItem' does not contain a property with the name 'Name'."}

And following stacktrace:

   at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName)
   at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts)
   at System.Web.UI.DataBinder.Eval(Object container, String expression)
   at APA.UI.Web.APAAdmin.Views.UserControls.Lookup.ItemTemplate.cell_DataBinding(Object sender, EventArgs e) in D:\Projects\Framework\2015\APA\APA.UI.Web.APAAdmin\Views\UserControls\Lookup.ascx.cs:line 217
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at System.Web.UI.Control.DataBind()
   at System.Web.UI.Control.DataBindChildren()



any helps will be very much appreciated !

http://demos.telerik.com/aspnet-mvc/diagram/editing

Is there an example or is it possible to replicate the shape editing/text insert shown in this mvc project in aspnet-ajax diagram project?

Thank you

Andy

Hi, i have a problem to fire the delete event using a GridButtonColumn with ConfirmDialogType="RadWindow", it show the dialog but when I click ok button it only close the window but don't invoke the delete event on the server, if I change it to ConfirmDialogType="Classic" it works ok.

 

here is the implementation

 

Hello
I would like a help, I have a Grid with two GridClientSelectColumn columns as coidgo below, I would like to perform a validation when the user select the column yes it uncheck the column, please someone has an example

 

                                            <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" Width="100%" 
                                                 AllowMultiRowSelection="true" OnPreRender="RadGrid1_PreRender"  Visible="true"   OnItemCreated="RadGrid1_ItemDataBound"  AutoGenerateColumns ="false" EnableViewState="true" > 
                                                  <ClientSettings Selecting-AllowRowSelect="true"  >
                                                  </ClientSettings>
                                            <MasterTableView  PageSize="8" AllowPaging="True" Width="100%"
                                                       DataKeyNames="ID_PID" >
                                                <Columns>
                                                           <telerik:GridBoundColumn DataField="ID_PID" DataType="System.Int32" 
                                                                    FilterControlAltText="Filter ID_PID column" HeaderText="ID_PID" 
                                                                    ReadOnly="True" SortExpression="ID_PID" UniqueName="ID_PID" Visible="false">
                                                                </telerik:GridBoundColumn>
                                                                <telerik:GridBoundColumn DataField="PERGUNTA_PID" 
                                                                    FilterControlAltText="Filter PERGUNTA_PID column" HeaderText="PERGUNTA_PID" 
                                                                    SortExpression="PERGUNTA_PID" UniqueName="PERGUNTA_PID">
                                                                </telerik:GridBoundColumn>
                                                                <telerik:GridBoundColumn DataField="RESPOSTA" 
                                                                    FilterControlAltText="Filter RESPOSTA column" DataFormatString="<strong>{0}</strong>"  HeaderText="RESPOSTA" 
                                                                    SortExpression="RESPOSTA" UniqueName="RESPOSTA">
                                                                </telerik:GridBoundColumn>
                                                                <telerik:GridBoundColumn DataField="FONTE" 
                                                                    FilterControlAltText="Filter FONTE column" HeaderText="FONTE"  Visible="false"
                                                                    SortExpression="FONTE" UniqueName="FONTE">
                                                                </telerik:GridBoundColumn>
                                                                



                                                                <telerik:GridClientSelectColumn UniqueName="VERDADEIRO"  >
                                                           </telerik:GridClientSelectColumn>
            
                                                                <telerik:GridClientSelectColumn UniqueName="FALSO"   >
                                                       </telerik:GridClientSelectColumn>
                                                                                                             
                                                   </Columns>


                                                                             
                                            </MasterTableView>

Print preview of Google chrome/Fire fox/IE browsers not showing the content inside the Radsplitter [Radpanes]. Please find the attached screenshot

 

Expected:

Print preview of the browser will show the content 

 

Currently the content which we are using ours is loading inside the radpanes. Is there any restricted access for the loading previews in browser print.

Hi,

Currently i have a column in my radGrid which is a date. i am displaying this data now as string.

my requirement is as follows

1. this column has the possibility of null value. when the value is null to display data as -
2. the data should be formatted as dd MMM yyyy
3. when clicking on the header the data should be sorted as date.

So currently since my column is in string when i click on the header it is sorting the data as string i.e the data will be sorted as follows

(for descending)

27 Jan 2017 
23 Mar 2017
21 Jul 2017
19 Jan 2017 

 

it is suppose to be sorted as

21 Jul 2017

23 Mar 2017

27 Jan 2017 

19 Jan 2017 

I am dynamically creating additional fields based on your example in the Online Demo. Here is my scenario:

I add 3 files. Each file has a label and input. If I "Remove" the second row (rowIndex = 2), the file is removed, but the label and input field is still displayed. I have not been successful removing the additional fields. 
I have attempted to use a variation of the old code provided in the RadUpload control:
var li = row.parentNode.parentNode;
var ul = input.parentNode.parentNode.parentNode;
etc., etc...
But, that does not work with the RadAsyncUpload control in javascript.
So, I have tried different things that revolve around "parentNode.removeChild()" or $(row.parent).remove() or var extraFields = row.parentNode.childNodes row.parentNode.removeChild(extraFields[i])  to no avail. Is there a simple way of completely deleting the custom controls / metadata, or, do I need to get the index and cycle through the collection and delete at the desired index? 
Any direction is greatly appreciated.

I wanted to use asyncupload control with multiple files uploading. I wanted to bind meta data for each file before uploading. I should be able to bind text box and a drop down list on each row apart from the file name and remove link. Can you please provide best solution with sample code ?

Hi i am using BatchEdit mode of Telerik Control binding to Objectdatasource as following markup , i want to change text of boundcolumn INVOICEUNIT from telerik ComboBox1 attribute "Attributes['Unit']" ,on selectionindexchanged event of ComboBox1 , and calculate values for another boundcolumn INVOICEAMOUNT on the basis of Attributes['Unit'] * boundcolumn INVOICENUMBER ,how can i do this with javascript so that calculated values are persisted in post back also ? I have tried with event ClientEvents-OnBatchEditSetCellValue ,but when values are changed in that boundcolumn ,it can be edited anymore ,if i click that cell (after values are changed in OnBatchEditSetCellValue)