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

Synchronization of shared Modules #53

Open derfasthirnlosenick opened 1 year ago

derfasthirnlosenick commented 1 year ago

Shared or External Modules might be an extremely powerful way for organizations to share user-defined Lambdas in their Excel sheets/applications.

Currently, Modules can only be manually imported from GitHub, which poses two concerns:

  1. In larger organisations, there might be procedural hurdles against putting company code on GitHub
  2. It requires manual resync every time there may or may not be an update

Hence, I'd love to see if it were possible to a) Save modules into an external file (could be a .txt for all that matters) b) Import modules from an external file (filesystem or HTTP) c) Link to an external module, or at least a regular synchronization with it (at least import)

Then organisations could publish standard modules containing vetted lambdas for their users to integrate and then use in their tools, while retaining a single source of code which can be maintained.

derfasthirnlosenick commented 1 year ago

One more benefit this would have: If Modules can be stored in external files, it'd be trivial to edit them using powerful code editors such as VSCode, trace them in version control systems etc.

jack-williams commented 1 year ago

Import modules from an external file (filesystem

I'm looking into adding file upload

msoar commented 6 months ago

I was also looking for a more robust solution for this. I wondered if in some future enhancement there may be the possibility to save these modules into a personal workbook that could be applied to any other sheet (something similar to VBA).

I also really like the original suggestion of importing a file or synchronisation too!