cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Incorrect argument for ERROR.TYPE in Excel Armenian & Xhosa

Incorrect argument for ERROR.TYPE in Excel Armenian & Xhosa
1

Upvotes

Upvote
 Jul 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

 

Comment
Comments
Mourad Louha
MVP
‎Jul 23 2018 12:16 AM
‎Jul 23 2018 12:16 AM

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

 

 

 

Stafford Quaid
Microsoft
‎Jul 23 2018 08:00 AM
‎Jul 23 2018 08:00 AM

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

Mourad Louha
MVP
‎Jul 23 2018 08:36 AM
‎Jul 23 2018 08:36 AM

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

Allen Smith
Copper Contributor
‎Oct 01 2018 08:13 AM
‎Oct 01 2018 08:13 AM
Status changed to: Working on it
 
Stafford Quaid
Microsoft
‎Nov 16 2018 07:10 AM
‎Nov 16 2018 07:10 AM

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

Staff

 

Stafford Quaid
Microsoft
‎Nov 16 2018 07:11 AM
‎Nov 16 2018 07:11 AM
Status changed to: Completed
 
Mourad Louha
MVP
‎Nov 17 2018 01:01 AM
‎Nov 17 2018 01:01 AM

Hi Stafford,

thanks :)

Best, Mourad

Similar Ideas
No similar ideas