if you create merged cells and then enter a URL in them, for example http://www.aspose.com and click on Edit link in the context menu immediately afterwards and change the display name to Aspose.Cells, the hyperlink will appear twice!? As you can see in the example file once for cell A1 and once for A1:E3.
I am not sure which behavior is correct.
- An error in Excel
- A bug of Cells
- It’s so designed by Excel
MergedCellsHyperlink.zip (6.2 KB)
var workbook = new Workbook("MergedCellsHyperlink.xlsx"); var sheet = workbook.Worksheets; // sheet.Hyperlinks has two items with same hyperlink but different area range