TransWikia.com

Change default text filter settings in Libreoffice CSV export

Ask Ubuntu Asked by Bruni on November 6, 2021

I would like to change the default settings that appear in Libreoffice under Ubuntu, when I click save as csv. I would like to use UTF-8, semicolon and “quote all text fields” as default.

I don’t seem to be able to find GUI settings for this, but maybe there is some configuration file I could modify?

I use Kubuntu 16.10, Libreoffice 5.3.0.3, but this is probably irrelevant to the answer.

2 Answers

there is a user-level configuration file located in below file (tested in Version: 6.0.7.3; thought as you mentioned as of v5.4 it remembers the last settings used):

/home/$USER/.config/libreoffice/4/user/registrymodifications.xcu

and below parameters controlling those items you desire to change their default values; so change them to the one you want (or add them if they are not exist start from 3rd line) like:

<item oor:path="/org.openoffice.Office.Calc/Dialogs/DBFExport"><prop oor:name="CharSet" oor:op="fuse"><value>76</value></prop></item>
<item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVExport"><prop oor:name="FieldSeparator" oor:op="fuse"><value>,</value></prop></item>
<item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVExport"><prop oor:name="QuoteAllTextCells" oor:op="fuse"><value>true</value></prop></item>
  • the CharSet value 76 indicate UTF-8 encoding;
  • the FieldSeparator is set to comma ,;
  • and QuoteAllTextCells to true

Answered by αғsнιη on November 6, 2021

This still is not possible. However, as of Libreoffice 5.4, Libreoffice remembers the last settings used, which mitigates the negative impact of this missing setting.

Answered by Bruni on November 6, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP