write_xlsx gives 2 errors when writing dates with NA - version 1.4.1

[mikecrobp]

The following code generates 2 issues

TodayDate <- as.POSIXct.Date(Sys.Date(),tz = "UTC")

df <- as_tibble(cbind.data.frame(datecol = rep(TodayDate,2), numcol = 1:2))

df[1,1] = NA
df[1,2] = NA

write_xlsx(df, path = "wxl.xlsx")

Issues:

1. Excel says the file is corrupt and then prompts to fix it
2. NA in Date col is now shown as nan(snan)

No issue with 1.4.0

[jeroen]

Hmm I don't think anything has changed in writexl, but maybe this is related to recent changes in base R wrt dates? Did you maybe test with r-devel?

[mikecrobp]

I am using very vanilla environment. R 4.2.1 plus packages based on binaries and source.
Regressing 4.1.1 to 4.1.0 seemed to make the difference.

I am very happy to do any other testing you need

[jeroen]

Can you test with the new version?

install.packages("writexl", repos = "https://ropensci.r-universe.dev")

[mikecrobp]

Can you test with the new version?

install.packages("writexl", repos = "https://ropensci.r-universe.dev")

Yes - that works for me. Thank you