GridView Excel Like Filter popup button not working in UI for WinForms GridView

Sakthi

6 posts

Member since:
Dec 2013

Posted 09 Jan 2014 Link to this post

Hi ,
I am using Excel Like Filter in my grid view. Using the filter I can select the value in check box , but not able to click the 'ok' or 'cancel' button to filter the values. The button not working.
Some time Only one time the button is working and thereafter it is not working.
Kindly find the attached picture and help me.
I am using the following code for excel look filter

me.gvSHEdit.EnableFiltering = True
Me.gvSHEdit.MasterTemplate.ShowHeaderCellButtons = True
Me.gvSHEdit.MasterTemplate.ShowFilteringRow = False

Please reply

GridSearchError.jpg

Ashish

3 posts

Member since:
Aug 2008

Posted 12 Jan 2014 Link to this post

I am also having the same issue. Pressing the Enter key filters fine, but the OK / Cancel buttons are not capturing the cursor. This has started to happen quite lately.

Sakthi

6 posts

Member since:
Dec 2013

Posted 13 Jan 2014 Link to this post

Hi
Let me know Are you solved this problem?
Even Enter key also not filtering the value?

Ashish

3 posts

Member since:
Aug 2008

Posted 14 Jan 2014 Link to this post

Solved it. Actually, the issue was with Visual Studio. In the project debug settings, the debug unmanaged code flag was set to true. U ticking this flag fixes the issue.

Sakthi

6 posts

Member since:
Dec 2013

Posted 14 Jan 2014 Link to this post

Hi
Thanks for your reply. In my VS2012 Professional I didn't see Unmanaged code Check box in Project Properties-> debugging and tools menu also.
Can you able to guide me how to get the check box in my VS

Sakthi

6 posts

Member since:
Dec 2013

Posted 14 Jan 2014 Link to this post

Hi
I solved the OK / Cancel button capturing problem. But the value not filtered the value.
Let me know do you have any idea on this

Ashish

3 posts

Member since:
Aug 2008

Posted 14 Jan 2014 Link to this post

Hi. Sorry but I am using 2010. Not sure about the 2012 interface. As for the filtering, it might be worth checking the data types.

Sakthi

6 posts

Member since:
Dec 2013

Posted 14 Jan 2014 Link to this post

Hi
I am using Excel Like filter in my Gridview. After select the values using Excel Like filter the values not filtered by click on OK or Enter button.
I am using visual Studio winforms 2013 and telerik 2013.
Below the code using the excel like filter

Me.gvSHEdit.EnableFiltering = True
Me.gvSHEdit.AllowAddNewRow = False
Me.gvSHEdit.[ReadOnly] = True
Me.gvSHEdit.MasterTemplate.ShowHeaderCellButtons = True
Me.gvSHEdit.MasterTemplate.ShowFilteringRow = False

Pleaser reply.

Gabriele

14 posts

Member since:
Oct 2010

Posted 27 Mar 2014 Link to this post

Same problem here, Excel like filtering is not working. Actually the same problem is present in the Telerik RadGridView Excel Like Filtering Demo project.

Gabriele

14 posts

Member since:
Oct 2010

Posted 27 Mar 2014 in reply to Ashish Link to this post

This is not a debugger issue, the project does not work in Relase shipped version and also Telerik Winforms Demos has the same exact problem using Excel Like Filter.

Dess | Tech Support Engineer, Sr.

Admin

3568 posts

Posted 31 Mar 2014 Link to this post

Hello Gabriele,

Thank you for writing.

As I mentioned in the support thread you have regarding the same matter, I was unable to reproduce the issue you are facing with the Excel-like filtering example in our demo application from the latest release. The referred options are accessible. I have attached my sample video (drag and drop over the browser to play), demonstrating the behavior on my end. In order to assist you further, we will need a sample project, as we have already mentioned in the support thread that you had opened.

Thank you for your co-operation.

Regards,
Desislava
Telerik

Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

FilteringDialog.zip

Hugo Furth

31 posts

Member since:
Dec 2008

Posted 14 May 2015 in reply to Dess | Tech Support Engineer, Sr. Link to this post

I have the exact same issue both in my programs AND UI for WinForms Q1 2014 SP1 demo...excel filtering for gridview does not work. I see from the video yours does....but mine does not (just as Gabriele described.)

I'm on Win 7 ultimate 64. Using the demo I can pop up the excel filtering, select (via clicking) the item/items to filter on, but then CANNOT click on Ok or Cancel even though both are enabled (Ok turns from grey to normal once an item is selected.) If I hit the enter key, the filtering works. But again, like Gabriele, I cannot click on Available Filters.

Any ideas appreciated.

Regards,
Hugo

Hugo Furth

31 posts

Member since:
Dec 2008

Posted 15 May 2015 in reply to Hugo Furth Link to this post

Update: Same exact programs run fine with Excel filtering working perfectly on my Win 8.1 64-bit machine. Happy to do anything I can to help track this down....very strange issue.

Hugo Furth

31 posts

Member since:
Dec 2008

Posted 15 May 2015 in reply to Hugo Furth Link to this post

Same exact programs run perfect fine on my Win 8.1 64-bit machine. Very strange issue. Happy to help out and run any tests to help track this down.

Hugo

Dess | Tech Support Engineer, Sr.

Admin

3568 posts

Posted 19 May 2015 Link to this post

Hello Hugo,

Thank you for writing.

I have tested the Excel-like filtering functionality in our Demo application on a Window7 machine with the specified version Q1 2014 SP1. It behaves as expected on my end. Please refer to the attached sample video (drag and drop over the browser to play it). Am I missing something? Would it be possible to get back to us with a video illustrating the behavior on your end? You can use Jing (a free tool) for capturing the video. Additionally, it would be highly appreciated if you can reproduce the problem in a sample project and provide it in a support ticket. Thus, we would be able to investigate the precise case and assist you further. Thank you in advance for the co-operation.

I am looking forward to your reply.

Regards,
Dess
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

ExcelLikeFiltering.zip

Hugo Furth

31 posts

Member since:
Dec 2008

Posted 27 May 2015 in reply to Dess | Tech Support Engineer, Sr. Link to this post

Dess -

Just wanted to follow up on this with you......the behavior where mouse-clicks are not responsive in the excel-filtering pop-up is something I've had an issue with multiple times.

However, I am sometimes in the habit of leaving my dev workstation on for a week or more at a time. Recently, I have been shutting this particular machine down each night. Since I have been doing that, I am NOT able to recreate the problem.

Of course, intermittent problems like this are the most difficult to track down. If you have any recommendation as to what I should send you if/when the problem occurs, please advise. I can do a jing capture, but all you would see is my mouse moving around (since it is the clicks that seem to stop functioning.)

Regards,

Hugo

Dess | Tech Support Engineer, Sr.

Admin

3568 posts

Posted 01 Jun 2015 Link to this post

Hello Hugo,

Thank you for writing back.

I am glad that currently you are not experiencing the described problem. However, without a reproducible scenario or a sample project replicating the issue we can make only conjectures what is causing the problem on that specific machine on your end. If you succeed in replicating the issue in a sample project it would be greatly appreciated if you get back to us with it. Thus, we would be able to investigate the precise case. Feel free to open a support ticket with the sample project. Thank you in advance for the co-operation.

If you have any additional questions, please let me know.

Regards,
Dess
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

Moi

3 posts

Member since:
May 2019

Posted 11 Jun 2019 Link to this post

Hello everyone,

Have you found a solution to this problem because I have the same with VS 2015 and telerik winforms 2019 ?

Thank you

Bests regards

Dess | Tech Support Engineer, Sr.

Admin

3568 posts

Posted 11 Jun 2019 Link to this post

Hello, Moi,

We are still unable to replicate such an issue locally. If you have at least one item check in the Excel-like filter popup, the OK and Cancel buttons are enabled. If all items are unchecked, then it is normal the OK button to be disabled:

I have also attached my sample project for your reference. Could you please specify the exact steps how to reproduce the problem?

Alternatively, feel free to submit a support ticket where you can provide a sample project demonstrating the problem you are facing. Thus, our support staff will be able to investigate the precise case and gladly assist you. Thank you in advance for your cooperation.

I am looking forward to your reply.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.

774710GridExcelLikeFiltering.zip