Issue 112067 - Importing CSV - Numbers recognized as Text with 'ticks
Summary: Importing CSV - Numbers recognized as Text with 'ticks
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: DEV300m80
Hardware: PC All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa, regression, release_blocker
Depends on:
Reported: 2010-06-03 09:33 UTC by Mechtilde
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description Mechtilde 2010-06-03 09:33:48 UTC
I imported an CSV (bank data)

As date as currencies are recognized as text with ticks.

If i open the same CSV with 3.2.1 and as I have done before it
was recognized as numbers.

So this is a very bad regression
Comment 1 niklas.nebel 2010-06-03 10:06:38 UTC
There is a new option "Detect special numbers", see issue 97416 and
If the option is not set, what you describe is intended behavior.
Comment 2 oc 2010-06-03 10:24:48 UTC
Due to the changes in cws koheicsvimport the behavior has changed. If you check
the "Detect special numbers" option the date and currency columns will be
correctly detected. (see also issue 97416)
Comment 3 Mechtilde 2010-06-03 13:59:40 UTC
I test it again using the new function it doesn't work as expected.

I test it with version DEV300m80
Comment 4 oc 2010-06-04 06:23:01 UTC
Could you please give an example of what goes wrong and what you expected
Comment 5 Mechtilde 2010-06-04 08:23:56 UTC
I reduce the data to date, numbers (w/o decimal) with version 3.2.1 and then
open it with DEV300_m80

Date and numbers without decimal are ok. Numbers with decimal are formated as text.

I send this CSV directly to oc.
Comment 6 Mechtilde 2010-06-04 11:09:56 UTC
the result of a short discussion is.

The CSV (character separated values) contains as a comma to separate the values
as a comma as the decimal separator.

then we need to look that the option "Quoted field as text" if this is
deactivated or not.

Only with the deactivated option it works right.

so I set the issue to worksforme again and close it. 
Comment 7 Mechtilde 2010-06-04 11:10:31 UTC
-> closed
Comment 8 jmpoo 2010-08-11 11:08:35 UTC
Detecting Date and Time as Text and mark it with ' as default is very irritating
for users. It works as designed but not as expected.

The expected behavior is, that date and time is detected as numbers, just like
older Ooo-Versions and also Excel did. Usually Series of mesurements are written
with time stamps to csv-files. To get xy-charts in Calc, it is necessary that
date and time has number format.

So please set "Detect special numbers" as default and change the new option to
"Detect special numbers as text". It might be more self-explanatory to users.