https://bugs.documentfoundation.org/show_bug.cgi?id=150635
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Mike Kaganski <[email protected]> --- 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.
