https://bugs.freedesktop.org/show_bug.cgi?id=86024
Bug ID: 86024
Summary: FORMATTING: Erroneous formatting of certain numbers
Product: LibreOffice
Version: 4.2.6.3 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
In a cell with default (automatic) formatting, using a column width of 0.90"
and Calibri size-12 font, the number 5385137647.06696 is displaying as 37647,
regardless of whether the cell produces the value from function or has the
value written to it directly.
The actual value is not lost, and manually choosing scientific notation
corrects the display problem. Changing the cell width a sufficient amount in
either direction also corrects the problem, triggering automatic scientific
notation for the correct value when narrower, and the full length value when
wider.
Creating a new spreadsheet, adjusting the font of any cell to the above
specifications, and placing 5385137647.06696 in that cell reproduces the effect
(the default column width of 0.89" is within the necessary range).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
