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

Context menu commands not showing when right-click on table range #4692

Open Nikodem98 opened 2 months ago

Nikodem98 commented 2 months ago

Context menu commands not showing when right-click on table range on macOS desktop and windows desktop Excel but works perfectly fine on web Excel.

Any way to fix this?

image image

AlexJerabek commented 2 months ago

Hi @Nikodem98,

Thanks for reporting this. @EsterBergen, could you please investigate?

EsterBergen commented 2 months ago

@Nikodem98 - can you provide more details about this issue? Are the context menus coming from a specific addin that was enabled for your sheet?

Nikodem98 commented 2 months ago

Yes, I created a addin that has some commands in right click menu. Everything works when I select a single cell or a range that is not a table. When I right click on selected table range commands from context menu are gone. It happens only on excel Mac/windows desktop application, on web excel works perception fine

EsterBergen commented 2 months ago

Thanks for clarifying! We'll investigate and get back to you soon,

EsterBergen commented 2 months ago

@Nikodem98 - and another clarifying question. When you say Table Range, is it purely a group of selected cells or is this range defined as a table in excel?

Nikodem98 commented 1 month ago

A range defined as a table. With group of cell with values it works fine( first screen shoot), but when I select a cells range defined as a table my context menu commands are gone (second screenshot) image image

as you can see there is a table ribbon at te top And the command are gone

EsterBergen commented 1 month ago

@Nikodem98 - Thanks again for reporting this feature gap. We've created an item in the backlog to bring win32/Mac to parity with web. (9177817). We will post a message here once we get a better sense on when we will be able to make this fix. Thanks!