https://bugs.documentfoundation.org/show_bug.cgi?id=170585
--- Comment #5 from Piotr Osada <[email protected]> --- Created attachment 205355 --> https://bugs.documentfoundation.org/attachment.cgi?id=205355&action=edit 'Detect scientific notation' does not change format to scientific on import Actually it's not a regression, but lack of functionality. Steps: 1) Copy values in scientific notation (1.23e-4) 2) Paste Special -> Use text import dialog 3) *Do not* select 'Detect scientific notation' Result: Cells where the pasted value is text <number>e<number> or <number>e-<number> will be formatted as text. Then: 4) Paste the same data but *do select* 'Detect scientific notation'. Result: Format of text-fomratted cells is not changed to number or scientific, so we can't format to another types without deleting ' (apostrophe) at start of the cell value. Suggestion: Make 'Text Import' set the format according to import options. Version does not matter. But observed with: Version: 25.8.4.2 (X86_64) Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df CPU threads: 8; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: en-US (pl_PL); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
