search

microsoft / advanced-formula-environment

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

When importing from Gist, formulas are not synchronized to the "Formulas" section in "Names" tab. #34

Open duds-sn opened 1 year ago

duds-sn commented 1 year ago

Importing the Gist to an empty workbook module image Gist imported image No formulas inside the tab image

jack-williams commented 1 year ago

This is the intended behaviour, which is new in AFE 1.1.

If you used the earlier version of AFE then the correct behaviour would be to see IFOMITTED both in the Manager tab as a card, and in the Editor tab as a definition.

We moved away from this approach. Now the "modules" (previously namespaces) are their own concepts and explicitly stored as files in the document.

These names are still represented in Names, but you will now find them under the Modules tab. Currently, the Modules tab only displays the names of the modules; we are adding an update that will list the definitions within each module too.

duds-sn commented 1 year ago

Okay, got it. Thanks for clarifying. Although I think it would be nice to be able to import from a Gist to the Functions tab. Even so, amazing job with the AFE. It made my life working with formulas in Excel a lot easier and more pleasurable!

jack-williams commented 1 year ago

Even so, amazing job with the AFE. It made my life working with formulas in Excel a lot easier and more pleasurable!

Thanks for the feedback - great to hear.

Although I think it would be nice to be able to import from a Gist to the Functions tab.

Yeah, I agree that AFE is missing a nice way to share individual functions in a way that is more lightweight than a module. I'm still trying to work out the design for that.