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
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:
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":
resolved fdo#39716 CSV import numbers in scientific notation
Thank you very much for this.