sparkline in template gives corrupted sheet

[theclue]

Describe the bug
When using an existing XLSX as a template file to fill and if this file has sparklines graphs in it, opening, updating and saving to a new XLSX file fives corrupted sheets.

This is true on all those scenarios:

1. R/openxlsx is used to manipulate the set of cells/region on which sparkline graphs are picking up data

2. R/openxlsx is used to manipulate the XLSX template but without touching those cells where sparkline graphs are defined

3. R/openxls is used to open, copy and then save a copy of the XLSX template, without touching any cell inside it

sessionInfo()
R version 3.6.0 (2019-04-26)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Debian GNU/Linux 9 (stretch)

Matrix products: default
BLAS/LAPACK: /usr/lib/libopenblasp-r0.2.19.so

locale:
[1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8 LC_COLLATE=en_US.UTF-8
[5] LC_MONETARY=en_US.UTF-8 LC_MESSAGES=C LC_PAPER=en_US.UTF-8 LC_NAME=C
[9] LC_ADDRESS=C LC_TELEPHONE=C LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C

attached base packages:
[1] stats graphics grDevices utils datasets methods base

other attached packages:
[1] forcats_0.4.0 stringr_1.4.0 dplyr_0.8.3 purrr_0.3.2 readr_1.3.1 tidyr_1.0.0 tibble_2.1.3 ggplot2_3.2.0
[9] tidyverse_1.2.1

loaded via a namespace (and not attached):
[1] zip_2.0.4 Rcpp_1.0.1 cellranger_1.1.0 pillar_1.4.2 compiler_3.6.0 tools_3.6.0 packrat_0.5.0
[8] zeallot_0.1.0 lubridate_1.7.4 jsonlite_1.6 lifecycle_0.1.0 nlme_3.1-139 gtable_0.3.0 lattice_0.20-38
[15] pkgconfig_2.0.2 rlang_0.4.1 openxlsx_4.1.3 cli_1.1.0 rstudioapi_0.10 haven_2.1.1 withr_2.1.2
[22] xml2_1.2.0 httr_1.4.1 generics_0.0.2 vctrs_0.2.0 hms_0.4.2 grid_3.6.0 tidyselect_0.2.5
[29] glue_1.3.1 R6_2.4.0 readxl_1.3.1 modelr_0.1.4 magrittr_1.5 backports_1.1.4 scales_1.0.0
[36] rvest_0.3.5 assertthat_0.2.1 colorspace_1.4-1 stringi_1.4.3 lazyeval_0.2.2 munsell_0.5.0 broom_0.5.2
[43] crayon_1.3.4

packageVersion("openxlsx")
[1] ‘4.1.3’

hope this helps! have a nice day!

[ycphs]

Could you please provide examples and details

[theclue]

Sorry, didn't noticed the reply. Which klind of details do you need?

To reproduce:

• Open an existing XLSX file with an existing sheet with sparkline defined as having data in A2:A20
• writeDataTable in A2:A20 (a tidy dataset, in my example)
• Saving the workbook

While trying to open the file with Excel, a warning that the file is corrupted pops up. Continuing, the file is empty.

[github-actions]

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue was closed because it has been stalled for 7 days with no activity.