Bug 114521 - SIN(RADIANS(180)=1,22464679914735E-16
Summary: SIN(RADIANS(180)=1,22464679914735E-16
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-18 06:42 UTC by Stefan Buraj
Modified: 2017-12-18 07:12 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Buraj 2017-12-18 06:42:53 UTC 
sin(radians(180)=0 
When entering the libreoffic sin (radians (180) returns result 1.22464679914735E-16
what is not a zero. 
When entering the libreoffic sin(pi()) returns result 1.22464679914735E-16
what is not a zero.
when entering the libreoffic cos(radians(90) returns result 6,12323399573677E-17
what is not a zero.
when entering the libreoffic cos((pi/2)) returns result 6,12323399573677E-17
what is not a zero.
Comment 1 Mike Kaganski 2017-12-18 07:12:51 UTC 
This is expected when working with floats that cannot be represented exactly in computer.

If you look into value of PI(), it's not equal to actual π, either.

https://en.wikipedia.org/wiki/Floating-point_arithmetic#Accuracy_problems

Closing WONTFIX.