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.
