OfficeDev / office-js

A repo and NPM package for Office.js, corresponding to a copy of what gets published to the official "evergreen" Office.js CDN, at https://appsforoffice.microsoft.com/lib/1/hosted/office.js.

https://learn.microsoft.com/javascript/api/overview

Other

670 stars 96 forks source link

[Excel Online] Function ScreenTips not showing #3387

Open knight-baron opened 1 year ago

knight-baron commented 1 year ago

When a user enters a formula function screen tips not showing

Your Environment

Platform [PC desktop, Mac, iOS, Office on the web]: Office on the web
Host [Excel, Word, PowerPoint, etc.]: Excel
Office version number: 16.0.16516.42310
Operating System: Windows 10
Browser (if using Office on the web): Microsoft Edge

Expected behavior

Excel Online should display the same function screen tips as the Excel install version.

Screenshot_1

Current behavior

Currently, the Excel online screen tips do not display information about the information that users must enter. (I remember before it was showing screen tips just like the Excel install version)

Screenshot_4

I wonder why I would have to click on the fx icon on the formula bar to be able to view the information the user needs to enter. instead of showing the same Excel install version.

Screenshot_7 - Copy

ghost commented 1 year ago

Thank you for letting us know about this issue. We will take a look shortly. Thanks.

knight-baron commented 1 year ago

Is there an update on when this will be resolved?

rundongmsft commented 1 year ago

Hi @knight-baron, Custom Function in Excel online currently does not have Function Arguments ScreenTips. "Letting Function Arguments ScreenTips support to Custom Function in Excel online" is a new feature ask, you can provide your request here: https://techcommunity.microsoft.com/t5/microsoft-365-developer-platform/idb-p/Microsoft365DeveloperPlatform.

gmichaud commented 1 year ago

@rundongmsft given how nice the new ScreenTips is I find it rather disappointing that support of custom functions was omitted and is considered a separate feature. All the information needed to support the screen tips is already present.

gmichaud commented 1 year ago

@knight-baron FYI another issue was open on this topic -- https://github.com/OfficeDev/office-js/issues/3228

I had commented on https://techcommunity.microsoft.com/t5/excel-blog/formula-argument-assistance/bc-p/3774495/highlight/true#M3446 when the announcement was first made, and a Program Manager at Microsoft responded that "supporting custom functions is on our backlog, but unfortunately, we don't have a solid timeline for it yet. I encourage you to follow the announcements of this portal for upcoming updates"