https://bugs.documentfoundation.org/show_bug.cgi?id=150635
--- Comment #1 from Tamas <tsf...@gmail.com> --- 1. Open a spreadsheet and enter a 14 digit number in a cell. Since the default column-width is probably less than 0.9-inch, the number format will automatically switch to scientific notation. 2. Enlarge the column-width to twice its default size and enter three more numbers under the previously entered number, 15, 16, and 17 digits long. The 17 digit number will automatically switch to scientific notation no matter how wide your column is and the 16 digit number will change as soon as you format it to “text”. 3. If the 16 or 17 digit numbers are now copied to a text file, it will copy in the scientific format which is not the same as the original number that was typed in the spreadsheet. As a matter of fact, the original number is lost (unless you happen to remember it) because the scientific notation cannot be converted back to long form beyond 16 digits. -- You are receiving this mail because: You are the assignee for the bug.
