Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-677

Hyperlinks are not imported into Excel table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: High High
    • None
    • 1.0
    • Jira Cloud for Excel
    • None
    • Minor

      Issue Summary

      When importing the data with the table option checked, the key column loses the hyperlink

      Steps to Reproduce

      1. Mark the options Allow hyperlinks and Import data into Excel Table
      2. Import data

      Expected Results

      The data is imported with the hyperlinks

      Actual Results

      The hyperlinks don’t work.

      Workaround

      Currently the workaround is to import without checking the option Import data into Excel Table and transform it into table

        1. image-2023-07-04-09-26-33-563.png
          image-2023-07-04-09-26-33-563.png
          21 kB

            [API-677] Hyperlinks are not imported into Excel table

            adrimars added a comment -

            Sadly the workaround can’t work if you have other parts of the Excel sheet that reference the table that the plugin creates itself (checked). Once the refresh deletes the tables, Excel will mark the formulas with #REF.  Then converting to a table later on will be a different table ref.  I'd be spending all my time fixing formulas.

            adrimars added a comment - Sadly the workaround can’t work if you have other parts of the Excel sheet that reference the table that the plugin creates itself (checked). Once the refresh deletes the tables, Excel will mark the formulas with #REF.  Then converting to a table later on will be a different table ref.  I'd be spending all my time fixing formulas.

              Unassigned Unassigned
              8e2ee97d25b6 Diego Leitão
              Affected customers:
              1 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated: