title: Openxslx and hyperlinks in Excel - Hyperlinks work but don't appear blue-coloured and underlined
body: <p>I am using <code>openxlsx</code> to generate a massive Excel file with a lot of cells containing internal hyperlinks (i.e. pointing to other locations within the same spreadsheet).</p>
  <p>Everything is working fine except for the format of the cells containing these hyperlinks: they are neither blue-coloured nor underlined, so they appear as plain text (but the formula inside is correct and the cell is clickable and points to the right cell).</p>
  <p>After having generated the Excel file, I can get the right format for these cells (blue-coloured and underlined) by editing each cell (F2) and validating them (ENTER).</p>
  <p>Any idea how to automate this pure format issue?</p>
  <p>[EDIT]: It seems it comes from a generic limitation of <code>openxlsx</code>: there is currently no 'superimpose' formatting option, just a 'replace' one. More explanations are provided in a new question here: <a href="https://stackoverflow.com/questions/73823657/openxlsx-is-there-a-superimpose-mode-for-styles">Openxlsx - Is there a superimpose mode for styles?</a></p>