We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Default separator for csv files [closed]

asked 2012-06-30 14:51:29 +0200

purbeckjm gravatar image

updated 2015-10-17 00:24:48 +0200

Alex Kemp gravatar image

How can I alter the default separator for Calc when opening .csv files?

Using Ubuntu, UK Language, and the default separator seems to be a comma, but when I import any .csv files, LO insists on using a Tab as the default separator.

To my thinking, the default separator for a "Comma Separated Value" file really really should be a Comma?

And yes, I know I can change the value when opening the file - I want to resolve the automatic opening with the right separator issue because I'm converting my wife to Linux and she hates it when we find things that are different - "Why can't Linux do this - Windows does it?" :-( She's neither a techie nor a patient end-user.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 00:25:03.349136



What do you mean by the term "import". Unless it is a UK Language issue, on my version on Ubuntu whey I right click and "Open with LibreOffice" or from within Calc select File>Open>Filename.csv it always remembers the last choice I made. So in essence the default becomes whatever I use.

dshimer gravatar imagedshimer ( 2012-07-01 00:34:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-07-02 19:36:34 +0200

qubit gravatar image

I'm running LO 3.4.4 on Ubuntu 11.10, and I can confirm @dshimer's results: If I import a CSV file I'll get a "Text Import" dialog box. If the default is set as "Separated by -> Tab" and I change that to "Separated by -> Comma," that changed selection (from Tab -> Comma) will persist when I open other CSV files.

Are you using LO in a regular user account, or something with locked-down privs like a Guest account?

edit flag offensive delete link more

Question Tools


Asked: 2012-06-30 14:51:29 +0200

Seen: 8,229 times

Last updated: Jul 02 '12