In Excel:
- Select a cell and ⌘K to add a link (set it to
http://example.com/manually-created)
- Enter the following formula into the cell:
=HYPERLINK("http://example.com/from-formula")
The cell will now show "http://example.com/from-formula".
When hovered or clicked, however, the the original "https://example.com/manually-created" URL will be used.
This isn't great from a security standpoint so we should offer an option to sanitize this.
How to clean this: When the cell has an l property, check if the formula has a call to HYPERLINK and discard the property.
In Excel:
http://example.com/manually-created)=HYPERLINK("http://example.com/from-formula")The cell will now show "http://example.com/from-formula".
When hovered or clicked, however, the the original "https://example.com/manually-created" URL will be used.
This isn't great from a security standpoint so we should offer an option to sanitize this.
How to clean this: When the cell has an
lproperty, check if the formula has a call to HYPERLINK and discard the property.