Bug 139893 - Calc export to CSV doesn't escape commas
Summary: Calc export to CSV doesn't escape commas
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-25 04:19 UTC by Kemal Ahmed
Modified: 2021-05-02 17:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kemal Ahmed 2021-01-25 04:19:55 UTC 
Description:
if I want to save a Calc as CSV and there are commas in the cells, it does not delimit them properly

Steps to Reproduce:
1. create a calc file
2. add a comma in one of the cells
3. save as CSV

Actual Results:
in-cell commas are not delimited

Expected Results:
in-cell commas should be delimited


Reproducible: Always


User Profile Reset: No



Additional Info:
all you need to do is do \,
Comment 1 [REDACTED] 2021-01-25 12:23:18 UTC 
You need to enable option "[x] Edit filter settings" when saving to csv file and from there you have 2 options:

Option 1: Change the field delimiter to some other character (e.g. semicolon ";") 
Option 2: Select option "[x] Quote all text cell"

From my perspective not a bug.
Comment 2 m_a_riosv 2021-01-26 00:05:24 UTC 
Agree with @Uwe_Auer comment.
Comment 3 Jean-Baptiste Faure 2021-05-02 17:09:52 UTC 
Closing as NotABug from comments #1 and #2

Best regards. JBF