https://bugs.documentfoundation.org/show_bug.cgi?id=150635
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Mike Kaganski <mikekagan...@hotmail.com> ---
This is not a bug; and this is exactly why passwords, telephone numbers, card
ids, and any other sequences of characters that are not numbers (i.e., are not
representing a value, and are not used for calculations) should be entered as
text.
See this FAQ: https://wiki.documentfoundation.org/Faq/Calc/Accuracy
It explains that Calc uses 64-bit binary numbers internally; and that format
only guarantees 15 decimals stored accurately.
Just pre-format respective cells/columns (which is also correct for CSVs), or
enter with leading apostrophe.
--
You are receiving this mail because:
You are the assignee for the bug.
