It looks like you're new here. If you want to get involved, click one of these buttons!

- 69.4K All Categories
- 73 General
- 73 Announcements
- 63.6K Microsoft Dynamics NAV
- 16.3K NAV Three Tier
- 38.1K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 112 Navision DOS
- 846 Navision e-Commerce
- 831 NAV Tips & Tricks
- 766 NAV Dutch speaking only
- 608 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 221 Dynamics CRM
- 107 Dynamics GP
- 9 Dynamics SL
- 1.5K Other
- 968 SQL General
- 379 SQL Performance
- 30 SQL Tips & Tricks
- 23 Design Patterns (General & Best Practices)
- Architectural Patterns
- 6 Design Patterns
- 3 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 999 General Chat
- 1.6K Website
- 78 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

Luc_VanDyck
AartselaarPosts: **3,632**Member, Moderator, Administrator

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

123MemberIf 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.

123Member60Member123MemberI 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,632Member, Moderator, AdministratorNAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)

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

11Memberhttps://ricardomoinhos.com/excel-buffer-detect-excels-language/