Bug 165659 - Data Provider: the user should be able to define the delimiter when importing CSV files
Summary: Data Provider: the user should be able to define the delimiter when importing...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.0 alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-Provider
  Show dependency tree / graph
 
Reported: 2025-03-09 23:19 UTC by Rafael Lima
Modified: 2025-03-10 01:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Sample CSV file with semicolon as delimiter (615 bytes, text/csv)
2025-03-09 23:19 UTC, Rafael Lima 		Details
View All 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 Rafael Lima 2025-03-09 23:19:37 UTC 
Created attachment 199714 [details]
Sample CSV file with semicolon as delimiter

In the Data Provider dialog, if the CSV file being imported uses some other delimiter as a semicolon ";", it will not separate columns as expected.

Steps to reproduce:
1) Open the Data Provider dialog
2) Select CSV in "Data Format"
3) Click "Browse" and select the file attached to this bug
4) Click "Apply"
5) Note that the columns are not separated; everything is in the first column

There should be a drop-down where the user can select the delimiter; possible options could be: Comma, Semicolon, Tab, Blank space.
Comment 1 m_a_riosv 2025-03-10 01:02:08 UTC 
+1
I think not only a dropdown, but the import dialog, as it show when opening a csv or when it is linked through the different Menu>Sheet>Insert sheet …. Or Menu>Sheet>External links. And afterward showed in Menu>Edit>External links.