https://issues.apache.org/ooo/show_bug.cgi?id=126052
--- Comment #2 from Lars Jødal <[email protected]> --- I have tried with US version 4.1.1 (after de-install Danish version, install US version) with no change: Only the first line is recognized as a number, the two numbers in scientific notation are imported as text. Additional finding: If I select the column at import and change the type from "Standard" to "English (US)" then the scientific format IS recognized as numbers. This behaviour is the same for the US and the Danish version of AOO. To sum up: Opening af *.csv file, I find that the scientific format is recognized if I a) select "Detect special numbers" b) or explicitly mark the column as "English (US)" but not by a standard import. My findings are identical for the Danish and the US versions of AOO 4.1.1. I have now also tried changing the Windows number setting to English (US). No change (except that of course the correctely imported number is shown as "5.49" instead of "5,49"). Thus, the issue does not seem to relate to the Windows settings. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
