microsoft / advanced-formula-environment

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

Enable change the order of the function argument in Name tab #42

Closed dlealv closed 1 year ago

dlealv commented 1 year ago

Currently, there is no way to change the order of the function arguments, not a big deal for a few arguments, but if you have several of them, and just decide to change the order, you need to remove all of them and recreate them again with the new order.

image

In the above example if I want y to be the first argument and x the second I need to remove them an recreate them again.

I tested in Excel for Web.

Thanks,

David

jack-williams commented 1 year ago

@dlealv, we have an unpublished user-interface update that improves the experience of defining functions. I'll close this once it is live.

cc @NWilson

jack-williams commented 1 year ago

We have merged a new change that updates the argument UI. The arguments are now inline pills so a user can delete and add pills at any position.

image

dlealv commented 1 year ago

Thanks I tested it and it works!!!