Description: The report builder should include in its function set the ability to create a hyperlink field like HYPERLINK in Calc. Many times, people needs generated documents that contains links to other files in the local computer or to a web page. Hope this will be easy to add this needed feature. Steps to Reproduce: For example, selecting an hypothetical HYPERLINK function from the function list. Actual Results: NA Expected Results: Should create a link and the text to display. Reproducible: Always User Profile Reset: No Additional Info: Hope that it will be added to LibreOffice 7.0
That functionality would require the backend database engine to support the hyperlink functionality, so it couldn't always be available, depending on the db engine being used, or am I misunderstanding what you want ? Otherwise, if it just the insertion of a hyperlink into a cell of the text table, then currently, I only know of the solution linked to below : https://forum.openoffice.org/en/forum/viewtopic.php?t=70399&p=464938#p464948 Confirming your request for enhancement.
(In reply to Alex Thurgood from comment #1) > That functionality would require the backend database engine to support the > hyperlink functionality, so it couldn't always be available, depending on > the db engine being used, or am I misunderstanding what you want ? > > Otherwise, if it just the insertion of a hyperlink into a cell of the text > table, then currently, I only know of the solution linked to below : > > https://forum.openoffice.org/en/forum/viewtopic.php?t=70399&p=464938#p464948 > > Confirming your request for enhancement. I meant that the function needs only to transform the URL (stored as string in the database) to a clickable link in the generated report (which means in Writer document), not in the backend database. For example HYPERLINK receives as arguments a label and the URL string, then create a clickable link. The example code you provided is not suitable if the total number of rows is not known before the execution of the query, which changes depending on the query needed for the report.