National language function names

[Stefi]

Hi All,

Does an English language Excel2003 recognize a function written in a
national language?

E.g. in a workbook produced by a Hungarian language version contains
=SZORZATÖSSZEG(...), which is =SUMPRODUCT(...)'s equivalent. Shall it be
transformed to =SUMPRODUCT(...) when opened in an English language version?

Thanks,
Stefi

 

[Niek Otten]

Yes. Not the old Analysis Toolpak functions, though.
There may be problems with constants, like FormatStrings in the TEXT
function and R1C1 style addresses in the INDIRECT() function, and probably
more.
With Excel2007 there is another issue with ATP functions; look here:
http://www.rondebruin.nl/atp.htm

 

[Stefi]

Thanks Niek, fortunately - for the moment - I need only basic functions!
Stefi


„Niek Otten†ezt írta: