Ask Your Question

How to alter default separator when exporting to csv file [closed]

asked 2017-05-23 15:48:50 +0200

osoll gravatar image

When saving a calculation sheet as a csv file LO asks to define the separator suggesting a ",". Howevere when selecting another cahcracter - for example a ";" - LO does not store this setting somewhere; so when preferring another character than "," in general each time this setting has to be retyped on each export. Is it possible to change the default settings for the separator for csv exports?

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 2020-10-05 00:19:32.291032

2 Answers

Sort by » oldest newest most voted

answered 2017-05-24 14:05:43 +0200

pierre-yves samyn gravatar image


AFAIK is not currently possible. However, even if it is not stricto sensu the answer to your question, the future version 5.4 memorizes the export parameters. See release notes & tdf#55236.


edit flag offensive delete link more

answered 2017-05-24 11:40:27 +0200

JohnHa gravatar image

File > Save As. Choose .csv under Save as type. Tick Edit filter settings. Save. Choose Keep current format. Choose the separator.

If this helps then please tick the answer and/or show you like it with an uptick.

edit flag offensive delete link more


Some seem to ignore the asked question and prefer instead to answer something they imagine, and for some isn't a single case.

Mike Kaganski gravatar imageMike Kaganski ( 2017-05-24 11:48:12 +0200 )edit

Question Tools

1 follower


Asked: 2017-05-23 15:48:50 +0200

Seen: 3,427 times

Last updated: May 24 '17