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: [email protected]
Reporter: [email protected]
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.
