Writing hyperlink formula after upgrading to version 4.2.4

[kbzsl]

Describe the bug
I found an issue when writing an hyperlink formula (writeFormula) after upgrading the openxlsx from 4.2.3 -> 4.2.4.

To Reproduce
Here is an example code:

library(dplyr)
library(openxlsx)

channels <- tribble(
  ~channel, ~homepage,
  "ABC", "https://www.abc.net.au/",
  "BBC", "https://www.bbc.com/",
  "CBC", "https://www.cbc.ca/"
)

channels <- channels |> 
  mutate(formula = paste0(
    '=HYPERLINK("', 
    homepage, 
    '", "', 
    channel, 
    '")')
  )

wb <- createWorkbook()
addWorksheet(wb, "channels")
writeDataTable(wb, "channels", channels, tableName = "channels")
writeFormula(wb, "channels", channels$formula, startRow = 2, startCol = 1)
freezePane(wb, "channels", firstRow = TRUE)
setColWidths(wb, "channels", cols = 1:ncol(channels), widths = "auto")
saveWorkbook(wb, file = here::here("temp",  "channels.xlsx"), overwrite = TRUE)

Screenshots

screenshot when using 4.2.3 (desired outcome):

screenshot when using 4.2.4

[ycphs]

I will take a look at it