Overlapping of Labels in grouping of rows in MS Excel with C#

Aspose.Cells Product Family
1

We have a requirement of adding multiple links in a single cell. As its not directly possible using Aspose and C# so adding multiple shapes with hyperlink. Which is working but now if we are doing the grouping of the rows data for that column is overlapping

But in MS Excel we can add multiple links in a single cell
grafik.png (25,8 KB)

is there a possiblity to add multiple hyperlink into a single cell using Aspose? or a way to fix the overlapping of links when we do grouping of rows.

Thanks in Advance

2

@exttarunnarang

Can you please clarify if you are looking for a solution to add multiple hyperlinks in a single cell or to fix the overlapping issue when grouping rows? Additionally, please specify the programming language you are using with Aspose.Cells.

3

@exttarunnarang,

Thanks for the screenshot.

Please create a sample Excel file containing multiple hyperlinks within a single cell in an MS Excel worksheet manually. Save the file, compress it into a zip format, and share it with us here. We will check how to achieve this functionality using Aspose.Cells APIs.

4

Thanks for your quick reply.
Attached herewith a excel sheet with a single column with multiple links in a cell
Sample.zip (7,1 KB)

5

@exttarunnarang,

Thanks for the sample file.

It seems this is not the file you were expecting. I manually reviewed your Excel file by opening it in MS Excel. I selected cell A1 in the worksheet, right-clicked on it, and chose the “Edit Hyperlink” option. Upon inspection, I found that all three links point to the same URL/address. This indicates that the three links displayed on separate lines are merely text representations of a single hyperlink embedded in the cell. For your reference, please see the attached screenshot: sc_shot1.png (96.9 KB).

To clarify, it is not possible to add multiple (different) hyperlinks within a single cell. You can only assign one hyperlink per cell. If you believe it is feasible to include multiple (different) hyperlinks in a single cell, please provide a sample Excel file demonstrating this. We will review it promptly.

6

Thanks a lot!
Got the point and even if we add three different URL in a different lines in a single cell but all point to a single hypelink.
So as I mentioned earlier we are using shapes and adding them. After that we do the grouping of the rows, then data for these links messed up see below screenshots in expand and collepse of the groups
Expand one
grafik.png (24,5 KB)
Collepsed one
grafik.png (32,4 KB)
grafik.png (47,2 KB)
grafik.png (41,4 KB)

seems hyperlinks are overlapping

Also attaching the sample excel sheet
SampleGrouping.zip (11,1 KB)

Please have a look. Are we doing something wrong or there are some setting for the shapes when doing grouping of rows or any other way to fix this

7

@exttarunnarang
If you want the shape moves and sizes with cell, please set
shape.Placement = PlacementType.MoveAndSize; with Aspose.Cells
or change it in MS Excel , right click the shape, Size and Properties, Properties : check Move and size with Cells

8

Thanks a lot … it worked…

9

@exttarunnarang
You are welcome, please feel free to write us back if you have further queries or comments.