search

microsoft / advanced-formula-environment

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

Import and export of the functions #64

Open siiilon opened 8 months ago

siiilon commented 8 months ago

I love the AFE, but after the GUI had changed from free-text editor to a new compartmentalized look where each function definition is inside it's own section, the implementation is inline and can't be edited unless the edit button is hit makes it much less useful for me suddenly. When I started to use it I loved the possibility to simply copy the whole thing at once, keep it in a separate text file inside GIT and work with it as a normal source code - diffs, branches, refactorrings etc. Is there a way how I could keep the copy of the function list in a local plain text file and import/export it as needed? I could use a stronger text editor/ide to work with the code and then simply test it after importing back (or synchronizing somehow) to the Workbook. Thank you in advance for any suggestions.

jack-williams commented 8 months ago

Does the module's tab help here? You can copy and paste the content between a file? Was there a specific feature in the previous version you were missing?

I think previously there was a "import from text" which was slightly different to what we have now.

siiilon commented 8 months ago

Hi Jack, it partially does. I can migrate it all there, but it would help a lot if I can simply export the whole thing to a text file. Additionally, what is the future of the Module tab? Will it stay in form of a free text editor, or will it suffer a similar redesigns in the foreseeable future? I don't really mind how is the built-in editor done, but I would appreciate if I can keep and edit it outside of AFE. Thank you in advance!