Dropdown list issue

[WaddoAU]

Hello,
We have a spreadsheet using dropdown list choices. This works perfectly on Desktop but on mobile we are getting the choices truncated (shortened) so it is very hard to make a choice.

Example: "What is your favorite colour" - shows in mobile as "What is ..."

I have tried everything to stop this and cannot work it out. It is same both on Android and IOS.

Please see screenshot for real example..

Any ideas?

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Dropdown list truncating
If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.

 

[WaddoAU]

Ok, no problem MrExcel. Have you seen this happen with Excel on Tablets, any fix you can suggest?

 

[Peter_SSs]

It isn't an area of expertise for me, but somebody might come along with a suggestion.

 

[WaddoAU]

For anyone else with this issue: I just spoke to Microsoft Representative and they confirmed the problem with Excel for Mobile devices, it appears it is a bug.

A very annoying bug to say the least. Works in Office Online, just not excel for mobile app.

Most of our Staff use this spreadsheet offline so its hurting us.

Least I know now

Link to Bug/Issue is in the excel user voice. "Expand Drop-down Lists to Show Full Text on iPad App"

Again apologies for posting in both forums, it was affecting our Business so I was panicking.