How to support multiple hyperlinks in one cell？ #2937

New Issue

1977744311 · 2023-05-10T06:28:43Z

1977744311 commented

2023-05-10 06:28:43 +00:00

How can I support multiple hyperlinks in a cell, or what should I do to support it？
I see support now, for example: ws["A1"].l = { Target: "https://sheetjs.com", Tooltip: "Find us @ SheetJS.com!" };

Whether to support: ws["A1"].l = [{ Target: "https://sheetjs.com", Tooltip: "Find us @ SheetJS.com!" }, ...];

How can I support multiple hyperlinks in a cell, or what should I do to support it？ I see support now, for example: ws["A1"].l = { Target: "https://sheetjs.com", Tooltip: "Find us @ SheetJS.com!" }; Whether to support: ws["A1"].l = [{ Target: "https://sheetjs.com", Tooltip: "Find us @ SheetJS.com!" }, ...];

sheetjs commented

2023-05-10 06:37:50 +00:00

Hyperlinks are currently a cell-level property. This is borne out of spreadsheet software limitations (Excel only supports one link per cell) and file format storage (XLS / XLSB / XLSX have no equivalent of <a href="link1">Link1</a> <a href="link2">Link2</a>)

Some formats like HTML and NUMBERS do support multiple links in a cell. In the future, we may consider changing hyperlinks to align with how Numbers works.

Hyperlinks are currently a cell-level property. This is borne out of spreadsheet software limitations (Excel only supports one link per cell) and file format storage (XLS / XLSB / XLSX have no equivalent of `<a href="link1">Link1</a> <a href="link2">Link2</a>`) Some formats like HTML and NUMBERS do support multiple links in a cell. In the future, we may consider changing hyperlinks to align with how Numbers works.

sheetjs closed this issue

2023-05-10 06:37:50 +00:00

Sign in to join this conversation.