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

1 month & a half later,  the "Hover text" is not working again...

#Facepalm

Answer 3

Hi bibibubu1,

We'd like to share with you that we cannot reproduce the hover text in Excel online in SharePoint online, and no official article mentions that this feature is available in Excel online.

For troubleshooting, could you please help to provide the following information?

1.When you can get the hover text in Excel online in Office 365, please help to capture a screenshot of it and share it with us.

2.Your tenant information. I have sent you a private message to collect it, you can check the PM via this link:

https://answers.microsoft.com/en-us/privatemessage/inbox

Regards,

Tina

Answer 4

Hi bibibubu1,

Thanks for your update in private message.

You mentioned "I wonder why there is no formula bar in Excel Online, while in view mode (even in read only). ", we'd like to explain it is expected that the formula bar is not available in read-only mode in Excel online, we suggest you vote for this related UserVoice, this is the best way to let the related team know your ideas and suggestion. Your understanding is appreciated.

In addition, we need time to investigate the feature for hover text in Excel online in Office 365, we will post back once we get any update.

Regards,

Tina

Answer 5

Hello Tina, the UserVoice you refer to is already mine!

By the way I do not understand why you say this is expected not to have the formula bar in read-only mode in Excel online, since this is the only way to read the cell content when it is larger than the cell width. Do you mean that this is expected because it was coded this way by purpose, and if yes, what would be the reason? I would definitely like to know. Or, if the developpers at MS have a suggestion to read cell contents in read-only mode when cells are filled with a large amount of text, I take.

Best Regards,

Bertrand