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
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?
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.
Thank you for looking into this. I am now more precise into the circumstances this bug happens (see the attached file and the comment).
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.
> - 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