Description: atan2(y,x) should return the same as atan(y/x) for x > 0. Instead, it returns atan(x/y). See https://en.wikipedia.org/wiki/Atan2 under "Definition and computation." Steps to Reproduce: 1. Enter =atan2(1,2) in a cell. 2. Enter =atan(0.5) in another cell. 3. Enter =atan(2) in another cell. Actual Results: atan2(1,2) returns 1.10714871779409. atan(0.5) returns 0.463647609000806. atan(2) returns 1.10714871779409. Expected Results: atan2(1,2) returns 0.463647609000806. atan(0.5) returns 0.463647609000806. atan(2) returns 1.10714871779409. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Microsoft Excel does the same as Calc for atan2. The definition seems to be atan2(x,y) instead of atan2(y,x). Therefore this is not a bug.
yes arguments of arctan2 function are x coordinate first, then y coordinate in Calc and Excel.
Because of this confusion, the help has the info: tip Programming languages have usually the opposite order of arguments for their atan2() function.