https://bugs.documentfoundation.org/show_bug.cgi?id=154131
Bug ID: 154131 Summary: Pasted text like 1E1 or 5E2 treated as scientific format Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: heiko.tie...@documentfoundation.org Blocks: 107575 I insert a large list of text from the clipboard and stumbled over the fact that content like 1E1 is converted to 10 or 5E2 to 50 (among other strings like CSE1, 1ECS etc.). Without sorting I wouldn't have realized this silent conversion. Solution is to mark this column explicitly as text. However I doubt many users keep in mind to do so. We could a) always use Text, b) warn if a column contains variable content, c) just don't convert scientific number formats. None is really good, maybe c) with an option to switch it on. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107575 [Bug 107575] [META] Number format bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.