Bug 91244 - LibreOffice showing scientific answer toa calculation
Summary: LibreOffice showing scientific answer toa calculation
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-12 20:44 UTC by amadorgilman
Modified: 2015-05-12 21:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
LibreOffice Spreadsheet (11.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-05-12 20:44 UTC, amadorgilman 		Details
View All 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 amadorgilman 2015-05-12 20:44:35 UTC 
Created attachment 115530 [details]
LibreOffice Spreadsheet

While doing a calculation which should have given a zero answer, LibreOffice Calc gave me a scientific answer.
The file is attached so anexpert can review it ans see what went wrong.
Comment 1 Joel Madero 2015-05-12 21:09:21 UTC 
This isn't a bug - this is a function of integers and how they are treated in software generally (all software will have some rounding errors).

Closing as NOTABUG.

For this case - if you right click the cell -> Format Cells...change decimals to 1, then back to 0, it'll correctly show 0 (despite it rounding to some very tiny number).