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.
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>
CharSet value 76 indicate UTF-8 encoding;FieldSeparator is set to comma ,;QuoteAllTextCells to trueAnswered 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
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP