Hello!

I've got a grid that has multiple, overlapping rows of data.  The purpose of this grid is to build an exportable Excel spreadsheet. 

Here would be a very simple example of how I need the spreadsheet to look in Excel

A                B                C                D                E

Name         DOB          Status       Amount 

John Q       12/12/20    Active       $100.00

As you can see - the Excel Columns are the standard, default A..E. 

Row 0 holds the "Headers" for the data directly beneath. 

Row 1 holds the actual data - but when I export this to Excel, I want to be able to tell it "This cell is text" or "This cell is a Date/Time" etc.

Is this possible? 

Thanks for the great products!

Curtis. 

Hi,

I have a multi-column combobox that is data-bound to a binding source control.

Then in the form code I have the following lines:

Me.RadMultiColumnComboBox1.DropDownStyle = RadDropDownStyle.DropDownList
Me.RadMultiColumnComboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend
Me.RadMultiColumnComboBox1.SelectedIndex = -1

The last line, in particular, is important in our case because we want to prevent the selection of the first record by default. Everything works fine except when there's only one record in the list.

When that happens, the textbox element picks up the display member of the lone item as soon as the user clicks the drop-down arrow. The text remains after the pop-up closes even if the user does not explicitly select the solo record.  This gives the user the false impression that a value has been set, but in reality the underlying value is still null.

We then found out that the second line of code above is what is causing this unwanted behavior. When commented out, an MCCB with a single record does not exhibit the problem.

We would like to keep the SuggestAppend feature working (i.e., in the case of multiple records), so is there a way to resolve this issue without having to resort to checking the number of records in the list?

I thought there was a way on a radgridview that the user could hit B and be taken to the first entry where the B is. I thought i saw that the gridview was able to do that, but it doesn't seem to be working for me. It might be that i need to setup a custom keydown, not sure.

Thanks in advance.

Hello,

The feature is to Change the part of rows background-color based on a cell

I want to set the BackColor of a row to a specific color based on information from a field.

The structure is different from classic Winform.

Can you help me please ?

Hello Team,
We are using the Telerik control RadSpinEditor in our windows application. we have set the Maximum Property as 1000 & Minimum Property as -100 for the SpinEditor.

Property ScreenShot : https://prnt.sc/5djfulRc2gGM

So when i click the Upper arrow & Down arrow the values are set correctly.

My Issue : When i trying to type the value on spineditor its allow to type more number of values. but it should allow only 1000. Please help us to resolve this issue. Video link added for your reference.

Video link : https://suganya-gmail.tinytake.com/df/1267028/thumbnail?type=attachments&version_no=0&file_version_no=0&thumbnail_size=preview

Hello, when my application adds items to the auto complete box pragmatically I turn them red. I wish to hide the X button so the user cannot remove them. Is this possible? I noticed there is a ShowRemoveButton property on the control but that seems like it is for all tokens?  Here is some of my code. Thank you for the assistance. 

Private Sub AddToken(ByVal ac As RadAutoCompleteBox, ByVal email As String)

Hello Team,
We are using the telerik RadGridView in our windows application.  In the grid we are having the header sorting option, after sorting we need to clear the sorting dynamically when click the remove filter icon. Video link mentioned for your reference. Please help us to resolve this issue.

Video link : https://suganya-gmail.tinytake.com/df/1265942/thumbnail?type=attachments&version_no=0&file_version_no=0&thumbnail_size=preview

Thanks in advance.

Hi, good day.

We use the same shortcut key in different places, where they can be in the general RadMenuItem but also on a menuitem in a RadContextMenu tied to a text box.

But, when i am focused on the text box and hit F12, it fires the radmenuitem F12 shortcut and never fires the contextmenu option. The ZIP file has the program that shows this.

Within windows using the standard menu and context menu, the context menu shortcut is fired and not the general menu shortcut. Windows seems to be treating it as you are on this field and there is a context menu with this shortcut - fire that event. Whereas Telerik seems to be looking at the general menu before the context menu.

Am i doing something wrong to get the context menu shortcut to fire and not the general menu shortcut?

Hello,

I have an unbound hierarchical radgridview that has a parent template and two child templates. The master templates work fine, I can insert, type or paste data. But in the child template, I cannot add any data or rows. It remains blank. Can you tell me what I am doing wrong?

My code are below.

Sorry I am using UI Winform

Thank you in advance.

private void TestForm_Load(object sender, EventArgs e)
        {            
         // Setup the Master Template
                RadGrid.MasterTemplate.Columns.Add          (new GridViewTextBoxColumn("Name"));
                RadGrid.MasterTemplate.Columns.Add          (new GridViewTextBoxColumn("Description"));
                RadGrid.MasterTemplate.Columns.Add          (new GridViewDateTimeColumn("Date"));
                RadGrid.MasterTemplate.Columns.Add          (new GridViewDecimalColumn ("Value"));
                RadGrid.MasterTemplate.Columns.Add          (new GridViewTextBoxColumn("Status"));
                RadGrid.MasterTemplate.Columns.Add          (new GridViewTextBoxColumn("NameCode"));
                RadGrid.MasterTemplate.Columns.Add          (new GridViewTextBoxColumn("Event"));

                RadGrid.AllowAddNewRow                              = true;
                RadGrid.AutoGenerateHierarchy                     = true;
                RadGrid.AutoSizeColumnsMode                      = GridViewAutoSizeColumnsMode.Fill;

                //Setup Child Template
                GridViewTemplate Childtemplate                       = new GridViewTemplate();
                RadGrid.MasterTemplate.Templates.Add         (Childtemplate );
                Childtemplate.AllowAddNewRow                         = true;
                Childtemplate.AutoSizeColumnsMode                 = GridViewAutoSizeColumnsMode.Fill;

                Childtemplate.Columns.Add                                (new GridViewTextBoxColumn  ("Name"));
                Childtemplate.Columns.Add                               (new GridViewTextBoxColumn  ("Description"));


                //Relation between Parent & child
                GridViewRelation relation                            = new GridViewRelation(RadGrid.MasterTemplate);
                relation.ParentTemplate                              = RadGrid.MasterTemplate;
                relation.ChildTemplate                               = Childtemplate;

                relation.ParentColumnNames.Add("Name");
                relation.ParentColumnNames.Add("Description");
                relation.ParentColumnNames.Add("PtDate");
                relation.ParentColumnNames.Add("Value");
                relation.ParentColumnNames.Add("Status");
                relation.ParentColumnNames.Add("NameCode");
                relation.ParentColumnNames.Add("Event");

                relation.ChildColumnNames.Add ("Name");
                relation.ChildColumnNames.Add ("Description");


                RadGrid.Relations.Add(relation);

 //load data
                LoadUnboundData();

        }