Create and edit named formulas using a powerful formula editor. With the advanced formula environment you can:
- Write named formulas using an editor that supports inline errors, intellisense, comments, and more.
- Indent formulas, making them easier to read.
- Edit all named formulas using a single code editor.
- Quickly reuse LAMBDA formulas by importing them from GitHub gists, or by copying them for other workbooks.
The advanced formula environment works in Excel for Desktop, Web, and Mac, without installing any additional software. All you need to do to get started is get the add-in from the Office store: https://aka.ms/get-afe.
The Microsoft Garage is an outlet for experimental projects for you to try. Learn more at https://garage.microsoft.com.
We currently only support one locale where , is the argument separator and ; is the name assignment separator. Localization feature requests can be tracked under Issues.
This repository contains documentation and examples only.
The default view is Manager view, which lists named formulas in the workbook. Sheet-scoped names are not displayed. Names can be created and edited inline, or by using a full screen editor.
Manager view also supports filtering names by queries such as names using a specific name, names used by a specific name, or the type of name.
The formula editor includes intellisense, inline errors, semantic renaming, and more.
The advanced formula environment will automatically layout formulas listed in Manager view to fit the screen, but this only changes the view and does not modify the stored formula. The formula text can be formatted using the full screen formula editor. The add-in will indent the formula to fit within the available screen width.
Existing definitions can be imported into a working using two methods: using GitHub gist URL, or pasting a text snippet.
Import via a gist, such as this. All the names in the gist will be added to the workbook. If you choose to import into a new namespace, each imported name will be prefixed by the namespace. This can be a good way to import names without worrying about conflicts with existing names. We assume each gist contains a single text file.
Import from text allows you to paste a series of name definitions into a text field and add them to the workbook. This feature is designed to be used with snippets created by the share button in the add-in. When you share a name from the add-in, we will include any names that the shared name references, ensuring that it works in any workbook.
An alternate representation of the name manager is Editor view. In Editor view, names are listed as assignments within a single code editor, making it easier to freely edit multiple names simultaneously.
Names are defined using the syntax name = formula;, for example:
addOne = LAMBDA(x, x + 1);
test = addOne(10) = 11;
The default code editor tab is called Workbook. Additional namespaces can be created to make it easier to add names without duplication.
Within namespace math, the name plus can be defined and referenced directly. When plus is saved to the Name Manager, all references to the name are qualified by the namespace.
Namespaces make it possible to quickly copy existing definitions into your workbook without conflict. Workbook is unique in that names defined within are saved in their unqualified form.
Namespaces are an experimental feature aimed to make the process of reusing names easier. Namespaces are not (yet) designed to be a robust mechanism for formula reuse and modularity. We are interested to hear your feedback about sharing formulas.
This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.
When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.