Android Question Atan2 backwards

[Raywingit]

Atan2 calculates (X,Y) instead of (Y,X) which appears to be a B4A bug in ver.5.80
This is compared to same function in Excel
Best way to handle this would be a note in function info, since changing it
would probably cause some grief.
Found this while converting a program from (Excel+VBA) to B4A.

 

[Erel]

ATan(1 / 2) = Atan2 (1, 2)

The signature is Atan2 (Y, X) where:
Y - the ordinate coordinate
X - the abscissa coordinate

 

[Raywingit]

In B4A I get : Atan(1 / 2) = 0.4636 = Atan2 (1, 2)
But in Excel: Atan(1/2) = 0.4636 and Atan2(1,2) = 1.1071

It may be that neither is wrong, but they are different. In Excel Atan2(2,1) = 0.4636.

 

[klaus]

Excel is different from programing languages.
From Excel help:
Atan2(x, y)
Programing languages:
Atan2(y, x)

 

[Raywingit]

• From Wikipedia:
• In Microsoft Excel,[4] OpenOffice.org Calc, LibreOffice Calc,[5] Google Spreadsheets,[6] iWork Numbers,[7] and ANSI SQL:2008 standard,[8] the atan2 function has the two arguments reversed.
• So B4A is exonerated, Microsoft is the bad guy. I like it.