https://bugs.documentfoundation.org/show_bug.cgi?id=126882
Bug ID: 126882
Summary: When a column's width is increased, the
subraction-result in it is off by a little.
Product: LibreOffice
Version: 6.2.5.2 release
Hardware: IA64 (Itanium)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: multipart...@gmail.com
Created attachment 153345
--> https://bugs.documentfoundation.org/attachment.cgi?id=153345&action=edit
A spreadsheet with a selection of subtractions showing the problem.
To reproduce:
Make a new spreadsheet.
In A1, put '121.1'
In B1, put '120.3'
In C1, put '=A1-B1'
Increase C1's column width to 3.23cm.
C1 now displays 0.799999999999997, which it should not.
Decrease C1's column width to 3.22cm.
C1 now displays 0.8, which it should.
If 'Format Cells' is used to set the number of decimal places to 15 or greater,
the tenths-place will never show an 8.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs