Setting read.xlsx() argument detectDates = TRUE cannot run

[KimberlyHinz]

When trying to read in a XLSX file with dates and using detectDates = TRUE, the console seems to freeze. It will not complete running, nor can I escape out of the code to stop it. R has to be either closed or forced closed through Task Manager.

I've been using as_date() with origin = "1899-12-30" as a workaround for the time being, but detectDates is more convenient.

[JanMarvin]

Hi, this should be fixed with 4.2.7.1. could you please try this?

[KimberlyHinz]

Hi, this worked! Thank you for the quick response!

[JanMarvin]

Thanks for reporting and testing. This was caused by some strange windows only bug.