- All Categories
- 73 General
- 73 Announcements
- 66.3K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 247 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 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
- 259 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. BC TechDays 2024: 13 & 14 June 2024, 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,63360Anyway, 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/