Bug 39716 - Import of values in scientific notation from CSV file
Summary: Import of values in scientific notation from CSV file
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.2 release
Hardware: All All
: low minor
Assignee: Eike Rathke
Whiteboard: target:3.6.0 target:7.4.0
Depends on:
Reported: 2011-08-01 06:13 UTC by Frank
Modified: 2022-03-24 20:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

A test case of scientific notation in a CSV file (1.26 KB, text/csv)
2011-08-01 06:18 UTC, Frank

Note You need to log in before you can comment on or make changes to this bug.
Description Frank 2011-08-01 06:13:12 UTC

Comment 1 Frank 2011-08-01 06:15:50 UTC
When importing a CSV file that contains values in scientific notation, the values are imported as text instead of as values.
Comment 2 Frank 2011-08-01 06:18:25 UTC
Created attachment 49786 [details]
A test case of scientific notation in a CSV file
Comment 3 Frank 2011-08-01 06:33:19 UTC
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.
Comment 4 Björn Michaelsen 2011-12-23 12:21:33 UTC
[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
Comment 5 Eike Rathke 2012-04-03 09:31:54 UTC
Resetting automatically applied "needinfo", description and test case are clear.
Comment 6 Not Assigned 2012-04-03 12:00:01 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":


resolved fdo#39716 CSV import numbers in scientific notation
Comment 7 Francisco 2012-06-07 17:30:32 UTC
Thank you very much for this.
Comment 8 Commit Notification 2022-03-24 20:09:04 UTC
Xisco Fauli committed a patch related to this issue.
It has been pushed to "master":


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:

Affected users are encouraged to test the fix and report feedback.