ycphs/openxlsx

Repeated newlines are combined into one when reading XLSX on Windows

uhkeller opened this issue · 0 comments

Describe the bug
When reading an XLSX file with multiple consecutive newlines ("\r\n"), on Windows these are incorrectly combined into a single "\n".

To Reproduce
Using a Windows machine, read the attached example file and observe the incorrect cell value:

library(openxlsx)
read.xlsx("data.xlsx")
#>                      column
#> 1 some text\nsome more text

Created on 2024-01-23 with reprex v2.1.0

Expected behavior
On macOS, reading the attached file works as expected:

library(openxlsx)
read.xlsx("data.xlsx")
#>                            column
#> 1 some text\r\n\r\nsome more text

Created on 2024-01-23 with reprex v2.1.0

Example files
data.xlsx

Additional context
Both systems are using R 4.3.2, openxlsx 4.2.5.2, Rcpp 1.0.12, stringi 1.8.3, zip 2.3.0, installed from CRAN using precompiled binaries. The files was created using Excel on a Mac. New lines were entered using Option+Enter.