Ranorex not able to find filter in Excel : General Questions

[sbaheti]

Hi,
There appears a filter in every column header of excel(our application situation).Cant able to identify the control(filter).When i tried to identify the control. only the rxpath of the cell is obtained.Help me to identify the control.

Herewith i attached the Screenshot.the control to be found is highlighted by red rectanle

Thanks,
Sonali.

[Support Team]

Hi,

Herewith i attached the Screenshot.the control to be found is highlighted by red rectanle

Sorry but it is not possible to get these buttons. These buttons are drawn by Excel and we cannot track them. But as a workaround you could click the cell on the center-right location to hit the button. The dropdown inside this button can be tracked. I will also file a bug for this issue and maybe the related developer will find a solution to provide the button.

Regards,
Peter
Ranorex Team

[sdaly]

Couldn't you use the gdi rawimage capture here?

[Support Team]

Hi,

Yes you could but you will have no joy, because the images are always the same. Means they have the same hashcode and the rectangle recognition is a bit off.

Regards,
Peter
Ranorex Team

[sdaly]

Ah yes! How about getting the matching raw images then use the column index as the instance?

[Support Team]

How about getting the matching raw images then use the column index as the instance?

Yes you could, but I wouldn't suggest this, because to work with instances alone is a bit fishy. (just my opinion) In combination with other attributes it is okay. But if there is no other chance I would use them too.

Regards,
Peter
Ranorex Team