Bug 142503 - error in functions sin
Summary: error in functions sin
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-26 15:49 UTC by Huysmans
Modified: 2021-05-26 16:33 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
calc file (30.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-26 15:55 UTC, Huysmans
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Huysmans 2021-05-26 15:49:45 UTC
Description:
for an angel of 180° Calc gives sin=1,22464679914735E-16	sin must be 0
for an angel of 360° Calc gives sin=-2,44929359829471E-16	sin must be 0
Formula used for sin   sin(radialen(angel))



Steps to Reproduce:
Formula used for sin   sin(radialen(angel))

2.
3.

Actual Results:
for an angel of 180° Calc gives sin=1,22464679914735E-16
for an angel of 360° Calc gives sin=-2,44929359829471E-16	

Expected Results:
In both cases te result must be 0
error persist in further multiples of 180°


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Versie: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU-threads: 12; Besturingssysteem: Linux 5.4; UI-render: standaard; VCL: gtk3; 
Locale: nl-BE (nl_BE.UTF-8); Calc: group
Comment 1 Huysmans 2021-05-26 15:55:23 UTC
Created attachment 172368 [details]
calc file
Comment 2 Mike Kaganski 2021-05-26 16:33:55 UTC
This is not a bug. Multiples of pi are not representable in IEEE 754 numbers used in Calc. See FAQ at [1].

[1] https://wiki.documentfoundation.org/Faq/Calc/Accuracy