Issue Summary

Often, it will occur there will be a plain text URL defined within a column. If there are many rows, you can opt to use the HYPERLINK function to create a hyperlink from the plain text URL, without much manual work. This is described here:

• Excel Hyperlink Function
• Google Sheets Hyperlink Function

When using a file with hyperlinks created with the HYPERLINK function in Confluence, the Excel Macro does not treat them as hyperlinks and they are therefore not clickable.

Steps to Reproduce

1. Create a page
2. Attach the file HyperlinkTest.xlsx
3. Add Excel Macro
4. View Page

Expected Results

Cell B2 should contain a clickable hyperlink.

Actual Results

Cell B2 is not a clickable hyperlink and recognized as only text. The content returned to the browser in the request GET http://localhost:8090/rest/office/1.0/view shows there is not a href reference.

Workaround

One workaround, if using Google Sheets is to perform a find and replace on the plain text URL. For example finding string "http" and replacing with string "http" will result in bulk conversion of all URLs to hyperlinks.