[Formula] ERRORTYPE vs ERROR.TYPE

l10n
#1

Hey

What is the difference between ERRORTYPE and ERROR.TYPE function? I have
problem because years ago local Sun Microsystems' translators started
translating function names with dot sign. In Polish "ERRORTYPE" is
"NR.BŁĘDU" (and many others are translated in the same convention). If I
now change "ERRORTYPE" for "NRBŁĘDU" and translate "ERROR.TYPE" for
"NR.BŁĘDU", how will it affect for users spreadsheets?

#2

Hi Mateusz,

What is the difference between ERRORTYPE and ERROR.TYPE function?

ERROR.TYPE is as defined in ODF OpenFormula and compatible with the
Excel ERROR.TYPE function. It returns specific numbers for certain
errors and otherwise #N/A

ERROR.TYPE return values are:

    1 for #NULL!
    2 for #DIV/0!
    3 for #VALUE!
    4 for #REF!
    5 for #NAME?
    6 for #NUM!
    7 for #N/A
    #N/A for Anything else

Seems this information is missing in the online help.

ERRORTYPE returns the internal number of any error, like 502 for Err:502 or 532
for #DIV/0 and is only available in LibreOffice.

I have
problem because years ago local Sun Microsystems' translators started
translating function names with dot sign. In Polish "ERRORTYPE" is
"NR.BŁĘDU" (and many others are translated in the same convention). If I
now change "ERRORTYPE" for "NRBŁĘDU" and translate "ERROR.TYPE" for
"NR.BŁĘDU", how will it affect for users spreadsheets?

Already existing formulas simply display the new names. Users would have
to get accustomed though to the changed names if they enter new
formulas.

  Eike