UI for WinForms

[SANDRO]

Hi, good day.

I have developed web applications using telerik controls with Visual Studio.

But now I'm going to develop a desktop application, so I'm going to use the Telerik controls for WinForms with Visual Studio.

I have three questions.

1. I have version 2017 of UI for ASP.NET AJAX installed, can I install a version of UI for Winforms 2022, do not create conflict?

2. What version of UI for Winforms is compatible with Visual Studio 2017?

3. In the project that I am going to carry out using Winforms, the idea is that the data is displayed as a dynamic excel table and graph. I have read the documentation and I understand that I would have to use several controls for that, I thought it would not be so laborious, is the latter correct or am I wrong?

Thank you very much for the help.

[Dess | Tech Support Engineer, Principal]

Hi, Sandro,

I will go straight to your questions.

1. You can install any version you want of the Telerik UI for WinForms suite: https://docs.telerik.com/devtools/winforms/installation-and-upgrades/installing-on-your-computer 

2. All of the versions are compatible with Visual Studio 2017. R3 2018 SP1 (2018.3.1016) is the latest version where the installer handles VS 2005 and VS 2008. After this version, Telerik integration is installed on newer versions of Visual Studio.

3. The control which is as close as possible to MS Excel is RadSpreadsheet. It is a control that allows editing tabular data utilizing a variety of cell formatting options, styles and themes. Please refer to our online documentation for more information: https://docs.telerik.com/devtools/winforms/controls/spreadsheet/overview 

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

[SANDRO]

Thank you very much for the support, I still have a doubt in question 3, for that I add the following:

In Winforms, can I create a pivot table and pivot chart and have them behave like in Excel (add/remove: fields, filters, columns, series, rows, values?

I understand that I would use several controls for that, unfortunately I have little time to deliver the development and that is why I would like to know if it is easy to integrate those controls or is it better to use Power BI?

[Dess | Tech Support Engineer, Principal]

Hi, Sandro,

Telerik UI for WinForms suite offers two separate controls, RadPivotGrid and RadSpreadsheet for the described requirements you have. However, please have in mind that only RadSpreadsheet offers add/edit/remove functionality. We already have a similar feature request for RadPivotGrid. You can track its progress, subscribe for status changes and add your comments on the following link: https://feedback.telerik.com/winforms/1371023-add-radpivotgrid-end-user-capabilities-for-editing-the-data 

Both, RadPivotGrid and RadSpreadsheet offers filtering functionality:

https://docs.telerik.com/devtools/winforms/controls/spreadsheet/features/filtering 

https://docs.telerik.com/devtools/winforms/controls/pivotgrid/filtering/group-filters 

However, only RadPivotGrid has built-in integration with RadChartView. Here is a similar request for RadSpreadsheet: https://feedback.telerik.com/winforms/1385929-radspreadsheet-add-support-for-charts 

I believe that you will need to use both controls in your application for the different functionalities you need to offer the end users. I would encourage you to have a look at our Demo application and the examples available for RadPivotGrid and RadSpreadsheet. To access the Live Demo simply click on the Windows Start button and type WinForms Demo. If you are not able to find the Live Demos using that approach you can also download it directly from here.