Hi,

I'm having a problem while exporting a GridView containing some GridViewCommandColumns to a XLS.

I get a FormatException error in Telerik.WinControls.GridView.dll on these columns.

The code I use for export:

GridViewSpreadExport spreadExporter = new GridViewSpreadExport(gridView);
spreadExporter.ExportChildRowsGrouped = true;
spreadExporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
spreadExporter.HiddenRowOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
SpreadExportRenderer exportRenderer = new SpreadExportRenderer();
spreadExporter.RunExport(sDialog.FileName, exportRenderer);

I don't necessarily need these columns in a XLS, so I tried to hide them before exporting, set some export properties and even set values:

gridView.Columns["column1"].IsVisible = false;
gridView.Columns["column1"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.None;

foreach (var row in gridView.Rows)
{
    row.Cells["column1"].Value = 1;
}

The only way a grid exports correctly is when GridViewCommandColumns are deleted from the grid.

Any idea what should I try? I use version 2021.2.511.40.

Thanks in advance.

Regards,

Tomáš

I'm trying to make a clear distinction between the parent and child rows.  I tried the following to change the background color of the child rows:

CellFormatting += (sender, args) =>
{
    if (args.Row.HierarchyLevel > 0)
        args.CellElement.BackColor = Color.Aquamarine;
};

It works, but only when my mouse hovers over a child row.

Also, I'm wondering why the rows in the child grid have plus signs to their left (see the attached image) when there is no third level.

I have not found it easy to figure this out from the API documentation.  There are probably properties that could get me what I want, but are they in the row class?  The template?  The child template?  The grid?  The view?  <shrug>

I once came across a document on your site that describes the overall grid structure and the relationships between these components.  Whether or not I can get help on these specific issues I'd appreciate a link to that document.

Thanks.

Never did this before, but I need to make a custom change to a control that will affect all instances of it throughout the application. If the user clicks in a masked edit control at any position and the control is empty, the cursor should jump to position 1. It works fine when I use the event handler of the control directly like this:

 private void mtbHomePhone_Click(object sender, EventArgs e)
        {
            if (mtbHomePhone.Value?.ToString()?.Length == 0)
            {
                mtbHomePhone.SelectionStart = 1;
                mtbHomePhone.SelectionLength = 0;
            }
        }

I'm trying to inherit from the control like this (using MyMaskedEdit in the designer.cs in place of RadMaskedEditBox) but the event is not firing. What am I doing wrong?

using Telerik.WinControls.UI;

namespace VisionUI.Common
{
    public class MyMaskedEdit : RadMaskedEditBox
    {
        protected override void OnClick(EventArgs e)
        {
            base.OnClick(e);

            if (this.Value?.ToString()?.Length == 0)
            {
                this.SelectionStart = 1;
                this.SelectionLength = 0;
            }
        }
    }
}

Thanks

Carl

Hi Team,

We are using RadDropDownList control version (2023.1.314)

We are getting  'System.StackOverflowException' exception while assigning value in the dropdownlist (its keep on recursion).

Could you please help on this?. Please find sample program below.

We are using visual Studio 2022 and Telerik.WinControls.UI.dll(2023.1.314)

Note: Its working fine in 2013.3.1.1127 version.

 private void comboBox1_SelectedIndexChanged(object sender, Telerik.WinControls.UI.Data.PositionChangedEventArgs e)
 {
    setOldValue();
 }

 private void setOldValue()
 {
    comboBox1.SelectedValue = 2;
 }

 private void button1_Click(object sender, EventArgs e)
 {
    comboBox1.SelectedValue = 1;
 }

Thanks

Rajkannan

For some reason - probably due to  me doing some re-sizing of columns - my sheets are now opening scrolled a bit to the right, which means my important left-hand columns are not visible without scrolling.

I assume this will be annoying to users - It certainly took me an hour to figure out what had happened to my left-hand columns. :-(

I tried to make the sheet scroll left in the control.load event:

 mySpreadsheetControl.HorizontalScroll.Value = 0

...but that didn't seem to work.

Does anyone know the right way to scroll left in a sheet?

Thanks

Hello,

i am using custom status and i would like to know if it is possible to set the width of the displayed status field.
I haven't found the right element at the AppointmentFormatting event to access the status field.

Regards,

Paul

Background:

• I have a gridview column subscribing to EditorRequired event.
• In the EditorRequired function, it will either prompt DropDownList or RadDateTimeEditor.

(Please refer attached for sample project)

 private void radGridView1_EditorRequired(object sender, EditorRequiredEventArgs e)
        {
            if (this.radGridView1.CurrentColumn.Name == "Value" && this.radGridView1.CurrentRow.Cells[2].Value.ToString() == "DropDown")
            {
                RadDropDownListEditor editor = new RadDropDownListEditor();
                RadDropDownListEditorElement element = editor.EditorElement as RadDropDownListEditorElement;
                element.DropDownStyle = RadDropDownStyle.DropDownList;
                element.AutoSizeItems = true;
                var selection = this.radGridView1.CurrentRow.Cells[3].Value.ToString().Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList();
                element.DataSource = selection;

                e.Editor = editor;
            }
            else if (this.radGridView1.CurrentColumn.Name == "Value" && this.radGridView1.CurrentRow.Cells[2].Value.ToString() == "Date")
            {
                RadDateTimeEditor editor = new RadDateTimeEditor();
                editor.CustomFormat = "dd-MMM-yyyy";
                e.Editor = editor;
            }
        }

Question:

• How to define the Date format?

I have tried to set the CustomFormat but the format remains as shown in the screenshot above.

 RadDateTimeEditor editor = new RadDateTimeEditor();
                editor.CustomFormat = "dd-MMM-yyyy";
                e.Editor = editor;

I'm trying to drag and drop RadCallout to an existing Form Designer, and while I don't get any errors and it appears that it drags and drops, the control doesn't remain on the form and does not appear in the Components Tray either. I do not have a problem adding other Rad controls, but Callout doesn't seem to work. Will it only work with a Rad Form? Or is there a prerequisite I should know about? Do I need to install something so that the Designer can properly display it?

I'm using Visual Studio Professional 2022 version 17.5.5 with Telerik UI for WinForms Extension 2023.1.313.33.

Thanks in advance!