Thank you for providing the sample spreadsheet for our testing.
We have evaluated the presented scenario and we are able to replicate the said problem, that is; the hyperlink does not redirect to specified address when clicked on the resultant HTML. We have logged this problem in our bug tracking system under the ticket CELLSNET-43775 for further investigation. Please allow us some time to properly analyze the problem cause, and get back to you with updates in this regard.