Range.hyperlink fails if the Hyperlink has been set with the cell formula

[fzumstein]

Range.hyperlink only works if the link has been set programmatically, not when it it set with the =HYPERLINK() formula.

[fzumstein]

Something like this will work:

import re
formula = Range('A1').formula
hyperlink = re.compile(ur'\"(.+?)\"').search(formula).group(1)  # or re.findall(r'\"(.+?)\"', formula)[0]

[Bernouilly]

This solution raise in new problem, though:
a formula containing a string (from a MATCH or a LOOKUP) will be interpreted as an hyperlink
The re should test the presence of 'HYPERLINK' instead.

EDIT: by the way, the workaround I used was to use the self.impl.hyperlink like:
sheet.range(cell_coord).impl.hyperlink

[fzumstein]

matching hyperlink is an issue because of non-english versions. How is your cell formula or could you attach a small example please, thanks.