Apache OpenOffice (AOO) Bugzilla – Issue 121114
Deleting columns from CSV file causes delimiter to revert to 'tab'
Last modified: 2023-01-23 07:13:13 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.
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
I just re-read my report and it seems fairly clear. What additional information do you require exactly?
I need more information
(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"?
Created attachment 80241 [details] Mistake for to save. Hello. 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)
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
We will help you
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.
I can't reproduce this with the latest Git on Windows or FreeBSD, nor with 4.1.X on Windows. It always saves the file with comma separators, never tabs. Can you please test a more recent version and tell us whether this bug has been fixed for you?
I can't reproduce this issue with version 3.4.1 on Windows 7. Not reproducible with the latest version on Windows.