https://bugs.documentfoundation.org/show_bug.cgi?id=170585
--- Comment #11 from Piotr Osada <[email protected]> --- (In reply to ady from comment #10) > ...other user might claim exactly the opposite: hey, I have > carefully formatted my cells in one way and the Import dialog has changed > that, simply because of some minor detail. I hadn't considered that kind of situation. And I see that it is also an important case. (1) When pasting values in scientific notation (e.g. 2.59595e-09) with 'Detect scientific notation' enabled, the values are correctly recognized as numbers, but the cell format is set to Number instead of Scientific. As a result, small values display as 0.00 — losing all meaningful digits. (2) When pasting into cells already formatted as Text (e.g. from a previous paste without 'Detect scientific notation', where undo is no longer available), the option does not override the existing Text format. The values remain text with a leading apostrophe prefix. Both cases could be addressed within the Text Import dialog itself: (1) 'Detect scientific notation' should apply Scientific format, not Number. Pasting 2.59595e-09 with 'Detect scientific notation' enabled: Current: ║ 0.0000000026 ║ ← Number format, meaningful digits are hidden Expected: ║ 2.59595E-09 ║ ← Scientific format (2) 'Detect scientific notation' should override Text format of destination cells when enabled — since the user has explicitly opted into number detection. Pasting into a cell already formatted as Text: Current: ║ 2.59595e-09 ║ ← still text, apostrophe prefix retained Expected: ║ 2.59595E-09 ║ ← Scientific format, number This would not conflict with the use case you described (preserving carefully formatted cells), because enabling 'Detect scientific notation' is an explicit user action — it signals intent to treat the data as numbers. -- You are receiving this mail because: You are the assignee for the bug.
