Use Monaco editor for editing formulas
The Formula column is a killer feature, but it can get tricky when the formula expression grows larger than the size of the editing area, and has a few levels of nested expressions.
Beyond just the ability to enlarge the editor, it would be fantastic to have a more advanced editor to assist here, and the obvious candidate is the https://microsoft.github.io/monaco-editor/
My suggestion for iterations for this would be:
- Just replacing the actual editor and make sure it's still working when editing and not (so no functional changes)
- Adding config and definitions needed for highlighting brackets and auto indentation
- Adding syntax highlighting of functions, operators, variables and value literals
- Auto-complete and intellisense tooltips of functions
Thank you for request!
AdminJulia (Product Owner, ALM Works) commented
Thank you for your request! Will check the Monaco for the next improvements.
We are working on the formula editor right now, possibility to enlarge the editor will be released soon.
Todd Levinson commented
I work at financial technology company and am responsible for a product that uses Monaco to help people create and edit queries in Excel using a custom, domain-specific query language. Monaco is really powerful and very flexible and the out of the box functionality is really good in terms of custom language/syntax support.
We've also had some very demanding UX requirements. Changing the visual design is easy, but we had to implement a customized version of the autocomplete to be consistent with our design patterns for autocomplete across all our products. This was harder and a bit more costly, but we were able to create a customized contrib of the autocomplete to handle all the additional logic we needed. We are also sharing our version of the editor across teams, so it can be used wherever this type of query editing is needed.