Issue 119396 - CSV file format
Summary: CSV file format
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO320m12
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2012-05-21 14:09 UTC by MAnthony
Modified: 2012-06-14 02:10 UTC (History)
2 users (show)

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

Attachments
CSV files-originals and converted (13.99 KB, application/x-zip-compressed)
2012-05-21 14:09 UTC, MAnthony 		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 MAnthony 2012-05-21 14:09:52 UTC 
Created attachment 77574 [details]
CSV files-originals and converted

I have used several different versions of "Calc" to open this same CSV file and I am getting issues with unexplained changes in the File Format. It appears that when a CSV file is opened the format for the file is not saved and a default format is used. I am assuming this because if I open the file make a change and then save it again Calc will save the file with quotes around everything even when the original CSV file was not that way. When I open the file and use the "save as" option to save it I get quotes around most of what needs quotes except if it was a date value in the original CSV. At this point I need to save this file in its original format without any change to the format and only changes to the values but can't get there with the current options in Calc. Please see the attachments. Also I am including more information on the machine I am running this on.

PC:
 OS: Windows 7 Enterprise
 Processor: Intel IF-2400 CPU @3.10GHz
 Installed memory(RAM): 4.0 GB
 System type: 64-bit OS
Comment 1 Regina Henschel 2012-05-21 16:03:05 UTC 
Perhaps you have used wrong filter settings? Try this:

Import:
Seperator      ,
Text delimiter "
check Quated fields as text
uncheck Detect special numbers

Export:
Character Set     Unicode
Field delimiter    ,
Text delimiter     "
check Quote all text cells
uncheck Save cell content as shown

Your example is far too large. Please reduce the number of columns, so that the document contains only those columns which are needed to reproduce the error.
Comment 2 Li Feng Wang 2012-06-14 02:10:32 UTC 
Can reproduce on AOO3.4 with Regina's filter settings.
but can't reproduce with 6 columns in front.

I agree to reduce sample file's numbers of columns to locate exactly.