The AFE is awesome ...
but in large or complex situations named ranges + lambda functions can be verbose, limited in functionality, and cumbersome
The Python Editor is fantastic ...
but python cells require internet access, have usage quotas, have a linear execution model, and don't support importing custom libraries.
Office Scripts are almost cool ...
but they can't be triggered by events
Javascript Custom Functions would be cool ...
if I didn't have to develop and deploy an entire add-in
What would really be useful is a JavaScript editor that gives us the ability to:
- Create, edit, and save Javascript Custom Functions
- Create and edit Office Scripts
- Trigger Office Scripts on workbook or worksheet events
- Open a dialog with custom HTML (report, message, or input form)
The AFE is awesome ...
but in large or complex situations named ranges + lambda functions can be verbose, limited in functionality, and cumbersome
The Python Editor is fantastic ...
but python cells require internet access, have usage quotas, have a linear execution model, and don't support importing custom libraries.
Office Scripts are almost cool ...
but they can't be triggered by events
Javascript Custom Functions would be cool ...
if I didn't have to develop and deploy an entire add-in
What would really be useful is a JavaScript editor that gives us the ability to: