Forum Discussion
_Elwetana
Mar 10, 2022Copper Contributor
Advanced formula environment, semicolons separate parameters
In localities that use comma as a decimal separator, the formula arguments are separated by semicolons, not commas. Therefore, it's not possible to use them as formula separators/terminators. When I run AFE on my computer, it splits formula by semicolons, like this:
and so on. It would be good if AFE could get information about decimal separator from Windows locale settings, or at least it would offer a setting to the user that could be used.
2 Replies
Sort By
That's not a bug, that's but design - AFE supports English version. That is Microsoft Garage project, which means pilot and limited one . Bit more is here
Support multiple locales · Issue #3 · microsoft/advanced-formula-environment (github.com)
microsoft/advanced-formula-environment: Create, edit, and reuse named formulas in Excel (github.com)
- T_Nielsen_Copper ContributorI think AFE is nice but its unfortunate that only english people can use it. Location detection and automatic conversion is very wanted