Issue - too much data

[Arthfael]

Expected Behavior

When writing from a data able with more than ill truncate data, with a warning, and properly format the cells.

Actual Behavior

Seems to actually write all of the data into the cells. On opening the file for the first time, Excel needs to repair records. No lasting corruption seems done to data (e.g. no shifting of subsequent cells, formatting corruption, etc...)

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

1. Create a data table with, in one cell, more than the maximum amount of data allowed by Excel (32,767) e.g. df <- data.frame(Col1 = paste(rep(1, 32,768), collapse = ""))

2. Write data to a workbook and save it

3. Open resulting xlsx file in Excel

sessionInfo()

• Version of openxlsx: 4.1.4
• Version of R: R version 3.6.1 (2019-07-05), R studio 1.3.1073

[Arthfael]

Oook, I looked in the comments to other issues... I will go to ycphs/openxlsx ^^