Re:Excel formulas in JavaScript
by dhekir on Thursday April 24, 2014 @05:13AM
(#7639089)
This also includes changing argument separators according to the locale. In France, for instance, where commas are used as decimal separators, function arguments must be separated by semicolons. Faithful i18n should take both into account.
[ Parent
| on HN ]
Luckily this is a UI thing and the files themself normalize to English. So the project could still be useful for opening Excel files on the web (theoretically).
Oooh, so if I make a spanish excel file and open it in an english excel, the function names are all translated?
That's actually pretty neat. Power of storing your equations in a binary format instead of plain text, I guess.
As far as I know it's still text, but the function names are stored in English and are only localised within the Excel UI.
Fun fact: Some old versions of Excel even had a localised VBA ... using ZeichenF instead of String and other oddities made that a very weird experience.