This project has moved and is read-only. For the latest updates, please go here.

Hyperlink function does not work after calculated.

Dec 4, 2014 at 5:45 AM
Hi , I am using EPPlus 4.0.1.1 .

I have a problem where Hyperlink function in my template excel file .
When saved template file after worksheet.calculated it results in #NAME?.

For example :
Cell formula : "M33" = HYPERLINK("#'Person'!A1","[Person]")
Displaying : #NAME?

Thanks!
Dec 5, 2014 at 12:42 PM
Edited Dec 5, 2014 at 12:44 PM
If I understand this correctly you are calling worksheet.Calculate() first?

The Hyperlink function is not yet supported by EPPlus, you can see the supported functions here:

http://epplus.codeplex.com/wikipage?title=Supported%20Functions&referringTitle=Documentation
Dec 8, 2014 at 1:10 AM
I see. Then I found a workaround about that.

Bad : OfficeOpenXml.CalculationExtension.Calculate(worksheet)

Good: OfficeOpenXml.CalculationExtension.Calculate(specificRange) 'Excluding hyperlink cells

Thanks !
Jan 5, 2015 at 1:24 PM
Hyperlink is now included in the latest code. Will be included in next release.
Jan 6, 2015 at 4:31 AM
I have confirmed it from commit of 202eaad0219f, it was good.

Thank you.