Forum Discussion
Copy existing formulas into Advanced Formula Environment module?
I haven't found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.
I could copy & paste one at a time ... but in some cases it would be onerous!
Situation: I have a few workbooks with several LAMBDA functions defined as "Names". I can bring up the list in AFE:
The "duplicate" button creates the copy only in the workbook with no option to move it to a module. I can "paste" the definitions in "Formulas>Use In Formula>Paste Names" from the menu and paste them into the module text, but then lose the comments ("Creates string with..." in the image).
Am I missing something?
Thanks!
To my knowledge there is no such functionality from the box. Here Import module from Name Manager · Issue #56 · microsoft/advanced-formula-environment (github.com) you may find the workaround, but I was not able to run it.
In any case it's better to discuss directly with AFE team on github Issues · microsoft/advanced-formula-environment (github.com)
2 Replies
To my knowledge there is no such functionality from the box. Here Import module from Name Manager · Issue #56 · microsoft/advanced-formula-environment (github.com) you may find the workaround, but I was not able to run it.
In any case it's better to discuss directly with AFE team on github Issues · microsoft/advanced-formula-environment (github.com)
Thanks; looks like all I need to do is enclose the name comments in "/**" and "*/" and format each function as "Name = Formula" in a text file. Easy enough.
