Hyperlink to local file no longer works

[robbiedesutter]

EPPlus usage

Personal use

Environment

Windows

Epplus version

8.0.2

Spreadsheet application

Excel version 2540 (Build 16.0.18730.20030) 64-bit

Description

Setting a hyperlink to a file on the local disk no longer works.

Since an Excel version update (I think to 2540), the hyperlink you set in code to a local file is no longer present when you open the file in Excel. It used to work fine.

No error is giving in code; also using an URL (https://) instead of a local file still works fine.
I've tried with Epplus version 8.0.2, 8.0.1, 7.7.0, 7.5.0 and 7.2.0 (all didn't work). Unfortunately, I cannot rollback the Excel version.

Sheet.Cells["A1"].Hyperlink = new Uri(sourceFilePath);

[JanKallman]

Thanks for reporting this. We will look at it and get back to you.

[swmal]

@robbiedesutter The below works for me when testing with the latest EPPlus 8 codebase:

[TestMethod]
public void I1963()
{
	using var p = OpenPackage("Issue1963.xlsx", true);
	var sheet = p.Workbook.Worksheets.Add("Sheet1");
	var filePath = "file:///c:\\Temp\\TestPic.png";
        var fileUri = new Uri(filePath);
			
	// 1. Use System.Uri
	sheet.Cells["A1"].Hyperlink = fileUri;
	// 2. Use OfficeOpenXml.ExcelHyperLink
	var hl = new ExcelHyperLink(filePath);
	hl.Display = "My Hyperlink";
	sheet.Cells["A2"].Hyperlink = hl;
	// 3. Use The SetHyperlink method
	sheet.Cells["A3"].SetHyperlink(fileUri);

	// style the hyperlink
	var ns = p.Workbook.Styles.CreateNamedStyle("HyperLink");
	ns.BuildInId = 8; //This is the id for the build in hyper link style.
	ns.Style.Font.UnderLine = true;
	ns.Style.Font.Color.SetColor(System.Drawing.Color.FromArgb(0xFF, 0x05, 0x63, 0xC1));
	sheet.Cells["A1:A3"].StyleName = "HyperLink";

	SaveWorkbook("Issue1963.xlsx", p);
}

Output:

See this wiki page for docs on hyperlinks with EPPlus.

[robbiedesutter]

Hi,

I've tried your steps, and it also did work for me with the latest Excel version.

Next, I tried to apply the same code in the Excel file I was using and updating, but it did fail again. So I assume that Excel file is most likely corrupt.

I started using a new Excel file instead, which works fine.