[Solved] CSV-Export - cannot Edit filter options

Discuss the spreadsheet application
Post Reply
tosho
Posts: 6
Joined: Sun Oct 31, 2010 3:25 am

[Solved] CSV-Export - cannot Edit filter options

Post by tosho »

Hi,

I need to save a spreadsheet to csv and want to use special field delimiter.
When I select "save as" I cannot check "edit filter settings" as it is grayed out, no matter which output format I choose.

I have no idea what to do about it.
Last edited by tosho on Tue Nov 02, 2010 5:24 am, edited 5 times in total.
OpenOffice 3.2 on Kubuntu Maverick (10.10)
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: CSV-Export - cannot Edit filter options

Post by Villeroy »

First select text as file type, then you can edit filter options for text.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
tosho
Posts: 6
Joined: Sun Oct 31, 2010 3:25 am

Re: CSV-Export - cannot Edit filter options

Post by tosho »

Unfortunately that's exactly what happens NOT.
As I told before, no matter which output format I choose (and Text CSV is one of them) the checkbox is grayed out.
Is there any extra or package I have to install to get this option? I made a fresh install of Kubuntu and as always some things are missing in the beginning.
OpenOffice 3.2 on Kubuntu Maverick (10.10)
tosho
Posts: 6
Joined: Sun Oct 31, 2010 3:25 am

Re: CSV-Export - cannot Edit filter options

Post by tosho »

Does anybody know where the value of the default delimiter for csv files is stored?
Maybe I can change this value to my needs "by hand" as a workaround.
OpenOffice 3.2 on Kubuntu Maverick (10.10)
tosho
Posts: 6
Joined: Sun Oct 31, 2010 3:25 am

CSV-Export - cannot Edit filter options [Solved]

Post by tosho »

Strange enough, but the problem disappeared. The checkbox is still gray, but the format dialog now appears after clicking the save button.

Sorry for the noise.
OpenOffice 3.2 on Kubuntu Maverick (10.10)
jesanabriah
Posts: 1
Joined: Mon Apr 20, 2020 8:26 am

Re: [Solved] CSV-Export - cannot Edit filter options

Post by jesanabriah »

The problem occurs when saving from a .csv. If you first save the file as .odt for example, then trying to save it again as .cvs will bring up the option you are looking for.
LibreOffice 6.1.5.2 on Debian 10
Post Reply