SOLVED

Copy existing formulas into Advanced Formula Environment module?

Copper Contributor

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:

pdtcaskey_2-1722611394469.png

 

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!

2 Replies
best response confirmed by pdtcaskey (Copper Contributor)
Solution

@pdtcaskey 

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)

@SergeiBaklan 

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.

1 best response

Accepted Solutions
best response confirmed by pdtcaskey (Copper Contributor)
Solution

@pdtcaskey 

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)

View solution in original post