Ask Your Question
0

How to alter default separator when exporting to csv file

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

2 Answers

Sort by » oldest newest most voted
2

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

pierre-yves samyn gravatar image

Hi

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.

Regards

edit flag offensive delete link more
-1

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,898 times

Last updated: May 24 '17