- 71.8K All Categories
- 73 General
- 73 Announcements
- 66K Microsoft Dynamics NAV
- 18.2K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 853 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 612 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 228 Dynamics CRM
- 108 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 33 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 258 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

Luc_VanDyck
Member, Moderator, Administrator Posts: **3,633**

When working with formula's in Excel using automation, you have to know what language-version of Excel is installed (English, Dutch, French, etc.) in order to write your formula (eg. SUM/SOM/SOMME, ROUND/AFRONDEN/...).

The function

There must be a way to use formula's independant of the language, so you only have to write them in English.

How can you do this?

The function

xlApp.International(lxlCountryCode));(with lxlCountryCode = 1) returns the language being used.

There must be a way to use formula's independant of the language, so you only have to write them in English.

How can you do this?

No support using PM or e-mail - Please use this forum.

NAV TechDays 2022: 17 & 18 November 2022, Antwerp (Belgium)

NAV TechDays 2022: 17 & 18 November 2022, Antwerp (Belgium)

0

## Comments

123If I do the following in Excel

Range("A1").Formula = "=Sum(B1:B10)", A1 will contain the formula in the local user his language.If I do the same in Navision, it A1 always contains

"=Sum(B1:B10)", it does not translate the formula.It would be SUPER, and I mean super super handy to get this working since we have EMEA offices where all users have Excel in their native language and I do not want to start looking at the Excel version of the user and start saving all formulas in all languages.

12360123I was actually entering an article about this on my blog when I got a message you replied to this post :-).

You can read how I solved it on my blog article here: http://www.noisyvan.com/2008/10/09/make-exporting-excel-formulas-fully-multilanguage-aware/.

Is it allowed to put just a link to this article or should I cope the content over here too?

3,633NAV TechDays 2022: 17 & 18 November 2022, Antwerp (Belgium)

60Anyway, I'll take a time and post this blog page here (screenshots will be from blog too):

14https://ricardomoinhos.com/excel-buffer-detect-excels-language/