CSV gets tab separated instead

Discuss the spreadsheet application
Post Reply
User avatar
xurizaemon
Posts: 3
Joined: Tue Nov 27, 2007 11:54 pm

CSV gets tab separated instead

Post by xurizaemon »

When I save a CSV that I've opened, and choose the format "CSV", my OpenOffice saves a tab-separated sheet instead.

It's not exactly hard to fix (perl -pi -e 's#\t#,#g' doc.csv) but it's not particularly endearing either :)

Any clue why this would be? Is this a known bug, or some misconfiguration (did I click the "commas are really tabs"button?)

Version is Openoffice.org 1:2.3.0-1ubuntu5, Mon Oct 15 09:22 2007
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: CSV gets tab separated instead

Post by acknak »

It may actually be the default; it's generally what I use anyway, so I don't notice it.

In the File > Save As dialog, there should be an "Edit filter settings" check. Tick that, make your settings and OK. The settings should be used by default the next time you want to save a CSV file.
AOO4/LO5 • Linux • Fedora 23
User avatar
xurizaemon
Posts: 3
Joined: Tue Nov 27, 2007 11:54 pm

Re: CSV gets tab separated instead

Post by xurizaemon »

thanks, acknak! worked a charm. will keep an eye out for that in future ...
Post Reply