Incorrect argument for ERROR.TYPE in Excel Armenian & Xhosa

Home
Incorrect argument for ERROR.TYPE in Excel Armenian & Xhosa
 07-22-2018
7 Comments (7 New)
Completed

Hi there,

maybe the following is a code bug, but it looks like a translation error and therefore I am posting it here. I firstly found the error in Excel 2013 and then tested Excel 2016 Version 1807 Build 10325.20075.

 

For reproducing, please install for Excel 2016 the Armenian (hy-am) language pack and for Excel 2013 the Language Interface Pack for Armenian. The ERROR.TYPE function looks in English like the following screenshot.

 

image.png

 

The argument #GETTING_DATA gives a result = 8 for Excel in English. In Armenian, the argument is shown as #N/A, which is incorrect. 

 

image.png

 

From Excel in English and other languages, I know that the tooltip normally shows the argument value in its text. For Armenian, which I don't speak, there are some texts starting with a # in the tooltips, which however do not correspond with the argument value.

 

Note: if I create an Excel file in an English Excel with the formula =ERROR.TYPE(#GETTING_DATA) e.g. in A1, the formula resolves to 8. If I switch the language to Armenian and open the file, the formula automatically changes to =ERROR.TYPE(#N/A) and still displays 8 as result. However, the formula should not be e.g. double clicked and validated by enter, because then, the formula takes automatically the real #N/A argument and then gives a result of 7.

 

Best,

Mourad

 

1 Upvote
Comment
Comments
Frequent Contributor

Hi there,

for Excel 2013, I found another language, where the same error ist present. Please install the Language Interface Pack for Xhosa (xh-za) and call the ERROR.TYPE function.

 

image.png

 

I tried to reproduce it in Excel 2016. For Excel 2016, the language pack for Xhosa (isiXhosa) is marked as Proofing Tools only. Installing it leads to that I can not select the language from the Office Language Tool. This leads me to the following questions:

 

  • When I install a LP for Office 2016, which is marked as Proofing Tools only, should the language appear in the language list within the Office Language Tool? If yes, then I think, something went wrong with my install (maybe due to my installation).
  • If no and the LP does not appear in the Office Language Tool, does it then mean, that the language including the translation of the UI and more parts is no more available for Office 2016?

Best,

Mourad

 

 

 

Microsoft

Hi @Mourad Louha

I am loving the new picture :). Leave it with us. We are hoping our Excel Localisation PM Roger Clarke will investigate and let you know what is going on. Staff

Frequent Contributor

Hi @Stafford Quaid,

thank you :)

PS: the picture was taken by an excellent photographer in Eupen (Belgium), I would recommend to anyone e.g. located in my region.

Best,

Mourad

Community Manager
Status changed to: Working on it
 
Microsoft

So the issue for Armenian was addressed. However these file are not exposed for us to localize in isiXhosa. Thanks for reporting it!

Staff

 

Microsoft
Status changed to: Completed
 
Frequent Contributor

Hi Stafford,

thanks :)

Best, Mourad