[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