Hyperlinks

v1.7.0 makes links work the way they do in Excel. A link is a property of a cell, not a cell type: the cell keeps its own value and formatting, and the link only decides what a click does. Writing links from code is Pro; links loaded from an xlsx or JSON file show and open in both editions.

• Hover a linked cell: the pointer turns into a hand and a tip shows the address — below the screen tip when the link has one — so you see where it goes before you click
• Click opens it in a new tab with noopener,noreferrer. Click and hold (0.6s) selects the cell instead, as in Excel, and a drag selects a range
• The first four links come from ws.setHyperlink(row, col, url, { tooltip }). ReoGrid does not restyle them: the blue underline is an ordinary setStyle({ color, underline: true }), just as Excel's Hyperlink style is ordinary formatting
• =HYPERLINK(address, label) shows its label. The address is evaluated on hover and click, so the second formula builds it from C8 — type another demo id there, such as zoom
• grid.onHyperlinkClick fires before anything opens. The Open order links carry an app:// address the page handles itself: event.cancel = true, then the order is selected in the table below. Tick Intercept every link to cancel them all
• Only http, https, mailto and tel addresses are opened. The file:/// link — common in Excel files — gets a short message on the cell instead, and a javascript: address is never run
• Links follow row/column insert and delete, sort and drag-to-move, and round-trip through xlsx (<hyperlinks>) and ReoGrid JSON