Translation of functionsnames 1

[DeGeus]

I have contact with office users wich use different languages. Most used are dutch, englisch and german.

I'm normally working with the dutch version of Excell 2000 but sometimes somebody calls for help on a certain problem. I do know then the formula name in dutch but have no idea how it's called in english or german. Has sombody a cross list so that I can find the translation of a certain function? And where can I find it on the internet?

many thanks

Leendert de Geus

http://WWW.CEC-CES.nl

 

[ilses]

Hello Leendert,

If you can give an e-mail address, I'll send you a cross-reference English-Dutch. It's an Excel sheet with some additional information on the functions such as arguments lists in English and Dutch.

Microsoft used to have a glossary for Office on an ftp site. I didn't keep a link but you could try a search at

http://www.microsoft.com/globaldev/default.mspx

Best regards,

Ilse

 

[01Patrik]

A "quick-tip" if you want to know how one special functions works in English, is to record it in a macro (use the function whilst recording), and then press Alt+F11 fot the VBA editor. The code should say something like

Cells(1,1).FormulaR1C1 = "=lookup(...)"

In this case stated by the lookup function.

VBA always shows the function in English, no matter which language version you use.

// Patrik

 

[01Patrik]

Hmm... after thinking a bit more, I realised you can also

sub Function_in_English()

If Selection.HasFormula = True Then Msgbox (Selection.formula)

Else: Msgbox ("No formula in selection. Klick 'OK', select a cell with a function and restart macro.")

End If

End Sub

// Patrik

 

[DeGeus]

@ Patrik

I value your posts but the problem is that for example a german person calls me and asks me for a certain function. Than I do know the gramar in dutch but don't know the gramar in german (for example) So on that moment it would be handy to have a list with translations lookup in english = ....... in german.

thanks anyway

Leendert de Geus

http://WWW.CEC-CES.nl

 

[01Patrik]

Sub convert_function()

Selection.Formula = Selection.Formula

End Sub

Write the function in a cell as you would have written it in the English version (Ignore the error message). Select that cell and run the macro above. This automatically converts the non-working English function in the cell to a working local one, if there is a function within the cell. Otherwise, nothing happends.

Note that the sub works an a multiple selection (array) as well!

If you can guide your user / friend / customer to creating this macro (and perhaps adding a shortcut key to it), then he'll / she'll never bother you again with questions like that.

// Patrik

 

[byundt]

DeGeus,
Laurent Longre posts a list of translations in 9 languages at

http://cherbe.free.fr/traduc_fonctions_xl97.html

I imported this list into a spreadsheet at

http://home.mchsi.com/~byundt/List_of_keywords_in_9_languages.xls

If you select columns A:I, then open the Data...Sort menu item--you can sort the list by any language.

Brad

 

[DeGeus]

@ byundt

This is exactly what I'm looking for. Many, many thanks. You've received your star already.

@ Patrik
thanks for your help, but as yoe read above, byundt offerde me the solution.



Leendert de Geus

http://WWW.CEC-CES.nl