Issue 112067

Summary:	Importing CSV - Numbers recognized as Text with 'ticks
Product:	Calc	Reporter:	Mechtilde <mechtilde>
Component:	open-import	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED IRREPRODUCIBLE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P2	CC:	issues, jmpoo-bugz
Version:	DEV300m80	Keywords:	oooqa, regression, release_blocker
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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 OpenOffice.org 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
http://wiki.services.openoffice.org/wiki/Calc/Features/Numbers_import_for_plain_text_files.
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.