Hello,

I am trying to export a radPivotGrid into excel as per the documentation

 private void radButton1_Click(object sender, EventArgs e)
        {
            SaveFileDialog sf = new SaveFileDialog();
            sf.Filter = "EXCEL | .xls";
            if (sf.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                // Telerik.WinControls.UI.Export.ExportToExcelML htmlexport = new Telerik.WinControls.UI.Export.ExportToExcelML(radPivotGrid_StockPositionPivot);
                //  htmlexport.RunExport(sf.FileName);


                PivotGridSpreadExport spreadExport = new PivotGridSpreadExport(radPivotGrid_StockPositionPivot);
                spreadExport.RunExport(@"..\..\exported-file.xlsx", new SpreadExportRenderer());
            }
        }

the red marked position is throwing an exception, and code suggestion is asking to create a new class to implement SpreadExortRenderer I am not sure how it can be done, any help will be appreciated. TIA

Please see the picture attached - I 'd like to display only the green options,

thank you

Dear sir/madam,

I used your solution for adding a checkbox in grouprows of a grid for UI Winforms:

winforms-sdk/GridView/GridCheckAllGroupRows at master · telerik/winforms-sdk · GitHub

Only specific grouprows need a checkbox, not all grouprows, which I handle in the CreateCell event. So far so good, seems to work perfect.

But.... when I start scrolling in the grid, because not all grouprows are visible in one screen, and the grouprows that have a checkbox leave the screen because of scrolling down, and then scrolling up again, the checkbox in the grouprow is gone, and grouprows that did not have the checkbox have now a checkbox?

Strange, I cannot figure out what is going wrong.

Hopefully  I succeeded in describing the situation clearly.
Help would be appreciated.

Kind regards.

Hi,

I have a radgridview with fullrowselect enabled. When i select a cell, the row is selected correctly, but the selected cell changes padding or width slightly which seems to affect the entire column.

It's just a minor visual annoyance, but is there a way to prevent this?

Thanks,

Philip

Hello!

My company is using RadGridView for an application where users can view and organize/edit SQL data. The grid is set to allow paging and up to 50 rows per page. Because of the size of some of the tables our users work with, the pages can number in the hundreds, which raises an issue when using the grid's built-in sorting capabilities. 

By default, the grid seems to sort all the data in the table as opposed to just the visible rows on screen. This results in a portion of data being displaying that is completely different from what is supposed to be on that page. What I'm looking to do is to have the grid sort only the child rows visible on the page.

I assume going the custom sort rout is necessary here? I've tried a bunch of different approaches to varying degrees of success, but nothing's gotten me quite there. The grid is data bound, which working around has been maybe the biggest hurdle for me so far. Ideally I'd like to be able to reorganize the rows on screen without having to rebind the grid, though I'm not sure how feasible that it. Regardless, any help is appreciated!

Best,

Rich

Hello!

I am currently using RadGridView for a project my company has me working on. We want to be able to prevent users from setting CellForeColor and CellBackColor to the same values (as seen in the image below). I've tried implementing a check on a variety of different elements to try and catch this case if it happens, but so far I've not had much luck. I guess more than anything I'm wondering which element I should be focusing on in order to catch this when it happens? I've scoured these forums and the rest of the internet and I haven't seen anything similar being asked. Any help is greatly appreciated, even if it's just a point in the right direction!

Best,

Rich

I am using Telerik UI for Winforms version 2022.1.118.40

I am trying to bind a treeview to a list of object-related data, but only the root nodes are displayed.

My object-related data looks like this:

public class MyRootObject
{
    public string Name {get; set;}
    public List<MyChildObject> ChildObjects {get; set;}
}

public class MyChildObject
{
    public string Name {get; set;}
}

My treeview is set up like this:

var myRootObjects = new List<MyRootObject>()
{
   new MyRootObject()
   {
      Name = "RootName",
      ChildObjects = new List<MyChildObject>()
      {
         Name = "ChildName"
      }
   }
}

MyTreeView.DataSource = myRootObjects;
MyTreeView.ChildMember = "ChildObjects";

I have tried different ways of setting the 'ChildMember' property, as per documentation ( https://docs.telerik.com/devtools/winforms/controls/treeview/data-binding/binding-to-object-relational-data ), such as 'myrootObjects\\ChildObjects', but I can not get the child objects to be displayed.

How do I get the child objects to be displayed?

I have a grid whose datasource is a list of DocumentGroup objects, each of which has a property "Others" of type IEnumerable<Document>.

I wrote the following:

        GridViewTemplate childTemplate = new GridViewTemplate();
        grdDocuments.Templates.Add(childTemplate);
        childTemplate.Columns.Add(new GridViewTextBoxColumn(nameof(Document.Docname)));
        childTemplate.Columns.Add(new GridViewTextBoxColumn(nameof(Document.Filepath)));
        GridViewRelation relation = new GridViewRelation(grdDocuments.MasterTemplate, childTemplate);
        relation.ChildColumnNames.Add(nameof(CompanyTb.DocumentGroup.Others));
        childTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
        grdDocuments.Relations.Add(relation);
        
        grdDocuments.Fill(Data.DocumentGroups);

(I'm not showing the whole setup of grdDocuments.)

This basically works, in that it shows a row for each DocumentGroup with the data in their columns, plus an icon to the left of each allowing the user to open the associated sub-grid of Documents.  Clicking on that icon gives me the correct number of rows under each DocumentGroup and each row has two columns (one for the Docname property and one for the Filepath property).

The only problem is that all the cells in all the Document rows are empty, even though there's data in the objects behind them.

What am I missing?

Hi,

I have an issue with the following simple code where I drag a label over a GridView header. The DragDrop codes works fine.

I recently added the following ligne

            SetLabelBorder(sourceLabel, true);

In the DynamicLabel_MouseDown event handler starting the DragDrop along with the DynamicLabel_MouseUp event handler.

The labelBorder is normally setup in the MouseDown event, but even if I simply click on the label and release it, the MouseUp event is not called and the border cannot be suppressed.

Here is the related code:

    RadLabel? PreviousLabelWithBorderSet = null;
    private void DynamicLabel_MouseDown(object? sender, MouseEventArgs e)
    {
        sourceLabel = sender as RadLabel;
        if (sourceLabel != null)
        {
            if (e.Button != MouseButtons.Left) return;

            isCurrentlyDragging = true;
            objCurrentlyDragged = DragObject.Label;
            SetLabelBorder(sourceLabel, true);

            gvCsvData.DragDrop += gvCsvData_DragDrop;
            if (sourceLabel != null) DoDragDrop(sourceLabel.Text, DragDropEffects.Copy);
        }
    }

    private void DynamicLabel_MouseUp(object? sender, MouseEventArgs e)
    {
        sourceLabel = sender as RadLabel;
        if (sourceLabel != null)
        {
            if (e.Button != MouseButtons.Left) return;
            if (sourceLabel != null) SetLabelBorder(sourceLabel, false);
        }
    }

    private void SetLabelBorder(RadLabel labelBorder, bool setBorder)
    {
         // Temporary : At least suppress previous label border if new one is selected !!
        if (PreviousLabelWithBorderSet != null)
        {
            PreviousLabelWithBorderSet.LabelElement.BorderVisible = false;
            PreviousLabelWithBorderSet = null;
        }

        if (setBorder)
        {
            labelBorder.LabelElement.BorderVisible = true;
            PreviousLabelWithBorderSet = labelBorder;
        }
        else { labelBorder.LabelElement.BorderVisible = false; }
    }

What am I doing wrong ?

Thanks

Patrick

I get this message when starting Visual Studio.

message: Visual Studio stopped responding for x seconds (x s anywhere from 6 to 20).

Disabling the extension Progress Telerik UI for WinForms Extension 2023.1.113.1 might help.

Microsoft Visual Studio Enterprise 2022 (64-bit) - Preview Version 17.6.0 Preview 1.0

and previous versions also.

Also previous versions of UI for WinForms.

It does not matter if I am working on a WinForms project or not.

Works find after that.

-George