=COS(RADIANS(60)) returns error with German UI
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
libreoffice (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
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!
---
ApportVersion: 2.0.1-0ubuntu7
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Beta i386 (20120405)
Package: libreoffice 1:3.5.2-2ubuntu1
PackageArchitec
ProcEnviron:
TERM=xterm
PATH=(custom, user)
LANG=de_DE.UTF-8
SHELL=/bin/bash
ProcVersionSign
Tags: precise
Uname: Linux 3.2.0-24-
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm audio cdrom dip fuse lpadmin netdev plugdev sambashare sudo video
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Low |
Changed in libreoffice (Ubuntu): | |
status: | Incomplete → New |
summary: |
- wrong help text + =COS(RADIANS(60)) returns error with German UI |
petroo, thank you for reporting this and helping make Ubuntu better. Regarding your comments:
>"Examples
=COS(RADIANS(60)) returns 0.5, the cosine of 60 degrees.
which will result in an error."
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.