Maintain links in XSL

Created on 17 August 2023, over 1 year ago
Updated 5 September 2023, over 1 year ago

Problem/Motivation

Excel spreadsheets can contain links, but any links in the view come through in the generated XML as unlinked text

Proposed resolution

Update the export code so that linked elements (e.g. view or edit links) are links when opened in Excel.

Feature request
Status

Closed: works as designed

Version

2.0

Component

Code

Created by

🇨🇦Canada mandclu

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @mandclu
  • 🇫🇷France lazzyvn paris

    I really don't understand what you wanna request.
    In my opinion, Excel does not understand that the content is text or HTML. You can import csv into Excel You will see it. you have to click on the cell once for firs time, it will automatically convert to a link.

    Another solution you can use module https://www.drupal.org/project/bootstrap_table it can download and open with excel (base on html)

  • 🇨🇦Canada mandclu

    In a spreadsheet I can link text. In my HTML I have the short word "Edit" that links to a very long absolute URL, and for usability reasons I want the same in my exported XLS.

    According to the documentation PhpSpreadsheet has the capability to hyperlink cells, so I'm requesting that this module implement this for views fields that are linked.

  • 🇫🇷France lazzyvn paris

    you can make patch for it? It can find in XlsEncoder.php
    There is a converter link for the image, I think you need to check the extension of the link and change cell format to html

  • Status changed to Closed: works as designed over 1 year ago
Production build 0.71.5 2024