Issue 121114 - Deleting columns from CSV file causes delimiter to revert to 'tab'
Summary: Deleting columns from CSV file causes delimiter to revert to 'tab'
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 3.4.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Nika
Keywords: needhelp
Depends on:
Reported: 2012-09-26 11:09 UTC by Nathan Stretch
Modified: 2016-12-30 04:22 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: Difficult

Simple 1x3 csv file, comma delimited. Follow steps 1-3 above to see delimiter change to tab (16 bytes, text/csv)
2012-09-26 11:09 UTC, Nathan Stretch
no flags Details
Mistake for to save. (34.03 KB, image/jpeg)
2013-02-09 04:28 UTC, Javier Lopez
no flags Details
Mistake for to open (55.31 KB, image/jpeg)
2013-02-09 04:31 UTC, Javier Lopez
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Nathan Stretch 2012-09-26 11:09:51 UTC
Created attachment 79647 [details]
Simple 1x3 csv file, comma delimited.  Follow steps 1-3 above to see delimiter change to tab

1) Open a comma-delimited CSV file.
2) Delete one or more columns
3) File/save

File is now tab delimited.  To prevent this, I have to go to 'Save as', and choose 'Edit filter settings' (which correctly default to comma), overwriting the original file.  

After going through the save as route once and explicitly setting filter settings, further column deletions do not cause file to revert to tab delimited, unless it is closed and re-opened.
Comment 1 Javier Lopez 2013-02-03 22:11:16 UTC
I don't understand that is your problem because Im checking this bug but I find not the mistake. I need more information please.

Javier Lopez
Comment 2 Nathan Stretch 2013-02-03 22:38:03 UTC
I just re-read my report and it seems fairly clear. What additional information do you require exactly?
Comment 3 Javier Lopez 2013-02-08 03:26:53 UTC
I need more information
Comment 4 Nathan Stretch 2013-02-08 03:31:56 UTC
(In reply to comment #3)
> I need more information

Seriously?  I just asked you what additional information you require, and your answer is to repeat that you need "more information"?
Comment 5 Javier Lopez 2013-02-09 04:28:24 UTC
Created attachment 80241 [details]
Mistake for to save.

I'm Sorry, I had not understood what was really their problem So that's why I asked because I thought that information what appeared to me was not a mistake so I asked another's advisers, to explaining to them about this bug. Just a question: Do you see these errors? (attached)
Comment 6 Javier Lopez 2013-02-09 04:31:55 UTC
Created attachment 80242 [details]
Mistake for to open

And this mistake for to open?

We will help you and I apologize for any inconvenience caused

Javier Lopez
Comment 7 Javier Lopez 2013-02-09 04:43:30 UTC
We will help you
Comment 8 Nathan Stretch 2013-02-09 07:07:04 UTC
Well, I don't speak spanish, so I'm not sure what your save error says, but I'm not getting any messages when saving.  The open box looks like the standard import dialog for csvs, so yes, I do see something like that when opening.

It's simple enough for you to follow my instructions though.  You don't even need my attachment.  Just create a CSV file with comma separators.  You can even just do it in notepad:

1) Open notepad
2) enter "col1,col2,col3" (no quotes)
3) save as test.csv
4) Open test.cvs in openoffice calc.  Click OK through that import dialog
5) You should see a spreadsheet with 3 columns.  All is good so far.  Now, delete one of the columns.  Doesn't matter which.  (Highlight the column and go to edit/delete cells.)
6) Go to file/save, then close calc.
7) Open the file in notepad again.  Notice that the columns are now separated by tabs instead of by commas like they should be.