[Bug?] Incorrect argument names shown for some native Excel formulas

microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel

https://aka.ms/get-afe

MIT License

113 stars 11 forks source link

[Bug?] Incorrect argument names shown for some native Excel formulas #86

Open santiago-afonso opened 3 months ago

santiago-afonso commented 3 months ago

Hello! I noticed when auditing a formula that the argument or parameter names for the ADDRESS formula are wrong in the AFE. Haven't yet noticed similar errors with other native Excel formulas.

Microsoft® Excel® for Microsoft 365 MSO (Version 2407 Build 16.0.17730.20000) 64-bit

As always, thank you!

SergeiStPete commented 3 months ago

Didn't catch. Till we add parameters any function is highlighted with error.

santiago-afonso commented 3 months ago

Didn't catch. Till we add parameters any function is highlighted with error.

Sorry for being unclear. As you can see in the formula bar screenshot, the first three args of ADDRESS are row_num, column_num, [abs_num]. Yet as seen in the AFE screenshot, AFE shows them as number, number, [number]. Then [a1] shows as [boolean].

Actually, knowing the expected types is useful, but the argument names need to be shown. Then I propose something like [a1:boolean].

jack-williams commented 3 months ago

This is a 'bug', or rather, I did not add the specific argument names for all functions (only common ones). However, I have since tracked down where I can find them all, so hopefully can update this.