Hello Christopher,
> As per LO built-in help for the COS function:
> "COS
> Returns the cosine of the given angle (in radians).
> Syntax
> COS(Number)
> Returns the (trigonometric) cosine of Number, the angle in radians.
> To return the cosine of an angle in degrees, use the RADIANS function."
>
> and the RADIANS function:
> "RADIANS
> Converts degrees to radians.
> Syntax
> RADIANS(Number)
> Number is the angle in degrees to be converted to radians.
> Example
> =RADIANS(90) returns 1.5707963267949, which is PI/2 to Calc's accuracy."
>
> =COS(RADIANS(60)) produces 0.5. This does not produce an error and
> nothing is misleading about the results. Feel free to report any future
> bugs you may find.
Sorry, but for MY version of LibreOffice I cannot confirm your
statements. I checked them out just a moment ago, with the current
complete setup of LibreOffice in Ubuntu 12.04.
Always the error message (in German) is "Fehler: Ungültiger Name", which
would be translated into: "Error: Invalid (function) name"
The reported LibreOffice version number is:
LibreOffice 3.5.2.2
Build-ID: 350m1(Build:202)
Anyhow: Thanks for looking into this thing!
Kind regards,
Peter
--
g.o.e.the LinguAdapt
Dr. Peter Roosen U. Vollmer & Dr. P. Roosen GbR
http://www.goethe-gbr.de http://www.linguadapt.de
http://www.peter-roosen.com
Tel. ++49 241 7091525 Tel. ++49 241 7091520
Aphasie- und Anopsietherapiesysteme: http://www.linguadapt.de
Vergleichen Sie Ihre Firma: http://www.filius-online.eu
Energietechnische Kostenfunktionen: http://kfserver.kaiserstadt.de
E-xx Kraftstoffe in Flugzeugen: http://vorodyn.de/ExxReport.html
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/983884
Title:
wrong help text
Status in “libreoffice” package in Ubuntu:
Invalid
Bug description:
calculating trigonometric functions for *degrees* requires the
addition of the operator RAD.
The libreoffice help system displays respective examples for SIN, COS
etc. as
Examples
=COS(RADIANS(60)) returns 0.5, the cosine of 60 degrees.
which will result in an error. The correct version would be:
=COS(RAD(60))
Since these kind of examples are given for several functions they are
strongly misleading!
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/983884/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
