Build 4.0.0.65 of xlsgen fixes the localization of all Excel functions supported by xlsgen, which means 500+ functions, in 6 languages including English, French, German, Spanish, Italian and Portuguese.

The formulas page in the documentation reflects how any function is called depending on the language of your choice (English by default).

As an example, a function such as AVERAGEIFS() in English was still called AVERAGEIFS() in German even though according to Microsoft Excel, it's MITTELWERTWENNS().

This did not affect how xlsgen stored formulas in Excel files, particularly XLSX/XLSM/... where formulas are stored in plain text, because formulas are supposed to be stored in English.

But for every other scenario, improper localization would add friction to someone used to Excel functions in their language. xlsgen fixes this with this build, at least for 6 languages.

Reminder : in the automatic source code generation tool which ships with xlsgen, you can choose which language to use for formulas.