Bug 58367

Summary: Accuracy of calculation of a big numbers
Product: LibreOffice Reporter: Taufik Hasan <taufikhasan>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG QA Contact:
Severity: critical    
Priority: medium CC: mariosv
Version: 3.6.4.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: File Showing error in calculation
Reformated file with decimal positions.

Description Taufik Hasan 2012-12-16 15:41:49 UTC
Created attachment 71588 [details]
File Showing error in calculation

Result of a calculation is in error, direct calculation gives good result (compare with a calculator)
File attached.
Comment 1 m.a.riosv 2012-12-16 23:00:35 UTC
Created attachment 71606 [details]
Reformated file with decimal positions.

There are numbers with decimals positions, so the calculations are being done with different numbers, in direct calculations you are using rounded numbers.

J3: =5105846,8282900
M11: =360000
J16: = J3*M$11   result 1838104858184,400000
J17: =5105847*360000

5105847 in J17 not equal to J3

Attached file changing the viewing cells format.
Comment 2 m.a.riosv 2012-12-16 23:00:53 UTC
Not a bug.
Please if you are not agree, reopen the bug.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.