Bug 148976 - Add option to import CSV columns as URL? FILEOPEN FORMATTING
Summary: Add option to import CSV columns as URL? FILEOPEN FORMATTING
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
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:


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

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
Description:
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)