Bug 148976 - Add option to import CSV columns as URL? FILEOPEN FORMATTING
Summary: Add option to import CSV columns as URL? FILEOPEN FORMATTING
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: CSV-Import
  Show dependency treegraph
Reported: 2022-05-07 12:28 UTC by swaush
Modified: 2022-05-09 12:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Sample .csv with urls (551 bytes, text/plain)
2022-05-08 16:17 UTC, swaush

Note You need to log in before you can comment on or make changes to this bug.
Description swaush 2022-05-07 12:28:07 UTC
If a csv file contains a column with hyperlinks these links will be imported as text. 
When importing the file the column type can be changed in the dropdown menu. Would it be possible to add the type Hyperlink or URL to this menu, and then automatically convert the column to links?
Another option would be to have a "Link" option in the cell formatting menu.

Steps to Reproduce:
1.Import CSV file with URLs in a column

Actual Results:
Column is formatted as text

Expected Results:
Column with links

Reproducible: Always

User Profile Reset: No

Additional Info:
There should be an easy way to format it as link
Comment 1 m.a.riosv 2022-05-08 14:56:06 UTC
Can you attach a sample csv file?
Comment 2 swaush 2022-05-08 16:17:35 UTC
Created attachment 180002 [details]
Sample .csv with urls
Comment 3 QA Administrators 2022-05-09 03:29:25 UTC Comment hidden (obsolete)