- 70.2K All Categories
- 73 General
- 73 Announcements
- 64.3K Microsoft Dynamics NAV
- 16.8K NAV Three Tier
- 38.2K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 112 Navision DOS
- 849 Navision e-Commerce
- 880 NAV Tips & Tricks
- 767 NAV Dutch speaking only
- 609 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 224 Dynamics CRM
- 107 Dynamics GP
- 9 Dynamics SL
- 1.5K Other
- 971 SQL General
- 379 SQL Performance
- 31 SQL Tips & Tricks
- 24 Design Patterns (General & Best Practices)
- Architectural Patterns
- 6 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 253 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

Luc_VanDyck
AartselaarMember, Moderator, Administrator Posts: **3,632**

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 2020: 19 & 20 November 2020, Antwerp (Belgium)

NAV TechDays 2020: 19 & 20 November 2020, 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,632NAV TechDays 2020: 19 & 20 November 2020, 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/