microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel
https://aka.ms/get-afe
MIT License
109 stars 11 forks source link

Hide/Minimize the Add-ins #39

Open dlealv opened 1 year ago

dlealv commented 1 year ago

When I load the Add-in and start using it, there is no way to minimize or hide it. If I close it (click on x) I need to add the Add-in again:

image

The ping/upping functionality is not clear how works at least in Excel Web. If I close the excel file and open it again I need to install the Add-ins again.

I think it is a good idea, to have a way to minimize it, without the need to install it again, the Add-in uses a significant portion of the screen, so it would be nice to minimize it when you want to focus on the content of the excel file itself.

jack-williams commented 1 year ago

This is probably something controlled by the add-in host, rather than something AFE can control. Do you use any other add-ins? Do they behave the same?

dlealv commented 1 year ago

thanks @jack-williams I use other add-ins, and they behave similarly, but at least I have the option to open it again:

image

but I don't have the option to re-open AFE. I need to do several steps: Go to the add-ins manager->Select my Add-ins, and then click on Add:

image

more steps. Now I realized that it appears in the Formula tab, but I usually work on the Home tab (I guess the majority of Excel users too), so once I close it I need to go to Formula and then click on the icon:

image
jack-williams commented 1 year ago

I understand the issue more, thanks for the extra info.

Unfortunately, I do not think there is anything actionable in the short-term. We recently moved AFE from the Home tab to the Formulas tab based on some user feedback. We are unlikely to move it back unless there is some extra related change that would justify the location being in the Home tab.

I'll keep an eye on this though, I do understand the usability challenges you are facing.

Thanks again for the feedback.

deletemeafter commented 1 year ago

@dlealv you can add the AFE icon on the home tab if you edit the ribbon. You can also add it to the quick access toolbar if you use it, so it will always be visible regardless of which ribbon tab you are on. This would have to be done on each device, or export the ribbon/quickaccess then import in another device.

Excel Options, then "Customize Ribbon" > Select "all commands" on left side > Create custom group under Home on right side using "new group" button > Select AFE on left side and press "add" in the middle.

dlealv commented 1 year ago

Thanks @gbin for the tip, but I use Excel for Web, I don't see such options. This is what I see from File->Option:

image

Regards,

David