https://bugs.documentfoundation.org/show_bug.cgi?id=154131
--- Comment #4 from V Stuart Foote <[email protected]> --- We have it documented that the "Detect special numbers" checkbox is supposed to reject scientific notation formatted numbers and treat it as text[1] [2]. But reality is the exponential notation of 1E1 or SE2 has already been detected in sc editshell as a number. Likewise fully formatted SE of 1.00E+01 and 5.00E+02 are detected as numbers. So either the documentation needs to be corrected (my preference), or the editshell needs to be tweaked to honor the dialog "Detect special numbers" setting. With detection checked off, the numbers are formatted general numbers, when detected special just the rendered number format code is changed. The editshell numeric value remains intact. I think handling the format is correct/preferred for the detection. IMHO the documentation is wrong. Try this set with and without the "Detect special numbers" checkbox: 1E1 5E2 CSE1 DDE3 1.00E+01 5.00E+02 2E0 3E3 1E4 1E0 1.2E4 1.004E0 2.0056E1 2.0056E0 then examine the cell content via the format cell. And of course if you need it/expect it to be formatted as text you need to indicate such (on the sheet column before import, or within the import dialog). So IMHO => NAB but the documentation needs to be corrected. =-ref-= [1] https://help.libreoffice.org/7.6/en-US/text/shared/00/00000208.html?System=UNIX&DbPAR=CALC&HID=modules/scalc/ui/textimportcsv/box1#hd_id314847422 [2] https://help.libreoffice.org/7.6/en-US/text/shared/00/00000208.html?&DbPAR=CALC&System=WIN "Detect special numbers When this option is enabled, Calc will automatically detect all number formats, including special number formats such as dates, time, and scientific notation. The selected language influences how such special numbers are detected, since different languages and regions many have different conventions for such special numbers. When this option is disabled, Calc will detect and convert only decimal numbers. The rest, including numbers formatted in scientific notation, will be imported as text. A decimal number string can have digits 0-9, thousands separators, and a decimal separator. Thousands separators and decimal separators may vary with the selected language and region." -- You are receiving this mail because: You are the assignee for the bug.
