Ask Your Question

How to alter default separator when exporting to csv file

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

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 close merge delete

2 Answers

Sort by » oldest newest most voted

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

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 +0100

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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,057 times

Last updated: May 24 '17