[Libreoffice-bugs] [Bug 132508] Libre calc - The COS function seems not to give the right result

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Apr 29 04:19:58 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=132508

--- Comment #5 from Ming Hua <ming.v.hua at qq.com> ---
Well, trignometric functions in Calc use radians instead of degrees for its
angle parameters.  So for the cosine of 180 degrees you need
"COS(RADIANS(180))" which gives the correct result -1.

This is well documented in both the tooltip information for Calc functions, and
Help documentation.  I believe MS Excel has the same behavior.

I know there is a bug with more detailed information on this bugzilla, but I
can't find it right now.  Regardless, this is either NOTABUG or WONTFIX.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200429/d6e2a5cf/attachment.htm>


More information about the Libreoffice-bugs mailing list