First time here? Check out the FAQ!
asked 2012-06-30 14:51:29 +0200purbeckjm
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.
answered 2012-07-02 19:36:34 +0200qubit
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?
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-06-30 14:51:29 +0200
Seen: 1,807 times
Last updated: Jul 02 '12