Bug 117272

Summary:	Calc: save as csv setting not remembered
Product:	LibreOffice	Reporter:	Guillaume Daudin <gdaudin>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	minor	CC:	xiscofauli
Priority:	medium
Version:	6.0.2.1 release
Hardware:	All
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	For explaining the bug

Description Guillaume Daudin 2018-04-27 08:09:31 UTC

Description:
When I save a .csv as a .csv in calc without editing the export filters, it puts double quotes around all text fields event though
- that option is not shown as ticked in the export filters
- If I go through «edit export filters» (and do not change anything), it does not put double quotes around all text fields.
FILESAVE

Steps to Reproduce:
1. save a csv file with «edit export filters"
2. uncheck the "put double quotes around all text fields" and save
3. save another csv file without "edit export filters"


Actual Results:  
The file is saved with double quotes around all text fields.

Expected Results:
The file should not have double quotes around all text fields.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15

Comment 1 eisa01 2018-05-10 12:51:28 UTC

I can not recreate this

If I save an ods file as csv it respects the default settings, and changes I do to the export settings persist to the next file save.

Only issue I see is that I always get the choice to edit export settings regardless of me checking the box.

I see now that you're working on a csv file and resaving as another. Even then it respects the last used settings in the export settings (it now only shows up if I click the export button)

Are you sure you're not confused on the last used settings?

Comment 2 Guillaume Daudin 2018-05-10 13:13:01 UTC

Created attachment 142016 [details]
For explaining the bug

Procedure : 
- Check the string cells are not quoted with BBEdit.
- Open with LibreOffice. In the import window, check "Format Quoted Fields as Text"
- Save as csv, check «Edit Filter Settings», uncheck option "Quote all text cells".
- Check the string cells are not quoted with BBEdit.
- Open with LibreOffice. In the import window, check "Format Quoted Fields as Text"
- Do not check "Edit Filter Settings".
- Check the sting celles are now quoted with BBEdit.

This is driving my Git repository crazy :) 

I do not have the problem if in the import window, "Format Quoted Fields as Text" is unchecked.

Comment 3 Guillaume Daudin 2018-05-10 13:14:19 UTC

Thank you for looking into this. I am now more precise into the circumstances this bug happens (see the attached file and the comment).

Comment 4 Guillaume Daudin 2018-05-10 13:22:40 UTC

There I a "save as csv" missing in the procedure of comment 2. It should be : 




- Check the string cells are not quoted with BBEdit.
- Open with LibreOffice. In the import window, check "Format Quoted Fields as Text"
- Save as csv, check «Edit Filter Settings», uncheck option "Quote all text cells".
- Check the string cells are not quoted with BBEdit.
- Open with LibreOffice. In the import window, check "Format Quoted Fields as Text"
- Save as csv, do not check "Edit Filter Settings".
- Check the sting celles are now quoted with BBEdit.

Comment 5 Xisco Faulí 2018-05-30 11:24:19 UTC

> - Check the string cells are not quoted with BBEdit.
> - Open with LibreOffice. In the import window, check "Format Quoted Fields
> as Text"
> - Save as csv, check «Edit Filter Settings», uncheck option "Quote all text
> cells".
> - Check the string cells are not quoted with BBEdit.
> - Open with LibreOffice. In the import window, check "Format Quoted Fields
> as Text"
> - Save as csv, do not check "Edit Filter Settings".
> - Check the sting celles are now quoted with BBEdit.

If Format Quoted Fields as Text is checked, then it's the expected behaviour. The option is remembered even if 'Edit Filter Setting' is unchecked.
Closing as RESOLVED NOTABUG