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).
Created attachment 109130 [details] Sample file showing the bug. Hi @Alexander, thanks for reporting. Reproducible. Win7x64Ult. Version: 4.2.7.2 Build ID: 933c0aa564ec4f8883ed5732c866db48dca4dac5 + Version: 4.4.0.0.alpha1+ Build ID: 8b21b5cbe78945b27525b4ce78ae3d981f90590f TinderBox: Win-x86@39, Branch:master, Time: 2014-11-06_03:55:51
Also reproducible with LO 4.3.3.2, Win 8.1.
I found the same on OSX 10.10 in LibreOffice 4.2.6.3 Build-ID: 3fd416d4c6db7d3204c17ce57a1d70f6e531ee21 Ill try to add another Attachement.
Created attachment 109265 [details] Broken formattting
Prio high as this may lead to completly wrong numbers
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.