| Summary: | Calc showing incorrect result in number format, but correct result in scientific format. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | spam.monopolycar |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | raal |
| Priority: | medium | ||
| Version: | 4.3.3.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | incorrect calculation in number format | ||
27468782973563,10 x 0,003 = 82406348920,6893 where is the problem? C16 = 82406348920,6894 C17 = 82406348920,6894 (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 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) Probably duplicate of bug 78503. Please try disable Calc option "Use printer metrics for text formatting". (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 *** |
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.