This project has moved. For the latest updates, please go here.

Hyperlink function does not work after calculated.

Dec 4, 2014 at 4: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!
Developer
Dec 5, 2014 at 11:42 AM
Edited Dec 5, 2014 at 11:44 AM
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 12: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 !
Developer
Jan 5, 2015 at 12:24 PM
Hyperlink is now included in the latest code. Will be included in next release.
Jan 6, 2015 at 3:31 AM
I have confirmed it from commit of 202eaad0219f, it was good.

Thank you.