https://bugs.documentfoundation.org/show_bug.cgi?id=173336
Bug ID: 173336
Summary: Recognize URLs and relative file references as
hyperlinks when opening CSV files
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 208296
--> https://bugs.documentfoundation.org/attachment.cgi?id=208296&action=edit
results of importing a csv file and editing individual cells
When opening a CSV file in Calc, cells containing URLs should be recognized as
hyperlinks in the same way as URLs entered interactively into a cell.
This should include at least:
* `https://...`
* `http://...`
* file references to local files
In particular, I would like relative file references to be resolved relative to
the directory containing the CSV file.
For example, if the CSV file is:
`/projects/myproject/backlog.csv`
and a cell contains a reference to:
`backlog/user-story-1.md`
or an equivalent `file:` reference, clicking it should open:
`/projects/myproject/backlog/user-story-1.md`
using the operating system's default application.
My use case is a software backlog stored as CSV, with detailed descriptions of
backlog items stored as Markdown files in a subdirectory. Keeping both CSV and
Markdown as text files makes them easy to manage with Git and development
tools.
Currently, URLs already present in a CSV file are not consistently converted
into hyperlinks when the file is opened. Editing the same cell can cause Calc
to recognize it as a hyperlink, resulting in different behavior depending on
whether the value was imported or entered interactively.
It would be useful if hyperlink recognition during CSV import behaved
consistently with hyperlink recognition during normal cell entry, and if
relative file links were resolved relative to the CSV document.
--
You are receiving this mail because:
You are the assignee for the bug.
