Excel Ribbon disappears

Ranorex Spy, Recorder, and Studio.
hvoelker
Posts: 4
Joined: Wed May 14, 2014 8:52 am

Excel Ribbon disappears

Post by hvoelker » Wed May 14, 2014 9:13 am

Hi there,

i just downloaded the trial version and started testing this morning. My first test is an AddIn for Excel. I'm Using Office 2013 Proffessional on Windows8. But the test failed at the beggining.

My steps:
-I open a new empty workbook
-Click on the AddIn in the menu
-the ribbon appears
- i click on a Add-Button in the ribbon

And that is where the software failes. The ribbon appears but before the software can click on the Add-Button the ribbon disappears again.

What am I doing wrong?

krstcs
Ranorex Guru
Posts: 2683
Joined: Tue Feb 07, 2012 4:14 pm
Location: Austin, Texas, USA

Re: Excel Ribbon disappears

Post by krstcs » Wed May 14, 2014 2:16 pm

You will probably want to set the ribbon to stay open all the time, instead of auto-closing. Otherwise you will have to make sure that the mouse stays over the ribbon at all times, and even that may not work 100%.
Shortcuts usually aren't...

hvoelker
Posts: 4
Joined: Wed May 14, 2014 8:52 am

Re: Excel Ribbon disappears

Post by hvoelker » Thu May 15, 2014 7:41 am

Thank you for your answer. I tried it with a mouse move action. Because of this, the ribbon stays open and the software is able to find the button. So it works so far and i can go on with my tests.

hvoelker
Posts: 4
Joined: Wed May 14, 2014 8:52 am

Re: Excel Ribbon disappears

Post by hvoelker » Mon May 19, 2014 9:19 am

Is it possible to set the ribbon stay open with ranorex?

mzperix
Posts: 137
Joined: Fri Apr 06, 2012 12:19 pm

Re: Excel Ribbon disappears

Post by mzperix » Mon May 19, 2014 10:36 am

Hi hvoelker,

this an office-related problem, and fortunately, there is a button to solve this problem :)

Look at the upper-right corner of either the office application ,there is a new button besides close-maximize-minimize buttons. Click on that icon and select Show Tabs and Commands.

See screenshot attached.

Best Regards,
Zoltan
Attachments
ribbon always open.png
ribbon always open.png (28.25 KiB) Viewed 1106 times

hvoelker
Posts: 4
Joined: Wed May 14, 2014 8:52 am

Re: Excel Ribbon disappears

Post by hvoelker » Mon May 19, 2014 11:10 am

Thanks su much. As you know now i'm not used to the new Office Version yet :oops: