Large List Boxes selecting wrong item in Excel for Mac 2016

[marcel_911]

Hi,

I am using Excel 2016 on a Mac as part of the 365 suite. (Including latest updates)

I need to use a List Box so the user can make selections.
Because of the horrible way I have to scroll a large list box I decided to make the list box the full length of the data (125 lines) and just scroll the whole sheet.

This seemed to work fine but I notice than when selecting items further down the list Excel is highlighting the item above. if I select the very lowest ones, Excel is selecting items TWO above the one I click on.

Is this a known bug?

 

[Jim Gordon]

Please go to the Excel menu and choose About Excel and reply with the version and build number. Excel on Mac gets updated almost weekly, so knowing which exact version you have might be important.

 

[marcel_911]

It says 15.25.

I have Excel as part of an Office 365 subscription.

 

[marcel_911]

I have added a screen recording of the behaviour just in case my description of it was not clear.

https://www.youtube.com/watch?v=bMzoauEJp2k

I have just updated to 15.26 and the problem still exists.

 

[Jim Gordon]

It's good that you are on the current update, because bug reports on updates gone by are not looked at closely. Use the Smile button in Excel and send a frown (including screen shot) to Microsoft so they can log this bug.

 

[marcel_911]

It's good that you are on the current update, because bug reports on updates gone by are not looked at closely. Use the Smile button in Excel and send a frown (including screen shot) to Microsoft so they can log this bug.

Ok, just done that. I never noticed that icon before.

The Mac version does not seem to be as "polished" as the windows one. I do not know if this problem exists on Windows. I will try it when I get back to work on Monday.