This is a migrated thread and some comments may be shown as answers.

GridView Excel Like Filter popup button not working

19 Answers 374 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Sakthi
Top achievements
Rank 1
Sakthi asked on 09 Jan 2014, 07:41 AM
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 

19 Answers, 1 is accepted

Sort by
0
Ashish
Top achievements
Rank 1
answered on 12 Jan 2014, 07:23 PM
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.
0
Sakthi
Top achievements
Rank 1
answered on 14 Jan 2014, 05:00 AM
Hi 
Let me know Are you solved this problem?
Even Enter key also not filtering the value?
0
Ashish
Top achievements
Rank 1
answered on 14 Jan 2014, 06:53 AM
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.
0
Sakthi
Top achievements
Rank 1
answered on 14 Jan 2014, 08:01 AM
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
0
Sakthi
Top achievements
Rank 1
answered on 14 Jan 2014, 08:08 AM
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
0
Ashish
Top achievements
Rank 1
answered on 14 Jan 2014, 08:57 AM
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.
0
Sakthi
Top achievements
Rank 1
answered on 14 Jan 2014, 09:07 AM
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.
0
Gabriele
Top achievements
Rank 1
answered on 27 Mar 2014, 02:09 PM
Same problem here, Excel like filtering is not working. Actually the same problem is present in the Telerik RadGridView Excel Like Filtering Demo project.
0
Gabriele
Top achievements
Rank 1
answered on 27 Mar 2014, 02:14 PM
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.
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 31 Mar 2014, 02:29 PM
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.

 
0
Hugo Furth
Top achievements
Rank 1
answered on 14 May 2015, 11:02 PM

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

 

0
Hugo Furth
Top achievements
Rank 1
answered on 15 May 2015, 05:49 PM
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.
0
Hugo Furth
Top achievements
Rank 1
answered on 15 May 2015, 05:51 PM

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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 19 May 2015, 11:13 AM
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
0
Hugo Furth
Top achievements
Rank 1
answered on 28 May 2015, 01:02 AM

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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 01 Jun 2015, 08:16 AM
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
0
Moi
Top achievements
Rank 1
answered on 11 Jun 2019, 08:57 AM

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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 11 Jun 2019, 11:58 AM
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.
0
Michelle
Top achievements
Rank 1
answered on 05 Aug 2020, 02:51 PM

Hi,

i got the solution.. you just have to run Visual Studio as admin.

best regards

Michelle

 

 

 

 

Tags
GridView
Asked by
Sakthi
Top achievements
Rank 1
Answers by
Ashish
Top achievements
Rank 1
Sakthi
Top achievements
Rank 1
Gabriele
Top achievements
Rank 1
Dess | Tech Support Engineer, Principal
Telerik team
Hugo Furth
Top achievements
Rank 1
Moi
Top achievements
Rank 1
Michelle
Top achievements
Rank 1
Share this question
or