'Set value and display for hyperlinks in a cell'

def _set_hyperlink(self, val):

    if (self._hyperlink_rel is None):
        self._hyperlink_rel = self.parent.create_relationship('hyperlink')
    self._hyperlink_rel.target = val
    self._hyperlink_rel.target_mode = 'External'
    if (self._value is None):
        self.value = val
