https://bugs.documentfoundation.org/show_bug.cgi?id=150635
Bug ID: 150635 Summary: Numbers larger than 15 digits cannot be FORMATED as TEXT Product: LibreOffice Version: 3.5.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: tsf...@gmail.com It is impossible enter numbers larger than 15 digits on a spread sheet, unless the cell or row or column was pre-formatted to be text (Format cells>Numbers>Text). Any number, larger than 15 digits is automatically converted to scientific notation which is all right for calculations but not for text value. Furthermore, such numbers converted to scientific notation and saved as text, are irretrievably lost. For example: 12345678901234567 entered as text, is not the same as its scientific equivalent 1.234567890123456E+16 and yet the long form number will be lost and cannot be retrieved. That means, the spread sheet cannot be used for storing long numerical passwords or open a .csv file containing such passwords or data. Pre-formatting the spreadsheet to “text” is not a solution because when opening a .csv file (or any data file) you cannot know which cells will require such formatting and the value in those cells will be lost. -- You are receiving this mail because: You are the assignee for the bug.