Bug 85830 - =COS(PI()/2) result is 6.12323399573677E-017 instead of zero
Summary: =COS(PI()/2) result is 6.12323399573677E-017 instead of zero
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.2.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-04 03:14 UTC by thce_lucian
Modified: 2014-11-04 23:48 UTC (History)
1 user (show)

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 thce_lucian 2014-11-04 03:14:56 UTC 
=COS(PI()/2) result is 6.12323399573677E-017 instead of zero

Hope it helps
Comment 1 MM 2014-11-04 19:33:26 UTC 
That's because you have options > libreoffice calc > calculate > 'limit decimals for general number format' off. Or put it on and set the decimal places at 16 or more. Anything less than 16 gives 0.
Comment 2 m_a_riosv 2014-11-04 23:48:20 UTC 
Please take a look to this comment
https://bugs.freedesktop.org/show_bug.cgi?id=50299
please take a look specially the comment#4.