Write number as character without Excel error

[JanMarvin]

In the example below we write 1992 three times: (i) as character, (ii) as numeric with a style format and (iii) as numeric. This is the output from Excel:

The first cell contains a number written as character, therefore the well known Excel green flag error. The second is the Excel way of writing a number as character. This uses a special style designed for this. Finally, the third is simply a number.

We might want to look into ways to write the correct way per default. Tough currently I am not sure how to approach this efficiently.

library(openxlsx2)


wb <- wb_workbook()$add_worksheet()$
  add_data(dims = "A1", x = "1992")$
  add_data(dims = "A2", x = 1992)$
  add_data(dims = "A3", x = 1992)

wb$add_cell_style(dims = "A2", applyNumberFormat = "1", quotePrefix = "1", numFmtId = "49")

# wb$open()