Summary: | Accuracy of calculation of a big numbers | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Taufik Hasan <taufikhasan> |
Component: | Spreadsheet | Assignee: | 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. |
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.
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.
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.