Page 2 of 5 FirstFirst 1 2 3 4 ... LastLast
Results 11 to 20 of 49

Thread: Online Excel Formula Translator to other languages

  1. #11
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,341
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by Bob Phillips View Post
    You mean that you haven't read that chapter in PED?
    Nope. Never had a need to.

    Quote Originally Posted by maninweb
    ...when I am ready, I'll post here an update.
    Cool deal Mourad, looking forward to seeing the next iteration.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #12
    Seeker jpr73's Avatar
    Join Date
    Apr 2011
    Location
    France
    Posts
    15
    Articles
    0
    Hay,
    Good idea Mourad, I will appreciate your online formula translator
    What about the following functions (in French syntax) :
    INFORMATIONS(no_type) :
    =INFORMATIONS("répertoire") =INFORMATIONS("nbfich") =INFORMATIONS("cellule") =INFORMATIONS("versionse")
    =INFORMATIONS("recalcul") =INFORMATIONS("version") =INFORMATIONS("systexpl")

    CELLULE(type_info;[référence]) :
    =CELLULE("adresse";$B$3) =CELLULE("colonne";$B$3) =CELLULE("contenu";$B$3) =CELLULE("coord";$B$3)
    =CELLULE("couleur";$B$3) =CELLULE("format";$B$3) =CELLULE("largeur";$B$3) =CELLULE("ligne";$B$3)
    =CELLULE("nomfichier";$B$3) =CELLULE("parentheses";$B$3) =CELLULE("protege";$B$3) =CELLULE("type";$B$3)
    Best regards

  3. #13
    Acolyte maninweb's Avatar
    Join Date
    Mar 2011
    Location
    Germany
    Posts
    88
    Articles
    0
    Excel Version
    2010, 2016, 2016 Insider
    Hi jpr73...

    Many Thanks for your feedback; I will check these functions and if necessary correct/add them :-)

    Regards :-)

  4. #14
    Excellent Idea. Microsoft has such a long way to go on languages and anything that helps is worthwhile.

    A couple of points:

    It seems to require function names to be in upper case.

    Comma/semicolon separators are complex, but Excel let's you override the system setting and change things without quitting Excel, so nobody need have a problem. I would stick to simple and use semicolons for non-English European languages and commas otherwise.

    Are you aware of http://www.piuha.fi/excel-function-n...tion/index.php

  5. #15
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,652
    Articles
    0
    Excel Version
    O365
    Seeing Tony join in reminds me that he posted a nice MS 'feature' recently, where the MID function in Swedish is EXTEXT in Excel 2003 and MITT in Excel 2010 (there may be others). Ron de Bruin also mentioned that in 2007 there was this bug that is fixed in SP2 http://www.rondebruin.nl/atp.htm.

    Not simple is it?

  6. #16
    Acolyte maninweb's Avatar
    Join Date
    Mar 2011
    Location
    Germany
    Posts
    88
    Articles
    0
    Excel Version
    2010, 2016, 2016 Insider
    Hi Tony, Hi Bob...

    Thank you, Tony, for your feedback. Yes, the tool assumes the function names in upper case letters, because Excel transforms
    formulas to upper case after enter was pressed.

    Bob, this means, I have to add those special cases to the array; assuming the formula names are in all cases unique. If so, then
    I think, this problem will be resolvable.

    Thanks both for the links

    I am currently preparing and extending my Excel file I used for the three current languages (I use a macro for generating the php files
    with the arrays) for more languages. I will then upload the file here; hoping that some people will have a look on it.

    I bought www.excel-translator.de (and .com) yesterday. The new domains are however only redirecting to the previous domain
    as I am also moving to another provider, but that's another problem and a long story.

    A subscript is now pointing to a developer version of the translator: http://translator.excel-ticker.de/developer.php Currently a copy
    of the released version is stored, but this will change soon. The developer version will then reflect my last developing state and when
    it's tested move to the release version. And I am also creating a support and bug reporting site for the translator; this work is in progress.

    Best regards :-)

  7. #17
    Acolyte maninweb's Avatar
    Join Date
    Mar 2011
    Location
    Germany
    Posts
    88
    Articles
    0
    Excel Version
    2010, 2016, 2016 Insider
    Hi all...

    I have uploaded my basic file serving me for the translations. The Excel file includes the translations
    of the english functions of Excel 2010 for German, French, Italian, Spanish, Dutch, Portuguese and
    Swedish. The worksheet is protected by an empty password.

    The translations were done by Excel, I installed all language packs on a VM, switched to another
    language and pressed my button "Extract". The first step was to enter all excel formulas in English
    manually; hope I have not forgotten one.

    When opening the file, your current language ID is shown in the red field on top left. If you want
    for example support me by providing languages, please just fill in in a empty column your language
    ID (a number like 1033), a language name and code (just as you like). When pressing "Extract"
    a dialogue searches those ID and puts all formulas to the column. If you are using the file,
    please don't change the sorting (based on English). The sheet contain hidden row, in case I
    forgot formulas for a character (A-Z); each char has placeholders for max 64 functions.

    I am now going to add the new languages to the translator and performing some changes to
    the algo; some questions:

    - What do you think, is there a need to also translate older Excel 4 macro functions?
    - May it make sense to translate the most used Add-In functions and if so which ones?

    Best Regards :-)
    Attached Files Attached Files

  8. #18
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,341
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Wow... a lot of work!

    Personally, I don't use much (if any) of the Excel 4 macro functions. I know there's some things that they're very useful for, but since they trigger security warnings in Excel 2010, and I never really did learn them, I avoid them.

    Re Add-ins... are you talking about add-ins like Laurant Longre's MoreFunc addin? I personally avoid them too, but I've seen quite a few people recommend that one at mrexcel.com...
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  9. #19
    Acolyte maninweb's Avatar
    Join Date
    Mar 2011
    Location
    Germany
    Posts
    88
    Articles
    0
    Excel Version
    2010, 2016, 2016 Insider
    Hi together...

    I have released version 1.05 on my server and added following features...

    • New languages for translations, so that the translator knows about the formulas for English, German, French, Spanish, Italian, Dutch, Portuguese and Swedish.
    • UTF 8 support for the language files for the Excel formulas and interface translations (currently only German, English and French). May be great if someone who speaks more languages can support me.
    • Parameter for setting the interface language when calling the translator, example http://translator.excel-ticker.de/tr...hp?Language=en loads the english interface, de and fr will then load German and French; default is English.
    • Two textboxes are now shown for the formulas, the first for the source formula and the second for the translated formula.
    • Minor changes for the parser. However, as I am planning to also be able to translate keywords in formulas (CELL("Filename"), ...) and some of the date and time formats, I will rewrite the parser as the current version is not able to do that.
    • The developer version for the translator is ready and and has additional options; the parser can be choosen there, primarly for me. So when developing, I am completely independent from the released version.

    Unfortunately, the file for extracting the formulas had a minor bug (especially for FALSE and TRUE), I have fixed this and uploaded a new version here.

    @Ken: thanks Personally I also do not use these old macros, but I know few people who do. May be perhaps the best to firstly finish the translator with the current formulas and the consider the Excel 4 macro formulas later when all things work fine. Concerning the Add-Ins, I thought about the Analysis Toolpack, for example for Excel 2003. As I know and if I am right, a considerable number of people is using this Add-In; for example for calculating the week number with the ISO Standard (I also avoid this Add-In). However, I am not sure if a localized version of this Add-In is installed with a language pack. If not, it will be IMHO more difficult to retrieve the translated formulas.

    Next steps for the translator will be to replace and improve the parser module, support the replacement for commas and semicolons, make the layout a little bit nicier, add languages, etc.. However this work will only start from September, as I am busy next week.

    Best Regards :-)
    Attached Files Attached Files

  10. #20
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,341
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Analysis toolpack, definitely. I checked your file though, and you listed the most common two that I use: EOMONTH and MROUND.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Page 2 of 5 FirstFirst 1 2 3 4 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •