Issue 115683 - calc imports scientific notation as text
Summary: calc imports scientific notation as text
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.0.0
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-19 16:27 UTC by theyogre
Modified: 2010-11-23 16:39 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
.csv file (actually tab delimited, but same result) used for import (270.10 KB, text/plain)
2010-11-19 16:31 UTC, theyogre 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description theyogre 2010-11-19 16:27:48 UTC 
I have a .csv file with data columns. Some of the data are in scientific notation.

1.2345e-08 (lower case e)

These cells are all imported as text, so they don't sort properly.
If I tell the import to detect special numbers, then it works. It was not
obvious to me that scientific notation was a special number. This seems like a
design flaw for which I can imagine different possible solutions. I don't know
anyone who regularly works with scientific notation who considers them special
numbers. A quick fix would be to show examples of common special numbers next to
that dialogue option, or even have a help entry that discusses "special numbers"
and what is meant by that option. I was unable to find one.
Comment 1 theyogre 2010-11-19 16:31:07 UTC 
Created attachment 75064 [details]
.csv file (actually tab delimited, but same result) used for import
Comment 2 theyogre 2010-11-19 16:34:29 UTC 
I'm using version 3.2.0.10
Comment 3 ooo 2010-11-23 16:39:44 UTC 
In the import dialog set the column type of those columns to "US English". In
the upcoming OOo3.3 you will be able to select the import locale for the entire
document.
Comment 4 ooo 2010-11-23 16:39:59 UTC 
Closing.