Bug 90984 - Calc showing incorrect result in number format, but correct result in scientific format.
Summary: Calc showing incorrect result in number format, but correct result in scienti...
Status: RESOLVED DUPLICATE of bug 78503
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-01 07:07 UTC by spam.monopolycar
Modified: 2015-05-03 06:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
incorrect calculation in number format (25.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-05-01 07:07 UTC, spam.monopolycar
Details

Note You need to log in before you can comment on or make changes to this bug.
Description spam.monopolycar 2015-05-01 07:07:06 UTC
Created attachment 115231 [details]
incorrect calculation in number format

While doing a certain calculation, i noticed that one of the results didn't seem right.

if you look at the attachment:

row 16 is a *simple* multiplication, in number format, with the incorrect result highlighted.

row 17 is the same multiplication, in scientific format, with the correct result.
Comment 1 raal 2015-05-01 08:23:37 UTC
27468782973563,10 x 0,003 = 82406348920,6893

where is the problem?


C16 = 82406348920,6894
C17 = 82406348920,6894
Comment 2 raal 2015-05-01 08:23:59 UTC
(In reply to raal from comment #1)
> 27468782973563,10 x 0,003 = 82406348920,6893
> 
> where is the problem?
> 
> 
> C16 = 82406348920,6894
> C17 = 82406348920,6894

Version: 5.0.0.0.alpha1+
Build ID: 59adad74084e9281887e3f78a225794f37b784d7
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-29_12:40:39
Comment 3 spam.monopolycar 2015-05-03 05:19:07 UTC
wow. this is completely bizarre. in my libreoffice calc window, i see

C15 -> 3.00E-003
C16 -> 6348921
C17 -> 8.24E+010


but when i cut and paste those same cells into any text editor, i get:

C15 -> 3.00E-003
C16 -> 82406348920.6894
C17 -> 8.24E+010

when i cut and paste those same cells anywhere in calc, i get the incorrect value.

all other cells perform the calculation correctly. 

if you aren't seeing the same thing, it must be specific to my computer, but i have no idea what would cause that.  

thanks for your time.


Version: 4.3.3.2
Build ID: 430m0(Build:2)
Comment 4 raal 2015-05-03 06:21:22 UTC
Probably duplicate of bug 78503. Please try disable Calc option "Use printer metrics for text formatting".
Comment 5 spam.monopolycar 2015-05-03 06:56:17 UTC
(In reply to raal from comment #4)
> Probably duplicate of bug 78503. Please try disable Calc option "Use printer
> metrics for text formatting".

yep. it looks very similar to bug 78503. except, when i enable printer metrics, it clears up the problem. with printer metrics disabled, i get the problem.

oh well. thank you again.

*** This bug has been marked as a duplicate of bug 78503 ***