search

microsoft / advanced-formula-environment

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

Module import fails under German localization #78

Open phish108 opened 2 months ago

phish108 commented 2 months ago

When importing the examples in AFE with a different localization, the example modules will fail to load due function names and separators errors.

It would be nice, if module authors could tag their localization of their module and AFE would translate the formulas as regular Excel Workbooks do.

Such a feature would simplify sharing modules in communities with different localizations.

A Pragma like // @lang=de or (because german is complicated) // @lang=de-ch could do the trick.

Maybe such feature already exists, but I did not find the examples.

phish108 commented 2 months ago

The switch Edit formulas in English solves the problem with the examples. But if a module is written in a different locale than this won't get imported :(

(a minimal example is available here).