When importing a CSV file that contains values in scientific notation, the values are imported as text instead of as values.
Created attachment 49786 [details] A test case of scientific notation in a CSV file
To reproduce: 1) Open LibreOffice 2) Select "Spreadsheet" 3) Click "File -> Open..." 3) Select test case file attached to this bug report 4) Ensure that "Comma" is selected under "Separated by" and text delimiter is " 5) Click "OK" I now see that selecting the "Detect special numbers" option does allow the scientific notation to be interpreted correctly, but one would think that it should be detected correctly by default anyway.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Resetting automatically applied "needinfo", description and test case are clear.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=35fed09a0c5560b56ba53c64da8dea28bf88acff resolved fdo#39716 CSV import numbers in scientific notation
Thank you very much for this.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/618b38fb406dfc578c60f63d002ecc1cf912a901 tdf#39716: sc: Add UItest It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.