Hover text/No hover text !!!

Question

Hello, following a previous question on Excel Online on Sharepoint, I noticed some cells with a lot of text has their content displayed as a hover text when the mouse pointer was on a cell (not the selected cell but the one with the pointer on it). So I managed to add a special formatting to my Excel file (adding one ' character plus 1 bold space at the beginning of each cells) in order to see that hover text. Problem, the host doesn't have Information Rights Management attached with the Sharepoint Server 2016 Standalone service, so I decided to try it at Microsoft directly... I managed to have IRM working at MS but this time, no more hover text on the formatted Excel file... So I am back to the starting point, having half of the wanted features on the host (hover text showing the whole cell content), and the othe half at MS (IRM). 

This litteraly drives me crazy not to have the same behavior...

Is there anyone at MS able to answer me: is there any setting in Office 365 to have this hover text with Excel Online ???

I tried a lot of permissions/IRM combinations and cannto have this hover test to work, and I start being desperate to have this working...

Best Regards

Answer 1

Hello Jim, I figured out that the "Hyperlink" method had a screentip feature documented, so I did a VBA script to transform all my cells into hyperlinks and it now works fine both with Excel and Excel Online. I also had to disable the "styles" for "hyperlink" & "followed hyperlink" objects to keep my original cell formats, but at least, now, the full cell content can be viewed.

Best Regards,

Bertrand #happy

Answer 2

Hi Bibibubu1,

We'd like to explain that in SharePoint online in Office 365, it is not available to have the hover text showing in Excel online with the pointer on it. We welcome and suggest you send feedback to UserVoice. Understanding your experience helps us make our products and service better for you and others.

Thanks for your understanding.

Regards,

Tina

Answer 3

Hello Tina, thanks for letting me know, but this is insane to have such inconsistent behaviors inbetween versions.

Indeed I already reported a similar issue previously under UserVoice, but my request will indeed be lost in space.

I don't think you're going anywhere with this UserVoice system, or at least you do not show the users that it actually leads to improvements in order to engage them using it, so I do not intend to participate anymore. For my last 2 questions, answers were "we cannot help but send your feedback to UserVoice". This is not satisfying for the customers in my opinion.

Thanks for the reply anyways.

Best Regards.

Answer 4

Hello again, few days later, it looks like the "Hover text" works in Office 365 Sharepoint/Excel online...

I will keep checking this regularly, because it enables things for me.

Best Regards